Data Engineer

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

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 other stakeholders to understand data requirements and deliver scalable solutions
Establish and enforce data quality standards, data governance practices, and documentation
Monitor and troubleshoot data pipelines, proactively resolving issues 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 and other applications

Requirements

• 5+ years of professional experience in data engineering or a closely related field
• Bachelor's degree in Computer Science, Information Systems, Engineering, or equivalent practical experience
• 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
• Candidates must reside and work within the United States
• Successful completion of pre‑employment drug testing and background verifications
• Preferred: Knowledge of Microsoft Fabric and Azure Databricks
• Preferred: Experience with Azure DevOps for CI/CD of data solutions
• Preferred: Familiarity with AI tools, including large language models and their integration into data workflows
• Preferred: Development experience with machine learning for forecasting, grouping, and anomaly detection
• Preferred: Knowledge of real‑time or streaming data architectures
• Preferred: Understanding of UniBasic databases and coding languages
• Preferred: Exposure to data catalog and data lineage tools
• Preferred: Understanding of Waterfall and Agile/Scrum development methodologies

Core Competencies

Demonstrates advanced proficiency in SQL Server and Azure SQL Database, with expertise in T‑SQL development, ETL processes using Azure Data Factory and SSIS, and data warehousing concepts. Capable of optimizing data pipelines and ensuring data quality while collaborating effectively with cross‑functional teams.

Highest-signal resume keywords

• SQL Server
• Azure SQL Database
• Azure Data Factory
• SSIS
• Data Warehousing

ATS Optimization Keywords

Hard Skills

• T‑SQL Development
• ETL Processes
• Data Modeling
• Data Governance
• Data Quality Standards
• Python
• C#
• Git
• Data Mart Design
• Incremental Load Patterns

Soft Skills

• Analytical Thinking
• Problem‑Solving
• Team Communication

Industry Keywords

• Data Engineering
• Data Pipelines
• Dimensional Modeling
• Star Schemas
• Agile/Scrum
• Waterfall
• Data Catalog
• Data Lineage

Tools & Technologies

• Microsoft Fabric
• Power BI
• Azure Analysis Services
• Azure Databricks
• Azure DevOps