Rates and Data Analyst

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

Career Opportunities with Midwest Energy, Inc.

Current job opportunities are posted here as they become available.

Subscribe to our RSS feeds to receive instant updates as new positions become available.

Job Summary (Overall Purpose of the Position)

The Rates and Data Analyst provide analytical and reporting support for rate development and implementation as well as supporting analytics needed across customer service operations. This position performs entry to intermediate-level data analysis, supports rate and tariff work, and develops dashboards and reports. The Analyst works with moderate independence and is responsible for transforming raw data into actionable insights, maintaining recurring reports, and contributing to data-driven decision-making. This role supports enterprise analytics efforts by developing meaningful visualizations, ensuring data quality, and assisting in process improvements that strengthen Midwest Energy’s analytics capabilities. At times, the Rates and Data Analyst acts as the customer-facing expert on rates for Midwest Energy.

Job Duties - Responsibilities – Tasks

Rates and Tariff

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

Utility Data Analytics

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

General

• Participate in special projects that involve data analysis, reporting improvements, or new analytics initiatives.
• Build effective working relationships with internal departments to understand data needs and deliver timely information.
• Promote safe working habits and follow all safety rules and regulations of Midwest Energy.
• Maintain awareness of changes in local, state, and federal rules that may impact Midwest Energy.
• Build internal and external relationships to enhance data-sharing, communication, and effective customer service.
• Perform other duties as assigned.

Education and Experience

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