Senior Analyst I-IV

Overview Sponsorship for Work Authorization Not Available. As a Senior Analyst I-IV, you'll play a key role in advancing CEI's analytics and decision-support capabilities. You'll 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. Responsibilities 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. Qualifications Required Skills and Abilities: Advanced SQL skills, including complex queries, joins, common table expressions, window functions, views, stored procedures, and analytical dataset creation. …