Volunteer Data Analyst Opt Jobs (NOW HIRING)

Consumers Energy is Michigan's largest energy provider, providing natural gas and/or electricity to 6.8 million of the state's 10 million residents in all 68 Lower Peninsula counties. Consumers Energy knows job number one is to keep the lights on for customers. We are committed to delivering reliable, clean, and affordable energy to our customers 24/7.
This position is not eligible for immigration sponsorship, e.g., H-1B, TN, etc. Please do not apply if you will need immigration sponsorship for a work visa now or in the future, including sponsorship for H-1B, TN, etc., now or in the future. We are unable to hire individuals with CPT, OPT, or STEM OPT for this position as the position is not eligible for participation in the H-1B lottery program and is not eligible for current or future immigration sponsorship for a work visa.
Location: This is a hybrid (virtual/onsite) position with required onsite days on Monday, Tuesday and Thursday assigned to One Energy Plaza located in Jackson, MI. The selected candidate must be within a commutable distance or willing to relocate (relocation package is available for those that qualify).
General Summary of Job Responsibilities
The Applications and Analytics team is at the heart of innovation, powering Michigan's future by crafting cutting-edge digital solutions that transform how our customers and communities experience energy. Guided by our Digital First strategy, we harness modern technical practices and agile methodologies to ensure data and insights are accessible, reliable, and actionable, enabling evidence-based decision-making, operational efficiency, and innovation across the organization. Join a dynamic team where collaboration, creativity, and impact converge!
We partner closely with business teams to uncover digital opportunities, prioritize high-impact outcomes, and deliver trustworthy, user-friendly technology. By embracing our CE Way principles-engaging on solutions, illuminating priorities, and minimizing waste-we build systems that are simple, helpful, and valuable. If you're passionate about innovation, community, and shaping a sustainable energy future, come grow with us at Consumers Energy!
The Senior Data Analyst plays a critical role in developing, enhancing, and maintaining standardized company data models. This position requires familiarity with at least one data domain and subject matter expertise within a specific business area. The Senior Data Analyst serves as a mentor to team members and brings strong technical expertise to ensure the accuracy, quality, and usability of data. They transform, design, and present data in ways that support informed decision making across the organization.
This role is responsible for delivering timely, high quality reporting that supports business strategies. It also requires coordination across multiple stakeholders, and may involve assuming project management responsibilities to lead teams or large initiatives.
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.
• Collects, cleans, and analyzes data from multiple sources using statistical methods and 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.
• Performs other duties as assigned.

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. Experience with data and information management, and hands on work with Big Data/NoSQL platforms at production scale.
  • [OR] Associate's degree in Information Technology, Data Analytics, or a related field, with six (6)+ years of relevant experience as described above.
  • [OR] High School Diploma, with eight (8)+ years of relevant experience as described above.

Preferred Experience
Candidates with one or more of the following skills will stand out:

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

Why should you join our team?
At Consumers Energy, we offer more than just a place to work. We foster a culture that supports career development, growth, and stability, and we take pride in offering our co-workers excellent benefits and compensation packages. We are deliberately creating an inclusive culture that makes our diverse team of co-workers feel valued, supported, and empowered every day. We're a company made up of thousands of people, all with different stories to share and work to do, but we stand united in our company purpose: world class performance delivering hometown service.
What we offer:

• Competitive compensation packages
• Medical, Dental and Vision
• 401k with company match
• Paid parental leave
• Up to 13 paid Holidays
• Paid time off
• Educational Assistance Program

Diversity, Equity & Inclusion:
We, at CMS Energy, value Diversity, Equity, & Inclusion. It is part of our DNA. We treat our employees with respect, we treat each other fairly and we value the opinions of others. We are passionate about building and nurturing an environment where everyone feels included. We don't discriminate. We seek to learn about each other and better understand our unique differences. Our uniqueness makes us authentic. We create safe spaces where everyone can be who they truly are. We invite difficult conversations and uncomfortable topics. We value diverse perspectives; this is what makes us great together. We harbor an inclusive environment where employees feel empowered to share their backgrounds, experiences, and ideas. Our Employee Resource Groups, Women in Energy (WE), Minority Advisory Panel (MAP), Pride Alliance of Consumers Energy (PACE), GENERGY, capABLE, Interfaith and Veterans Advisory Panel (VAP) are key enablers to living the values of our company culture: Caring, Empowered, Deliberate, Agility, and Ownership.
All qualified applicants will not be discriminated against and will receive consideration for employment without regard to protected veteran status, disability, race, color, religion, sex, age, sexual orientation, gender identity or national origin.