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.)
• Business domain knowledge
• Database design and query optimization experience

Other Requirements:

• Basic to intermediate-level programming skills in structured query language (e.g., SQL, Java, Python, etc.)
• Ability to articulate business questions through pulling data from relational databases
• Proficient with business intelligence tools and data blending tools (e.g., Microsoft Power Platform)
• Proficient with Big Data platforms, including data extraction and data connections for analytics
• Ability to adapt to software platforms for retrieving, analyzing, sharing, and visualizing data
• Ability to identify optimal analytical tools based on problem requirements
• Advances self and other’s knowledge in business processes, new analytical frameworks, and data-driven technologies and applications
• Ability to communicate technical information and complex data analytics to a non-technical audience in a clear and concise manner (in both verbal and written form)

Additional Information

Incumbents may engage in all or some combination of the activities and accountabilities and utilize a variety of the competencies cited in this description depending upon the organization and role to which they are assigned.  This description is intended to describe the general nature and level of work performed by incumbents in this job.  It is not intended as an all-inclusive list of accountabilities or responsibilities, nor is it intended to limit the rights of supervisors or management representatives to assign, direct and control the work of employees under their supervision.

#LI-TD1

PRIVACY NOTICE TO CALIFORNIA JOB APPLICANTS 
 

At DTE Energy, we are committed to providing an inclusive workplace where everyone feels welcome and a sense of belonging. We seek individuals with a heart for service, a passion to help our communities prosper, and ideas to help shape the future of energy. We are proud to be an equal opportunity, employer that considers all qualified applicants without regard to race, color, sex, sexual orientation, gender identity, age, religion, disability, national origin, citizenship, height, weight, genetic information, marital status, pregnancy, protected veteran status or any other status protected by applicable federal and/or state laws.