Sr Strat Database Specialist

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

PRIMARY PURPOSE OF POSITION

Provide data mining, data analysis, database marketing and consulting services. Manage the planning, direction, coordination and strategic/tactical deployment of internal and external data resources within the Exelon Utility Data Warehouses. Perform 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. Position may be required to work extended hours for coverage during storms or other energy delivery emergencies.

Primary Duties

PRIMARY DUTIES AND ACCOUNTABILITIES

• Perform advanced analysis including customer intelligence analyses; operating performance improvement, campaign targeting/segmentation strategies, campaign response analyses, and analytic strategies for company research and customer relationship management initiatives. (20%)
• Analyze data using advanced data mining techniques in support of process improvement initiatives using tools such as SPSS or SAS. (15%)
• Advise, plan and collaborate with directors, managers, business specialists and analysts by accessing and analyzing strategic customer, operating, and marketing information. Advise, counsel and support the development of strategic business plans, marketing plans and product/program implementation plans. (15%)
• Plan and coordinate the development and utilization of Exelon Utilities Data Warehouses. Build, modify, monitor and maintain a CRM database system. (5%)
• Develop, implement and monitor predictive models for improved operational performance, new product/program penetration, account acquisition, segmentation, etc. (10%)
• 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.). (15%)
• Provide expert analytical and operational support to the business unit. (20%)

Job Scope

JOB SCOPE

• Provide strategic data mining and analyses
• Advise and counsel officers, directors, managers and business specialists on analytical findings and recommend courses of action that redirect resources to improve operational performance, increase penetration of existing products and services, launch new products and services, drive customer satisfaction, or assist with overall emerging business issues.
• Develop and maintain the Data Warehouses, the primary depository of internal operational, 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.
• Support business unit strategic planning.
• Integration of business knowledge and functional priorities to address complex problems and non-standard situations

Minimum Qualifications

MINIMUM QUALIFICATIONS

• Education: Bachelor's degree required in market research, marketing, statistics, computer science or in lieu of a degree, 6-9 years of relevant experience.
• Experience: Consulting experience (4-7 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

PREFERRED QUALIFICATIONS

• Master's degree in Computer Science/Information Systems Management, Business Administration, Market Research or Marketing.
• 2+ years' experience with energy company specific systems and data, including billing systems, outage management systems.

Benefits

• Annual salary will vary based on a candidate's skills, qualifications, experience, and other factors: $88,800.00/Yr. – $122,100.00/Yr.
• Annual Bonus for eligible positions: 15%
• 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.

---