P Job Summary p As a Senior Analytics Engineer at OEC, you will be the backbone of our data layer - designing, building, and maintaining the models that power business decisions across the company.
You will own critical areas of our dbt project, ensure Snowflake data assets are clean and trusted, and bring a modern, AI-assisted mindset to how we build and ship analytics.
/pp This is a senior individual contributor role.
You will lead by example, set standards, mentor peers, and collaborate closely with Data Scientists, Product Managers, and Engineers to turn raw data into reliable, documented, and governed analytical assets.
/pp Key Responsibilities Duties /pulli Design, build, and maintain scalable dbt models following modular, layered architecture.
/lili Own model performance: optimize Snowflake queries, configure materializations (incremental, table, view) and clustering strategies.
/lili Evolve dbt best practices: testing coverage, documentation, and source freshness checks.
/lili Code reviews for dbt PRs, establish modeling conventions, and contribute to the team#39;s analytics engineering playbook.
/lili Design Snowflake database and schema structures, manage roles and access controls, and optimize warehouse sizing.
/lili Monitor and reduce compute costs through query profiling, result caching, and warehouse auto-suspend policies.
/lili Partner with Data Platform/Engineering on ingestion pipelines, Snowpipe configurations, and external stage setups.
/lili Use Claude and other AI tools as a force multiplier: accelerate model generation, documentation writing, SQL refactoring, and test creation.
/lili Champion AI-assisted workflows within the team, sharing effective prompting patterns and use cases that improve team velocity.
/lili Explore agentic analytics workflows and contribute to their adoption.
/lili Partner with engineers and business stakeholders to translate analytical requirements into robust data models.
/lili Guide and mentor Associate and mid-level Analytics Engineers through code reviews, pairing sessions, and knowledge sharing.
/lili Define team conventions around naming, folder structure, model contracts, and testing thresholds.
/li /ulp Skills Qualifications /pulli5+ years of experience in analytics engineering, data engineering, or a closely related data role.
/lili Expert-level dbt (Core or Cloud): layered modeling, advanced testing, macros, packages (dbt-utils, dbt-expectations), and CI/CD integration.
/lili Deep Snowflake expertise: query optimization, materialization strategies, clustering and access control.
/lili Advanced SQL and performance tuning.
/lili Strong understanding of data modeling concepts.
/lili Experience building or maintaining BI semantic layers and working with tools such as Sigma, Looker, Tableau, or Power BI.
/lili Excellent documentation habits: you believe models without docs are technical debt.
/lili Strong written and verbal English communication - you can explain data decisions to both engineers and business stakeholders.
/li /ulp Strong Plus /pulli Hands-on experience with AI tools for development tasks: query writing, documentation, debugging, and code review.
/lili Python proficiency for data transformation tasks, pipeline scripting, or working with the dbt Python model interface.
/lili Experience with orchestration tools (Airflow, Dagster, or dbt Cloud jobs).
/lili Understanding of automotive parts, catalog, or marketplace data domains.
/lili Experience working in a product-led data team with exposure to event/product analytics.
/li /ulp Why You Should Join Us /pp Our vision is to make it fast and easy for auto repair shops to find the right parts across all of their suppliers with one search.
Together, OEC#39;s team helped countless businesses save valuable time so they can focus on their customers — and we#39;re just getting started.
/pp The position is fully remote, with the requirement to attend quarterly in-person meetings.
/p /p