Senior Data Engineer — Azure DW, ETL & SQL Expert

Jobtailor; Covington (LA); On-site; USD 120,000 - 160,000; Full time

Job summary

Jobtailor in the United States is seeking an experienced Data Engineer to design, develop, and maintain robust ETL/ELT pipelines using Azure Data Factory and SSIS, and to build data warehouse schemas in SQL Server and Azure SQL Database.

You will optimize T-SQL queries, collaborate with data analysts and scientists, enforce data quality and governance, and help modernize the data platform with emerging technologies. Applicants must be US-based and eligible to work full-time.

Qualifications

• 5+ years of professional experience in data engineering or a closely related field.
• Advanced proficiency in SQL Server and Azure SQL Database, including T-SQL development and query optimization.
• Hands-on experience building and maintaining SSIS packages for complex ETL workflows.
• Strong experience with Azure Data Factory (pipelines, linked services, triggers, data flows).
• Working knowledge of Microsoft Fabric, including Power BI, Azure Analysis Services, and Tabular Models.
• Solid understanding of data warehousing concepts: dimensional modeling, star schemas, Kimball and Inman methodology.
• Experience designing and implementing data marts and enterprise data warehouse solutions.
• Familiarity with third normal form (3NF) database structures, slowly changing dimensions (SCDs), and incremental load patterns.
• Strong proficiency in at least one programming language (Python, C#).
• Experience with source control systems (Git) and collaborative development workflows.
• Ability to work independently and translate complex business requirements into scalable technical data solutions.
• Excellent analytical thinking, problem‑solving, testing, and team communication skills.
• Applicants must be currently authorized to work in the United States on a full‑time basis.

Responsibilities

• Design, develop, and maintain robust ETL/ELT pipelines using Azure Data Factory and SSIS.
• Build and manage data warehouse schemas, models, and processes in SQL Server and Azure SQL Database.
• Optimize complex T-SQL queries, stored procedures, and database objects for performance and reliability.
• Collaborate with data analysts, scientists, and stakeholders to understand data requirements and deliver scalable solutions.
• Establish and enforce data quality standards, governance, and documentation.
• Monitor and troubleshoot data pipelines to ensure data availability and accuracy.
• Participate in code reviews, architectural design discussions, and engineering best practices.
• Evaluate and integrate emerging data technologies to modernize the data platform.
• Support data collection, storage, access, transformation, quality, and security for analysis.

Skills

SQL Server

Azure SQL Database

Azure Data Factory

SSIS

Data Warehousing

Python

C#

Git

Data Modeling

ETL

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, or equivalent practical experience

Tools

Power BI

Azure Databricks

Microsoft Fabric

Azure DevOps

Job description

Jobtailor in the United States is seeking an experienced Data Engineer to design, develop, and maintain robust ETL/ELT pipelines using Azure Data Factory and SSIS, and to build data warehouse schemas in SQL Server and Azure SQL Database.

You will optimize T-SQL queries, collaborate with data analysts and scientists, enforce data quality and governance, and help modernize the data platform with emerging technologies. Applicants must be US-based and eligible to work full-time.