Senior Analyst I-IV

Cooperative Energy Incorporated (formally ECG); Marietta (GA); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Competitive pay

Medical, dental, vision & prescription

Health Savings Account

Life insurance & disability

401K with company match

Paid holidays and time off

Job summary

Cooperative Energy Incorporated in Marietta, GA seeks a Senior Analyst I–IV to advance analytics, forecasting, and automation. You will develop SQL-driven data solutions, create dashboards, and support power supply planning and budgeting with data-driven insights.

Placement within levels I–IV depends on experience, leadership, independence, and impact. This role emphasizes modernizing processes and translating analyses into actionable business recommendations.

Qualifications

• Advanced SQL skills including complex queries and stored procedures.
• Experience with Power BI dashboards, models, and paginated reports.
• Strong quantitative and statistical forecasting, variance analysis, and data validation.
• Ability to translate analysis into practical business recommendations.
• Experience automating processes and strengthening analytical controls.
• Excellent communication and time-management skills.

Responsibilities

• Develop and improve analytical methods supporting forecasting, budgeting, resource evaluation, 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.

Skills

Advanced SQL

Power BI

Data validation

Automation

Communication

Education

Bachelor's degree preferred in quantitative field

Tools

Python

R

ETL/SSIS

VBA

APIs

Job description

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

Bachelor's 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.

Learn More Here

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: https://ecg-llc.com/

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