Associate Data Analyst

DTE Energy; Detroit (MI); Hybrid; USD 55,000 - 85,000; Full time

Job summary

DTE Energy is seeking an entry-level data analyst to collect, review, validate, and structure business data for interpretation. You will perform statistical predictive analysis to derive insights and support better business decisions.

You will own data cleansing, develop dashboards, and train teams in self-service reporting, enabling scalable analytics across the enterprise.

Qualifications

• Degree with quantitative emphasis or coursework in statistics, CS, engineering, math, data science, economics.
• Strong background in quantitative analytics and data-driven decision making.
• Experience or coursework in extracting large data sets and ETL design is preferred.

Responsibilities

• Conducts data analysis to make business recommendations (cost-benefit, forecast, what-if).
• Owns data cleansing and accuracy for data elements used publicly.
• Develops processes, security, data quality and governance for enterprise data use.
• Ensures data integration with other domains to meet business requirements.
• Delivers findings with visual dashboards and clear presentations to stakeholders.
• Develops, updates, and automates reports and dashboards at scale.
• Collaborates with stakeholders to define end-to-end analyses, scorecards, and deliverables.
• Trains users on self-service reporting and BI tool usage.

Skills

SQL scripting

Data visualization

Business analytics

Stakeholder communication

Statistical analysis

Education

Bachelor's or Master's degree in a quantitative field

Tools

SQL

SAP

Oracle

PeopleSoft

Tableau

WebI

Lumira

Job description

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

• Entry level job responsible for collecting, reviewing, validating and structuring business data for interpretation. Performs statistical predictive analysis to derive insight and support better business decisions.

Key Accountabilities

• Conducts data analysis to make business recommendations (e.g., cost-benefit, invest-divest, forecasting, predictive, what-if, impact analysis, etc.)
• Owns data cleansing and accuracy for various data elements used publicly.
• Develops and manages processes, roles, security access, standards, data quality/integrity, etc. to ensure effective and efficient use of data throughout the enterprise.
• Ensures business process consistency and integration with other functional domains in order to meet DTE business requirements and solutions.
• Delivers effective presentations of findings and recommendations to multiple levels of stakeholders, creates visual displays of quantitative information.
• Develops, modifies, and automates reports, iteratively builds and prototypes dashboards to provide insights at scale, solving for analytical needs.
• Collaborates with cross-functional stakeholders to understand their business needs, formulates complete end-to-end analysis that includes data gathering, analysis, ongoing scaled deliverables, and presentations, through scorecards and dashboards.
• Trains and enables self-service reporting capability and use of business intelligence tools for their supported business unit(s).
• Develops actionable insights from in-depth data analysis to help DTE Energy focus on key decisions to improve products, services, and customer satisfaction.

Minimum Education & Experience Requirements

• Individuals who will be obtaining their degree within nine months from submitting interest will be considered; however, verification of the degree will be required prior to starting in the job

Other Qualifications

Preferred

• Bachelor's or Master's degree with emphasis on coursework of a quantitative nature (e.g, Statistics, Computer Science, Engineering, Mathematics, Data Sciences, Industrial/Organizational Psychology and Business Economics, etc)
• Background or coursework in in-depth quantitative analytics
• Experience in scripting with SQL, extracting large sets of data, and design of ETL flows
• Work experience in an interdisciplinary/cross-functional field
• Utility or customer-oriented industry experience

Other Requirements

• Intermediate-level experience with statistical packages (e.g, R, SAS, SPSS, Stata, MATLAB, etc)
• Experience articulating product questions, pulling data from relational databases technologies (e.g SAP, PeopleSoft, ORACLE, SQL), using statistical tools to solve business problems, and to conduct indepth analysis to support decision making
• Proficiency in Business Intelligence (BI) tools (e.g, Webi, Analysis, Lumira, Tableau etc)
• Excellent interpersonal, analytical and problem solving skills, including ability to communicate technical information and complex data analytics to a nontechnical audience
• Self-starter in advancing skillset in data, analytics and technical capabilities
• Ability to manage multiple projects at one time and meet tight deadlines
• Deep interest and aptitude in data, metrics, analysis, trends, statistics, and program evaluation
• Distinctive problem solving skills and strong business acumen
• Capable of translating analysis results into business recommendations
• Strong written and verbal communication skills

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

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.