Data Integrity Administrator
Role details
Job location
Tech stack
Job description
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. This position will report to an IT Manager and will be required to report to the Milton Keynes, UK office location, as determined by SHI Management. Role Description Include but not limited to; + 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. Behaviours 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 Data Integrity Administrator 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., This position will report to an IT Manager and will be required to report to the Milton Keynes, UK office location, as determined by SHI Management., * 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.
Behaviours 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.
Requirements
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. SHI UK is an equal opportunity employer and does not discriminate on the basis of race, religion, gender, sexual orientation, national origin, age, disability, or any other legally protected status. We encourage applications from all qualified candidates and we are dedicated to providing a fair and accessible recruitment process. #LI-MB3 Equal Employment Opportunity - M/F/Disability/Protected Veteran Status, * 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.
