Senior Analyst I-IV

Sponsorship for Work Authorization Not Available.

As a Senior Analyst I-IV youll play a key role in advancing CEIs analytics and decision-support capabilities. Youll develop SQL-driven data solutions forecasts reporting tools and automated processes that help guide power supply planning budgeting operations and strategic business decisions. This is an exciting opportunity for someone who enjoys solving complex problems improving processes and using data to drive business success. Placement within Levels I-IV is based on experience expertise leadership independence and organizational impact.

Essential Duties and Responsibilities:

• Develop and improve analytical methods supporting forecasting budgeting resource evaluation operational analysis and strategic decisions.
• Create and maintain SQL queries views stored procedures analytical datasets and reporting structures.
• Independently extract transform validate analyze and interpret large datasets from multiple sources.
• Design and maintain Power BI dashboards semantic models DAX measures and paginated reports.
• Perform variance sensitivity scenario regression statistical and trend analyses to explain results and quantify risk.
• Automate recurring analytical and reporting processes to improve efficiency consistency controls and documentation.
• Analyze power supply alternatives market and fuel trends load growth cost drivers and strategic opportunities.
• Evaluate financial operational and business impacts of resource options supplier opportunities and other alternatives.
• Work with subject matter experts to define requirements validate assumptions and translate results into practical recommendations.
• Modernize legacy processes standardize repeatable workflows and reduce reliance on manual spreadsheet-based analysis.
• Document methodologies assumptions data sources business rules and validation steps.
• Serve as a technical resource for analytics forecasting reporting automation and data-driven problem solving.

Level Progression:

Senior Analyst I: Performs analytical assignments with guidance and develops proficiency in CEI processes SQL Power BI forecasting and data validation.

Senior Analyst II: Independently completes complex analyses develops reporting and automation solutions and provides recommendations to management and stakeholders.

Senior Analyst III: Leads complex analytical projects designs scalable solutions serves as a subject matter expert and mentors analysts and business users.

Senior Analyst IV: Leads enterprise analytical and modernization initiatives establishes methods and standards advises leadership and influences strategic decisions.

Required Skills and Abilities:

• Advanced SQL skills including complex queries joins common table expressions window functions views stored procedures and analytical dataset creation.
• Experience developing Power BI solutions including dashboards semantic models DAX measures and paginated reports.
• Strong quantitative statistical forecasting variance-analysis data-validation and problem-solving skills.
• Ability to independently analyze large datasets and convert complex results into clear business recommendations.
• Demonstrated ability to automate processes strengthen analytical controls and implement maintainable solutions.
• Strong communication presentation organization critical-thinking and time-management skills.

Desired Skills and Experience:

• Experience with Python R or another analytical programming language.
• Experience with predictive analytics regression statistical forecasting scenario modeling simulation or optimization.
• Familiarity with automated reporting enterprise business intelligence ETL SSIS cloud analytics APIs VBA or data integration technologies.
• Experience in utility operations energy markets finance operations consulting or another analytical environment is beneficial but not required.

Education and Work Experience:

Bachelors degree preferred in Computer Science Data Science Statistics Mathematics Engineering Economics Business Analytics Finance or another quantitative or analytical discipline. Equivalent combinations of education experience and demonstrated technical capability may be considered.

• Senior Analyst I: Generally five or more years of relevant analytical experience.
• Senior Analyst II: Generally seven or more years of relevant experience with demonstrated independence in complex analysis and solution development.
• Senior Analyst III: Generally ten or more years of relevant experience with demonstrated leadership of complex analytical initiatives.
• Senior Analyst IV: Demonstrated expert-level capability and the ability to lead enterprise solutions and influence strategic decisions. No fixed minimum years of experience are required.

Primary Objective of the Role:

Help CEI transition from manual spreadsheet-centered analysis toward SQL-driven analytics automated business intelligence repeatable forecasting methods stronger analytical controls and sustainable decision-support capabilities.

Benefits

• Competitive pay-Negotiable based upon experience
• Medical dental vision & prescription drug coverage
• Health Savings Account
• Life insurance & disability
• 401K with company match
• Paid holidays and time off

Learn more about CEI at: Energy Incorporated participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S.

All contingent offers are based upon successful completion of our pre-employment verification process.