Data Engineer

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 position is onsite minimally 3 days a week at 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 Data Engineer is responsible for collaborating with analytic teams and business partners across the enterprise to gather data requirements and design, build, and maintain data pipelines and architecture in alignment with IT best practices. Key responsibilities include developing data warehouses; designing, extracting, and loading data; testing data solutions; performing data modeling; and ensuring the reliability and performance of data applications. The role also involves building analytic tools, preparing and cleaning large datasets, developing ETL solutions using various technologies, creating data visualizations, and identifying opportunities to automate manual data processes. The Data Engineer will seek guidance from Senior and Principal Data Engineers and Data Architects as needed. 
 

Essential Duties and Responsibilities

• Assemble and clean large datasets from multiple sources to support functional business requirements for small to large enhancements. 
• Capture and evaluate requirements from Data Architects or business partners, assess development alternatives, and establish timelines. 
• Create data visualizations that support customer insights, operational efficiency, and key business performance metrics using various reporting tools. 
• Identify opportunities to enhance internal processes, automate manual data tasks, optimize performance, and improve overall data quality. 
• Prepare artifacts that support proposed solutions and document project activities. 
• Provide incident management and technical consulting support for existing applications and solutions. 
• Offer technical guidance for enhancements of varying complexity, including solution alternatives, design, testing, and documentation. 
• Partner with stakeholders and IT teams to design and develop efficient data pipelines for enhancements of all sizes. 
• Perform other duties as assigned or as necessary. 

Knowledge/Skills/Abilities

• Ability to work effectively with contract employees and vendors. 
• Knowledge of change and release tools and processes used to implement solutions across multiple teams and technologies. 
• Understanding of data design principles and systems engineering concepts, including structured design, supportability, survivability, reliability, scalability, and maintainability. 
• Knowledge of project planning and full lifecycle delivery within an Agile framework. 
• Excellent verbal and written communication skills with the ability to work across all leve