Data Engineer

Data Engineer

Insight Global is hiring a Data Engineer to contribute to ongoing operational data workflows for a major healthcare partner. This individual will focus on supporting data ingestion and processing in a high-volume healthcare environment. On a day-to-day basis, the engineer will work extensively with SQL and SSIS, reviewing and interpreting legacy SSIS packages, running heavy queries, and validating data accuracy across multiple processes. The team requires careful transformation, auditing, and verification to ensure strict HIPAA compliance and complete data isolation between clients. Much of the work is routine and detail-oriented, with occasional data issues to troubleshoot, and includes validating that all components of existing SSIS packages are accurately maintained or migrated as part of ongoing platform transitions.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.

Skills and Requirements:

• 4+ years of hands-on data engineering experience
• Strong proficiency in SQL, with a solid understanding of best practices and extensive experience working with SQL Server and SSIS
• Demonstrated experience performing in-depth data analysis, including writing and maintaining complex SQL queries
• Extensive experience working with SSIS packages, including:
• Reading and interpreting existing SSIS packages
• Understanding end-to-end package workflows and individual process steps
• Reviewing and validating legacy SSIS packages to ensure accuracy and completeness
• Confirming all processes within a package (e.g., multiple workflows) are properly migrated and aligned
• Prior experience supporting ETL processes, including:
• Transforming inbound data files
• Loading data into downstream systems
• Developing, maintaining, and understanding complex SQL transformations
• Demonstrates strong diligence and attention to detail
• Experience supporting client data ingestion processes, with a strong understanding of handling healthcare PHI/PII data
• Hands-on experience with Azure Data Factory (ADF)
• Prior experience working with Snowflake
• Previous experience migrating data pipelines from SSIS to ADF