Senior Data Engineer

Pipe Recruit; Town of Poland (NY); Hybrid; USD 100,000 - 130,000; Full time

Job summary

A leading data-focused company is seeking a Senior Data Engineer to work remotely. The candidate will be responsible for migrating and optimizing data models, fixing SQL syntax differences, and collaborating with teams to ensure successful data integration. Required qualifications include a Bachelor's degree, 3+ years of experience in data engineering or analytics, and strong skills with SQL and BI tools like Tableau. This role also emphasizes communication and a pragmatic approach to data solutions.

Qualifications

• 3+ years in data engineering, BI, or analytics.
• 2+ years in financial services or SaaS.
• Hands-on experience with dbt and modern data modeling practices.

Responsibilities

• Migrate and optimize dbt models from Redshift and Snowflake to Trino.
• Fix SQL syntax differences between Redshift, Snowflake, and Trino.
• Collaborate with teams to validate migration impacts.
• Participate in agile workflows for efficient execution of tasks.

Skills

SQL proficiency (Redshift, Snowflake, Trino/Iceberg)

Experience with BI tools like Tableau

Familiarity with Git for version control

Knowledge of Jinja templating and macros in dbt

Strong communication skills

Pragmatic approach to data solutions

Education

Bachelor's degree in Computer Science, Information Systems, Mathematics, or related field

Tools

dbt (Data Build Tool)

Tableau

Git

Job description

Job Title: Senior Data Engineer

Location: Remote

Key Responsibilities

• Migrate and Refactor Data Models: Convert and optimize dbt models from Redshift and Snowflake to Trino (Iceberg), ensuring compatibility and performance.
• SQL Syntax Conversion: Fix SQL syntax differences between Redshift, Snowflake, and Trino.
• Data Modeling: Refactor and optimize data models to align with modern best practices for Iceberg.
• BI Integration: Work with Tableau assets to ensure data sources align with the new infrastructure.
• Collaboration: Partner with engineering and analytics teams to validate and test migration impacts.
• Version Control: Use Git to version control dbt models and ensure seamless deployments.
• Daily Standups: Participate in agile workflows to prioritize and execute migration tasks efficiently.

Must-Have Qualifications

• Education: Bachelors degree in Computer Science, Information Systems, Mathematics, or a related field (or equivalent experience).
• Experience:
  • 3+ years in data engineering, BI, or analytics.
  • 2+ years in financial services or SaaS.
  • Hands-on experience with dbt (Data Build Tool) and modern data modeling practices.
• Technical Skills:
  • Strong proficiency in SQL (Redshift, Snowflake, Trino/Iceberg).
  • Experience with BI tools like Tableau.
  • Familiarity with Git for version control.
  • Knowledge of Jinja templating and macros in dbt.
• Soft Skills:
  • Strong communication skills to guide teams through infrastructure changes.
  • Pragmatic approach to balancing speed and accuracy in data solutions.

Nice-to-Have Qualifications

• Experience working in startup environments.