Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead data model projects and support analytics team with system enhancements.
- Company: Join a dynamic Change and Transformation team focused on data architecture.
- Benefits: Enjoy flexible working arrangements and collaborate on innovative projects.
- Why this job: Make a direct impact on enterprise data strategy while working with cutting-edge technology.
- Qualifications: 8-12 years of business analysis experience, especially in database systems and data modelling.
- Other info: Work hybrid in the UK and engage with cross-functional teams.
The predicted salary is between 54000 - 84000 £ per year.
Location: Hybrid, UK
Experience Level: 8-12 years
Contract Type: Contract
About the Role
We are seeking an experienced Senior Business Analyst with strong database and data modelling expertise to join our Change and Transformation team. This role combines strategic data architecture work with operational analytics support, requiring deep technical knowledge of database systems and data impact assessment capabilities. You will split your time between leading critical data model refinement projects (80% of role) and supporting our Data & Analytics team with system enhancement requirements (20% of role).
Key Responsibilities
- Data Model Architecture & Impact Assessment (80% - 4 days/week)
- Lead comprehensive impact assessments of proposed data model structure changes across our complex systems landscape
- Analyse dependencies and relationships between proprietary custom-built systems and external platforms (ServiceNow, etc.)
- Conduct detailed data mapping and dependency analysis to identify downstream effects of model changes
- Collaborate with technical architects to design optimal data model structures that minimise system disruption
- Document and communicate impact findings to technical and business stakeholders with clear risk assessments
- Develop migration strategies and implementation roadmaps for approved data model changes
- Work closely with Data Architecture team to ensure proposed models align with enterprise data strategy
- Gather and analyse requirements from Data & Analytics team for internal system improvements and reporting enhancements
- Translate analytical requirements into detailed technical specifications for development teams
- Design and document database schema changes required for new reporting capabilities
- Conduct feasibility assessments for proposed analytics and reporting solutions
- Coordinate with development teams to ensure accurate implementation of data and reporting requirements
- Support UAT activities for data and analytics system enhancements
- Create and maintain technical documentation for all data and analytics system changes
- Bridge the gap between data architects, developers, and business stakeholders
- Facilitate technical workshops and requirements gathering sessions
- Provide expertise on database design best practices and data governance
- Support data quality initiatives and system optimisation projects
- Contribute to enterprise data strategy and architecture decisions
Essential Requirements
- Database & Technical Experience
- 8-12 years of Business Analysis experience with minimum 5 years focused on database/data systems
- Expert knowledge of relational database design, normalisation, and data modelling principles
- Hands-on experience with SQL query writing, database performance optimisation, and data analysis
- Proven track record of conducting complex systems impact assessments
- Experience with ETL processes, data warehousing concepts, and reporting system design
- Knowledge of database platforms (SQL Server, Oracle, MySQL, PostgreSQL, or similar) and ideally warehouse solutions (Snowflake)
- Experience working with data transformation tools, including setting test parameters for quality.
- Deep understanding of enterprise system architectures and data flow dependencies
- Experience with both proprietary custom-built systems and commercial platforms (ServiceNow preferred)
- Strong knowledge of API integrations, data synchronisation, and system interfaces
- Cloud Based architecture awareness, ideally with Azure.
- Understanding of data governance, data quality, and master data management principles
- Experience with data migration projects and system consolidation initiatives
- Advanced requirements gathering and stakeholder management capabilities
- Proven ability to translate complex technical concepts for business audiences
- Experience with agile methodologies and working with development teams
- Strong documentation and process mapping skills, including UI wireframe creation
- Risk assessment and impact analysis expertise
What We Offer
- Opportunity to work on cutting-edge data architecture projects
- Direct impact on enterprise data strategy and system architecture
- Collaboration with Data Architecture and Analytics teams
- Flexible working arrangements
Reporting Structure
This role reports to the Director of Strategic Programs and will work closely with:
- Data Architecture team
- Data & Analytics team
- Development teams and technical architects
- Senior business stakeholders across all divisions
- External system vendors and integration partners
Data Transformation Business Analyst employer: Nigel Franks International
Contact Detail:
Nigel Franks International Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Transformation Business Analyst
✨Tip Number 1
Familiarise yourself with the specific database platforms mentioned in the job description, such as SQL Server, Oracle, and Snowflake. Having hands-on experience or even completing relevant online courses can give you a significant edge during discussions.
✨Tip Number 2
Brush up on your SQL skills, especially in writing complex queries and optimising database performance. Being able to demonstrate your technical prowess in SQL during interviews will show that you're ready for the challenges of this role.
✨Tip Number 3
Prepare to discuss your experience with data impact assessments and how you've successfully managed dependencies in previous projects. Real-life examples will help illustrate your capabilities and make you stand out.
✨Tip Number 4
Network with professionals in the data architecture field, particularly those who have experience with enterprise systems and data governance. Engaging in conversations can provide insights and potentially lead to referrals for the position.
We think you need these skills to ace Data Transformation Business Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience in database systems and data modelling. Focus on relevant projects where you've led impact assessments or collaborated with technical teams.
Craft a Compelling Cover Letter: In your cover letter, emphasise your expertise in relational database design and your ability to translate complex technical concepts for business audiences. Mention specific tools and methodologies you’ve used that align with the job requirements.
Showcase Relevant Experience: When detailing your work history, focus on your 8-12 years of business analysis experience, particularly the 5 years dedicated to database and data systems. Include examples of your work with ETL processes and data warehousing.
Highlight Collaboration Skills: Since this role involves cross-functional collaboration, mention any experience you have working with diverse teams, such as data architects, developers, and business stakeholders. Provide examples of how you facilitated workshops or gathered requirements.
How to prepare for a job interview at Nigel Franks International
✨Showcase Your Database Expertise
Make sure to highlight your extensive experience with relational database design and data modelling principles. Be prepared to discuss specific projects where you successfully conducted impact assessments and optimised database performance.
✨Demonstrate Analytical Skills
Prepare examples that illustrate your ability to gather and analyse requirements effectively. Discuss how you've translated complex analytical needs into technical specifications, ensuring clarity for development teams.
✨Emphasise Cross-Functional Collaboration
Talk about your experience working with diverse teams, including data architects, developers, and business stakeholders. Share instances where you facilitated workshops or sessions that bridged gaps between technical and non-technical audiences.
✨Prepare for Technical Questions
Expect questions related to systems integration, API knowledge, and cloud-based architecture. Brush up on your understanding of data governance and quality principles, as well as any relevant tools you've used in data transformation projects.
