Associate Data Engineer

 DTE is one of the nation’s largest diversified energy companies. Our electric and gas companies have fueled our customer’s homes and Michigan’s progress for more than a century. And as Michigan’s largest source of renewable energy, we’re creating a cleaner, healthier environment to power our future. We’re also serving communities beyond Michigan, where our affiliated businesses offer renewable energy, emission control technologies, and energy services to industries in 19 states.
 

But we’re more than a leading energy company... and working at DTE is more than just a job. At DTE, we take great care of each other and our customers, and we use our energy to be a force for growth and prosperity in our communities.  When you join us, you’ll be part of a team that welcomes, recognizes, and celebrates differences and values everyone’s health, safety, and wellbeing.  Are you ready to make that kind of difference? Bring your energy to DTE. Together, we can achieve great things.
 

Testing Required: Not Applicable

Hybrid Role: Must be able to come on-site periodically and reside a commutable distance from the assigned work location.

Emergency Response: Yes – Must be available to perform a primary assignment in support of DTE’s emergency response to storms or other events that impact service to our customers.

Job Summary

Supports data integration and analytics projects involving enhancements to data collection, automation, transformation, storage, delivery, and reporting processes.  Works with teams to provide data engineering analysis for data retrieval and data processing, including performance tuning, delivery design for down-stream analytics, machine learning modeling, feature engineering, and reporting. Provides support to more experienced team members for data engineering projects. Span of control: 0; individual contributor.

Key Accountabilities

• Builds data process pipelines (in on-premise or Cloud platforms) required for optimal extraction, transformation, and loading of data from a wide variety of data sources
• Performs analysis required to troubleshoot data related technical issues and assist in the resolution of data issues, including maintaining optimal data transformation processes
• Deploys and automates machine learning models in a data environment (e.g., structured query language (SQL) servers, cloud platforms, on-premise servers, etc.)
• Builds data structures to accommodate business intelligence tools or machine learning models and refines these data structures based on simulated data growth
• Provides data engineering support to project teams involving data architects, server engineers, and data scientists to help identify relevant data, analyze data quality, design data processing pipeline, and develop prototypes
• Assembles large, complex structured and un-structured data sets that meet business requirements and prepares reporting/visualizations based on the data pipeline design/analysis
• Works to identify and automate manual processes, optimize data delivery, and re-design infrastructure for greater scalability

Minimum Education & Experience Requirements

This is a multi-track base requirement job; education and experience requirements can be satisfied through one of the following options:

Minimum Education and Experience:

• Bachelor’s degree with emphasis on coursework of a quantitative nature (e.g., Computer Science, Mathematics, Physics, Data Science, and Econometrics, etc.) and 1 year of experience working in a data engineering, data analytical, or computer programming function; OR
• Master’s degree with emphasis on coursework of a quantitative nature (e.g., Computer Science, Mathematics, Physics, Data Science, Econometrics, etc.) 

Other Qualifications

Preferred:

• Intermediate-level proficiency in business intelligence tools and data blending tools (e.g., Power BI, etc.)
• <