At a Glance
- Tasks: Join our Data & BI Team to develop and maintain our cloud-based data platform.
- Company: Dynamic company in Oxford focused on digital transformation and innovation.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on cutting-edge technology and career advancement.
- Why this job: Make a real impact by shaping our data capabilities and driving enterprise reporting.
- Qualifications: BSc/BA in Computer Science and 5+ years of experience in data engineering.
The predicted salary is between 60000 - 80000 £ per year.
Due to our continued success in our online platform, we are expanding our portfolio to increase our current offerings, adding more products to our corporate intelligence and due diligence solutions. We have a new and exciting opportunity for a Senior Analytics Engineer to join the team based at our Head Office in Oxford. This opportunity is to work with our Data & BI Team, scoping out new potential developments and redevelopments of our data platform used by our clients. We are striving to digitally transform all areas of the company and require a strong, capable, and structured Senior Analytics Engineer to help achieve this. Our data capabilities are predominantly in the cloud, supporting all areas of the business.
Responsibilities:
- Develop and maintain 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 into 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.
This job description provides an indication of the role and responsibilities, but should not be construed as an exhaustive list of duties that the post holder may be asked to undertake.
Requirements:
- 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.).
- 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.
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.
Senior Analytics Engineer in Oxford employer: Diligencia
Join our dynamic team in Oxford as a Senior Analytics Engineer, where you'll play a pivotal role in shaping our data platform and driving digital transformation. We pride ourselves on fostering a collaborative work culture that encourages innovation and professional growth, offering opportunities to work with cutting-edge technologies in a supportive environment. With a focus on employee development and a commitment to maintaining high data quality standards, we provide a rewarding workplace for those looking to make a meaningful impact.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Analytics Engineer in Oxford
✨Tip Number 1
Network like a pro! Reach out to current employees on LinkedIn or attend industry meetups. Getting to know someone inside the company can give you a leg up and might even lead to a referral.
✨Tip Number 2
Prepare for the interview by brushing up on your technical skills. Make sure you can talk confidently about Azure SQL Server, ETL processes, and data architecture. We want to see you shine!
✨Tip Number 3
Showcase your problem-solving skills during interviews. Be ready to discuss how you've tackled challenges in past projects, especially around data quality and cloud solutions. We love a good story!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining our team.
We think you need these skills to ace Senior Analytics Engineer in Oxford
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Senior Analytics Engineer role. Highlight your experience with Azure SQL Server, ETL workflows, and any relevant projects that showcase your skills in data management and analytics.
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about this role and how your background aligns with our mission at StudySmarter. Don’t forget to mention specific technologies you’ve worked with that are relevant to the job.
Showcase Your Projects:If you've worked on any interesting projects, especially those involving cloud data platforms or BI tools, make sure to include them. We love seeing real-world applications of your skills, so don’t hold back!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen on joining our team!
How to prepare for a job interview at Diligencia
✨Know Your Tech Inside Out
Make sure you’re well-versed in the technologies mentioned in the job description, like Azure SQL Server and ETL workflows. Brush up on your Python scripting skills and be ready to discuss how you've used these tools in past projects.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've tackled complex data challenges in previous roles. Be ready to explain your thought process and the solutions you implemented, especially in relation to data quality and integrity.
✨Understand the Business Context
Familiarise yourself with the company’s products and how they use data to drive decisions. This will help you translate business needs into technical specifications during the interview, showing that you can bridge the gap between tech and business.
✨Prepare for Collaboration Questions
Since the role involves working with various teams, think of examples where you’ve successfully collaborated with developers, product owners, or business analysts. Highlight your experience in Agile/SCRUM environments and how you’ve managed tight deadlines while maintaining attention to detail.
