Analytics Engineer

• Work directly with business stakeholders to understand their domain and translate questions into data solutions — delivering iteratively from quick explorations to production-ready data products
• Design and build data models (dimensional models, semantic layers) and implement them as Snowflake views, DBT marts, and Power BI datasets
• Build and optimize Power BI semantic models (DAX, Power Query) and design reports that surface your models effectively
• Write consumption-layer SQL (views, transforms, analytical queries) across Snowflake and SQL Server to serve downstream analytics
• Consolidate data solutions into modern analytics platforms, improving consistency and reducing technical debt
• Define and document metric definitions, business logic, and data product specifications
• Design and implement data quality tests (dbt tests, SQL validations) and contribute to the team's testing standards and governance framework
• Collaborate with Data Engineers through code reviews, shared planning, and PR-based workflows

• Collaboration with the Senior Data Engineer to design, develop, and maintain scalable data pipelines and ETL processes that support internal reporting and embedded analytics.
• Partner with the data analysts to understand data needs, assisting in the creation of dashboards, reports, and KPIs.
• Design and build data solutions to support reporting, analytics, and business insights for supply chain solutions.
• Ensuring high data quality, integrity, and security across the different data solutions.
• Participate in building dashboards and visualisations to communicate insights to stakeholders clearly and effectively.
• Troubleshoot and resolve data-related issues, improving data flow efficiency and performance.
• Evaluate and recommend improvements in our data tools, architecture, and practices, focusing on long-term scalability and adaptability.
• Support in designing, building, and maintaining advanced data models and data warehouses.
• Writing, optimising, and reviewing SQL queries for data extraction and transformation.

See all jobs on JobTailor

Analytics Engineer

Junior Analytics Engineer, Data Analyst – 12 Month Fixed Term