Data Analyst Apprentice

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

The primary purpose of this position is to assist Senior level data analytics professionals in the design, planning, and research associated with analysis of departmental business operations, program performance and outcomes. This entry level role is comprised of on the job learning and skill development and application of learning project experience. Position may be required to work extended hours for coverage during storms or other energy delivery emergencies. The primary duties of this position include, but not limited to, the management, governance, analysis and visualization of data; the creation and coordination of project plans; the application of design thinking techniques; and the presentation and communication of insights derived from the data.

Primary Duties:

PRIMARY DUTIES AND ACCOUNTABILITIES

- Research data issues, such as missing values and mismatched types, by retrieving, cleansing, and distributing the data as appropriate to resolve discrepancies and provide timely and accurate information to functional area team members

- Ensures the integrity of data through the creation of data standards by supporting the update of data dictionaries, the maintenance of use case documentation, and the documenting of data analysis procedures.

- Gathers report requirements from business partners and project team members to design reports using software or tools such as MS Power BI and MS Excel

- Assists the team in the interpretation of analysis results by building data models and preparing reports on findings that include actionable recommendations

- Contributes to the planning of research on the underlying business drivers that warrant the design and implementation of data analytics projects. Develops project plans utilizing department software tools, such as MS Project, to delineate tasks, deliverables, time/cost estimates.

- Utilizes design thinking techniques to determine proper visual representation(s) (table, graph, chart, etc.) to communicate and present each storytelling instance.

Job Scope:

JOB SCOPE

The Data Analytics Apprentice position is structured to offer a two-phase on-the-job learning and skill building experience which will equip the Data Analytics Apprentice with knowledge and skills to address the business department's data management and analysis needs. This will be accomplished by the Data Analytics Apprentice's participation in the Data Analytics Career Pathway Apprenticeship program. As a member of the apprenticeship program, the Data Analytics Apprentice will assist senior level Data Analytics professionals in the planning and execution of data management and analysis projects in support of designated department research and or reporting services. Upon completion of the apprenticeship phase 1 required courses, on the job assignments and projects; and satisfactory performance on the end of phase assessment, the Data Apprentice will advance to the phase 2 of the apprenticeship program. During phase two of the apprenticeship program, the Data Analytics Apprentice will be assigned more complex research & problem resolution assignments while applying data analytics methods learned in the Data Analytics Apprenticeship program phase 1.

POSTING NOTE

This position supports PECO's Data Analytics Career Pathway apprenticeship pilot program.

Minimum Qualifications: MINIMUM QUALIFICATIONS

High School Diploma or GED -2 Letters of Recommendation (from prior employer, educator, coach, youth leader) -Satisfactory Performance on Program Entrance Assessment -Strong oral and written communication Skills - Demonstrated interest and competency in math, computer science, business concepts, accounting, information management disciplines -Digital Literacy -Strong interpersonal skills, teamwork tendencies

Preferred Qualifications: PREFERRED QUALIFICATIONS

-Working knowledge of statistical analysis -Proficient in use of MS Suite -Experience developing digital presentations

Benefits: Benefits

- Annual salary will vary based on a candidate’s skills, qualifications, experience, and other factors: $44,800.00/Yr. – $61,600.00/Yr.

- Annual Bonus for eligible positions: 7%

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