Data Engineer

Data Engineer - Emergency Preparedness and Response Location: Detroit, MI, US Company: DTE Electric Company Job ID: 17094 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 Employment Sponsorship: This position is not eligible for visa sponsorship currently. Hybrid Role: This role is hybrid, with an established schedule of in-person work required at an assigned work location. Any remote work is expected to be performed from an employee’s primary residence, unless allowed (or prohibited) through the Company’s remote work guidelines. 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 Conducts data integration and analytics projects that automate data collection, transformation, storage, delivery, and reporting processes. Ensures optimization of data retrieval and processing, including performance tuning, delivery design for down-stream analytics, machine learning modeling, feature engineering, and reporting. Works across multiple areas/teams to develop data integration methods that advance enterprise data and reporting capabilities. Span of control: 0; individual contributor. Key Accountabilities Facilitates data engineering projects and collaborates with stakeholders to formulate end-to-end solutions, including data structure design to feed downstream analytics, machine learning modeling, feature engineering, prototype development, and reporting Works with business units, data architects, cloud engineers, and data scientists to identify relevant data, analyze data quality, design data requirements, and develop prototypes for proof-of-concepts Develops data sets and automated pipelines that support data requirements for process improvement and operational efficiency metrics Designs and implements data process pipelines in on-premise or Cloud platforms required for optimal extraction, transformation, and loading of data from multiple data sources Builds reporting and visualizations that utilize data pipeline to provide actionable insights into compliance rates, operational efficiency, and other key business performance metrics Designs and implements effective automation and testing strategies for data pipelines and processing methods Deploys and automates Machine Learning Models in a data environment (e.g., SQL server, Cloud platform, on-premise servers and machines), including workflow orchestration, scheduling and advanced data processing implementation, and data delivery tools Minimum Education & Experience Requirements This is a dual-track base requirement job; education and experience requirements can be satisfied through one of the following two options: Bachelor’s degree with emphasis on coursework of a quantitative nature (e.g., Computer Science, Mathematics, Physics, Data Science, Econometrics, etc.) and 3 years 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.) and 1 year of experience working in a data engineering, data analytical, or computer programming function. Other Qualifications Preferred Qualifications: Experience with cloud platforms and cloud commuting concepts (e.g., Azure) Business domain knowledge SQL Database design and query optimization experience Advanced business acumen Experience with utility/energy industry Knowledge of DTE’s ADMS Outage Management System and business processes Proficiency in SQL, including writing efficient queries and supporting basic data model or schema design. Intermediate programming skills in a modern language such as Python, C#, Java, or R to support data transformation and automation. Hands‑on experience building and maintaining data pipelines using cloud‑based platforms (e.g., Azure data services such as Data Factory, Databricks, or equivalent) Experience supporting analytics and reporting use cases using BI and data visualization tools (e.g., Power BI / Microsoft Power Platform) Experience integrating data from multiple source systems with attention to data quality and reliability. Demonstrated proficiency in developing or deploying artificial intelligence models Ability to partner with business stakeholders to clarify requirements, ask the right questions, and turn them into actionable data pipelines and datasets. Demonstrated examples of written and oral communication skills such as oral presentations, detailed status reports and training delivery Other Requirements: Intermediate-level programming skills in structured query language (e.g., SQL) Intermediate-level programming skills in a modern programming language (e.g., C#, Python, R, Java, etc.) Experience in agile development and working with continuous integration/continuous delivery (CI/CD) pipelines Intermediate-level ability in articulating business questions and pulling data from relational databases Intermediate-level proficiency in business intelligence tools and data blending tools (e.g., Microsoft Power Platform, Power BI, etc.) Proficiency with Big Data platforms, including data extraction and connection to the platform for analytics (e.g., Azure Data Factory, Azure Databricks, Hive, Spark, etc.) Ability to adapt to software platforms for retrieving, analyzing, sharing, and visualizing data Ability to identify optimal analytical tools based on problem requirements Analytical, problem solving, planning, and decision-making skills, with ability to identify key issues from a broad range of alternatives and recommend optimal solutions Advances self and other’s knowledge and skillset 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) Ability to work overtime during peak periods; flexibility in working hours required Proficiency with cloud commuting concepts Ability to collaborate effectively with an agile team by managing expectations about delivery timelines and explaining complex technical conceps effectively 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. 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. #J-18808-Ljbffr