DTE Energy Data Analyst in Detroit, Michigan
Detroit, MI, US
Company: DTE Electric Company
Job ID: 7837
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
Intermediate job responsible for collecting, reviewing, validating and structuring business data for interpretation. Performs statistical, quantitative, and/or predictive analysis to derive insight and support better business decisions. This role also includes the responsibility of serving as the data steward for all data within the discipline. Additionally, this role requires you to teach others the tools, techniques and best practices in self-service reporting and data handling.
Conducts data analysis to make business recommendations (e.g., cost-benefit, invest-divest, forecasting, predictive, what-if, impact analysis, etc.)
Provides data stewardship through ongoing monitoring of data elements, strategic planning on entry points, cleansing plans, data sources, structural design of data model, and integration with other systems.
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
Bachelor's degree and 3+ years of experience working in a data and analytical function
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 in-depth analysis to support decision making
BS in Computer Science
Demonstrated experience with creating Power BI dashboards
Managing large data sets and writing SQL queries to Maximo and SAP databases
Operations dashboard experience reporting various BU metrics
Cost per unit analysis and reporting
Excellent interpersonal, analytical and problem solving skills, including ability to communicate technical information and complex data analytics to a nontechnical audience
Demonstrated proficiency in Business Intelligence (BI) tools (e.g, Webi, Analysis, Lumira, Tableau, etc)
Intermediate knowledge of applied research design, including multivariate statistical analysis
Demonstrated 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.
Skilled in the data model and functionality of BW and BOBJ (Business Objects) tools.
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 law.