Data Engineer

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 #J-18808-Ljbffr Jobtailor