What are the responsibilities and job description for the Data Engineer (Snowflake / dbt / Fivetran) position at Motion Recruitment?
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
Tech Breakdown
You Will Receive The Following Benefits
Posted By: Tariq Othman
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
- 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.
Tech Breakdown
- 40% Snowflake Administration & Optimization
- 30% dbt Development & Data Modeling
- 20% Data Pipeline Development & ELT Management
- 10% AI & Advanced Analytics Initiatives
- 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
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
Posted By: Tariq Othman
Salary : $140,000 - $165,000