Data Analytics Analyst

Delmarva Power & Light Co.; Northern (KY); Hybrid; USD 66,000 - 91,000; Full time

Benefits offered by this job

401(k) match and company contribution

Medical, dental and vision insurance

Life and disability insurance

Generous paid time off and parental/le

Employee Assistance Program

Job summary

Exelon is seeking a data analytics professional to design, develop and implement business intelligence and digital solutions across its EAS services. You will build automated reports and dashboards using Power BI, SQL and related tools to identify trends and enable data-driven decision making for auditors and business partners.

The role involves embedding data analytics into business processes, supporting control environment improvements and coordinating analytics initiatives across multiple

Qualifications

• Undergraduate degree in a relevant field such as data analytics, information systems, engineering or related subject.
• 2–4 years of relevant experience.
• Strong analytical skills with attention to detail.
• Ability to query, interpret and visualize data from multiple sources.
• Proficient in Excel.
• Experience with SQL.
• Experience with Power BI or Tableau.
• Strong written and verbal communication skills.
• Customer service orientation.

Responsibilities

• Collaborate in the design, development and implementation of BI, analytics and digital solutions to support assurance and business enablement activities, including dashboards and data visualizations.
• Support internal processes to improve the control environment and embed data analytics in business processes.
• Build EAS team capabilities in analytics, data visualization and data modeling to enable a high-performing learning organization.
• Manage and administer the EAS data analytics platform and database that houses data from across Exelon for detailed analysis.

Skills

Analytical skills

Communication skills

Attention to detail

Data storytelling

Team collaboration

Education

Bachelor's degree

Tools

SQL

Power BI

Tableau

Power Apps

Power Automate

Excel

Job description

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, 20,000 colleagues strong serving more than 10.7 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).

We're committed to creating an environment where every person can thrive. Our employee experience is grounded in four tenets that guide how we support our people: purposeful careers, growth opportunities, community impact, and support to thrive.

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

The purpose of this specialized position is to design, develop and implement business intelligence, data analytics and digital solutions (reporting, dashboards and data visualization, advanced analytics, and workflow automation) across the full suite of EAS services while developing programmatic and ad-hoc data solutions from core Exelon systems. The position requires advanced technical skills and will primarily use Power BI, SQL, Power Apps and Power Automate to develop automated data-analytical reports and workflows on company-wide data to identify trends, patterns, and insights, and enable data-driven, risk-informed decision making for our auditors and business partners. The purpose of this role is to also enable business partners across BSC and our various OpCos by developing and embedding data analytics solutions in business processes to solve data and analytics-related challenges and further optimize the control environment. The position will understand Exelon's applications, platforms and databases, which serve as data sources, including the associated risks and controls. Additionally, individual could be responsible for the coordination and execution of core assurance and business enablement. activities, including business risk assessment activities, design and operational effectiveness testing, and evaluation of control failures while serving as liaison to business partners to ensure that the companies risk management, governance and internal control processes are operating effectively. Individual will support other business initiatives and will be responsible for expressing opinions and providing insight on the adequacy and effectiveness of the control environment while identifying and communicating continuous improvement, control optimization and risk mitigation opportunities to business partners.

Primary Duties

• Collaborate in the design, development and implementation of business intelligence, data analytics and digital technology solutions to support core assurance and business enablement activities. Includes the preparation and delivery of dashboards and data visualization summaries to support formal communications and informed insights on the adequacy and effectiveness of business processes and internal controls.
• Support other EAS and business initiatives to continuously improve internal processes and optimize the control environment. Includes developing and embedding data analytics solutions in business processes to solve data and analytics-related challenges.
• Provide active assistance and support of others to build EAS team capabilities in the use of analytics, data visualization and data modeling techniques. Enable a high performing learning organization.
• Management and database administration of a dedicated EAS data analytics platform and database which houses data from across Exelon for detailed analysis (Accounts Payable, HR, Utility Billing, etc.).

Job Scope

Works under minimal supervision

Minimum Qualifications

• Undergraduate degree in Social Science, Data Analytics, Statistics, Information Systems/Technology, Business, Engineering, Finance, Mathematics, Computer Science or related subject area
• 2 to 4 years of relevant experience
• Strong analytical skills with the ability to collect, organize and analyze significant amounts of information with attention to detail and accuracy
• Comfort querying, interpreting and visualizing data from a variety of different sources to create a cohesive story
• Proficient user skills in Excel
• Experience in SQL
• Experience with data exploration, data visualization, data preparation, report design and delivery using Power BI/Tableau or other business intelligence tools
• Strong written and verbal communication skills, including the ability to communicate technical concepts to a non-technical audience
• High standards for customer service and the ability to build effective working relationships

Preferred Qualifications

• Proficient user skills in Power Query, Power Pivot
• Experience developing Power BI Dashboards, Power Apps and Power Automate solutions
• Experience & knowledge in relational databases

Benefits

• Annual salary will vary based on a candidate’s skills, qualifications, experience, and other factors: $66,400.00/Yr. – $91,300.00/Yr.
• Annual Bonus for eligible positions: 10%
• 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
• Employee Assistance Program and resources for mental and emotional support
• Wellbeing programs such as tuition reimbursement, adoption and surrogacy assistance and fitness reimbursement
• Referral bonus program
• And much more

Note: Exelon-sponsored compensation and benefit programs may vary or not apply based on length of service, job grade, job classification or represented status. Eligibility will be determined by the written plan or program documents.