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.
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 Senior Data Engineer operates independently with minimal supervision and is responsible for collaborating with various analytics teams and business partners across the enterprise to gather data requirements, and design and build data pipelines and architecture in alignment with IT best practices. Responsibilities include developing data warehouses, designing extraction and loading functions, testing data models, and ensuring the smooth operation of data applications. The role also involves building analytical tools, assembling and cleansing large datasets, designing and implementing ETL processes using various technologies, creating data visualizations, and identifying opportunities to automate manual data wrangling processes to optimize performance and enhance data quality.
Essential Duties and Responsibilities
Provide technical leadership in incident management and offer consulting and support for existing applications and solutions.
Assemble and cleanse large, complex datasets from various sources to meet business requirements for medium to large-scale enhancements, IT projects, or technical modeling initiatives.
Capture and evaluate requirements from data architects or business stakeholders, assess development alternatives, and establish project timelines.
Develop analytical tools that leverage data pipelines to deliver actionable insights into customer acquisition, operational efficiency, and other key business metrics.
Collaborate with stakeholders and IT teams to design and implement efficient data pipelines for medium to large-scale projects.
Design and create advanced data visualizations to support customer insights, operational efficiency, and performance metrics using various reporting tools.
Prepare, review, and approve documentation and artifacts to support solution development and implementation.
Provide technical expertise for medium to large-scale projects in areas such as solution design, testing, and documentation.
Identify and improve internal processes to automate manual data wrangling, enhance performance, and improve data quality.
Perform other duties as assigned or required.
Knowledge/Skills/Abilities
Strong understanding of data testing methodologies and tools.
Proficient in database management principles, including data structures, modeling, warehousing, and transaction processing.
Knowledge of data design principles and systems engineering concepts such as structured design, supportability, reliability, scalability, and maintainability.
Excellent verbal and written communication skills; able to engage effectively with all levels of the organization.
Skilled in building and maintaining productive relationships with business and IT teams.
Familiarity with project planning and full lifecycle delivery using Agile methodologies.
Ability to work effectively with contractors and vendors.
Understanding of change and release management tools and processes across multiple teams and technologies.
Education/Experience
Bachelor's degree in computer, engineering, data sciences or related field with four (4) or more years of experienceas anintermediate data engineer. Experience with advanced analytic tool build, data architecture/design, user requirements definition, build BIG data pipeline, understanding of ETL tool extraction, basic data testing aptitude, and/or understanding of analytic tool deployment processes and best practices
[OR]Associate'sdegree in computer, engineering, data sciences or related field with six (6)or more years of experienceas anintermediate data engineer. Experience with advanced analytic tool build, data architecture/design, user requirements definition, build BIG data pipeline, understanding of ETL tool extraction, basic data testing aptitude, and/or understanding of analytic tool deployment processes and best practices
[OR]High School Diploma/GED with eight (8) or more years of experienceas anintermediate data engineer. Experience with advanced analytic tool build, data architecture/design, user requirements definition, build BIG data pipeline, understanding of ETL tool extraction, basic data testing aptitude, and/or understanding of analytic tool deployment processes and best practices
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... For full info follow application link.
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, sexual orientation, gender identity or national origin.
