Interim Data Availability Lead

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.

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.
• Comfortable working in a service desk focused 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..