An Important Message about Exelon Recruitment during COVID-19

We hope that you and your loved ones are managing through this challenging and uncertain time. The COVID-19 pandemic has demanded unprecedented changes to our daily lives. That said, what hasn’t changed for us is the vital work we do, and our commitment to ensuring the safety of our candidates, employees, customers, and communities. While our hiring process looks a bit different today, with 100 percent virtual interviewing and other solutions in place to facilitate proper social distancing, we remain focused on powering possibilities for new talent who are ready to join us in making a difference. As always, you can find our available opportunities here. We truly appreciate your continued interest in opportunities with Exelon and our family of companies.

Sr Energy Efficiency Data Specialist - ComEd

This job posting is no longer active.

Location: OAK BROOK, IL, United States
Organization: ComEd
Job ID: 223498
Date Posted: Jan 18, 2020

Share: mail

Job Description


At Exelon, we've got a place for you! 

Join the nation's leading competitive energy provider, with one of the largest electricity generation portfolios and retail customer bases in the country. You will be part of a family of companies that strives for the highest standards of power generation, competitive energy sales, and energy delivery. Our team of outstanding professionals is focused on performance, thought leadership, innovation, and the power of ideas that come from a diverse and inclusive workforce. 

Exelon will provide you the tools and resources you need to design, build and enhance a successful career. We are also dedicated to motivating the success of our employees through competitive base salary, incentives, and health and retirement benefits. 

Join Exelon and share your passion at a forward-thinking Fortune 100 company. Establish yourself in a place where you can truly shine and create a brighter, more sustainable tomorrow. Energize your career at Exelon!


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 is required to work extended hours, including 24 x 7 coverage during storms or other energy delivery emergencies. 



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.


Bachelors 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. 


Microsoft Certified Technology Specialist (MCTS) certification for SQL Server

Three years experience with Microsoft SQL Server, including SQL Server 2016, SQL Server Data Tools, Python and Oracle

Experience with Office 365 Power Apps (Power BI)

Familiarity with Salesforce and/or other commercial CRM systems

Working knowledge of Microsoft Sharepoint 2010, Microsoft IIS, VMWare and Windows Server 2012R2



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 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.


Number of personnel managed (direct): none now but will potentially be 1-2 in the future, (indirect): several contractors and hosted system vendors.

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. 

VEVRAA Federal Contractor 

EEO is the Law Poster
Share: mail

Frequent Job Searches

Recently Viewed Jobs

Most Recent Job Searches

Relevant Jobs

Personalize this site