Job SummaryThe Data Analyst collaborates with SHI management to support data-driven requests and initiatives, conducting data collection, analysis, and performance tracking across various segments. This role involves generating and merging reports from multiple databases, writing PowerBI reports, and performing ad-hoc analysis to identify opportunities and develop scenarios. The Data Analyst will assist with business cases, deliver monthly and quarterly reporting on financial and operational KPIs, and work closely with stakeholders to enhance data for analysis and performance management.
Role Description- Collaborate with SHI management to support numerous requests and project initiatives including from other SHI departments based on data.
- Data collection & analysis of activity including forecasts across various segments and milestones.
- Track & detail activity and performance against goals, forecasts and Plan.
- Account Mapping by locating the appropriate salesperson for assigned list of leads.
- Generate reports from multiple databases/data sets merging into spreadsheets and/or database.
- Write reports in PowerBI for reporting and performance management.
- Analyze, interpret, format, and summarize data for management review.
- Work with stakeholders to obtain, validate, and enhance data utilized for analysis and performance tracking.
- Perform ad-hoc analysis that aids in identifying opportunities, creating assumptions, and developing scenarios.
- Assist with business cases defined with clear scope, intended outcomes, quantifiable benefits, and expenses.
- Monthly and quarterly reporting focused on the entire portfolio of initiatives. This will include:
- Financial performance: measure expense and savings on a profit and loss statement (P&L), cash flow impact, working capital impact, or productivity benefit.
- Operational KPIs: tracking hours saved, utilization, # of instances, etc., depending on the project.
- Commentary: work with initiative owners to identify drivers for the month, quarter, and future outcomes.
Behaviors and Competencies- Analytical Thinking: Can apply critical thinking to analyze data, identify patterns, and make basic inferences.
- Data Analysis: Can identify patterns and trends in data, propose hypotheses, and use statistical techniques to test them.
- Data Literacy: Can identify relevant data sources, collect data, and use basic tools to interpret and report findings.
- Critical Thinking: Can analyze and interpret data to inform decision-making, and propose solutions based on logical reasoning.
- Attention to Detail: Can identify errors or inconsistencies in work and make necessary corrections.
- Communication: Can effectively communicate complex ideas and information, and can adapt communication style to the audience.
- Problem-Solving: Can identify problems, propose solutions, and take action to resolve them without explicit instructions.
- Technical Expertise: Can apply technical knowledge and skills effectively in most situations, with occasional guidance.
- Time Management: Can generally use time effectively and is working towards improving task prioritization and deadline management.
- Continuous Improvement: Can identify moderate areas for improvement and implement moderate changes.
Skill Level Requirements- Database management and reporting skills - Intermediate
- Strong organizational skills - Intermediate
- Experience with customer relations and satisfaction - Intermediate
- Ability to multitask and complete tasks with efficiency and accuracy - Intermediate
- Ability to follow direction while working individually and in a team environment - Intermediate
- Ability to accept, understand, and learn from management feedback - Intermediate
- Ability to work effectively within all levels of an organization, both internally and externally - Intermediate
- Strong negotiation skills with the ability to influence stakeholders - Intermediate
Other Requirements- Bachelor's degree or equivalent experience required.
- 2-4 years of experience in a data and analysis-related field.
- Advanced knowledge of Microsoft Excel & Access for reporting and database management
- Proficient with Microsoft Office applications
- Working knowledge of finance concepts, principles, and practices preferred.
The estimated annual pay range for this position is $70,000 - $100,000 which includes a base salary and bonus. The compensation for this position is dependent on job-related knowledge, skills, experience, and market location and, therefore, will vary from individual to individual. Benefits may include, but are not limited to, medical, vision, dental, 401K, and flexible spending.
