Data Engineer (Investment Banking)

Phyton Talent Advisors; Jersey City (NJ); On-site; USD 110,000 - 160,000; Full time

Job summary

Phyton Talent Advisors is seeking a Data Engineer to design, build, and maintain dbt-based transformation pipelines in a Snowflake environment. You will collaborate with backend and frontend engineers, product managers, and analysts to create analytics-ready data models that power application features, reporting, and strategic insights.

The role emphasizes clean data design, modern tooling, and hands-on implementation of data warehouses, ETL/ELT pipelines, data quality, and CI/CD integration

Qualifications

• Bachelor’s degree in computer science or a related field.
• 3–5 years of data/analytics engineering focusing on SQL-based transformations.
• Hands-on experience with dbt core/cloud as a primary development tool.
• Strong SQL and data modeling knowledge (star/snowflake).

Responsibilities

• Design, build, and maintain scalable dbt models and transformation pipelines.
• Develop data warehouses using Snowflake and optimize performance.
• Build and maintain ETL/ELT pipelines from multiple sources.
• Enforce data quality with tests and version control in dbt.
• Collaborate with engineers, product managers, and analysts.
• Participate in Agile ceremonies and manage tasks with Jira.

Skills

SQL

dbt Core/Cloud

Data modeling

Git

Agile/Scrum teamwork

Analytical thinking

Education

Bachelor’s degree in Computer Science / Data Engineering

Tools

dbt Core

Snowflake

Airflow

Jira

Python

Git

Job description

Job Summary We are seeking a skilled and detail-oriented Data Engineer to join our cross-functional Agile team. In this role, you will be responsible for designing, building, and maintaining modular, reliable data transformation pipelines using dbt (Data Build Tool) in a Snowflake environment. You will collaborate closely with backend and frontend engineers, product managers, and analysts to create analytics-ready data models that power application features, reporting, and strategic insights. This is an exciting opportunity for someone who values clean data design, modern tooling, and working at the intersection of engineering and business.

Responsibilities

• Design, build, and maintain scalable, modular dbt models and transformation pipelines using DBT Core.
• Understand DBT Architecture thoroughly and experience in writing Python operators in DBT flow.
• Strong experience in writing Jinja code, macros, seeds etc.
• Design and develop data warehouses using Snowflake.
• Build and maintain ETL/ELT pipelines to load data from multiple sources.
• Optimize Snowflake performance (Clustering, Warehouses, Query tuning).
• Implement data security (roles, access control, masking).
• Knowledge of data modeling techniques like data vault and dimensional modeling (Kimball/Inmon).
• Automate workflows using data orchestration tools (Apache Airflow or Snowflake Tasks).
• Collaborate with full-stack developers and UI/UX engineers to support application features that rely on transformed datasets.
• Work closely with analysts and stakeholders to gather data requirements and translate them into reliable data models.
• Enforce data quality through rigorous testing, documentation, and version control in dbt.
• Participate in Agile ceremonies (e.g., stand-ups, sprint planning) and manage tasks using Jira.
• Integrate dbt into CI/CD pipelines and support automated deployment practices.
• Monitor data performance and pipeline reliability, and proactively resolve issues.

Qualifications

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

Required Skills

• 3-5 years of experience in data engineering or analytics engineering, with a focus on SQL-based data transformation.
• Hands-on production experience using dbt core or dbt cloud as a primary development tool.
• Strong command of SQL and solid understanding of data modeling best practices (e.g., star/snowflake schema).
• Proven experience with Snowflake as a cloud data warehouse.
• Familiarity with Git-based version control workflows.
• Strong communication and collaboration skills, with the ability to work across engineering and business teams.
• Experience working in Agile/Scrum environments and managing work using Jira.
• A track record of building and maintaining scalable dbt projects in a production setting with Snowflake and Airflow.
• Experience working in cross-functional teams involving developers, analysts, and product managers.
• A strong sense of ownership, documentation habits, and attention to data quality and performance.

Preferred Skills

• Exposure to CI/CD pipelines and integrating dbt into automated workflows.
• Experience with cloud platforms such as AWS.
• Understanding of how data is consumed in downstream analytics tools (e.g., Sigma, Qlik, Power BI).
• Familiarity with Docker and container-based development.