Sr Enrg Efficiency Data Spclst - Exelon
Oak Brook, IL
About the Job
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
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
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
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.
Minimum 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.
Preferred Qualifications
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
Benefits
+ Annual salary will vary based on a candidate's skills, qualifications, experience, and other factors:USD $93,600.00/Yr. - USD $140,400.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.
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
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
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
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.
Minimum 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.
Preferred Qualifications
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
Benefits
+ Annual salary will vary based on a candidate's skills, qualifications, experience, and other factors:USD $93,600.00/Yr. - USD $140,400.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.
Source : Exelon
