SQL Data engineer

The Data Engineer is responsible for developing, maintaining, and optimizing data pipelines and integration processes that support analytics, reporting, and business operations. This role focuses on designing and implementing scalable data solutions using Snowflake and Informatica , ensuring that data is accurate, reliable, and accessible to key stakeholders across the organization.

The primary work location for this role will be at Broad Street, Boston Massachusetts .

Responsibilities : Key Responsibilities

• Design, build, and maintain ETL / ELT pipelines using Informatica to move and transform data from various source systems into Snowflake .
• Ensure data handling and storage comply with HIPAA , HITECH , and organizational privacy / security standards.
• Support the development of data models, schemas, and views in Snowflake to enable efficient data querying and analytics.
• Support interoperability and data exchange initiatives using healthcare standards such as HL , FHIR , and X EDI .
• Implement data ingestion, transformation, and quality processes to ensure consistent, trusted data across environments.
• Monitor and troubleshoot data pipelines to ensure high performance and reliability.
• Collaborate with data analysts, data scientists, other data engineers, and business users to understand data requirements and deliver solutions.
• Develop and maintain documentation for data flows, metadata, and transformation logic.
• Assist with data security, access control, and governance within Snowflake and Informatica.
• Participate in testing, deployment, and release management for new data workflows and enhancements.

Required Qualifications

Preferred Knowledge, Skills & Abilities :

Soft Skills

Education and Certification :

EEO : -