Snowflake/Python Developer

Job Description

*ONSITE INTERVIEW NEXT WEEK IN JERSEY CITY, NJ. NO EXCEPTIONS FOR VIRTUAL!!**

\n

\n

*DO NOT APPLY IF YOU CANNOT GO ONSITE FOR INTERVIEW*

\n

\n

Key Responsibilities

\n

\n
• Design, build, and maintain scalable, modular dbt models and transformation pipelines using DBT Core.

\n

• Understand DBT Architecture thoroughly and experience in writing Python operators in DBT flow. Strong experience in writing Jinja code, macros, seeds etc.

\n

• Design and develop data warehouses using Snowflake.

\n

• Build and maintain ETL/ELT pipelines to load data from multiple sources.

\n

• Optimize Snowflake performance (Clustering, Warehouses, Query tuning).

\n

• Implement data security (roles, access control, masking)

\n

• Knowledge of data modeling techniques like data vault and dimensional modeling (Kimball/Inmon).

\n

• Automate workflows using data orchestration tools (Apache Airflow or Snowflake Tasks)

\n

• Collaborate with full-stack developers and UI/UX engineers to support application features that rely on transformed datasets.

\n

• Work closely with analysts and stakeholders to gather data requirements and translate them into reliable data models.

\n

• Enforce data quality through rigorous testing, documentation, and version control in dbt.

\n

• Participate in Agile ceremonies (e.g., stand-ups, sprint planning) and manage tasks using Jira.

\n

• Integrate dbt into CI/CD pipelines and support automated deployment practices.

\n

• Monitor data performance and pipeline reliability, and proactively resolve issues.

\n

\n

\n

Mandatory Qualifications & Skills

\n

\n
• 3–5+ years of experience in data engineering or analytics engineering, with a focus on SQL-based data transformation.

\n

• Hands-on production experience using dbt core or dbt cloud as a primary development tool.

\n

• Strong command of SQL and solid understanding of data modeling best practices (e.g., star/snowflake schema).

\n

• Proven experience with Snowflake as a cloud data warehouse.

\n

• Python skills for data pipeline integration or ingestion.

\n

• Familiarity with Git-based version control workflows.

\n

• Strong communication and collaboration skills, with the ability to work across engineering and business teams.

\n

• Experience working in Agile/Scrum environments and managing work using Jira.

\n

• Nice-to-Have Skills Exposure to CI/CD pipelines and integrating dbt into automated workflows.

\n

• Experience with cloud platforms such as AWS.

\n

• Understanding of how data is consumed in downstream analytics tools (e.g., Sigma, Qlik, Power BI).

\n

• Familiarity with Docker and container-based development.

\n

\n

\n

Education & Experience

\n

\n
• Bachelor’s degree in computer science, Data Engineering, or related field.

\n

• A track record of building and maintaining scalable dbt projects in a production setting with Snowflake and Airflow.

\n

• Experience working in cross-functional teams involving developers, analysts, and product managers.

\n

• A strong sense of ownership, documentation habits, and attention to data quality and performance.

\n