Senior Analytics Engineer - SQL/Azure Data Factory/Fabric

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.

Main accountabilities

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 (eg, 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