ComEd - Sr Data Specialist - Hybrid

This job posting is no longer active.

Location: , Hybrid Remote, United States
Organization: ComEd
Job ID: 240992
Date Posted: Nov 2, 2022
Job: CUSTMRCARE-Customer Operations

Share: mail

Job Description

Description

Be a part of something powerful at America's premier energy provider!

At Exelon, we are united by our values and shared vision for a cleaner and brighter future. We encourage curiosity, value diverse perspectives and we never stop looking for ways to be, work and do better. We know the future is in our hands. That's why we're looking for people like you, who have the power to make a difference.

As the nation's largest utility company, we serve more than 10 million customers through six fully regulated transmission and distribution utilities:  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). All 18,000 of us are committed to delivering safe, reliable and affordable energy to our customers, strengthening our communities, supporting a clean energy future and reducing our impact on the changing climate.

Our people are the heart and soul of our business. Whether it's powering lives, supporting communities or collaborating with colleagues, an Exelon employee is talented, compassionate, forward-thinking and inspired. We are empowered to evolve and advance our careers in an open and inclusive environment. We pride ourselves on being the kind of place where people want to come and stay. We know that investing in our employees' futures strengthens ours, which is why we offer competitive compensation, incentives and health and retirement benefits.

PRIMARY PURPOSE OF POSITION

Oversee and manage all aspects of key information management systems that have been developed in support of the energy efficiency portfolio, including all reporting, data input/output processes, user interfaces and other related processes. Work with program managers to identify gaps in data processes and develop solutions. Work with IT vendor(s) to maintain infrastructure and platforms. Position may be required to work extended hours, including 24 x 7 coverage during storms or other energy delivery emergencies.


PRIMARY DUTIES AND ACCOUNTABILITIES

  • Oversee data management of these (and other related) systems, including: a) Extraction, Transformation and Loading (ETL) processes b) Enhancement and usability improvements c) Cross-platform functionality d) Data Quality and Integrity e) Report and Dashboard Development 
  • Work with program managers and other key staff to address concerns and align platform functionality with program needs 
  • Lead small team (1-2 persons) to address ongoing needs of program implementers, marketing personnel, regulatory compliance, etc. Duties may include development of ad-hoc reports or ETL processes, development of data cubes and management of Sharepoint users and sites 
  • Ensure that all data systems comply with ComEd's and Exelon's data security requirements as well as applicable Federal and State laws. Identify deficiencies and develop processes to remediate any deficiencies found. 
  • Manage system enhancements and upgrades as needed. Work with vendors to manage upgrades, enhancements, patches and fixes on a timely basis. Provide general oversight and management to vendors of hosted systems. 


JOB SCOPE

  • Oversee several key information management systems that have been developed in support of energy efficiency programs. Systems include:
  • 1) Project Tracking and Reporting System. This multi-faceted system was consists of several key elements:
  • a) A centralized tracking database; this system runs under SQL Server 2012, and serves as the central repository for numerous programs.
  • i. This data is used to track program and portfolio performance versus goals and targets
  • ii. This data supports regulatory compliance requirements
  • b) Web-based tracking systems; these systems were developed using Visual Studio, and are used to enter, track and report on key business energy efficiency programs.
  • c) Sharepoint Farm - used to provide program managers with a number of key reports as well as to enable collaboration among implementers and other key parties.
  • 2) CRM System - this platform provides program implementers with access to key data regarding business customers, facilitates lead management and lead harvesting, and allows tracking and viewing of customer communications from implementers and program managers. EnergyOrbit is used as the current CRM platform.
  • 3) Marketing Database - This platform receives data from a multitude of sources, cleans and optimizes the data using industry-standard protocols, and renders the data in a user interface for query development. The system also provides full support for marketing campaign management and tracking. Axciom's MarketEdge is the currently used system as its Marketing Database platform, although this function is being transitioned to another vendor.
  • Number of personnel managed (direct): none now but will potentially be 1-2 in the near future, (indirect): several contractors and hosted system vendors.

Qualifications

MINIMUM QUALIFICATIONS

  • Bachelor's degree in Computer Science/Computer programming + 5 - 8 years relevant experience One year experience with Microsoft SQL Server 2008R2 or later, including Reporting Services, Integration Services, Analysis Services, and Other Data Tools components
  • Strong knowledge of T-SQL, including ability to write complex queries
  • Ability to communicate with and coordinate with a wide variety of professionals ranging from engineers to vendors, to subcontractors.
  • Experience with visualization/dashboard tools (PowerBI) and working knowledge of Microsoft PowerApps; prior experience with SQL and Python also a plus.


PREFERRED QUALIFICATIONS

  • Microsoft Certified Technology Specialist (MCTS) certification for SQL Server Three years experience with Microsoft SQL Server, including SQL Server 2012 and SQL Server Data Tools
  • Familiarity with Salesforce and/or other commercial CRM systems
  • Working knowledge of Microsoft Sharepoint 2010, Microsoft IIS, VMWare and Windows Server 2012R2

 

 

 

Share: mail
 

Frequent Job Searches

Recently Viewed Jobs

Most Recent Job Searches

Relevant Jobs