Data Engineer

Talantir; Jackson (MI); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

Medical, Dental and Vision

401k with company match

Paid parental leave

Up to 13 paid Holidays

Paid time off

Educational Assistance Program

Job summary

Consumers Energy, Michigan’s leading energy provider, seeks a data-focused professional to join the Applications and Analytics team. The role focuses on building scalable data pipelines, dashboards, and data visualizations to enable evidence-based decisions and operational efficiency.

You will collaborate with business and IT teams to deliver reliable, user-friendly digital solutions. The position emphasizes agile delivery, data quality, and governance, with relocation support and onsite work in

Qualifications

• Bachelor’s degree in Computer Science, Engineering, Data Science, or a related field, plus two (2) years of software engineering experience.
• Associate’s degree in Computer Science, Engineering, Data Science, or a related field, plus four (4) years of software engineering experience.
• High School Diploma, plus six (6) years of software engineering experience, with the same beginner-level experience as outlined above.

Responsibilities

• Assemble and clean large datasets from multiple sources to support business requirements for enhancements.
• Capture and evaluate requirements from Data Architects or business partners, set timelines.
• Create data visualizations that support customer insights and KPIs using reporting tools.
• Identify opportunities to enhance internal processes and automate data tasks.
• Develop data pipelines and provide incident management and technical consulting support.

Skills

Analytical thinking

Verbal and written communication

Agile delivery

Stakeholder collaboration

Data testing

Data architecture

Education

Bachelor’s degree in Computer Science/Engineering/Data Science

Associate’s degree with 4 years experience

High School Diploma with 6 years experience

Tools

Databricks

Python

Spark/PySpark

dbt

Job description

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!

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 levels of the organization. Strong ability to establish and maintain effective working relationships with both business and IT teams. Understanding of data testing methodologies and related tools. Understanding of database management principles, data structures, data modeling, data warehousing, and transaction processing.

Education/Experience

Education/Experience Bachelor’s degree in Computer Science, Engineering, Data Science, or a related field, plus two (2) years of software engineering experience. Requires beginner-level experience in analytic tool development, data architecture and design, requirements definition, building large-scale data pipelines, ETL tool usage, basic data testing, and analytic tool deployment methodologies. [OR] Associate’s degree in Computer Science, Engineering, Data Science, or a related field, plus four (4) years of software engineering experience, with the same beginner-level experience as outlined above. [OR] High School Diploma, plus six (6) years of software engineering experience, with the same beginner-level experience as outlined above.

Preferred Experience

• Proficiency in building and operating pipelines in Databricks (Jobs/Workflows, parameterization, cluster policies, reusable libraries).
• Strong Python engineering skills for data (modular development, packaging patterns, logging, error handling, performance optimization).
• Solid Spark/PySpark experience (join strategies, partitioning, caching, skew mitigation, incremental processing).
• Experience designing dimensional models (facts/dimensions, conformed dimensions, SCD patterns, bridge tables).
• Proficiency with dbt (macros, snapshots, tests, documentation, exposures, CI integration, model refactoring).
• Experience implementing lakehouse/data architecture patterns (bronze/silver/gold layers, data product concepts, semantic consistency).
• Familiarity with governance and cataloging concepts (e.g., Unity Catalog-style organization, workspace/domain separation principles).
• Strong SQL skills for transformation and optimization (window functions, CTEs, query tuning).
• Experience connecting curated datasets to consumption tools (e.g., Power BI integration).
• Comfort working in Agile delivery environments and producing clear technical documentation and artifacts.

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.