FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in defining and building BI and Data Warehouse logical and physical models, including data lake architectures, while effectively facilitating client workshops to gather and translate data requirements into actionable data models.
Highest-signal resume keywords
Data Architecture ExpertiseBI/Data Warehouse ModellingClient Workshop FacilitationData Modelling Tools ProficiencyRelational Database Technologies
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Data Lakehouse ModelsData MeshData Flow DefinitionLogical Data ModelsPhysical Data ModelsSource-to-Target Data MappingNormalised ModelsDimensional ModelsData MigrationData Warehouse Architecture
Soft Skills
Analytical SkillsProblem SolvingOrganisational SkillsCo-ordination SkillsTeam Leadership
Tools & Technologies
ErwinIBM Rational System ArchitectOracleSQL Server
Certifications & Qualifications
SC Clearance Eligibility
Industry Keywords
Data ManagementBusiness IntelligenceData ArchitectureData ModellingData Analysis
Tech Stack
Tools & technologiesOracleSQL
About the role
Key responsibilities & impact- Work in delivery teams, analysing data and comparing it to requirements
- Facilitate client workshops and interviews to gather requirements and turn them into data models
- Define conceptual, logical, and physical data models using Inmon, Kimball, and data lakehouse models
- Define data flows for BI, Data Warehouse, and Data Migration applications, including source-to-target data mapping
- Contribute to bid and project solution architecture definitions
- Participate in pre-sales and bid efforts to define and explain BI and data management solution architectures
- Act as design authority for small to large BI or Data Management application projects
- Own delivery of the data architecture and models supporting projects
- Work directly with clients to deliver data architectures in required formats using agreed data design and modelling tools
Requirements
What you’ll need- In-depth understanding of modern data architectures, including data lakehouses, data mesh, and hyperscaler offerings
- Demonstrable experience defining and building BI/Data Warehouse logical and physical models, including normalised and dimensional models, and data lake architectures
- Expertise in at least one data modelling tool, preferably Erwin and/or IBM Rational System Architect
- Expertise in running client workshops to extract and understand client data requirements and turn them into data models
- Thorough appreciation of architecture, design, and data-related issues affecting Data Warehouse and BI applications
- Experience across relational and database technologies, including Oracle and SQL Server
- Good analytical skills and a logical approach to problem solving
- Pragmatic and detail orientated
- Excellent organisational and co-ordination skills
- Demonstrable team leadership attributes
- To be eligible for SC clearance, must have lived and worked in the UK continuously for the past 5 years
Benefits
Comp & perks- Pension Scheme - contributions matched up to 10%
- Private medical cover
- Income Protection
- Life Assurance
- 25 days paid leave + National Holidays
- Flex benefits program
- Continuous training, certifications, and career development opportunities
- High Business Impact – Drive meaningful outcomes and contribute to strategic objectives
- Strong Project Exposure – Gain visibility through a high-profile, business-critical project