Rates and Data Analyst

Midwest Energy•Hays, KS

3d•Onsite

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

Requirements

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.
Solid understanding of basic statistics, data validation, and quality control, required.

Nice To Haves

Utility industry experience helpful but not required.

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