Sr. Data Engineer
3B Staffing LLC, Boston, MA, United States
Client:
State of MA/EOHHS
Location:
Boston, MA (Hybrid) Candidate must live in MA/RI/NH/CT and be available if requested for a F2F interview
Duration:
12+ month contract
Rate:
$70 an hour C2C
Title:
Sr. Data Engineer
Requirements:
Snowflake, SQL, IICS/PowerCenter, ETL
Position Description
EOHHS is seeking to hire an experienced Senior SQL Data Engineer to work with our EHS IT team supporting the Department of Mental Health and Department of Public Health Hospitals. This role provides technical leadership in the design, development, optimization, and support of enterprise Business Applications, Data Warehouse solutions, and critical healthcare data processes and reporting platforms.
The Senior Data Engineer owns end-to-end data solutions, leads complex data initiatives, and partners closely with business, analytics, and IT stakeholders to ensure secure, reliable, and high-quality data delivery in a regulated healthcare environment.
The primary work location for this role will be 40 Broad Street, Boston, Massachusetts. HYBRID
DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES
Lead the design, development, and optimization of scalable ETL/ELT pipelines using Informatica to integrate data from diverse source systems into Snowflake.
Provide technical ownership of Snowflake-based data warehouse solutions, including architecture, performance tuning, and cost optimization.
Ensure data ingestion, storage, and processing fully comply with HIPAA, HITECH, and organizational privacy and security standards.
Lead the development and evolution of enterprise data models, schemas, and analytics-ready views in Snowflake.
Support and guide interoperability and data exchange initiatives using healthcare standards such as HL7, FHIR, and X12 EDI.
Define and enforce data quality, validation, and reconciliation frameworks to ensure trusted and consistent data across environments.
Proactively monitor, troubleshoot, and resolve pipeline performance, reliability, and data quality issues.
Mentor and provide technical guidance to data engineers; conduct design and code reviews.
Collaborate with data analysts, data scientists, architects, DevOps, and business stakeholders to translate requirements into scalable technical solutions.
Lead documentation efforts for data flows, metadata, transformation logic, and operational procedures.
Partner with security and governance teams to implement role-based access controls, data governance, and auditability within Snowflake and Informatica.
Participate in and influence testing strategies, deployment automation, release management, and SDLC best practices.
Contribute to tool selection, architectural standards, and continuous improvement initiatives across the data platform.
Required Qualifications
6-8+ years of experience in SQL-based data engineering, ETL/ELT development, or data warehousing.
Demonstrated experience leading or owning complex data initiatives in enterprise environments.
Hands-on expertise with:
Snowflake Cloud Data Platform, including advanced SQL development, data modeling, and performance optimization.
Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS) for large-scale ETL/ELT design.
Advanced SQL skills, including complex queries, procedures, and deep understanding of data warehousing concepts.
Strong experience designing, coding, testing, documenting, and maintaining database systems and data pipelines.
Solid understanding of SDLC, Agile/Scrum methodologies, and DevOps practices.
Experience integrating structured and semi-structured data (JSON, XML, CSV).
Experience working in cloud environments (AWS, Azure, or GCP) and cloud storage platforms (e.g., S3, Blob Storage).
Strong understanding of data governance, metadata management, and data quality frameworks.
State of MA/EOHHS
Location:
Boston, MA (Hybrid) Candidate must live in MA/RI/NH/CT and be available if requested for a F2F interview
Duration:
12+ month contract
Rate:
$70 an hour C2C
Title:
Sr. Data Engineer
Requirements:
Snowflake, SQL, IICS/PowerCenter, ETL
Position Description
EOHHS is seeking to hire an experienced Senior SQL Data Engineer to work with our EHS IT team supporting the Department of Mental Health and Department of Public Health Hospitals. This role provides technical leadership in the design, development, optimization, and support of enterprise Business Applications, Data Warehouse solutions, and critical healthcare data processes and reporting platforms.
The Senior Data Engineer owns end-to-end data solutions, leads complex data initiatives, and partners closely with business, analytics, and IT stakeholders to ensure secure, reliable, and high-quality data delivery in a regulated healthcare environment.
The primary work location for this role will be 40 Broad Street, Boston, Massachusetts. HYBRID
DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES
Lead the design, development, and optimization of scalable ETL/ELT pipelines using Informatica to integrate data from diverse source systems into Snowflake.
Provide technical ownership of Snowflake-based data warehouse solutions, including architecture, performance tuning, and cost optimization.
Ensure data ingestion, storage, and processing fully comply with HIPAA, HITECH, and organizational privacy and security standards.
Lead the development and evolution of enterprise data models, schemas, and analytics-ready views in Snowflake.
Support and guide interoperability and data exchange initiatives using healthcare standards such as HL7, FHIR, and X12 EDI.
Define and enforce data quality, validation, and reconciliation frameworks to ensure trusted and consistent data across environments.
Proactively monitor, troubleshoot, and resolve pipeline performance, reliability, and data quality issues.
Mentor and provide technical guidance to data engineers; conduct design and code reviews.
Collaborate with data analysts, data scientists, architects, DevOps, and business stakeholders to translate requirements into scalable technical solutions.
Lead documentation efforts for data flows, metadata, transformation logic, and operational procedures.
Partner with security and governance teams to implement role-based access controls, data governance, and auditability within Snowflake and Informatica.
Participate in and influence testing strategies, deployment automation, release management, and SDLC best practices.
Contribute to tool selection, architectural standards, and continuous improvement initiatives across the data platform.
Required Qualifications
6-8+ years of experience in SQL-based data engineering, ETL/ELT development, or data warehousing.
Demonstrated experience leading or owning complex data initiatives in enterprise environments.
Hands-on expertise with:
Snowflake Cloud Data Platform, including advanced SQL development, data modeling, and performance optimization.
Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS) for large-scale ETL/ELT design.
Advanced SQL skills, including complex queries, procedures, and deep understanding of data warehousing concepts.
Strong experience designing, coding, testing, documenting, and maintaining database systems and data pipelines.
Solid understanding of SDLC, Agile/Scrum methodologies, and DevOps practices.
Experience integrating structured and semi-structured data (JSON, XML, CSV).
Experience working in cloud environments (AWS, Azure, or GCP) and cloud storage platforms (e.g., S3, Blob Storage).
Strong understanding of data governance, metadata management, and data quality frameworks.