Job description

Job Description STRATEGIC STAFFING SOLUTIONS HAS AN OPENING. This is a Contract Opportunity with our company that MUST be worked on a W2 Only. No C2C eligibility for this position. Visa Sponsorship is Available. The details are below. "Beware of scams. S3 never asks for money during its onboarding process." Job Title: Information Security Data Engineer Location: Charlotte, NC 28202 Contract Length: 12+ Months Hybrid Work (3 days on site/ 2 days remote) Job ref #243001 Qualifications/Requirements 5+ years 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 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.

Requirements