Data Engineer (contract)

Title: Data Engineer Location: Charlotte, NC Duration: 12 months Work Engagement: W-2 Benefits on offer for this contract position: Health Insurance, Life insurance, 401K and Voluntary Benefits Summary: In this contingent resource assignment, you may: Consult on complex initiatives with broad impact and large-scale planning for Information Security Engineering. Review and analyze complex multi-faceted, larger scale or longer-term Information Security Engineering challenges that require in-depth evaluation of multiple factors including intangibles or unprecedented factors. Contribute to the resolution of complex and multi-faceted situations requiring solid understanding of the function, policies, procedures, and compliance requirements that meet deliverables. Strategically collaborate and consult with client personnel. 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. 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. Qualifications: • Applicants must be authorized to work for ANY employer in the U.S. This position is not eligible for visa sponsorship. • 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.