Data architect
Budget: $250 – $750 USD
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
• 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
Related categories:
Data Warehousing
Data Architecture
Data Governance
Data Modeling
Performance Tuning
Informatica
Snowflake