Data Engineer

Mercor is partnering with a cutting-edge AI research lab to hire a Senior Data/Analytics Engineer with expertise across DBT and Snowflake’s Cortex CLI. In this role, you will build and scale Snowflake-native data and ML pipelines, leveraging Cortex’s emerging AI/ML capabilities while maintaining production-grade DBT transformations. You will work closely with data engineering, analytics, and ML teams to prototype, operationalise, and optimise AI-driven workflows—defining best practices for Snowflake-native feature engineering and model lifecycle management. This is a high-impact role within a modern, fully cloud-native data stack.

Responsibilities

• Design, build, and maintain DBT models, macros, and tests following modular data modeling and semantic best practices.
• Integrate DBT workflows with Snowflake Cortex CLI, enabling:
• Feature engineering pipelines
• Model training & inference tasks
• Automated pipeline orchestration
• Monitoring and evaluation of Cortex-driven ML models
• Establish best practices for DBT–Cortex architecture and usage patterns.
• Collaborate with data scientists and ML engineers to produce Cortex workloads in Snowflake.
• Build and optimise CI/CD pipelines for dbt (GitHub Actions, GitLab, Azure DevOps).
• Tune Snowflake compute and queries for performance and cost efficiency.
• Troubleshoot issues across DBT arti-facts, Snowflake objects, lineage, and data quality.
• Provide guidance on DBT project governance, structure, documentation, and testing frameworks.

Required Qualifications

• 3+ years experience with DBT Core or DBT Cloud, including macros, packages, testing, and deployments.
• Strong expertise with Snowflake (warehouses, tasks, streams, materialised views, performance tuning).
• Hands-on experience with Snowflake Cortex CLI, or strong ability to learn it quickly.
• Strong SQL skills; working familiarity with Python for scripting and DBT automation.
• Experience integrating DBT with orchestration tools (Airflow, Dagster, Prefect, etc.).
• Solid understanding of modern data engineering, ELT patterns, and version-controlled analytics development.

Nice-to-Have Skills

• Prior experience operationalising ML workflows inside Snowflake.
• Familiarity with Snow-park, Python UDFs/UDTFs.
• Experience building semantic layers using DBT metrics.
• Knowledge of MLOps / DataOps best practices.
• Exposure to LLM workflows, vector search, and unstructured data pipelines.

Why Join

• You will be an hourly contractor through Mercor, working 20–40 hours per week with flexibility.
• Direct opportunity to build next-generation Snowflake AI/ML systems with Cortex.
• High-impact ownership of DBT and Snowflake architecture across production pipelines.
• Work alongside top-tier ML engineers, data scientists, and research teams.
• Fully remote, high-autonomy environment focused on innovation, velocity, and engineering excellence.

We consider all qualified applicants without regard to legally protected characteristics and provide reasonable accommodations upon request.