Senior Snowflake Engineer Technical Lead
Posted Updated
Description
Job Title: Senior Snowflake Engineer Technical Lead
Location: Boston, MA (60 Western Ave, Suite 9100, 9th Floor Hybrid: 2.5 days/week or 10 days/month onsite starting January)
Duration: 18-Month Contract (Potential for FTE Conversion based on performance)
Role Overview
- We are seeking an experienced, hands-on Senior Snowflake Engineer / Technical Lead to lead Snowflake-based data and analytics solutions in Boston, MA. In this role, you will drive the architecture, modernization, and scalability of an enterprise analytics platform supporting resourcing and strategic decision-making across pharmaceutical R&D. This 18-month contract blends deep technical execution with technical leadership-guiding a Data Integration / Application Engineer and collaborating closely with Product Owners, Data Governance, and global technology partners.
Key Responsibilities
- Snowflake Architecture: Own the technical design of Snowflake data models, SQL transformations, warehouse configuration, and secure data access; design for scalability, maintainability, and reuse.
- Platform Engineering: Build and enhance production-grade SQL and Python components, data services, and automated jobs; evaluate technical debt and modernize existing platforms without service disruption.
- Data Integration: Design reliable ELT/ETL pipelines and REST APIs connecting enterprise data sources to Snowflake and downstream applications with clear data contracts, lineage, and monitoring.
- Shared Data Foundation: Develop reusable, trusted datasets and interfaces supporting resourcing, portfolio/performance analytics, and future AI-enabled workflows.
- GxP & Data Governance: Partner with Data Governance, Information Security, and Quality & Compliance on privacy, role-based access controls, auditability, validation evidence, and GxP compliance where applicable.
- Performance & Operations: Optimize query performance and compute costs, establish monitoring/alerting, investigate production defects, and maintain operational runbooks and recovery procedures.
- Technical Leadership: Define engineering standards for GitLab, peer code reviews, automated testing, CI/CD, documentation, and controlled releases while mentoring a Data Integration / Application Engineer.
- Stakeholder Partnership: Translate business requirements into clear technical designs, estimates, and delivery milestones across IT, Architecture, Data Governance, and Product Owners.
Required Qualifications (Must-Haves)
- Education: Bachelor's or advanced degree in Computer Science, Software Engineering, Data Engineering, Information Systems, or equivalent practical experience.
- Experience: Minimum 4+ years in software or data engineering, including substantial hands-on experience developing and supporting production Snowflake solutions and leading technical workstreams.
- Snowflake & SQL: Advanced SQL, Snowflake data modeling, warehouse design, query profiling, performance tuning, and secure data-access patterns.
- Python: Strong production-quality Python for data processing, application integrations, scheduled workflows, and automated testing (e.g., pandas, requests, pytest).
- Data Engineering: Hands-on experience building ELT/ETL pipelines, orchestration, data quality checks, reconciliation, lineage, and production troubleshooting.
- APIs & Integration: Experience integrating enterprise systems via REST APIs, secure authentication, and documented interfaces.
- Engineering Practices: Proficiency with Git/GitLab, peer code reviews, CI/CD, automated testing, deployment controls, and observability (logging, metrics, alerting).
- Regulated Environments: Understanding of enterprise data privacy, information security, computer system validation (CSV), and traceability in GxP-regulated environments.
- Location & Work Model: Must be local to Boston, MA and able to work hybrid onsite (2.5 days/week or 10 days/month starting January).
- Preferred Qualifications (Nice-to-Haves)
- Master's degree in Computer Science, Data Engineering, or a related technical field.
- Hands-on experience with Snowpark, dbt, Airflow, or comparable transformation and orchestration tools.
- Experience implementing role-based access control (RBAC), data masking, and secure data sharing in cloud data platforms.
- Background supporting enterprise analytical applications or dashboards (e.g., R Shiny, Shiny for Python).
- Cloud and containerization experience (AWS, Docker).
- Prior experience in Pharmaceutical R&D, clinical/resourcing analytics, or other regulated industries.
- Active GitHub profile or portfolio demonstrating relevant data engineering work.
Thanks
Sri Vardhan Chilakamukku
Infobahn SoftWorld Inc.
Skills
Sign in to read and join the discussion.