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:2040 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 DBTCortex 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 2030 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: [Confidential Information]
PS: Our team reviews applications daily. Please complete your AI interview and application steps to be considered for this opportunity.
,
