Software Engineer – Data Insights

McKesson; 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

• 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

Requirements

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a 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 a 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

Core Competencies

Demonstrates expertise in designing and supporting scalable data warehouse solutions using Snowflake and Matillion, with strong SQL development skills for data transformations and integrations. Proficient in optimizing data architecture and ensuring data quality while collaborating with cross-functional teams to deliver actionable insights.

Highest-signal resume keywords

• SQL Development


• Data Engineering


• Snowflake


• ETL/ELT Pipelines


• Data Warehousing

ATS Optimization Keywords

Hard Skills

• SQL


• Data Modeling


• Data Quality Practices


• Query Tuning


• Data Pipeline Development


• Data Integration


• Performance Optimization


• Troubleshooting


• Analytics Engineering


• Change Data Capture

Soft Skills

• Analytical Skills


• Problem-Solving Skills

Industry Keywords

• Data Warehousing


• Data Engineering


• Software Engineering


• Agile Development


• Business Intelligence

Tools & Technologies

• Snowflake


• Matillion


• Oracle


• Azure


• Git


• CI/CD


• Looker


• Power BI


• Tableau


• Qlik Replicate