Senior Data Engineer (Hybrid)

Serigor Inc.; Wilmington (DE); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Serigor Inc. in Wilmington, DE, is seeking a Senior Data Engineer (Hybrid) to lead a large-scale data modernization program. You will design Snowflake structures, build scalable data pipelines, and collaborate across analytics, engineering, and governance teams.

The role emphasizes data migration from legacy systems, CI/CD automation in Azure DevOps, data quality, metadata management, and rapid delivery in an Agile environment.

Qualifications

• 7+ years of experience in Data Engineering or Data Management.
• Strong Snowflake experience.
• Advanced SQL development skills.
• Experience with SSIS and enterprise ETL.
• Experience with Azure DevOps and CI/CD pipelines.
• Experience with data modeling and governance.
• Experience with Agile methodologies.

Responsibilities

• Data migration and modernization of enterprise assets.
• Design, develop, and maintain Snowflake schemas and data models.
• Build and optimize ETL/ELT pipelines and data integrations.
• Support reporting datasets and analytics initiatives.
• Contribute to data governance, quality, and metadata programs.
• Participate in QA, testing, and deployment activities.
• Provide documentation and knowledge transfer across teams.

Skills

Snowflake

SQL

Python

ETL/ELT

Azure DevOps

Data modeling

Data governance

Agile

Tools

SSIS

Microsoft Purview

Job description

Job Title: Senior Data Engineer (Hybrid)

Location: Wilmington, DE/Berwyn, PA

Duration: 18 Months, quarterly increments

Job Description

Senior Data Engineer to support a large-scale enterprise data modernization initiative focused on migrating critical banking and enterprise data assets into a centralized Snowflake platform. This strategic program will transform how data is organized, governed, and utilized across the organization, enabling improved analytics, reporting, data quality, and business decision-making.

The consultant will join a multi-year transformation effort focused on migrating approximately 30 enterprise data domains from legacy platforms into a modern cloud-based ecosystem. Working within an Agile environment, this individual will play a critical role in designing, engineering, testing, governing, and supporting enterprise data solutions that power the future state of data and analytics across the organization.

Key Responsibilities

• Data Migration & Modernization
  • Analyze source systems, legacy databases, and existing data architectures.
  • Design and implement Snowflake database structures, schemas, and data models.
  • Migrate enterprise data assets from multiple source systems into Snowflake.
  • Build, enhance, and maintain ETL/ELT processes utilizing SSIS and related technologies.
  • Develop data transformation logic to support reporting and analytics requirements.
  • Validate data integrations and transformation accuracy.
• Data Engineering
  • Design, develop, and maintain scalable data pipelines.
  • Optimize data ingestion, transformation, and storage processes.
  • Support Azure DevOps (ADO) CI/CD pipelines and deployment automation.
  • Create reusable frameworks, standards, and methodologies for data movement and integration.
  • Develop SQL and Python-based solutions to support enterprise data initiatives.
• Reporting & Analytics
  • Develop reporting datasets and data marts.
  • Support the creation of business intelligence and analytical solutions.
  • Ensure consistency and accuracy between reports and source systems.
  • Collaborate with business stakeholders to support reporting requirements.
• Data Governance & Data Quality
  • Support enterprise data governance initiatives and best practices.
  • Implement and maintain data retention policies.
  • Improve data quality, consistency, lineage, and integrity.
  • Assist with metadata management and governance programs.
  • Support evaluation and implementation of governance platforms such as Microsoft Purview.
  • Contribute to Master Data Management (MDM) initiatives.
• Quality Assurance & Testing
  • Develop data testing strategies and quality assurance processes.
  • Support reconciliation, data validation, and defect remediation activities.
  • Participate in User Acceptance Testing (UAT) and QA cycles.
  • Support deployment validation and production release activities.
• Operational Support
  • Provide ongoing support for production data platforms and related processes.
  • Troubleshoot performance issues, data failures, and platform incidents.
  • Perform root cause analysis and implement corrective actions.
  • Support quarterly release cycles and post-deployment activities.
  • Assist with future migration and platform enhancement initiatives.
• Documentation & Knowledge Transfer
  • Create and maintain technical documentation, including:
  • Data mappings
  • Source-to-target specifications
  • ETL/ELT process documentation
  • Data lineage documentation
  • Architecture diagrams
  • Operational procedures
  • Conduct knowledge transfer sessions with internal teams.
  • Promote engineering standards, documentation practices, and best practices.

Minimum Education and Experience

• Degree and/or certifications required: NA (not specified by the client).
• 7+ years of experience in Data Engineering, Data Warehousing, or Data Management.
• Strong experience designing and developing solutions within Snowflake.
• Advanced SQL development skills.
• Experience with SSIS and enterprise ETL development.
• Experience building ELT/ETL pipelines and data integration solutions.
• Experience with Azure DevOps (ADO), CI/CD pipelines, and release management.
• Experience with data modeling, schema design, and database architecture.
• Knowledge of data governance, metadata management, and data quality frameworks.
• Experience supporting Agile software development methodologies.

Preferred Qualifications

• Experience within financial services, banking, or regulated industries.
• Experience with Python scripting and automation.
• Experience with Microsoft Purview or similar data governance tools.
• Experience with Master Data Management (MDM) initiatives.
• Familiarity with enterprise data modernization and cloud migration programs.
• Understanding of source-to-target mapping and data lineage analysis.

Desired Experience

• The ideal candidate will have experience providing senior-level consulting and engineering services across:

• Snowflake Database Design & Architecture
• Data Modeling & Schema Development
• Enterprise Data Migration
• Data Integration & ETL/ELT Development
• Azure DevOps Pipeline Development
• Data Governance Programs
• Data Quality Remediation
• Metadata & Lineage Management
• Agile Delivery & Release Management
• Business and Technical Requirements Analysis

Soft Skills

• Strong analytical and problem-solving abilities.
• Excellent communication and stakeholder management skills.
• Ability to translate business requirements into technical solutions.
• Strong documentation and organizational skills.
• Ability to work independently while collaborating across multiple teams.
• Experience working with cross-functional business, analytics, QA, and engineering teams.

Skills

Experience in Data Engineering, Data Warehousing, or Data Management.

Required

7

Years

Strong experience designing and developing solutions within Snowflake.

Required

Years

Advanced SQL development skills.

Required

Years

Experience with SSIS and enterprise ETL development.

Required

Years

Experience building ELT/ETL pipelines and data integration solutions.

Required

Years

Experience with Azure DevOps (ADO), CI/CD pipelines, and release management.

Required

Years

Experience with data modeling, schema design, and database architecture.

Required

Years

Knowledge of data governance, metadata management, and data quality frameworks.

Required

Years

Experience supporting Agile software development methodologies.

Required

Years

Experience within financial services, banking, or regulated industries.

Desired

Years

Experience with Python scripting and automation.

Desired

Years

Experience with Microsoft Purview or similar data governance tools.

Desired

Years

Experience with Master Data Management (MDM) initiatives.

Desired

Years

Familiarity with enterprise data modernization and cloud migration programs.

Desired

Years

Understanding of source-to-target mapping and data lineage analysis.

Desired

Years