16 days ago
Responsibilities
- Lead the end-to-end architecture, design, and implementation of scalable Snowflake data platforms.
- Define and enforce enterprise data architecture standards, dimensional modeling practices, naming conventions, design patterns, and engineering best practices.
- Design and implement maintainable ETL/ELT pipelines using dbt and cloud-native technologies.
- Translate business and clinical requirements into scalable technical architectures with distributed stakeholders.
- Implement data governance, lineage, metadata management, cataloging, and automated data quality frameworks.
- Ensure platform compliance with GDPR and pharmaceutical validation, security, and regulatory requirements.
- Implement DataOps automation, testing, deployment, workflow orchestration, monitoring, and CI/CD pipelines.
- Optimize Snowflake performance, queries, clustering, storage tiering, and cloud costs.
- Provide architectural guidance, code reviews, hands-on mentorship, and technical leadership to engineering teams.
- Evaluate emerging technologies and partner with infrastructure, SecOps, and DevOps teams on availability, resilience, and security.
Requirements
- Strong hands-on expertise in Snowflake, including data warehousing, performance tuning, security, and cost optimization.
- Deep understanding of data warehousing, dimensional modeling, and star and snowflake schemas.
- Advanced proficiency in SQL and complex query optimization.
- Extensive ETL/ELT development experience, especially with dbt.
- Experience designing data architectures and distributed data systems.
- Strong exposure to Git, Jenkins, GitHub Actions, and Azure DevOps for CI/CD pipelines.
- Experience working with AWS.
- Preferred experience with Apache Airflow or similar orchestration tools.
- Preferred exposure to data lake and lakehouse architectures.
- Preferred experience with Tableau or Power BI.
- Prior pharmaceutical or healthcare experience involving clinical, R&D, or commercial data is preferred.
- Strong stakeholder management, communication, architecture decision-making, enterprise strategy, and Agile/Scrum experience.
Benefits
- Remote position.
About Virtusa
Virtusa is a global IT services and consulting firm that builds and runs digital platforms, applications, and cloud systems for large enterprises. It sells project-based engineering, systems integration, and managed services across industries such as financial services, healthcare, and telecommunications. Founded in 1996 and headquartered in Southborough, Massachusetts, Virtusa is privately held and owned by BPEA EQT after previously trading on NASDAQ.