Sr Data Analyst

General Summary

Consumers Energy is Michigan’s largest energy provider, serving 6.8 million of the state’s 10 million residents. This position is not eligible for immigration sponsorship.

Essential Duties And Responsibilities

• Collaborates with departments across the organization to identify data needs, goals, and objectives.
• Identifies trends and patterns in data and provides recommendations for improvement, optimization, and new value opportunities.
• Applies knowledge of data and its interaction with applications to troubleshoot issues, analyze root causes, and recommend solutions.
• Cleans, transforms, and prepares datasets using tools such as SQL, Python, R, and Excel.
• Communicates insights to leadership and other stakeholders through presentations, reports, dashboards, and visualizations.
• Performs statistical analysis and interprets results from advanced analytical techniques.
• Supports data investigations and analytical needs for departmental initiatives.

Knowledge/Skills/Abilities

• Ability to analyze and interpret data to support informed decision making.
• Ability to present findings to diverse audiences, both technical and nontechnical.
• Ability to identify, analyze, and solve a wide range of problems.
• Ability to understand both the big picture and the detailed components of data initiatives.
• Excellent written and verbal communication skills.
• Knowledge of statistical analysis, data visualization, and an understanding of data modeling and data engineering concepts.

Education/Experience

• Bachelor’s degree in Information Technology, Data Analytics, or a related field, with four (4)+ years of experience transforming data into meaningful insights, presenting to business stakeholders, and driving business value.
• Associate’s degree in Information Technology, Data Analytics, or a related field, with six (6)+ years of relevant experience as described above.
• High School Diploma, with eight (8)+ years of relevant experience as described above.

Preferred Experience

• Familiarity with Databricks and its analytical capabilities.
• Strong understanding of dimensional modeling concepts (fact tables, dimensions, star schema) and their role in analytics.
• Proficiency in writing complex SQL queries, including joins, aggregations, and window functions.
• Experience cleaning, transforming, and preparing datasets using tools such as Python.
• Ability to design clear, impactful dashboards and visualizations using Tableau, Power BI, or visualization libraries.
• Advanced Excel/Google Sheets skills, including pivot tables, lookups, and complex formulas.
• Expertise in developing KPIs, metrics, and data driven recommendations that support business objectives.