Join the diverse and dynamic team that powers Michigan's largest energy provider and one of the nation's largest gas and electric combination utilities.  Consumers Energy services 6.8 million of Michigan's 10 million residents - caring for our friends and neighbors in all 68 Lower Peninsula counties.  We embrace a cleaner and leaner utility vision focused on eliminating energy waste and adding renewable energy from sources such as wind and solar.

 

LOCATION: The successful candidate will be expected to work in a hybrid status of reporting to any Consumers Energy Service Center every Monday, Tuesday, and Thursday with home office flexibility on Wednesday and Friday.

 

GENERAL SUMMARY OF JOB RESPONSIBILITIES:

The Data Engineer will be responsible for partnering with various analytic teams and business partners throughout the enterprise to collect data requirements and design and build data pipelines/architecture as per IT best practices defined. Creating a data warehouse, design-related extraction, loading data functions, testing designs, data modeling, and ensure the smooth running of applications. Building analytic tools, assembling and cleaning BIG data, designing and building ETL using various technology languages, creating data visualization, assembling large data and identifying and improving internal process to automate manual data wrangling, optimizing performance, and improve data quality. Seek guidance from Senior/Principal Data Engineers and Data Architects as needed.
 

ESSENTIAL DUTIES AND RESPONSIBILITIES: Design Kimball based dimension and fact tables based on business requirements. New designs must contribute to  the overall team data model if applicable Assemble and clean BIG data; data sets including various data sources to meet functional business requirements for small to large enhancements Capture/evaluate requirements from the data architect or business partner Consider development alternatives, and establish timelines Create data visualizations for customer insight, operational efficiency and other key business performance metrics using various reporting tools Identify opportunities to improve internal process to automate manual data wrangling, optimizing performance, and improve data quality Prepare artifacts to support solutions as well as to document activities as part of a project Provide incident management and direct technical consulting and support for current applications/solutions Provide technical guidance for small to large enhancements in areas of solution alternatives, design, testing and documentation Work with Various Stakeholders/IT to design and build efficient data pipelines for small to large enhancements Other duties as assigned or may be necessary

 

KNOWLEDGE/SKILLS/ABILITIES: Knowledge of project planning/full lifecycle delivery using Agile framework, preferably using ADO Understanding of data test methodologies and testing tools Understanding of database management principles and methodologies, including data structures, data modeling, data warehousing and transaction processing Proficiency in Python, SQL and Kimball design concepts must be demonstratable Knowledge of data design principles (dimension/fact), methods and approaches Able to apply systems engineering concepts such as: data structured design, supportability, survivability, reliability, scalability and maintainability Ability to work effectively with contract employees and vendors Knowledge of change and release tools and processes utilized to implement solutions across multiple teams and technologies Knowledge of data design principles, methods, and approaches, applying systems engineering concepts such as: data structured design, supportability, survivability, reliability, scalability, and maintainability Knowledge of project planning/full lifecycle delivery using Agile framework Must have excellent verbal and written communication skills and be able to work with all levels of the organization Proficient in establishing and maintaining good working relationships (business and IT teams) Understanding of data test methodologies and testing tools Understanding of database management principles and methodologies, including data structures, data modeling, data warehousing, and transaction processing
 

EDUCATION/EXPERIENCE:

Bachelor’s degree in computer, engineering, data sciences or related field with two (2) or more years of applicable experience [OR] Associate’s degree in computer, engineering, data sciences or related field with four (4) or more years of applicable experience [OR] High School Diploma with six (6) or more years of applicable experience

 

2 - 4 years 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 required
 

PREFERRED SKILLS:

Experience with Python, SQL, ADF, DBT and Databricks 

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’s Advisory Panel (WAP), Women’s 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.