Energy Rates Analytics & Insights Specialist

Midwest Energy, Inc.; Hays (KS); On-site; USD 65,000 - 85,000; Full time

Job summary

Midwest Energy, Inc. seeks a Rates and Data Analyst to support rate development, tariff analysis, and enterprise analytics initiatives. The role involves transforming raw data into actionable insights, building dashboards and recurring reports for customer service operations.

Collaborating across departments, you will maintain data quality, perform forecasting analyses, and expand Power BI and SQL usage while contributing to data governance and process improvements.

Qualifications

• Bachelor’s degree in analytics, economics, business, accounting, engineering, information systems, or related field; or equivalent combination of education and relevant work experience.
• 1–3 years of experience summarizing data into reports or building simple reports, or a related role preferred. Experience directly in data analytics or business intelligence preferred.
• Beginning proficiency with Excel, including summary statistics, formulas, lookups, and data transformation, required.
• Ability and wiliness to learn tools such as Power BI and SQL required.
• Utility industry experience helpful but not required.
• Solid understanding of basic statistics, data validation, and quality control, required.
• Applies sound analytical judgment by reviewing data carefully, identifying patterns or inconsistencies, and using available information to support accurate conclusions.
• Demonstrates Intellectual curiosity by asking thoughtful questions and seeking to understand complex data.
• Applies a structured approach to problem-solving by gathering relevant information, evaluating possible causes, and supporting data-driven recommendations.
• Manages work independently; manages assigned tasks, follows established processes, asks questions when needed, and takes ownership of completing accurate work.
• Ability to extract synthesize insights from structured datasets and communicate findings
• Ability to manage multiple assignments, meet deadlines, and adapt to shifting priorities.
• Effective verbal and written communication with both technical and non-technical audiences.
• Models a team-oriented mindset by collaborating with multiple departments to understand data needs and share information.

Responsibilities

• Assist the Rates and Tariff Manager with data collection and analysis.
• Research and resolve issues and questions involving rates and tariffs. Make changes to tariff documents as issues are identified.
• Support load forecasting, revenue forecasting, and rate design analyses.
• Analyze customer usage patterns, load profiles, customer classes, and seasonal trends using billing and AMI data.
• Examine and track external factors affecting energy and gas sales volumes, including weather and economic factors.
• Prepare rate comparison analyses and assist Customer Service Representatives with complex billing issues.
• Manage the renewable generation interconnection program, guiding customers and vendors through the process, and coordinating with the engineering department for final approval.
• Develop and maintain Excel reports and (ultimately) Power BI dashboards that support Customer Service research.
• Perform data cleaning, quality checks, and validation to ensure accuracy of analytics outputs.
• Conduct usage trend analysis, load pattern studies, and customer segmentation work under guidance from Rates & Tariff Manager.
• Document data workflows, reporting processes, and standard operating procedures.
• Assist in enhancing enterprise reporting structures, data governance practices, and routine analytics processes.
• Provide ad-hoc insights and data summaries for management, rate design, outage analysis, and customer programs.

Skills

Data analysis

Excel proficiency

Communication

Learning new tools

Education

Bachelor's degree in analytics, economics, business, accounting, engineering, information systems, or related field

Tools

Power BI

SQL

Job description

Midwest Energy, Inc. seeks a Rates and Data Analyst to support rate development, tariff analysis, and enterprise analytics initiatives. The role involves transforming raw data into actionable insights, building dashboards and recurring reports for customer service operations.

Collaborating across departments, you will maintain data quality, perform forecasting analyses, and expand Power BI and SQL usage while contributing to data governance and process improvements.