Find & Apply For Software Developer / Engineer Jobs in New Brunswick, New Jersey

Job Description Insight Global is seeking a Senior Snowflake Engineer with 8+ years of overall data engineering experience to support a global solutions and services provider delivering enterprise data solutions to a leading healthcare end client. In this client-facing role, you will be responsible for designing, building, and optimizing the Snowflake data environment that will serve as the centralized platform for trusted enterprise data.

This role will work closely with the MDM Data Architect, data governance stakeholders, and engineering teams to translate the target-state MDM and enterprise data architecture into scalable, production-ready Snowflake solutions. A major focus will be ingesting and integrating master and operational data from enterprise source systems, implementing transformation and data quality frameworks, and ensuring trusted golden-record data can be efficiently consumed by downstream analytics, applications, and reporting platforms.

The ideal candidate is a senior, hands-on data engineer with 8+ years of professional data engineering experience and strong depth in Snowflake who can independently own complex engineering initiatives while contributing to technical design decisions, engineering standards, and modernization efforts within a regulated healthcare environment.

KEY RESPONSIBILITIESDesign and build scalable Snowflake data structures supporting master data and broader enterprise data workloadsDevelop ingestion and transformation pipelines to move data from enterprise sources and MDM platforms into SnowflakeBuild Snowflake-native ELT solutions utilizing advanced SQL, Streams, Tasks, stored procedures, and other appropriate Snowflake capabilitiesPartner with the MDM team to consume and operationalize golden-record data, including mastered entities, hierarchies, crosswalks, source identifiers, survivorship outputs, and other MDM attributesDevelop data models that support trusted enterprise views of customer, provider, product, organization, or other applicable master data domainsImplement incremental processing, change data capture, reconciliation, exception handling, and restart/recovery capabilities across data pipelinesDevelop automated data quality controls to validate completeness, accuracy, consistency, uniqueness, and integrity of data entering SnowflakeBuild and maintain ETL/ELT workflows that reliably integrate high-volume and complex enterprise dataDesign and implement secure data access patterns utilizing RBAC, masking policies, row-level security, encryption, and audit controlsOptimize warehouse configuration, query performance, storage patterns, compute utilization, and overall Snowflake costBuild monitoring and alerting capabilities for pipeline failures, data quality issues, SLA violations, and platform performanceImplement development and deployment standards utilizing Git and CI/CD pipelinesCreate reusable engineering frameworks and patterns to accelerate the onboarding of new data sources and MDM domainsSupport migration and modernization of legacy data pipelines, databases, and datasets into the target-state Snowflake architectureCollaborate with data governance teams to support metadata management, lineage, classification, business definitions, and governed access to enterprise dataProduce technical documentation including solution designs, data mappings, source-to-target specifications, runbooks, and operational support documentationParticipate in architecture and code reviews and provide technical guidance to other engineersTroubleshoot and resolve complex production issues related to Snowflake, data pipelines, data quality, and downstream consumption Skills and Requirements Minimum of 8+ years of professional data engineering experience, with demonstrated experience owning complex enterprise data engineering solutions4+ years of hands-on Snowflake engineering experience preferredAdvanced hands-on expertise with Snowflake architecture and engineering, including databases, schemas, warehouses, stages, Streams, Tasks, secure views, stored procedures, and performance optimizationAdvanced SQL skills with experience developing complex transformations across large-scale enterprise datasetsExtensive experience designing and building ETL/ELT pipelines for cloud-based enterprise data platformsExperience integrating Snowflake with multiple enterprise source systems, APIs, MDM platforms, and data integration technologiesStrong knowledge of dimensional, relational, and enterprise data modeling techniquesExperience implementing automated data quality, reconciliation, validation, and monitoring frameworksStrong understanding of data governance and master data concepts, including the role of golden records and governed enterprise dataExperience working with Python for data engineering, automation, and pipeline developmentExperience working within Git, CI/CD, and modern software/data engineering practices, including version control, automated testing, and controlled deploymentsAbility to troubleshoot complex data issues across source systems, transformation layers, Snowflake, and downstream consumersStrong communication skills with the ability to operate directly with architects, engineering teams, and client stakeholders in a senior technical capacityExperience supporting healthcare industry data initiatives, including working with PHI or other regulated dataUnderstanding of HIPAA security and privacy requirements as they apply to cloud data platformsExperience integrating Snowflake with MDM platforms such as IBM InfoSphere MDM, Informatica MDM, Reltio, SAP MDG, Semarchy, or ProfiseeFamiliarity with MDM concepts including golden records, match/merge, survivorship, source ranking, hierarchies, crosswalks, and data stewardshipExperience with Informatica Cloud Data Governance and Catalog (CDGC) or comparable data governance/catalog solutionsExperience modernizing legacy data warehouses or ETL platforms into SnowflakeSnowflake certifications such as SnowPro Core or SnowPro AdvancedExperience implementing automated data testing frameworks and data observability solutionsExperience working in a consulting, professional services, or client-facing enterprise environment 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 employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to 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 the recruiting process, please send a request to HR@insightglobal.com.