Data Insights Engineer: Snowflake & ETL Specialist

Jobtailor; Irving (TX); On-site; USD 110,000 - 150,000; Full time

Job summary

Jobtailor in Irving, TX is seeking a Data Engineer to design, build, and support scalable data warehouse solutions using Snowflake and Matillion. You will develop SQL-based transformations, data models, and integrations for BI and analytics, while ensuring data quality and reliability across enterprise sources like Oracle.

Responsibilities include optimizing warehouse performance, troubleshooting production issues, and collaborating with engineers, analysts, product teams, and stakeholders to

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field, or equivalent experience with typically 4+ years of relevant professional experience
• 4+ years of experience in Data Engineering, Software Engineering, Data Warehousing, or related technical field
• Strong SQL development experience, including complex queries, transformations, joins, and performance optimization
• Experience building and supporting ETL/ELT pipelines
• Experience with Snowflake or a comparable cloud data warehouse platform
• Understanding of data warehousing concepts, data modeling, and data quality practices
• Experience using Git-based source control, CI/CD pipelines, and Agile development methodologies
• Strong troubleshooting, analytical, and problem-solving skills
• Experience with Snowflake, Matillion, Oracle, Azure, and Change Data Capture technologies such as Qlik Replicate preferred
• Familiarity with Looker, Power BI, Tableau, dimensional modeling, analytics engineering, AI/ML technologies, and translating business requirements into scalable data solutions preferred

Responsibilities

• Design, build, and support scalable data warehouse solutions and data pipelines using Snowflake and Matillion
• Develop SQL-based transformations, data models, and integrations for reporting, analytics, and business intelligence solutions
• Integrate data from Oracle and other enterprise systems while ensuring data quality, accuracy, and reliability
• Optimize data warehouse performance through query tuning, efficient data architecture, and platform best practices
• Troubleshoot and resolve data pipeline, production, and warehouse issues supporting business-critical operations
• Support source control, CI/CD, code reviews, testing, and production deployments
• Partner with engineers, analysts, product teams, architects, and business stakeholders to deliver documented data solutions and actionable insights

Skills

SQL Development

Data Warehousing

ETL/ELT Pipelines

Data Modeling

Data Quality Practices

Query Tuning

Data Pipeline Development

Data Integration

Git-based Source Control

CI/CD

Looker

Power BI

Tableau

Qlik Replicate

Education

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

Tools

Snowflake

Matillion

Oracle

Azure

Git

CI/CD

Looker

Power BI

Tableau

Qlik Replicate

Job description

Jobtailor in Irving, TX is seeking a Data Engineer to design, build, and support scalable data warehouse solutions using Snowflake and Matillion. You will develop SQL-based transformations, data models, and integrations for BI and analytics, while ensuring data quality and reliability across enterprise sources like Oracle.

Responsibilities include optimizing warehouse performance, troubleshooting production issues, and collaborating with engineers, analysts, product teams, and stakeholders to