Senior Analytics Engineer

OEConnection LLC; United Kingdom; À distance; GBP 100 000 - 140 000; Plein temps

Avantages offerts par ce poste

Fully remote

Quarterly in-person meetings

Résumé du poste

OEConnection LLC is seeking a Senior Analytics Engineer to design, build, and maintain scalable dbt models and Snowflake data assets, enabling trusted analytics across the business. You will own critical areas of our dbt project, optimize queries, configure materializations, and lead by example.

This senior IC role involves mentoring peers, collaborating with data scientists and product managers, and shaping the analytics engineering playbook.

Qualifications

• 5+ years of experience in analytics engineering or a closely related data role.
• Expert-level dbt (Core or Cloud) with layered modeling, testing, macros, packages, and CI/CD integration.
• Deep Snowflake expertise with query optimization, materialization strategies, clustering, and access control.
• Advanced SQL and performance tuning.
• Strong understanding of data modeling concepts.
• Experience building or maintaining BI semantic layers and working with Looker/Tableau/PowerBI.

Responsabilités

• Design, build, and maintain scalable dbt models following a modular, layered architecture.
• Own model performance: optimize Snowflake queries, configure materializations, and clustering strategies.
• Evolve dbt best practices: testing coverage, documentation, and source freshness checks.
• Code reviews for dbt PRs, establish modeling conventions, and contribute to the analytics engineering playbook.
• Design Snowflake database and schema structures, manage roles and access controls, and optimize warehouse sizing.
• Monitor and reduce compute costs through query profiling, result caching, and warehouse auto-suspend policies.
• Partner with Data Platform/Engineering on ingestion pipelines, Snowpipe configurations, and external stages setups.
• Use Claude and other AI tools as a force multiplier for faster model generation, documentation writing, SQL refactoring, and test creation.
• Champion AI-assisted workflows and share prompting patterns and use cases that improve team velocity.
• Explore agentic analytics workflows and contribute to their adoption.
• Partner with engineers and business stakeholders to translate analytical requirements into robust data models.
• Guide and mentor Associate and mid-level Analytics Engineers through code reviews and knowledge sharing.
• Define team conventions around naming, folder structure, model contracts, and testing thresholds.

Connaissances

dbt expertise

Snowflake proficiency

SQL performance tuning

Data modeling concepts

BI semantic layers

English communication

Outils

dbt Core/Cloud

Snowflake

Looker

Tableau

PowerBI

Sigma

Airflow

Dagster

Description du poste

Job Summary

AsaSeniorAnalyticsEngineeratOEC,youwillbethebackboneofourdatalayer-designing,building,andmaintainingthemodelsthatpowerbusinessdecisionsacrossthecompany.Youwillowncriticalareasofourdbtproject,ensureSnowflakedataassetsarecleanandtrusted,andbringamodern,AI-assistedmindsettohowwebuildandshipanalytics.

Thisisaseniorindividualcontributorrole.Youwillleadbyexample,setstandards,mentorpeers,andcollaboratecloselywithDataScientists,ProductManagers,andEngineerstoturnrawdataintoreliable,documented,andgovernedanalyticalassets.

Key Responsibilities & Duties

• Design,build,andmaintainscalabledbtmodelsfollowingmodular,layeredarchitecture.
• Ownmodelperformance:optimizeSnowflakequeries,configurematerializations(incremental,table,view)andclusteringstrategies.
• Evolvedbtbestpractices:testingcoverage,documentation,andsourcefreshnesschecks.
• CodereviewsfordbtPRs,establishmodelingconventions,andcontributetotheteam’sanalyticsengineeringplaybook.
• DesignSnowflakedatabaseandschemastructures,managerolesandaccesscontrols,andoptimizewarehousesizing.
• Monitorandreducecomputecoststhroughqueryprofiling,resultcaching,andwarehouseauto-suspendpolicies.
• PartnerwithDataPlatform/Engineeringoningestionpipelines,Snowpipeconfigurations,andexternalstagesetups.
• UseClaudeandotherAItoolsasaforcemultiplier:acceleratemodelgeneration,documentationwriting,SQLrefactoring,andtestcreation.
• ChampionAI-assistedworkflowswithintheteam,sharingeffectivepromptingpatternsandusecasesthatimproveteamvelocity.
• Exploreagenticanalyticsworkflowsandcontributetotheiradoption.
• Partnerwithengineersandbusinessstakeholderstotranslateanalyticalrequirementsintorobustdatamodels.
• GuideandmentorAssociateandmid-levelAnalyticsEngineersthroughcodereviews,pairingsessions,andknowledgesharing.
• Defineteamconventionsaroundnaming,folderstructure,modelcontracts,andtestingthresholds.

Skills & Qualifications

• 5+yearsofexperienceinanalyticsengineering,dataengineering,oracloselyrelateddatarole.
• Expert-leveldbt(CoreorCloud):layeredmodeling,advancedtesting,macros,packages(dbt-utils,dbt-expectations),andCI/CDintegration.
• DeepSnowflakeexpertise:queryoptimization,materializationstrategies,clusteringandaccesscontrol.
• AdvancedSQLandperformancetuning.
• Strongunderstandingofdatamodelingconcepts.
• ExperiencebuildingormaintainingBIsemanticlayersandworkingwithtoolssuchasSigma,Looker,Tableau,orPowerBI.
• Excellentdocumentationhabits:youbelievemodelswithoutdocsaretechnicaldebt.
• StrongwrittenandverbalEnglishcommunication-youcanexplaindatadecisionstobothengineersandbusinessstakeholders.

StrongPlus

• Hands-onexperiencewithAItoolsfordevelopmenttasks:querywriting,documentation,debugging,andcodereview.
• Pythonproficiencyfordatatransformationtasks,pipelinescripting,orworkingwiththedbtPythonmodelinterface.
• Experiencewithorchestrationtools(Airflow,Dagster,ordbtCloudjobs).
• Understandingofautomotiveparts,catalog,ormarketplacedatadomains.
• Experienceworkinginaproduct-leddatateamwithexposuretoevent/productanalytics.

Why You Should Join Us

Ourvisionistomakeitfastandeasyforautorepairshopstofindtherightpartsacrossalloftheirsupplierswithonesearch.Together,OEC’steamhelpedcountlessbusinessessavevaluabletimesotheycanfocusontheircustomers—andwe’rejustgettingstarted.

Thepositionisfullyremote,withtherequirementtoattendquarterlyin-personmeetings.