C2C contract jobs
Location New York Onsite
Must Have Skills
Strong handson expertise with dbt Core model development Jinjamacros sources tests documentation and packaging reusability
Advanced SQL complex transformations performance tuning query optimization
Solid dimensionaldata warehouse modeling knowledge starsnowflake factsdimensions SCD concepts as applicable
Experience delivering ELT on Databricks Databricks SQL Delta Lake concepts efficient joinsfile layouts understanding of medallion patterns bronze silver gold where used
Git proficiency with PRbased workflows branching code reviews merge strategies cherry picking
CI practices for dbt eg run dbt compilebuildtest in pipelines enforce quality gates
Ability to build scalable maintainable models modular layers naming conventions documented contracts
Secondary NicetoHave Skills
Exposure to Orchestration tools ADFAirflowDagsterPrefect etc
Familiarity with downstream consumption patterns
Comfortable using AIassisted dev tools eg Copilot in accordance with company policy
Soft Skills
Strong problemsolving and analytical thinking
Excellent communication skills to collaborate with crossfunctional teams data engineers analysts product managers
Ability to mentor junior engineers and promote best practices
Detailoriented with a focus on data quality and reliability
Adaptability in fastpaced evolving environments
Ownership mindset with proactive approach to challenges
Qualifying Questions
1 Willing to work from customer location
2 Can you describe a complex DBT project youve led including challenges and outcomes
3 How do you ensure data quality and reliability in DBT transformations
4 What strategies do you use to optimize SQL queries and DBT models for performance
5 Have you implemented CICD pipelines for DBT projects If yes how
7 Whats your experience with cloud data warehouses Snowflake BigQuery Redshift etc
8 How do you handle documentation and testing in DBT projects”
To apply for this job email your details to neha.chaudhary@compunnel.com