Data Engineer – SQL Server, SSIS & Microsoft Fabric

Data Engineer – SQL Server, SSIS & Microsoft Fabric
Location: Charlotte, NC (Hybrid – 3 days in office)
W2

Job Summary
We are seeking a highly skilled Data Engineer to design, build, and maintain robust data
pipelines and integration workflows using SQL Server, SSIS, and Microsoft Fabric. This role
is critical to enabling secure, scalable, and high-performance data solutions that support
cybersecurity metrics, reporting, and automation initiatives.
Key Responsibilities
 Design and implement ETL pipelines using SSIS and SQL Server to support data
ingestion, transformation, and delivery across cybersecurity platforms.
 Develop and optimize data workflows within the Microsoft Fabric ecosystem, including
Azure Data Factory, Synapse Analytics, and OneLake.
 Collaborate with data analysts, architects, and cybersecurity SMEs to translate business
requirements into scalable data solutions.
 Maintain and enhance SSIS packages, including deployment, configuration, and job
scheduling via SQL Server Agent.
 Participate in database migration and modernization efforts, including Always On
configurations and cross-data center replication.
 Ensure data quality, integrity, and lineage through rigorous validation, logging, and
monitoring practices.
 Support hybrid cloud deployments and integration between on-premises SQL
environments and Microsoft Fabric services.
 Document data models, workflows, and operational procedures for QA, audit and
knowledge transfer.
Required Qualifications
 5+ years of experience in data engineering with a focus on SQL Server and SSIS.
 Hands-on experience with Microsoft Fabric components such as Azure Data Factory,
Synapse, and Data Lake.
 Strong SQL skills, including performance tuning, stored procedures, and job automation.
 Experience with enterprise-scale ETL processes and data warehousing.
 Familiarity with data governance, security, and compliance in regulated environments.
 Financial services experience, specifically big banks.

Preferred Qualifications
 Experience with Spark SQL, PySpark, or Databricks within Microsoft Fabric.
 Exposure to DevOps practices, including CI/CD pipelines for data workflows.
 Knowledge of structured streaming and real-time data processing.
 Familiarity with metadata management and data cataloging tools.
Tools & Technologies
 Microsoft SQL Server (2016+)
 SSIS, SSMS, SQL Server Agent
 Microsoft Fabric (Azure Data Factory, Synapse, OneLake)
 PowerShell, Python (for automation and validation)
 Git, Azure DevOps