Senior Snowflake Engineer / Technical Lead (Contract-to-Hire) ? Location: Boston, MA (Hybrid) ? Work Schedule: Local candidates only. Beginning in January, this role requires approximately 2.5 days per week onsite (10 days per month). ? Duration: 18-Month Contract ? Contract-to-Hire Opportunity: Potential for full-time conversion based on performance.
Lead Enterprise Data Innovation with Snowflake
Key Responsibilities
- Snowflake Architecture & Data Platform Leadership Own the design and architecture of Snowflake data models, warehouse configurations, SQL transformations, and secure access frameworks. Build scalable, maintainable, and reusable data solutions that support enterprise analytics and operational reporting. Define technical standards and best practices for data engineering and platform development.
- Data Engineering & Integration Design and implement reliable ELT/ETL pipelines, APIs, and integrations connecting enterprise data sources with Snowflake and downstream applications. Establish data lineage, monitoring, and governance processes to ensure trusted and traceable data. Create reusable datasets and data services that support current business analytics and future AI-enabled initiatives.
- Platform Modernization & Development Develop and enhance production-grade solutions using Snowflake, SQL, and Python. Modernize existing platforms and reduce technical debt while maintaining operational stability. Build and support automated workflows, data services, and scheduled processing jobs.
- Data Security, Compliance & Governance Collaborate with Data Governance, Information Security, and Quality teams to implement privacy, auditability, validation, and access-control requirements. Support compliance initiatives, including environments that require GxP controls and system validation.
- Production Support & Performance Optimization Optimize Snowflake performance, scalability, and cost efficiency. Implement monitoring, logging, alerting, incident response processes, and recovery procedures. Troubleshoot production issues and continuously improve platform reliability.
- Technical Leadership Establish engineering standards for GitLab, code reviews, automated testing, CI/CD, documentation, and release management. Provide technical guidance and mentorship to engineering team members. Translate business requirements into technical roadmaps, architecture designs, delivery plans, and implementation estimates.
Required Qualifications
- Education Bachelor’s degree in Computer Science, Software Engineering, Data Engineering, Information Systems, or a related field, or equivalent professional experience.
- Experience 4+ years of experience in software engineering or data engineering.
- Proven success designing, building, and supporting production Snowflake environments.
- Experience leading technical workstreams and mentoring engineers.
- Technical Expertise Advanced SQL and Snowflake capabilities, including: Data modeling Warehouse design Query optimization and profiling Performance tuning Secure data access patterns Strong Python development experience for: Data processing Enterprise integrations Scheduled workflows Automated testing Libraries such as pandas, requests, and pytest Hands-on experience with ETL/ELT pipelines, orchestration, data quality frameworks, lineage tracking, and production troubleshooting. Experience integrating enterprise systems through REST APIs, authentication protocols, and documented interfaces. Strong knowledge of Git/GitLab, CI/CD pipelines, automated testing, deployment controls, logging, monitoring, and alerting.
- Additional Requirements Understanding of enterprise data security, privacy, traceability, compliance, and validation requirements in regulated environments.
- Excellent communication skills with the ability to explain technical concepts and architecture decisions to both technical and non-technical stakeholders.
- Experience collaborating with distributed and global teams.
Preferred Qualifications
- Master's degree in Computer Science, Data Engineering, or a related technical discipline.
- Experience with Snowpark, dbt, Apache Airflow, or similar data transformation and orchestration tools.
- Expertise implementing role-based security, data masking, and secure data-sharing practices.
- Experience supporting analytical applications or dashboards using R Shiny, Shiny for Python, or comparable technologies.
- Experience with AWS, Docker, and cloud-native deployments.
- Experience within regulated industries, including life sciences, healthcare, manufacturing, or other compliance-driven environments.
- GitHub portfolio or technical project portfolio showcasing relevant work.
Why Join This Opportunity?
- Lead architecture and engineering decisions for a high-impact enterprise data platform.
- Work with modern technologies including Snowflake, Python, APIs, cloud platforms, and AI-enabled data solutions.
- Influence data strategy while remaining deeply involved in hands-on development.
- Mentor engineers and establish best practices across the data engineering lifecycle.
- Opportunity to transition into a full-time leadership role based on performance.
SEO Keywords: Senior Snowflake Engineer, Snowflake Technical Lead, Data Engineering Lead, Cloud Data Architect, Snowflake Developer, Data Platform Engineer, ETL Engineer, Python Developer, SQL Engineer, Data Warehouse Architect, AWS Data Engineer, Airflow, dbt, Data Integration, Hybrid Jobs Boston, Technical Lead Data Engineering.