Data Transformation Business Analyst
- Shoreham-by-Sea, West Sussex
- Contract
- Full-time
- 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
- 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, MySQLPostgreSQL, 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
- 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
- Data Architecture team
- Data & Analytics team
- Development teams and technical architects
- Senior business stakeholders across all divisions
- External system vendors and integration partners