Role description
Role: Data Analyst/Data Modelling Analyst
Hybrid working model with 3 days work from office
Permanent/ Fixed term/ Contract inside IR 35
Long term contract duration
Immediate start
Min 10+ years of data analysis/ data modelling experince preferred
Applicants must be legally authorized to work in the United Kingdom without the need for current or future visa sponsorship
We are looking for a highly skilled Data Analyst / Data Modelling Analyst who can operate between a traditional Data Analyst and a Data Architect role. The ideal candidate will have strong analytical capabilities combined with a solid understanding of modern data architecture principles, data modelling techniques, and end-to-end data lifecycle management.
The resource will work closely with business stakeholders, data analytics teams, Data Engineers and Architects to define requirements, analyse data, design data structures, and support enterprise reporting and analytics solutions. Experience working with Medallion Architecture (Bronze, Silver, Gold layers), Kimball dimensional modelling methodologies, Power BI, and exposure to Databricks is highly desirable
Responsibilities
Data Analysis & Insight Generation
- Analyse business and operational data to identify trends, insights, risks and opportunities.
- Develop clear and actionable recommendations based on data analysis.
- Support the creation and maintenance of dashboards, reports and datasets that enable informed decision-making.
- Define, track and report on key performance indicators and success metrics.
- Work with stakeholders to understand data requirements and translate them into meaningful analytical outputs.
Data Quality & Governance
- Ensure data quality and integrity across the full data lifecycle, from source systems through to reporting and analytics.
- Conduct data validation, reconciliation and quality assurance activities to identify and resolve data issues.
- Support the definition and implementation of data quality rules and controls.
- Assist with documenting data lineage, transformations and business definitions to support transparency and trust in data.
- Promote best practices for data governance, accuracy and consistency.
Data Modelling & Architecture Support
- Support and contribute to the design and implementation of modern data platforms using Medallion Architecture principles.
- Understand and support data movement and transformation across Bronze, Silver, and Gold layers of logical and physical data models across business domains.
- Assist with dimensional modelling activities, including fact and dimension design using Kimball methodologies.
- Support the documentation and maintenance of Data Vault models within raw and business integration layers.
- Help define and document data flows, business entities and relationships across enterprise systems.
- Contribute to the ongoing development of architecture standards, principles and modelling best practices.
- Support metadata management, data catalogue and data discoverability initiatives.
Requirements & Business Engagement
- Engage with business stakeholders to understand requirements, pain points and opportunities.
- Translate business requirements into clear and technically viable data specifications.
- Collaborate with Engineers, Architects and Product teams to ensure solutions meet business needs.
- Support workshops, discovery activities and requirement gathering sessions.
- Maintain clear traceability between user requirements and delivered data products.
Collaboration & Communication
- Work closely with Data Architects, Data Engineers, Product Managers and Business stakeholders to deliver effective data solutions.
- Produce clear documentation, presentations and recommendations suitable for technical and non-technical audiences.
- Communicate findings, insights and proposed solutions in a concise and engaging manner.
- Support adoption and understanding of data products through training, documentation and stakeholder engagement
Skills & Experience
Essential
- Strong analytical skills with the ability to interpret complex datasets and translate findings into actionable insights.
- Proficiency in SQL with experience querying, validating and analysing data directly from databases.
- Experience working with reporting tools, dashboards, performance metrics and analytical datasets.
- Strong experience with Power BI including dashboard development, data modelling and business reporting.
- Understanding of data quality principles, validation techniques and governance processes.
- Ability to gather and document business requirements and translate them into technical data solutions.
- Strong stakeholder management skills with experience working directly with business users and analytics teams.
- Understanding of modern data platform concepts and enterprise data architecture principles.
- Knowledge of Medallion Architecture and data processing across Bronze, Silver and Gold layers.
- Experience with dimensional modelling and Kimball methodology.
- Strong problem-solving and critical-thinking capabilities.
- Excellent written and verbal communication skills.
- Ability to manage multiple tasks and priorities in a fast-paced environment
Desirable
- Experience supporting data architecture initiatives and working in a hybrid Data Analyst / Data Architect capacity.
- Hands-on experience designing and maintaining fact and dimension models using Kimball methodologies.
- Understanding of Data Vault principles and modern data architecture practices.
- Exposure to Databricks for data querying, transformation and analytics workloads.
- Experience working with cloud-based data and analytics platforms.
- Experience documenting data lineage, metadata and business definitions.
- Understanding of data governance, master data and enterprise data management concepts.
- Experience working in Agile delivery environments.
- Exposure to data catalogue or metadata management tools.
- Experience supporting the end-to-end data journey from ingestion through curated business-ready datasets.
If interested, please apply with your updated CV for an immediate discussion
#UST
Skills
Data Analysis, Data Modeling, Power BI, SQL, Cloud Data Warehousing, Dashboard Development, Metadata Management, Databricks, Data Vault, Data Validation, Microsoft Excel, Data Architecture, Medallion
About UST
UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.
