Senior Analytics Engineer

Senior Analytics Engineer - SQL / Azure Data Factory / Fabric - is required by fast growing, international organisation.Job purposeDue 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 accountabilitiesResponsible for developing and maintaining the existing data platform in the cloudPerform analysis of proposed information requests and collaborate with the business units to drive enterprise reportingWrite 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 guidelinesAlways strive to meet corporate goals and look for opportunities to use technology to do soSelect the best technology solutions for business problemsEnsure pristine data quality in all delivered solutionsProvide solid documentation on all design and coding projectsMaintain confidentiality of the information being processed, stored, or accessed by the end-users on the networkEnsure that the data architecture is scalable and maintainableDesign, implement, and continuously expand data acquisition by performing extraction, transformation, and loading activitiesBuild, debug, monitor and troubleshoot databases and ETL processes to ensure optimal performance, reliability, and integrityDesign, develop and maintain data stores (data warehouses, data marts and related information repositories) to support organisational reporting, analytics, and integrationsTranslate business needs to technical specifications for BIDesign, implement, monitor, and maintain BI environments and database servers to meet usage and performance demandsEstablish 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 reliabilityCreate and maintain supporting documentation, including data dictionaries, data flows and database schemas, necessary to document database environments and ensure maintainabilityCollaborate with developers, product owners and business analysts in conceptualising, designing, and developing new database applications, modules, and enhancementsAssist 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 practicesRequirements specific to the roleYou 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 detailExperience/skills regarded as ideal but not essentialExcellent 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 requiredBasic salary £60-65,000 + excellent benefitsBased Oxford 3 days per week, 2 days remoteTPBN1_UKTJ