Job Title: Data Analyst
Industry: Utilities / Energy Services
Location: Detroit, MI – Hybrid Tues–Thurs onsite (3 days onsite)
Duration: 10–12 months – W2 Contract
Schedule: Full-time | 40 hours per week
Qualifications
• 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
• Experience in scripting with SQL, extracting large sets of data, and design of ETL flows
• Work experience in an interdisciplinary/cross functional field
• 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
Responsibilities
• 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 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 focus on key decisions to improve products, services, and customer satisfaction