Data Engineer (Snowflake / dbt / Fivetran)

$140000 - $165000

Seeking a Senior Data Engineer for a full-time, hybrid role in Addison, TX (3 days onsite). This position will play a key role in building and ultimately owning a modern data platform for a growing home services organization, leveraging Snowflake, dbt, Fivetran, Azure, and AI technologies. The ideal candidate will help drive enterprise reporting, data warehousing, and future AI initiatives across a multi-site business operating nationwide.

What makes this opportunity unique? You'll join during company-wide data transformation, helping build and own a brand-new Snowflake environment from the ground up. This is a high-impact role offering significant ownership, direct exposure to executive leadership, hands-on work with AI technologies, and a clear path to becoming the organization's long-term data engineering leader.

Required Skills & Experience

• 7+ years of Data Engineering experience

• Strong hands-on experience with Snowflake , including administration, optimization, and performance tuning

• Advanced dbt experience with ownership of production projects (models, tests, snapshots, macros, CI/CD, and environment management)

• Experience with Fivetran , Airbyte, Stitch, or similar ELT/integration platforms

• Strong understanding of data warehousing concepts and dimensional data modeling

Desired Skills & Experience

• Snowflake Cortex Experience

• AI/LLM integrations and prompt engineering experience

• Experience with Great Expectations, Monte Carlo, Elementary, Soda, or similar data quality tools.

• SnowPro Certification

• Experience in multi-site or rapidly growing organizations through M&A activities.

What You Will Be Doing

Tech Breakdown

• 40 % Snowflake Administration & Optimization

• 30 % dbt Development & Data Modeling

• 20 % Data Pipeline Development & ELT Management

• 10 % AI & Advanced Analytics Initiatives

Daily Responsibilities

• Own and optimize the Snowflake platform and data warehouse

• Develop and maintain dbt models, data pipelines, and data marts

• Manage data ingestion and integrations through Fivetran and related tools

• Ensure data quality, monitoring, and pipeline reliability

• Partner with business stakeholders and consulting teams to deliver scalable analytics solutions

• Evaluate and implement AI-driven capabilities, including Snowflake Cortex and LLM integrations

• Drive data engineering best practices, governance, and platform growth throughout the organization

The Offer

You will receive the following benefits:

• Eligible for salary bonus

• Medical, Dental & Vision Insurance

• PTO & Paid Holidays

• 401(k) with Company Match

• Hybrid Schedule (3 Days Onsite)

• Strong Growth & Leadership Opportunity

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

Motion Recruitment Partners (MRP) is an Equal Opportunity Employer. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying, and no sponsorship is currently available. Employment is subject to the successful completion of a pre-employment screening. Accommodation will be provided in all parts of the hiring process as required under MRP’s Employment Accommodation policy. Applicants need to make their needs known in advance.