Data Engineer

CMS Energy, Corp.; Jackson (MI); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

Medical, Dental, Vision

401k with company match

Paid parental leave

Paid holidays

Educational assistance

Job summary

Consumers Energy is seeking a Data Engineer to partner with analytics teams and business stakeholders to design, develop, and maintain data pipelines and architectures. The role supports data warehouses, ETL processes, data models, testing strategies, and performance optimization.

You will build analytical tools, assemble large datasets, and create data visualizations while seeking opportunities to automate manual data preparation and improve data quality.

Qualifications

• Bachelor's degree in computer, engineering, data sciences or related field with two (2) or more years of data engineering or software engineering experience.
• Associate's degree with four (4) or more years of data engineering or software engineering experience.
• High School Diploma/GED with six (6) or more years of data engineering or software engineering experience.

Responsibilities

• Gather and evaluate requirements from Data Architects and stakeholders; set project timelines.
• Assemble, cleanse, and prepare large datasets from multiple sources.
• Collaborate to design scalable data pipelines.
• Develop data visualizations and reporting for customer insights and KPIs.
• Identify opportunities to automate data prep and improve quality.
• Prepare technical documentation and artifacts for solutions.
• Provide guidance for design, testing, and implementation activities.
• Support incident management and production support for existing solutions.

Skills

Communication

Stakeholder relations

Agile methodologies

Data testing

Collaboration

Database management

Data modeling

Data warehousing

Change management

Deployment processes

Education

Bachelor's degree in computer science / engineering / data sciences or related field

Associate's degree in computer science / engineering / data sciences or related field

High School Diploma / GED with 6+ years experience in data engineering or software engineering

Tools

Databricks

Delta Lake

Delta Live Tables

Databricks Workflows

Unity Catalog

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 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 Data Engineer is responsible for partnering with analytics teams and business stakeholders across the enterprise to gather data requirements and design, develop, and maintain data pipelines and architectures in accordance with established IT standards and best practices. This role supports the development of data warehouses, data extraction and loading processes, data models, testing strategies, and application performance optimization.

The Data Engineer will build analytical tools, assemble and prepare large and complex datasets, design and develop ETL solutions using various technologies, create data visualizations, and identify opportunities to automate manual data preparation processes. Additionally, this role focuses on improving data quality, optimizing system performance, and ensuring the reliability and scalability of data solutions. Guidance from Senior and Principal Data Engineers, as well as Data Architects, will be sought as needed.

Essential Duties and Responsibilities

• Gather and evaluate requirements provided by Data Architects and business stakeholders; assess development alternatives and establish project timelines.
• Assemble, cleanse, and prepare large and complex datasets from multiple data sources to support business requirements for small and large-scale enhancements.
• Collaborate with business partners, stakeholders, and IT teams to design and develop efficient, scalable data pipelines.
• Develop data visualizations and reporting solutions that provide customer insights, operational efficiencies, and key business performance metrics.
• Identify opportunities to automate manual data preparation and transformation processes, improve data quality, and optimize system performance.
• Prepare technical documentation and project artifacts that support solution development and project deliverables.
• Provide technical guidance and support for solution design, testing, documentation, and implementation activities.
• Support incident management processes and provide technical consulting and production support for existing applications and solutions.
• Perform other duties as assigned.

Knowledge/Skills/Abilities

• Excellent verbal and written communication skills with the ability to effectively interact with all levels of the organization.
• Demonstrated ability to establish and maintain productive working relationships with business and IT teams.
• Knowledge of project planning and full software development lifecycle delivery using Agile methodologies.
• Understanding of data testing methodologies, quality assurance practices, and testing tools.
• Ability to collaborate effectively with contractors, consultants, vendors, and cross-functional teams.
• Understanding of database management principles and methodologies, including data structures, data modeling, data warehousing, and transaction processing.
• Knowledge of data design principles, methodologies, and best practices, including concepts such as structured design, scalability, reliability, maintainability, supportability, and survivability.
• Familiarity with change management, release management tools, and deployment processes across multiple technologies and teams.

Education/Experience

• Bachelor's degree in computer, engineering, data sciences or related field with two (2) or more years of data engineering or software engineering experience. Beginner level experience with analytic tool build, data architecture/design, user requirements definition, build BIG data pipeline, understanding of ETL tool extraction, basic data testing aptitude, and understanding of analytic tool deployment processes and best practices.
  • [OR]Associate's degree in computer, engineering, data sciences or related field with four (4) or more years of data engineering or software engineering experience. Beginner level experience with analytic tool build, data architecture/design, user requirements definition, build BIG data pipeline, understanding of ETL tool extraction, basic data testing aptitude, and understanding of analytic tool deployment processes and best practices.
  • [OR] High School Diploma/GED with six (6) or more years of data engineering or software engineering experience. Beginner level experience with analytic tool build, data architecture/design, user requirements definition, build BIG data pipeline, understanding of ETL tool extraction, basic data testing aptitude, and understanding of analytic tool deployment processes and best practices.

Preferred Experience

• Demonstrated experience designing and building scalable data pipelines using Databricks technologies, including Delta Lake, Delta Live Tables (DLT), Databricks Asset Bundles, Databricks Workflows, Unity Catalog, Structured Streaming, and Lakehouse Architecture.
• Working knowledge and practical application of Medallion Architecture principles.
• Strong experience in data modeling, including the design and implementation of star schema models.
• Experience developing, implementing, and maintaining data quality frameworks, validation rules, and monitoring processes.
• Experience leveraging CI/CD pipelines and DevOps best practices to support data engineering development, deployment, and operational efficiency.

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 HolidaysPaid 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 (Different Generations), capable (Different Abilities), Interfaith, People Planet Partners, 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.

Consumers Energy is an Equal Opportunity Employer, please review our Equal Employment Opportunity Policy, Family and Medical Leave Act, and Military Leave Allowance. CMS Energy endeavors to make https://careers.consumersenergy.com/ accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact our team at [e-mail]. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. ACCOMMODATION NOTICE: Federal law and many state laws require employers to make accommodations to disabled applicants and employees where the accommodation does not impose an undue hardship on the employer. For those applicants seeking a position within the State of Michigan, a disabled individual needing accommodation for employment must notify the employer in writing within 182 days after the need is known or should have been known. Michigan law provides that failure of a Michigan employee to properly notify the employer will preclude any claim that the employer failed to accommodate the disabled individual. However, this does not waive an individual’s right under the Americans with Disabilities Act of 1990, as amended, which sets no time limit for requesting an accommodation nor does it require such accommodation in writing.