Principal strategy database specialist - utility data extraction - sql python

Who We Are

We're powering a cleaner, brighter future.

Exelon is leading the energy transformation, and we're calling all problem solvers, innovators, community builders and change makers. Work with us to deliver solutions that make our diverse cities and communities stronger, healthier and more resilient.

We're powered by purpose-driven people like you who believe in being inclusive and creative, and value safety, innovation, integrity and community service. We are a Fortune 200 company, 19,000 colleagues strong serving more than 10 million customers at six energy companies -- Atlantic City Electric (ACE), Baltimore Gas and Electric (BGE), Commonwealth Edison (ComEd), Delmarva Power & Light (DPL), PECO Energy Company (PECO), and Potomac Electric Power Company (Pepco).

In our relentless pursuit of excellence, we elevate diverse voices, fresh perspectives and bold thinking. And since we know transforming the future of energy is hard work, we provide competitive compensation, incentives, excellent benefits and the opportunity to build a rewarding career.

Are you in?

Primary Purpose

Provide data mining, database marketing and consulting services to all energy delivery organizations. Manage the planning, direction, coordination and strategic/tactical deployment of internal and external data resources within the ComEd Customer Data Warehouses. Perform high-level analysis and prepare comprehensive reports to support business operations. Research and provide statistical, financial and operational information. Develop, organize and present performance reports for both internal and external use. Provide expert analytical and operational support to the business units. Perform identical functions for PECO under an approved Affiliate Level Agreement, as necessary.

Position may be required to work extended hours, including 24 x 7 coverage during storms or other energy delivery emergencies.

Primary Duties

• Manage, support, and perform customer intelligence analyses, campaign targeting/segmentation strategies, campaign response analyses, and analytic strategies for corporate research and customer relationship management initiatives.

• Analyze customer transactional data using advanced data mining techniques in support of process improvement initiatives using tools such as SPSS or SAS.

• Advise, plan and collaborate with directors, managers, business specialists and analysts by accessing and analyzing strategic customer and marketing information. Advise, counsel and support the development of strategic business plans, marketing plans and product/program implementation plans.

• Plan, direct and coordinate the development and utilization of ComEd Customer Data Warehouses. Build, modify, monitor and maintain a CRM database system.

• Recommend, develop, implement and monitor predictive models for new product/program penetration, account acquisition, profitability, segmentation and retention.

• Conduct complex modeling, forecasting, trending, variance analysis, business case development, and other financial and operational analysis (e.g., operational effectiveness, budget, resource, workload, workforce and capacity utilization, competitor, etc.).

• Provide expert analytical and operational support to the business unit.

Job Scope

• Provide strategic data mining, database marketing and related consulting services to all ComEd organizations.

• Advise and counsel corporate officers, directors, managers and business specialists on analytical findings and recommend courses of action that redirect resources to increase penetration of existing products and services, launch new products and services, respond to competitive challenges, drive customer satisfaction, or assist with overall emerging business issues.

• Develop and maintain the ComEd Customer Data Warehouses, the primary depository of internal customer and externally purchased customer data. It is the role of this position to provide internal customers with data and analysis that best positions the company going forward.

• Manage operating budget associated with customer data warehouses and external data services.

• Support business unit strategic planning.

• Integration of business knowledge and functional priorities to address complex problems and non-standard situations

Minimum Qualifications

• Education: Bachelor's degree required in market research, marketing, statistics, computer science or equivalent business experience.

• Experience: Consulting experience (8-10 years) in customer analysis, customer relationship management, marketing communications or marketing research. Experience in segmentation analysis and strategy, database analysis and implementation and relational database extraction/manipulation. Proficient in relational database query languages such as SQL.

• Analytical Abilities: Proven ability to manage and conduct data analysis, extrapolate and integrate the data, draw conclusions, and provide clear, concise, actionable information. Proven ability to apply findings to both strategic and tactical business plans and resilient in changing or uncertain situations.

• Technical Knowledge: Working knowledge of data manipulation / analytical tools for use in mainframe and client / server environments. Computer literate in Microsoft Office Suite of products. Business knowledge of statistical analysis and statistical applications in business situations.

• Communication Skills: Ability to translate data analysis and findings into coherent conclusions and actionable recommendations to executives. Ability to translate executive vision and guidance into methods and analytics. Excellent oral and written communication skills.

Preferred Qualifications

• Master's degree in Computer Science/Information Systems Management, Business Administration, Market Research or Marketing.

• 5+ years experience with energy company specific systems and data, including billing systems, outage management systems.

Benefits

Benefits

• Annual salary will vary based on a candidate's skills, qualifications, experience, and other factors: $102,400.00/Yr. - $140,800.00/Yr.

• Annual Bonus for eligible positions: 20%

• 401(k) match and annual company contribution

• Medical, dental and vision insurance

• Life and disability insurance

• Generous paid time off options, including vacation, sick time, floating and fixed holidays, maternity leave and bonding/primary caregiver leave or parental leave

• Employee Assistance Program and resources for mental and emotional support

• Wellbeing programs such as tuition reimbursement, adoption and surrogacy assistance and fitness reimbursement

• Referral bonus program

• And much more

Note: Exelon-sponsored compensation and benefit programs may vary or not apply based on length of service, job grade, job classification or represented status. Eligibility will be determined by the written plan or program documents.

Exelon is proud to be an equal opportunity employer and employees or applicants will receive consideration for employment without regard to: age, color, disability, gender, national origin, race, religion, sexual orientation, gender identity, protected veteran status, or any other classification protected by federal, state, or local law. If you are an individual with a disability and need an accommodation to complete the application, please email us at [email protected].