Senior Data Engineer (Snowflake / dbt / Fivetran / AWS)

Motion Recruitment; Dallas (TX); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Retirement Benefits

Paid Time Off

Life Insurance

Professional Development

Job summary

Motion Recruitment is seeking a Senior Data Engineer to join a growing enterprise data team in the North Dallas area. This full-time, onsite role requires four days per week in the office and focuses on a large-scale data modernization initiative using Snowflake and AWS.

You will build scalable data products, establish engineering standards, and help shape the future of a rapidly expanding data organization, with responsibilities across ingestion, ETL/ELT, warehousing, and cloud technologies.

Qualifications

• 5+ years of data engineering experience.
• Strong Snowflake experience with sizing, clustering, partitioning and performance tuning.
• Experience with Fivetran data ingestion and CDC pipelines.
• Strong dbt experience including staging, intermediate, and mart layer development.
• ETL/ELT pipeline development experience.

Responsibilities

• Hands-on data engineering across ingestion, transformation, and warehousing.
• Contribute to a large-scale data modernization initiative using Snowflake and AWS.
• Establish engineering standards and best practices across the team.
• Build scalable data products and enterprise data solutions.

Skills

Data Engineering Experience

Snowflake

Fivetran

dbt

ETL/ELT

Job description

We are seeking a Senior Data Engineer to join a growing enterprise data team within a leading financial services organization in the North Dallas area. This full-time opportunity requires onsite collaboration four days per week and offers the chance to play a key role in a large-scale data modernization initiative. The organization is making significant investments in modern data platforms, cloud technologies, and enterprise data products, creating an exciting environment for engineers who want to build scalable solutions, influence technical direction, and help shape the future of a rapidly expanding data organization.

This team is being built from the ground up under new data leadership with a mission to centralize data, modernize analytics capabilities, and deliver scalable data products across the business. The ideal candidate is a well-rounded data engineer with experience across data ingestion, ETL/ELT development, data warehousing, and cloud technologies. You’ll have the opportunity to work throughout the entire data lifecycle while helping establish engineering standards, best practices, and enterprise-scale solutions built on Snowflake and AWS.

Required Skills & Experience

• 5+ years of Data Engineering experience
• Strong Snowflake experience including warehouse sizing, clustering, partitioning, and performance optimization
• Experience with Fivetran data ingestion and CDC pipelines
• Strong dbt experience including staging, intermediate, and mart layer development
• ETL/ELT pipeline development experience

Desired Skills & Experience

• Data warehouse architecture experience
• Analytics engineering expertise
• Data governance and data quality experience
• Experience building enterprise data products
• Kafka or streaming platform experience

What You Will Be Doing

Tech Breakdown

• 35% Snowflake & Data Warehousing
• 25% dbt & Data Transformation
• 20% Data Ingestion & Fivetran
• 10% Python/PySpark Development
• 10% DevOps, Terraform & CI/CD

Daily Responsibilities

• 80% Hands-On Engineering
• 10% Architecture & Technical Design
• 10% Team Collaboration

The Offer

• Medical, Dental, and Vision Insurance
• Retirement Benefits
• Paid Time Off
• Life Insurance
• Professional Development Opportunities

Applicants must be currently authorized to work in the US on a full-time basis now and in the future.