Data Operations Lead

Thispositionisatemporary,fixed-termassignmentforaperiodoftwoyearsWhyThisRoleMattersDatapowerseverydecision.Yourexpertisewillensurethesystemsbehindthosedecisionsremainreliable,scalable,andreadyforwhat'snext.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 experiencedDatabase&BusinessIntelligenceEngineer,you'llplayacriticalroleinmaintainingandevolvingthedatainfrastructurethatsupportsourfinancesystems,reportingenvironment,andenterpriseapplications.This is an opportunity to join a highly collaborative team where your technical expertise will directly influence system reliability, dataaccessibility,andbusinessperformance.You'llbetrustedtoleadcomplexdatabaseinitiatives,optimizecriticalsystems,andhelpshapethefutureofourMicrosoftdataecosystem,includingSQLServer,PowerBI,andMicrosoftFabric.Ifyou'remotivatedbysolvingcomplextechnicalchallenges,improvingbusiness-criticalplatforms,andtransformingdataintomeaningfulinsights,we'dlovetohearfromyou.WhatYourImpactIsInthisrole,youwill:Ensuretheavailability,performance,andstabilityofERM'scoreSQLdatabaseenvironmentandbusinessintelligenceplatforms.Supportandoptimizecriticalbusinesssystems,includingERM'sfinanceplatformandenterprise-widereportingsolutions.Enabledata-drivendecision-makingbymaintainingtrusted,accessible,andhigh-performingdataassets.Driveimprovementsindatabasearchitecture,dataintegration,analyticscapabilities,andreportingsolutions.PartnerwithteamsacrossITandthewiderbusinesstodeliverinnovative,scalabletechnologysolutions.ContributetotheevolutionofERM'smoderndataplatformstrategy,leveragingMicrosoftFabric,PowerBI,andadvancedanalyticstechnologies.WhatYou'llBringRequired5+yearsofexperienceasaDatabaseAdministrator,DataEngineer,BIEngineer,orsimilarrole.AdvancedexpertiseinMicrosoftSQLServerandrelatedtechnologies.StrongproficiencyinSQL,storedprocedures,functions,views,queryoptimization,anddatabaseperformancetuning.Experiencewithdatabasedesign,schemadevelopment,logicalandphysicaldatamodelling.Strongunderstandingofquerylanguagesandanalyticstechnologies,includingSQL,MDX,DAX,PowerQuery(M),andPostgreSQL.Experiencebuilding,maintaining,andoptimizingETL/ELTprocessesusingSSIS,AzureDataFactory,MicrosoftFabric,orequivalenttools.Hands-onexperiencedevelopingandsupportingPowerBIsolutions,includingPowerBIDesktopandPowerBIService.Experiencecreatingandmaintaininganalyticsdatapipelinesthatsupportreporting,insights,andoperationaldecision-making.KnowledgeofMicrosoftFabricarchitecture,includingOneLake,Lakehouses,Warehouses,Pipelines,andNotebooks.Understandingofbusinessintelligencebestpractices,includingdimensionalmodelling,datawarehousing,anddatagovernance.Experiencesupportingmission-criticalsystemswithastrongfocusonuptime,stability,andserviceexcellence.WorkingknowledgeofWindowsServerenvironmentsandnetworkingfundamentals.Experienceoperatingwithinregionalorglobalorganizations.Bachelor'sdegreeinarelevantfieldorequivalentcombinationofeducationandexperience.PreferredExperiencesupportingenterprisefinancesystemsorERPplatforms.ExperienceworkingwithSSRS,ReportBuilder,andotherreportingtechnologies.Knowledgeofcloud-baseddataarchitecturesandmodernanalyticsplatforms.Experiencesupportingbespokebusinessapplicationswithcomplexdatabasedependencies.ExposuretoservicemanagementorITIL-alignedsupportenvironments.Experiencementoringcolleaguesandcontributingtotechnicalcapabilitydevelopmentwithinateam.CertificationsinMicrosoftSQLServer,PowerBI,Fabric,AzureData,orrelatedtechnologies.KeyResponsibilitiesEnsureAvailabilityofCriticalDataPlatformsActasthesubjectmatterexpertforSQLServerdatabases,businessintelligenceplatforms,andsupportingback-endsystems.Maintainmaximumuptime,performance,reliability,andsecurityacrossenterprisedatabaseenvironments.Monitor,troubleshoot,andresolvedatabase-relatedincidents,performanceissues,andservicedisruptions.Participateinon-callandoccasionalout-of-hourssupporttomaintainbusiness-criticalservices.SupportandEnhanceEnterpriseSystemsEnsurethesmoothoperationandoptimalperformanceofERM'sfinancesystemsandotherSQL-dependentapplications.Partnerwithsoftwarevendorsandinternalstakeholderstoidentify,troubleshoot,andresolvesystemissues.Developenhancementsthatimproveperformance,scalability,anduserexperience.Supportintegrationanddataflowsacrossmultiplesystemsandplatforms.DriveDataandAnalyticsExcellenceDesign,develop,andmaintainrobustdatamodels,datawarehouses,andanalyticalsolutions.Buildandoptimizedatapipelinesthattransformdataintoactionablebusinessinsights.Ensuredatasetsfrommultiplesourcesremainaccurate,centralized,governed,andaccessible.DevelopandmaintainPowerBIreports,dashboards,andreportingsolutionsthatsupportstrategicandoperationaldecision-making.AdvanceMicrosoftFabricandModernDataCapabilitiesSupportandenhanceERM'sMicrosoftFabricenvironment,includinganalyticsengineering,dataorchestration,andreportingcapabilities.Contributetothedevelopmentofscalablemoderndataarchitectureandbestpractices.Identifyopportunitiestoimprovedataprocessingefficiency,reportingperformance,andplatformscalability.CollaborateAcrosstheBusinessPartnercloselywithITteams,businessstakeholders,vendors,andtechnologyleaderstodeliversolutionsthatsupportorganizationalobjectives.Helptranslatebusinessrequirementsintotechnicalsolutionsthatdelivermeasurablevalue.Fostercollaborativeworkingrelationshipsacrossteamsandfunctions.DeliverTechnicalLeadershipandOperationalExcellenceActasatrustedtechnicalexpertandescalationpointforcomplexdatabaseandanalyticschallenges.Maintainaccuratedocumentation,supportrecords,andtechnicalstandards.Contributetocontinuousimprovementinitiativesthatenhanceteamcapability,servicequality,andoperationaleffectiveness.ResearchemergingtechnologiesandrecommendimprovementsthatstrengthenERM'sdataandanalyticscapabilities.JoinERMandhelpbuildthedatafoundationthatpowerssmarterdecisions,strongerbusinessperformance,andthefutureofsustainablebusinessconsultingworldwide.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..SummaryLocation: London, United KingdomType: Full time