Senior Data Engineer: Snowflake & Azure Pipelines Lead

Robotic Technologies Automation; Irving (TX); On-site; USD 110,000 - 160,000; Full time

Job summary

Robotic Technologies Automation is seeking an experienced Data Engineer to design, build, and optimize scalable data pipelines around Snowflake in Irving, TX. The role emphasizes data modeling, SQL proficiency, and ETL/ELT development using Informatica, Azure Data Factory, and dbt.

You will collaborate with analysts and architects to deliver accurate analytics, ensure data governance, and troubleshoot production issues across cloud platforms such as AWS or Azure.

Responsibilities

• Design, develop, and maintain scalable data pipelines using Snowflake.
• Strong experience in data modeling, including dimensional modeling, star and snowflake schemas.
• Develop complex SQL queries, stored procedures, and performance-optimized data transformations.
• Build and maintain ETL/ELT pipelines using tools such as Informatica, Azure Data Factory, dbt, or similar.
• Implement data integration from multiple source systems into Snowflake.
• Optimize Snowflake queries, warehouses, storage, and overall performance.
• Develop data models for analytics, reporting, and business intelligence.
• Ensure data quality, accuracy, security, and governance.
• Work with business analysts, architects, and data teams to understand requirements.
• Troubleshoot data pipeline and production issues.
• Participate in code reviews, documentation, and technical design discussions.

Job description

Robotic Technologies Automation is seeking an experienced Data Engineer to design, build, and optimize scalable data pipelines around Snowflake in Irving, TX. The role emphasizes data modeling, SQL proficiency, and ETL/ELT development using Informatica, Azure Data Factory, and dbt.

You will collaborate with analysts and architects to deliver accurate analytics, ensure data governance, and troubleshoot production issues across cloud platforms such as AWS or Azure.