Sr Strat Database Specialist

13 Nov 2024
Apply

Who We AreWe'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 PurposePRIMARY PURPOSE OF POSITIONProvide data mining, data analysis, database marketing and consulting services. Manage the planning, direction, coordination and strategic/tactical deployment of internal and external data resources for the Atlantic City Electric’s energy efficiency programs. Oversee data management (inclusive of calculations of savings measures and financial data), data quality and integrity, report and dashboard development for all Atlantic City Electric Energy Efficiency programs. 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 DutiesPRIMARY DUTIES AND ACCOUNTABILITIES

Perform advanced analysis including customer intelligence analyses; operating performance improvement, campaign targeting/segmentation strategies, campaign response analyses, and analytic strategies for energy efficiency, demand response and building decarbonization initiatives.

Oversee data management (inclusive of calculations of savings measures and financial data), data quality and integrity, report and dashboard development for all Atlantic City Electric Energy Efficiency programs. This involves creating data models, defining process flows, and establishing business rules.

Analyze 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, operating, and marketing information. Advise, counsel and support the development of strategic business plans, marketing plans and product/program implementation plans.

Manage QA/QC for all data maintained in etrack+. Identify deficiencies and develop processes to remediate any deficiencies found. Customize the platform by implementing validation rules, creating task sequences, and templatizing documents. Set up and administer program workflows using eTrack+, ensuring seamless execution of tasks.

Work with Energy Efficiency Program Managers for data validation and conduct complex modeling, forecasting, trending, variance analysis to identify recommendations for program improvements. Develop, implement and monitor predictive models for improved operational performance, new product/program penetration, segmentation, etc.

Collaborate with Business, Planning and Support to manage system enhancements and upgrades, coordinate with vendor, and control user access levels and record modifications.

Job ScopeJOB SCOPE

Provide strategic data mining and analyses.

Advice 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 eTrack+, the primary depository of Atlantic City Electric energy efficiency 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 QualificationsMINIMUM 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 QualificationsPREFERRED 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 or eTrack+.

Ability to generate intuitive reports and dashboards to provide actionable insights on program performance leveraging PowerBI.

Benefits

Annual salary will vary based on a candidate's skills, qualifications, experience, and other factors:USD $87,200.00/Yr. - USD $130,800.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 (based on position)

Long Term Incentive Plan for eligible positions

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

Referral bonus program

And much more

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 DandI@exeloncorp.com.

Full-time
  • ID: #52875294
  • State: Delaware Newark 19702 Newark USA
  • City: Newark
  • Salary: USD TBD TBD
  • Showed: 2024-11-13
  • Deadline: 2025-01-12
  • Category: Et cetera
Apply