Search

Senior Snowflake Engineer

PublishedPublished: 6/14/2022
Engineering
|

Job Description

Job Description

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.

\nCompany Description

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.

Company Description

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.

Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...