How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Interim Data Availability Lead
Job Title: Data Availability Leader
Department: IT
Reporting to: Sean Birch
Based: London Office
Environmental Resources Management (ERM) is a leading global provider of environmental, health, safety, risk, social consulting and sustainability related services. With 8000 people working in 42 countries out of 160 offices, ERM is committed to providing a service that is consistent, professional and of the highest quality to create value for our clients. Over the past five years we have worked for more than 50 percent of the Global Fortune 500 delivering innovative solutions for business and selected government clients helping them understand and manage the sustainability challenges that the world is increasingly facing.
Job Description:
To ensure the smooth running of all SQL databases, data models and Power BI reports, working in an environment using Microsoft SQL Server, SSAS, SSIS, Power BI and MS Fabric. Your focus will be on SQL and its related technologies whilst also ensuring the smooth running and maximum uptime of ERM’s finance system (GMS). You will be covering the lead role within a small team providing round the clock support ensuring data availability for ERM’s key databases.
Responsibilities:
- SME on supporting, maintaining, and enhancing our SQL, BI, and mid / back-end systems (including Finance systems, Data Analytics, and SQL dependent systems such as ERM’s bespoke H&S system).
- Ensure maximum uptime for our database systems.
- Ensure the Finance system is performing to acceptable levels and work with the Finance software vendor to tackle and resolve issues.
- Ensure datasets from different sources are kept centralised and accessible.
- Liaise closely with other IT functional managers.
- Occasionally required to work out of hours (late nights / weekends).
Principal Accountabilities:
- Working as an experienced engineer within programmes improving business delivery through technical excellence by performing a variety of project tasks.
- Responsible for maintaining and developing the capability and competency of their team so that customer demands are met.
- Through partnership and communication, work across ERM IT to create collaborative working relationships that demonstrably drives capability.
- Recognised as an experienced engineer internally with colleagues.
- To perform activities in a productive, timely and effective manner.
- To maintain appropriate records of time spent, actions taken and item status to facilitate management, future problem resolution and to keep users informed of progress.
- To keep users up to date with progress and to liaise with colleagues and partners in an appropriate manner.
- To liaise with users regarding escalated issues and to agree appropriate courses of action and priorities.
- To assist in other activities of the IT function as directed.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Knowledge, Skills and Experience:
- 5+ years as a DBA
- Extensive knowledge of database query languages (SQL, MDX, DAX, M (Power Query), Postgres), database design, optimizing queries, internals knowledge of query planning
- Knowledge of working with SQL queries, stored procedures, functions and views
- Strong SQL/data manipulation skills required including cleaning and handling data
- Orchestration: Strong familiarity with SQL Server Agent and SSIS
- Designing database schemas
- Expertise in data modelling, both logical and physical
- Ability to create and maintain analytics data pipelines in Fabric, or using ADF or SSIS that generate data and insight to power business decision making
- Understanding of Fabric architecture including OneLake, Lakehouses, Warehouses, Pipelines, and Notebooks.
- Scalability and performance: understanding how Fabric handles large datasets and optimizes compute.
- Reporting and visualization: Power BI (Desktop and Service), Report Builder, SSRS
- Understanding of business intelligence best practices (i.e. dimensional modelling, ETL pipelines)
- Experience working in a Regional or Global role.
- Windows server knowledge (intermediate), networking (intermediate)
- A degree in a related field is required or equivalent experience
Personal Attributes:
- Ability to communicate and interact successfully with a diverse community and to develop and maintain positive professional relationships with colleagues and community members.
- Self-starter and results orientated, able to work under minimal guidance
- Intellectual curiosity and desire to learn new things, techniques and technologies
- Ability to research and report on problems, solutions, products and vendors.
- Creative thinking and problem solving.
- Ability to effectively prioritize and execute tasks in a high-pressure environment
- Experience working both independently and in a team-oriented, collaborative environment
- Excellent oral and written communication skills, with a focus on technical or instruction-oriented writing and in clearly communicating complicated concepts over the phone, in person, and in writing.
- Ability to work both independently and as a team member.
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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
At ERM, sustainability is our business. We are the world’s largest advisory firm focused solely on sustainability, offering unparalleled expertise across business and finance. ERM partners with clients to operationalize sustainability at pace and scale, through our unique combination of strategic transformation and technical delivery capabilities. Our diverse global team of experts works with the world’s leading organizations to help them set clear sustainability targets, measure progress and operationalize strategy through deep implementation and business transformation. With more than 50 years of experience, our ability to integrate sustainability solutions and our depth and breadth of technical knowledge are why organizations choose to partner with us as their trusted advisor. Every one of us firmly believes in the potential to create value for our clients through an integrated approach to sustainability (because we have personally seen it and professionally achieved it). Our team members are passionate about client service. We work closely with our clients to help them operationalize their sustainability goals and meet their environmental, health and safety objectives while advancing ERM’s purpose through delivering tangible progress in what the United Nations coined The Decade of Action. Organizing our people across globally integrated communities of technical and strategic talent positions ERM to be a “boots to boardroom” leader in bringing that value creation to our clients, partners, and the world. We recruit exceptional professionals with a personal and professional passion for sustainability and nurture them to even greater success as specialists. We prepare our consultants to bring integrated, innovative and sustainable solutions to our clients and provide opportunities for ongoing development across a variety of subject areas related to technical, business, and personal growth. At ERM, effort pays off and becomes career defining work that leaves a positive imprint on our planet.
ERM Homepage
Explore All Open Roles
Explore Early Careers Roles
Explore Experienced Professional Roles
Explore Partnership Roles
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location