Sr Strategic Database Specialist job at Pepco Holdings

Job Description

This position will serve as a senior data scientist in the Smart Grid and Technology group within the Pepco Holdings Technical Services Division. The successful candidate will have a key role in planning and implementation of the strategic analytics programs using machine learning and advanced statistical modeling and in collaboration with IT and various business area teams across the PHI and Exelon Utilities.

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 Company 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, including 24 x 7 coverage during storms or other energy delivery emergencies.

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.
Analyze data using advanced data mining techniques in support of process improvement initiatives using a variety of tools.
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.
Plan and coordinate the development and utilization of Company Utilities Data Warehouses. Build, modify, monitor and maintain a CRM database system.
Develop, implement and monitor predictive models for improved operational performance, new product/program penetration, account acquisition, segmentation, etc.
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.

Minimum Requirements:

Bachelor’s degree required in market research, marketing, statistics, computer science or equivalent business experience.
Experience: Consulting experience (5-8 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 Experience:

2+ years of experience in Energy/Utility company specific systems and data, including billing systems, outage management systems, geographical information systems, etc.
Proficiency in both structured and unstructured data management systems such as Hadoop
Hands on experience with data science development tools such as R and Python
Hands on experience with advanced business intelligence and data visualization tools such as Tableau or QlikView to develop dashboards for business users

Interested in this position?

Click here to learn how to get in touch