Senior Analytics Engineer

• We are responsible for developing and maintaining our existing cloud data platform.
• We analyse proposed information requests and collaborate with business units to drive enterprise reporting.
• We write scripts to import and export data into enterprise applications while maintaining data integrity across systems.
• We use enterprise report-writing tools to extract data and support automated reporting in compliance with regulatory guidelines.
• We select the best technology solutions for business problems and look for opportunities to use technology to achieve corporate goals.
• We ensure high data quality in all delivered solutions.
• We provide clear documentation for all design and coding projects.
• We maintain confidentiality of information processed, stored, or accessed by end users on the network.
• We ensure that our data architecture is scalable and maintainable.
• We design, implement, and expand data acquisition through extraction, transformation, and loading activities.
• We build, debug, monitor, and troubleshoot databases and ETL processes to ensure optimal performance, reliability, and integrity.
• We design, develop, and maintain data stores such as data warehouses, data marts, and related repositories to support reporting, analytics, and integrations.
• We translate business needs into technical specifications for BI.
• We design, implement, monitor, and maintain BI environments and database servers to meet usage and performance demands.
• We establish performance and reliability metrics for data stores, reports, dashboards, and analytics tools.
• We design, implement, and tune relational queries, stored procedures, and table-valued functions for optimal performance and reliability.
• We create and maintain supporting documentation, including data dictionaries, data flows, and database schemas.
• We collaborate with developers, product owners, and business analysts to design and develop new database applications, modules, and enhancements.
• We assist with the design and development of data schemas and definitions to support Business Intelligence and Data Warehousing requirements.
• We follow and maintain data security policies and practices.

Technologies:

• Azure
• Business Intelligence
• C#
• CI/CD
• Cloud
• Cosmos DB
• DevOps
• ETL
• Fabric
• Git
• Support
• MongoDB
• Network
• NoSQL
• Power BI
• Python
• RBAC
• SQL
• Security
• Windows
• Data Warehouse
• Informatica
• Snowflake
• Talend, We are a fast-growing, international organisation expanding our online platform and broadening our corporate intelligence and due diligence solutions. This is a new opportunity for a Senior Analytics Engineer to join our Data & BI team at our Head Office in Oxford, where we are driving digital transformation across the business and building cloud-based data capabilities to support all areas of the company. We offer a basic salary of £60,000-£65,000 plus excellent benefits. The role is based in Oxford three days per week with two days remote.

• We require a minimum of a BSc/BA in Computer Science or a related field, plus other professional management training.
• We require 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.
• We require architectural experience in Azure Data Warehousing; experience with NoSQL technologies such as Cosmos DB or MongoDB is a plus.
• We require advanced SQL CI/CD automation using Azure DevOps for deployments.
• We require proficiency in GIT for repository management, branching strategies, and collaboration.
• We require strong Python scripting skills for data automation, orchestration, and pipeline optimisation.
• We require working knowledge of C# for maintaining and modifying legacy Windows applications.
• We require experience with Power BI, QuickSight, or similar analytics tools.
• We require adherence to ETL and data management best practices, including incremental loads, error handling, and metadata logging.
• We require knowledge of data protection regulations such as GDPR and CCPA, and security protocols including encryption and RBAC.
• We require experience as an Agile/SCRUM practitioner, ideally with offshore team collaboration.
• We require the ability to migrate legacy systems to modern cloud architectures.
• We require the ability to anticipate issues, recommend pragmatic solutions, and write clean, reusable code.
• We require strong stakeholder communication skills, from engineers to non-technical leaders.
• We require the ability to manage tight deadlines with attention to detail.