Data Engineer

Socket.dev; Jackson (MI); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical, Dental, Vision

401k with company match

Paid time off

13 paid holidays

Educational Assistance Program

Job summary

Consumers Energy in Michigan seeks a Data Engineer to design, develop, and maintain data pipelines and architectures in line with IT standards. You will partner with analytics teams and business stakeholders to gather requirements and translate them into scalable data solutions.

The role focuses on ETL, data warehouses, data quality, and performance optimization, with guidance from senior engineers. Hybrid work with some onsite days in Jackson, MI is available.

Qualifications

• 2+ years in data engineering or software engineering.
• Strong understanding of ETL and data warehousing concepts.
• Experience with data quality and data governance practices.

Responsibilities

• Gather and evaluate requirements from data architects and stakeholders.
• Assemble, cleanse, and prepare large data sets from multiple sources.
• Design and develop scalable data pipelines and ETL processes.
• Develop data visualizations and reporting solutions for insights.
• Identify opportunities to automate data prep and improve data quality.
• Prepare technical documentation and project artifacts.

Skills

Data pipelines

SQL

Python

Communication

Agile

Data modeling

Education

Bachelor's degree in CS/Engineering/Data Science

Associate degree

High School Diploma

Tools

Databricks

Delta Lake

CI/CD

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