About The Job
Mercor connects elite creative and technical talent with leading AI research labs. Headquartered in San Francisco, our investors include Benchmark, General Catalyst, Peter Thiel, Adam D'Angelo, Larry Summers, and Jack Dorsey.
Position: Senior Data/Analytics Engineer
Type: Hourly contractor
Compensation: $35–$70/hour
Location: Remote
Commitment: 20–40 hours/week
Role 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 to enable feature engineering pipelines, model training and inference tasks, automated pipeline orchestration, and 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 optimize CI/CD pipelines for DBT using GitHub Actions, GitLab, and Azure DevOps.
* Tune Snowflake compute and queries for performance and cost efficiency.
Qualifications
Must-Have
* 3+ years experience with DBT Core or DBT Cloud, including macros, packages, testing, and deployments.
* Strong expertise with Snowflake (warehouses, tasks, streams, materialized 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.
Preferred
* Prior experience operationalizing 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.
Application Process (Takes 20–30 mins to complete)
* Upload resume
* AI interview based on your resume
* Submit form
Resources & Support
* For details about the interview process and platform information, please check: https://talent.docs.mercor.com/welcome/welcome
* For any help or support, reach out to: support@mercor.com
PS: Our team reviews applications daily. Please complete your AI interview and application steps to be considered for this opportunity.
,