Supply chain data analyst - sql

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

Responsible for development and execution of data analytics programs for Supply, including developing and maintaining reports utilizing PowerBI, SQL, and other technologies. Provide oversight and perform analysis of supply operations, financial management, eSourcing, and KPI reporting.

Primary Duties

PRIMARY DUTIES AND ACCOUNTABILITIES

• Implement process and programs that support monitoring and analysis of the Supply Chain (10%)

• Maintain reporting applications and systems to ensure ongoing availability of data to stakeholders (20%)

• Automate and improve existing reports to provide enhanced guidance to stakeholders (25%)

• Interface with business stakeholders and provide guidance on retrieving, validating, and analyzing information on all aspects of the Supply Chain process (25%)

• Participate on cross functional and cross business unit project teams in support of changes to business process using existing and new technologies and/or systems. (10%)

• Develop new reporting solutions to further enhance overall Supply Chain governance, analytics, and support key business initiatives (10%)

Job Scope

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.

• Travel on average 10% across Exelon sites and business units, as business needs dictate.

• Individual will have no direct reports.

Minimum Qualifications

MINIMUM QUALIFICATIONS

• Undergraduate degree in Mathematics, Computer Science, Statistics, Information Systems/Technology, Accounting, Business, Engineering, Finance or related subject area with 4-7 years' experience or in lieu of a degree, 6-9 years of experience.

• Strong PC and computer skills (Word, Excel, Access, Power Point, Passport, Hyperion).

• Strong communicator, written and oral, with strengths in organization and planning.

• Knowledge and experience with ERP and eSourcing systems specifically as they apply to the integration of supply management with work mgmt. including inventory, Purchasing and Accounts Payable functions

• Experience creating new PowerBI data flows and complex reports, combining data from multiple sources

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

Preferred Qualifications

PREFERRED QUALIFICATIONS

• Experience leveraging various analytical tools including, but not limited to data analysis (Python, R, Power Query, etc.), dashboard and visualization (Power BI), ETL (SSIS), reporting tools (Hyperion, OBIEE, Business Objects), etc.

• Experience developing business applications, mobile and digital analytics and automation solutions.

• Experience planning and executing projects and initiatives with demonstrated ability to work on multiple projects and teams concurrently.

• Advanced knowledge of Microsoft Office Suite including SharePoint, Excel and PowerPoint.

Benefits

Benefits

• Annual salary will vary based on a candidate's skills, qualifications, experience, and other factors: $80,800.00/Yr. - $111,100.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

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

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 [email protected].