At a Glance
- Tasks: Lead data operations and ensure the reliability of critical database systems.
- Company: Join ERM, a leader in sustainable business consulting with a focus on innovation.
- Benefits: Enjoy a competitive salary, inclusive culture, and opportunities for professional growth.
- Other info: Be part of a diverse team committed to creating an inclusive workplace.
- Why this job: Make a real impact by optimising data systems that drive smarter business decisions.
- Qualifications: 5+ years in database management, strong SQL skills, and experience with PowerBI.
The predicted salary is between 63000 - 77000 £ per year.
This position is a temporary, fixed-term assignment for a period of two years.
Why This Role Matters
Data powers every decision. Your expertise will ensure the systems behind those decisions remain reliable, scalable, and ready for what's next. At ERM, we're investing in modern data platforms, analytics, and business intelligence capabilities that enable teams across the globe to operate more effectively. As an experienced Database & Business Intelligence Engineer, you'll play a critical role in maintaining and evolving the data infrastructure that supports our finance systems, reporting environment, and enterprise applications. This is an opportunity to join a highly collaborative team where your technical expertise will directly influence system reliability, data accessibility, and business performance. You'll be trusted to lead complex database initiatives, optimize critical systems, and help shape the future of our Microsoft data ecosystem, including SQL Server, Power BI, and Microsoft Fabric. If you're motivated by solving complex technical challenges, improving business-critical platforms, and transforming data into meaningful insights, we'd love to hear from you.
What Your Impact Is
- Ensure the availability, performance, and stability of ERM's core SQL database environment and business intelligence platforms.
- Support and optimize critical business systems, including ERM's finance platform and enterprise-wide reporting solutions.
- Enable data-driven decision-making by maintaining trusted, accessible, and high-performing data assets.
- Drive improvements in database architecture, data integration, analytics capabilities, and reporting solutions.
- Partner with teams across IT and the wider business to deliver innovative, scalable technology solutions.
- Contribute to the evolution of ERM's modern data platform strategy, leveraging Microsoft Fabric, Power BI, and advanced analytics technologies.
What You'll Bring
- 5+ years of experience as a Database Administrator, Data Engineer, BI Engineer, or similar role.
- Advanced expertise in Microsoft SQL Server and related technologies.
- Strong proficiency in SQL, stored procedures, functions, views, query optimization, and database performance tuning.
- Experience with database design, schema development, logical and physical data modelling.
- Strong understanding of query languages and analytic technologies, including SQL, MDX, DAX, Power Query (M), and PostgreSQL.
- Experience building, maintaining, and optimizing ETL/ELT processes using SSIS, Azure Data Factory, Microsoft Fabric, or equivalent tools.
- Hands-on experience developing and supporting Power BI solutions, including Power BI Desktop and Power BI Service.
- Experience creating and maintaining analytics data pipelines that support reporting, insights, and operational decision-making.
- Knowledge of Microsoft Fabric architecture, including OneLake, Lakehouses, Warehouses, Pipelines, and Notebooks.
- Understanding of business intelligence best practices, including dimensional modelling, data warehousing, and data governance.
- Experience supporting mission-critical systems with a strong focus on uptime, stability, and service excellence.
- Working knowledge of Windows Server environments and networking fundamentals.
- Experience operating within regional or global organizations.
- Bachelor's degree in a relevant field or equivalent combination of education and experience.
Preferred Experience
- Supporting enterprise finance systems or ERP platforms.
- Experience working with SSRS, Report Builder, and other reporting technologies.
- Knowledge of cloud-based data architectures and modern analytics platforms.
- Experience supporting bespoke business applications with complex database dependencies.
- Exposure to service management or ITIL-aligned support environments.
- Experience mentoring colleagues and contributing to technical capability development within a team.
- Certifications in Microsoft SQL Server, Power BI, Fabric, Azure Data, or related technologies.
Key Responsibilities
- Ensure Availability of Critical Data Platforms: Act as the subject matter expert for SQL Server databases, business intelligence platforms, and supporting back-end systems. Maintain maximum uptime, performance, reliability, and security across enterprise database environments. Monitor, troubleshoot, and resolve database-related incidents, performance issues, and service disruptions. Participate in on-call and occasional out-of-hours support to maintain business-critical services.
- Support and Enhance Enterprise Systems: Ensure the smooth operation and optimal performance of ERM's finance systems and other SQL-dependent applications. Partner with software vendors and internal stakeholders to identify, troubleshoot, and resolve system issues. Develop enhancements that improve performance, scalability, and user experience. Support integration and data flows across multiple systems and platforms.
- Drive Data and Analytics Excellence: Design, develop, and maintain robust data models, data warehouses, and analytical solutions. Build and optimize data pipelines that transform data into actionable business insights. Ensure datasets from multiple sources remain accurate, centralized, governed, and accessible. Develop and maintain Power BI reports, dashboards, and reporting solutions that support strategic and operational decision-making.
- Advance Microsoft Fabric and Modern Data Capabilities: Support and enhance ERM's Microsoft Fabric environment, including analytics engineering, data orchestration, and reporting capabilities. Contribute to the development of scalable modern data architecture and best practices. Identify opportunities to improve data processing efficiency, reporting performance, and platform scalability.
- Collaborate Across the Business: Partner closely with IT teams, business stakeholders, vendors, and technology leaders to deliver solutions that support organizational objectives. Help translate business requirements into technical solutions that deliver measurable value. Foster collaborative working relationships across teams and functions.
- Deliver Technical Leadership and Operational Excellence: Act as a trusted technical expert and escalation point for complex database and analytics challenges. Maintain accurate documentation, support records, and technical standards. Contribute to continuous improvement initiatives that enhance team capability, service quality, and operational effectiveness. Research emerging technologies and recommend improvements that strengthen ERM's data and analytics capabilities.
Join ERM and help build the data foundation that powers smarter decisions, stronger business performance, and the future of sustainable business consulting worldwide. ERM is committed to creating an inclusive workplace where everyone feels valued, respected, and empowered to thrive; it’s an essential part of what makes ERM a great place to build a career and helps us create better solutions for our clients. We welcome talent from all backgrounds and provide equal opportunities for every candidate. If you have a disability, are neurodivergent, or need accommodations during the selection process, we’re here to support you. Our commitment doesn’t stop at hiring. Once you join us, we’ll ensure you have the tools, support, and adjustments needed to succeed and feel a true sense of belonging. Learn more about our Diversity, Inclusion & Belonging (DIB) efforts by visiting our website or exploring our 2025 Sustainability Report.
Summary Location: London, United Kingdom Type: Full time
Data Operations Lead in London employer: ERM Group
ERM is an exceptional employer, offering a unique opportunity for regulatory professionals to thrive in a collaborative and inclusive environment. With a commitment to employee growth and development, ERM provides access to world-class experts and resources, ensuring that you can make a meaningful impact while working on complex sustainability challenges. Located in vibrant cities like London and Manchester, ERM fosters a culture of respect and empowerment, making it a great place to build a rewarding career in the chemicals regulatory field.
StudySmarter Expert Advice🤫
We think this is how you could land Data Operations Lead in London
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like ERM Group!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Operations Lead at ERM Group.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like ERM Group.
✨Apply Directly through Our Website
When you find a suitable opening like Data Operations Lead at ERM Group, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Operations Lead in London
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at ERM Group, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at ERM Group. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at ERM Group
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at ERM Group!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
