Senior Analytics Engineer

Tech4; Oxford; Hybrid; GBP 60,000 - 65,000; Full time

Benefits offered by this job

Excellent benefits

Job summary

Tech4 in Oxford is seeking a Senior Analytics Engineer to shape and scale our cloud-based data platform. You will own the data pipelines, optimize workflows, and collaborate with Data & BI to deliver enterprise reporting and dashboards.

The role requires extensive Azure experience (ADF, SQL Server, Fabric, Synapse), strong SQL and Python, CI/CD with Azure DevOps, and the ability to work with offshore teams while maintaining data quality and security.

Qualifications

• Minimum a BSc/BA in Computer Science or related field.
• 5+ years in Azure SQL Server, Azure Data Factory, Fabric or Synapse.
• Experience with Azure Data Warehousing and NoSQL is a plus.
• Advanced SQL with CI/CD automation using Azure DevOps.
• Proficiency in Git for version control and collaboration.
• Strong Python scripting for data automation and pipelines.
• Experience with Power BI or similar analytics tools.
• Knowledge of GDPR and data security practices.
• Agile/SCRUM experience with offshore teams.
• Ability to translate business needs into technical specifications.

Responsibilities

• Develop and maintain the cloud-based data platform.
• Analyze information requests and drive enterprise reporting with business units.
• Write scripts to import/export data while preserving integrity.
• Extract data for automated reporting with governance and compliance.
• Select technology solutions to meet corporate goals and scale data architecture.
• Build, monitor, and optimize ETL processes and data stores.
• Provide documentation including data dictionaries and schemas.
• Collaborate with developers, product owners and analysts on new apps.
• Ensure data security policies are followed and data quality remains high.

Skills

Azure SQL Server

Azure Data Factory

Microsoft Fabric

ETL/ELT workflows

Synapse

SQL

Python scripting

GIT

Power BI

Agile/SCRUM

Stakeholder communication

Education

BSc/BA in Computer Science or related

Tools

Azure DevOps

C#

NoSQL Databases

Cosmos DB

Job description

Senior Analytics Engineer - SQL / Azure Data Factory / Fabric - is required by fast growing, international organisation.

Job purpose

Due to their continued success in their online platform, they are expanding their portfolio to increase their current offerings, adding more products to their corporate intelligence and due diligence solutions. They have a new and exciting opportunity for a Senior Analytics Engineer to join the team based at their Head Office in Oxford.

This opportunity is to work with their Data & BI Team, scoping out new potential developments and redevelopments of their data platform used by their clients. They are striving to digitally transform all areas of the company and require a strong, capable, and structured Senior Analytics Engineer to help achieve this. Their data capabilities are predominantly in the cloud, supporting all areas of the business.

• Responsible for developing and maintaining the existing data platform in the cloud
• Perform analysis of proposed information requests and collaborate with the business units to drive enterprise reporting
• Write scripts for importing and exporting data into enterprise applications, maintaining the integrity of the data across the applications
• Use enterprise report writing tools to extract data and share information for automated reporting in compliance with regulatory guidelines
• Always strive to meet corporate goals and look for opportunities to use technology to do so
• Select the best technology solutions for business problems
• Ensure pristine data quality in all delivered solutions
• Provide solid documentation on all design and coding projects
• Maintain confidentiality of the information being processed, stored, or accessed by the end-users on the network
• Ensure that the data architecture is scalable and maintainable
• Design, implement, and continuously expand data acquisition by performing extraction, transformation, and loading activities
• Build, debug, monitor and troubleshoot databases and ETL processes to ensure optimal performance, reliability, and integrity
• Design, develop and maintain data stores (data warehouses, data marts and related information repositories) to support organisational reporting, analytics, and integrations
• Translate business needs to technical specifications for BI
• Design, implement, monitor, and maintain BI environments and database servers to meet usage and performance demands
• Establish performance and reliability metrics for all data stores, reports, dashboards, and analytics tools
• Design, implement and tune relational queries, stored procedures, and table-valued functions for optimal performance and reliability
• Create and maintain supporting documentation, including data dictionaries, data flows and database schemas, necessary to document database environments and ensure maintainability
• Collaborate with developers, product owners and business analysts in conceptualising, designing, and developing new database applications, modules, and enhancements
• Assist with the design and development of data schemas and definitions to support Business Intelligence and Data Warehousing requirements
• Follow and maintain data security policies and practices

Requirements specific to the role

You will:

• Have a minimum of a BSc/BA in Computer Science or a related field, and other professional management training
• Extensive (5+ years) experience in at least 3 of the following: Azure SQL Server 2022, Azure Data Factory (ADF), Microsoft Fabric, ETL/ELT workflows and Synapse.
• Architectural experience in Azure Data Warehousing, with bonus points for NoSQL (Cosmos DB, MongoDB, etc.).
• Advanced SQL CI/CD automation using Azure DevOps for deployments.
• Proficiency in GIT for repository management, branching strategies, and collaboration.
• Strong Python scripting for data automation, orchestration, and pipeline optimisation.
• Working knowledge of C# for maintaining/modifying legacy Windows applications.
• Experience with Power BI, QuickSight, or similar tools for analytics.
• Adherence to ETL/data management best practices (e.g., incremental loads, error handling, metadata logging).
• Knowledge of data protection regulations (GDPR, CCPA) and security protocols (encryption, RBAC).
• Agile/SCRUM practitioner with experience in offshore team collaboration.
• Ability to migrate legacy systems to modern cloud architectures.
• Anticipates issues, recommends pragmatic solutions, and writes clean, reusable code.
• Articulate with stakeholders, from engineers to non-technical leaders.
• Manages tight deadlines with attention to detail

Experience/skills regarded as ideal but not essential

• Excellent understanding of Entity-Relationship/Multidimensional Data Modelling (Star schema, Snowflake schema), Data Warehouse Life Cycle and SQL Server.
• Experience in creating master and child packages, package configurations, logging and using variables and expressions in packages
• Experience working with offshore teams preferred
• Experience writing technical specifications for work to be performed by other developers
• Development experience in C# with good software methodology/practices
• Informatica, Talend, Azure SQL Server, NoSQL Databases including MongoDB, DynamoDB, etc, experience helpful but not required

Basic salary £60-65,000 + excellent benefits

Based Oxford 3 days per week, 2 days remote