Please Accept our Privacy Policy
Job Title: Senior Snowflake Engineer
Location: Boston, MA 02134
Duration: Contract - 12 months, with (potential conversion to FTE)
Work Schedule: Monday–Friday, 8:00 AM – 5:00 PM (Hybrid, 3 days/week)
Job Description
Responsibilities:
· Snowflake architecture: Own technical design of data models, SQL transformations, warehouse configuration, and secure access for Octopus and related BSO data products. Design for scalability, maintainability, and reuse.
· Platform engineering: Build and improve production-grade SQL and Python components, data services, and automated jobs. Assess technical debt and modernize the Octopus platform without disrupting service.
· Data integration: Design reliable ELT/ETL pipelines and APIs connecting approved enterprise data sources to Snowflake and downstream applications with clear contracts, lineage, and monitoring.
· Shared data foundation: Develop reusable, trusted datasets and interfaces supporting resourcing, portfolio, and performance analytics and future AI-enabled workflows across BSO.
· GxP and data trust by design: Collaborate with Data Governance, Information Security, and Quality & Compliance on privacy, access controls, auditability, validation evidence, and relevant GxP requirements where applicable.
· Performance and operations: Optimize query performance and cost, implement monitoring and alerting, investigate incidents and defects, and maintain production runbooks and recovery procedures.
· Technical leadership: Set engineering standards for GitLab, code review, automated tests, CI/CD, documentation, and controlled releases. Guide and review the work of a Data Integration / Application Engineer.
· Stakeholder partnership: Translate business requirements into clear technical designs, estimates, and delivery tasks. Coordinate architecture, dependencies, and approvals with IT & Architecture, Data Governance, and business Product Owners.
Required Skills & Qualifications:
· Education: Bachelor’s or advanced degree in Computer Science, Software Engineering, Data Engineering, Information Systems, or a related field, or equivalent practical experience.
· Experience: 4+ years in software or data engineering, including hands-on work developing and supporting production Snowflake solutions and leading technical workstreams.
· Technical delivery: Ability to translate business requirements into architecture, estimates, implementation plans, technical risks, and release dependencies. Able to guide another engineer without owning portfolio prioritization.
· Snowflake and SQL: Advanced SQL, Snowflake data modeling, warehouse design, query profiling, performance tuning, and secure data-access patterns.
· Python: Production-quality Python for data processing, application integrations, scheduled workflows, and automated testing (for example, pandas, requests, pytest).
· Data engineering: ELT/ETL pipelines, orchestration, data quality checks, reconciliation, data lineage, and troubleshooting of production data flows.
· APIs and integration: Integrating enterprise systems through REST APIs, secure authentication, and reliable, documented interfaces.
· Engineering practices: 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, and the need for computer system validation and traceability where GxP requirements apply.
· Communication: Ability to explain architectural decisions and trade-offs to technical and non-technical colleagues and work effectively across global teams.
Preferred Skills:
· Master’s degree in Computer Science, Data Engineering, or a relevant technical discipline.
· Experience with Snowpark, dbt, Airflow, or comparable transformation and orchestration tools.
· Hands-on implementation of role-based access, data masking, and secure data sharing in cloud data platforms.
· Support for enterprise dashboards or applications, including R Shiny, Shiny for Python, or comparable analytical interfaces.
· Experience with cloud platforms such as AWS and containerized deployments using Docker.
· Experience in pharmaceutical R&D, resourcing or demand-planning platforms, or other regulated industries.
· A GitHub profile or portfolio with relevant work.
BCforward is a leading workforce solutions company connecting skilled professionals with top employers nationwide. We are committed to empowering careers through meaningful opportunities, professional growth, and exceptional support throughout the employment journey.