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