DTE Energy

Associate Data Analyst

DTE Energy

full-time

Posted on:

Location Type: Office

Location: Detroit • Missouri • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Job Level

JuniorMid-Level

Tech Stack

ETLOracleSQLTableau

About the role

  • 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.
  • 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.

Requirements

  • Minimum: Bachelor's degree. 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
  • 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
  • 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.
Benefits
  • 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.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
data analysisstatistical predictive analysisdata cleansingETL designscripting with SQLquantitative analyticsstatistical packagesBusiness Intelligence toolsdata visualizationdashboard prototyping
Soft skills
interpersonal skillsanalytical skillsproblem solving skillscommunication skillsself-starterproject managementbusiness acumenability to meet deadlinescollaborationpresentation skills