Exelon
Data Analyst
Exelon, Chicago, Illinois, United States, 60290
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
This purpose of this position is to perform data analytics activities supporting the Human Resources Reporting & Analytics team’s functions and applications. As part of the day-to-day, the individual in this role will support client inquiries through data extraction, reporting, and analysis; leverage data solutions and methodologies to extract insights, trends, and patterns leading to data-driven insights; identify and employ the use of diverse and cutting edge analytics tools; provide end user education, issue remediation, and recommendations for change; and support database and data application system implementations and maintenance.
Primary Duties
Collect requirements and compile information to answer client’s most important data questions. This may require building queries using SQL, developing reports and dashboards for others to interact with, utilize, and better understand underlying data, relationships, and resulting insights. Maintain, improve, and automate existing reporting and analytics solutions using sustainable and scalable methods. Communicate findings to internal and external stakeholders on a recurring and ad-hoc basis.
Operational support of HR applications including system configuration, documentation, and customization as required. This includes helping develop oversight and governance strategies of report and analytics generation and standardization.
Manage relationships with stakeholders, continuously improve processes for end-users, and act as an internal liaison between HR, business clients, and IT.
Job Scope
Individual will be expected to demonstrate the following skill areas with some consistency.
Analytical - applies critical thinking and intellectual curiosity to solve complex problems with various tools and techniques. Demonstrates rapid learning and agility to proactively and effectively factor cost of controls into defining issues and issue resolution. Helps to optimize and simplify business processes.
Communication - provides clear written and verbal communication while actively engaging and leveraging active listening skills. Adapts messaging based on audience and situation while exhibiting strong understanding of the business. Constructively challenges issues through use of crucial conversations.
Talent Development - applies situational leadership to provide feedback and actively engage with others. Leverages coaching to enhance talent development and to build skills and capabilities. Able to translate feedback into action while self-identifying development areas and career opportunities. Actively demonstrates emotional intelligence and self-awareness.
Risk and Controls Mastery - Demonstrates ability to identify, assess and mitigate risk using a holistic perspective, as well as formulating action plans to achieve desired business outcomes. Applies professional judgement and strong understanding of company control frameworks and processes, to strengthen the control environment while preventing and detecting fraud.
Individual will have no direct reports.
Minimum Qualifications
Undergraduate degree in Mathematics, Computer Science, Statistics, Information Systems/Technology, Accounting, Business, Engineering, Finance or related subject area.
3+ years of relevant experience.
Strong critical thinking and analytic skills.
Experience writing complex SQL, includes understanding database systems and creating connections to data sources.
Proficient in querying, interpreting and visualizing data from a variety of different sources to create a cohesive story.
Knowledge of metrics, data and business intelligence strategies.
Able to manage multiple priorities, be results-oriented, customer-focused and show initiative.
Demonstrated ability to perform under pressure.
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.
Works under minimal supervision.
#LI-hybrid
Preferred Qualifications
Experience leveraging various analytical tools including, but not limited to data analysis and querying (SQL, Python, R, Power Query, etc.), dashboard and visualization (Power BI), ETL and data pipelines (SSIS), reporting tools (Hyperion, OBIEE, Business Objects), etc.
Experience developing business applications, digital analytics, and automation solutions.
Experience translating technical insights and requirements into digestible and meaningful information for all audiences.
Experience planning and executing projects and initiatives with demonstrated ability to work on multiple projects and teams concurrently.
Works under minimal supervision.
Benefits
Annual salary will vary based on a candidate's skills, qualifications, experience, and other factors:USD $80,000.00/Yr. - USD $120,000.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 (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
This purpose of this position is to perform data analytics activities supporting the Human Resources Reporting & Analytics team’s functions and applications. As part of the day-to-day, the individual in this role will support client inquiries through data extraction, reporting, and analysis; leverage data solutions and methodologies to extract insights, trends, and patterns leading to data-driven insights; identify and employ the use of diverse and cutting edge analytics tools; provide end user education, issue remediation, and recommendations for change; and support database and data application system implementations and maintenance.
Primary Duties
Collect requirements and compile information to answer client’s most important data questions. This may require building queries using SQL, developing reports and dashboards for others to interact with, utilize, and better understand underlying data, relationships, and resulting insights. Maintain, improve, and automate existing reporting and analytics solutions using sustainable and scalable methods. Communicate findings to internal and external stakeholders on a recurring and ad-hoc basis.
Operational support of HR applications including system configuration, documentation, and customization as required. This includes helping develop oversight and governance strategies of report and analytics generation and standardization.
Manage relationships with stakeholders, continuously improve processes for end-users, and act as an internal liaison between HR, business clients, and IT.
Job Scope
Individual will be expected to demonstrate the following skill areas with some consistency.
Analytical - applies critical thinking and intellectual curiosity to solve complex problems with various tools and techniques. Demonstrates rapid learning and agility to proactively and effectively factor cost of controls into defining issues and issue resolution. Helps to optimize and simplify business processes.
Communication - provides clear written and verbal communication while actively engaging and leveraging active listening skills. Adapts messaging based on audience and situation while exhibiting strong understanding of the business. Constructively challenges issues through use of crucial conversations.
Talent Development - applies situational leadership to provide feedback and actively engage with others. Leverages coaching to enhance talent development and to build skills and capabilities. Able to translate feedback into action while self-identifying development areas and career opportunities. Actively demonstrates emotional intelligence and self-awareness.
Risk and Controls Mastery - Demonstrates ability to identify, assess and mitigate risk using a holistic perspective, as well as formulating action plans to achieve desired business outcomes. Applies professional judgement and strong understanding of company control frameworks and processes, to strengthen the control environment while preventing and detecting fraud.
Individual will have no direct reports.
Minimum Qualifications
Undergraduate degree in Mathematics, Computer Science, Statistics, Information Systems/Technology, Accounting, Business, Engineering, Finance or related subject area.
3+ years of relevant experience.
Strong critical thinking and analytic skills.
Experience writing complex SQL, includes understanding database systems and creating connections to data sources.
Proficient in querying, interpreting and visualizing data from a variety of different sources to create a cohesive story.
Knowledge of metrics, data and business intelligence strategies.
Able to manage multiple priorities, be results-oriented, customer-focused and show initiative.
Demonstrated ability to perform under pressure.
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.
Works under minimal supervision.
#LI-hybrid
Preferred Qualifications
Experience leveraging various analytical tools including, but not limited to data analysis and querying (SQL, Python, R, Power Query, etc.), dashboard and visualization (Power BI), ETL and data pipelines (SSIS), reporting tools (Hyperion, OBIEE, Business Objects), etc.
Experience developing business applications, digital analytics, and automation solutions.
Experience translating technical insights and requirements into digestible and meaningful information for all audiences.
Experience planning and executing projects and initiatives with demonstrated ability to work on multiple projects and teams concurrently.
Works under minimal supervision.
Benefits
Annual salary will vary based on a candidate's skills, qualifications, experience, and other factors:USD $80,000.00/Yr. - USD $120,000.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 (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.