Job type
ContractLocation
BerkshireWorking Pattern
Full-timeSpecialism
Data & Advanced AnalyticsIndustry
Manufacturing & ProductionPay
£20 - £25 per hour, Inside Ir35
Data Analyst, SQL, Power BI, 5 Days On-Site, 3-month contract
Your new role
This is a hands-on role that combines Excel, Access, SQL and application configuration, giving you the opportunity to work directly with customer data and gain a deep understanding of how business systems operate behind the scenes. You'll be responsible for preparing and importing customer datasets, validating outcomes, troubleshooting issues, and helping configure how information is presented within the application.
If you enjoy problem-solving, working with data, and understanding how databases and applications interact, this role offers an excellent opportunity to develop a broad technical skill set in a supportive environment.
Key Responsibilities
Data Preparation & Transformation
- Prepare, cleanse and structure customer datasets using Microsoft Excel.
- Utilise formulas, lookups, data validation and transformation techniques to ensure data quality.
- Review and resolve data anomalies prior to import.
Database Management
- Import customer data into an Access-based database.
- Maintain data integrity throughout the import and validation process.
- Understand database structures, including tables, relationships and queries.
SQL & Data Analysis
- Write and modify SQL queries within Access.
- Extract, analyse and validate data for testing and reporting purposes.
- Investigate data discrepancies and support issue resolution.
Application Testing & Configuration
- Validate imported data within the live business application.
- Test functionality and confirm customer data is displayed accurately.
- Configure screens, views and interface elements to present SQL output clearly to end users.
- Support ongoing enhancements to improve the user experience.
Continuous Improvement
- Identify opportunities to improve data quality and data-loading processes.
- Work closely with developers and application specialists to resolve issues.
- Contribute ideas to improve workflow efficiency and reporting accuracy.
What you'll need to succeed
- Strong Microsoft Excel skills, including formulas, lookups and data manipulation.
- Experience working with Microsoft Access databases.
- Basic SQL query writing and data analysis skills.
- Strong attention to detail and accuracy.
- Excellent problem-solving and analytical abilities.
- Ability to learn new systems quickly.
What you'll get in return
- Work with real customer data and see the immediate impact of your work.
- Gain valuable experience across Excel, Access, SQL and application configuration.
- Learn the inner workings of a proprietary business application.
- Receive direct support and mentoring from the team that designed and built the system.
- Develop skills that provide an excellent foundation for a career in Data, Business Systems, Application Support or Business Intelligence.
- Enjoy a varied role with genuine opportunities to learn and grow.
What you need to do now
If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.
If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion about your career.
