Senior Snowflake Engineer Job at TALENT Software Services, Boston, MA

  • TALENT Software Services
  • Boston, MA

Job Description

Job Description

Job Description

 

Role                   :             Senior Snowflake Engineer / Technical Lead

Location            :             Boston, MA – Hybrid Role

Duration            :            12+ Month Contract

 

Job Summary:


As a Senior Snowflake Engineer / Technical Lead, you will be the technical lead for BSO’s Snowflake-based data and analytics solutions, reporting to the Business Digital, Data & AI Infrastructure Lead. You will advance Octopus, the platform supporting resourcing and strategic decision-making across PDD, by designing and building robust data architecture, integrations and scalable enhancements. This 18-month contractor engagement combines hands-on engineering with technical leadership, guiding a Data Integration / Application Engineer and collaborating with Product Owners, business teams and Roche technology partners.

 

Key Responsibilities

 

  • Snowflake architecture: Own the technical design of Snowflake data models, SQL transformations, warehouse configuration and secure data 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; evaluate technical debt and modernize the existing Octopus platform without disrupting service.
  • Data integration: Design reliable ELT/ETL pipelines and APIs that connect approved enterprise data sources to Snowflake and downstream applications, with clear data contracts, lineage and monitoring.
  • Shared data foundation : Develop reusable, trusted datasets and interfaces that support resourcing, portfolio and performance analytics as well as future AI-enabled workflows across BSO.
  • GxP and data trust by design : Work 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, establish 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.

 

Who You Are (Must Haves)

You are a pragmatic, hands-on technical leader who enjoys improving established enterprise data products. You combine deep Snowflake expertise with strong engineering judgement, a focus on reliability and the ability to explain technical trade-offs to business colleagues.

 

Education : Bachelor’s or advanced degree in Computer Science, Software Engineering, Data Engineering, Information Systems or a related field, or equivalent practical experience.

Experience : At least 4 years in software or data engineering, including substantial hands-on experience developing and supporting production Snowflake solutions and leading technical workstreams.

 

Technical delivery : Experience translating business requirements into architecture, engineering estimates, implementation plans, technical risks and release dependencies; able to guide another engineer without owning portfolio prioritisation.

Snowflake and SQL : Advanced SQL, Snowflake data modelling, 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 (for example pandas, requests and pytest).

Data engineering: Hands-on experience with ELT/ETL pipelines, orchestration, data quality checks, reconciliation, data lineage and troubleshooting of production data flows.

APIs and integration: Experience 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 and alerting).

Regulated environments : Understanding of enterprise data privacy, information security and the need for computer system validation and traceability where GxP requirements apply.

Communication : Explains architectural decisions and trade-offs clearly to technical and non-technical colleagues, and works effectively across global teams.

 

Preferred Qualifications

 

  • Master’s degree in Computer Science, Data Engineering or another relevant technical discipline.
  • Snowpark, dbt, Airflow or comparable data transformation and orchestration tools.
  • Hands-on experience implementing role-based access, data masking and secure data sharing in cloud data platforms.
  • Experience supporting enterprise dashboards or applications, including R Shiny, Shiny for Python or comparable analytical interfaces.
  • Experience with cloud platforms such as AWS and containerized deployments (Docker).
  • Experience in pharmaceutical R&D, resourcing or demand-planning platforms, or another regulated industry.
  • A GitHub profile or portfolio showing relevant work is an advantage.

Job Tags

Contract work, For contractors

Similar Jobs

BrightSpring Health Services

CNA / Certified Nursing Assistant - Hospice Aide Job at BrightSpring Health Services

 ...dressing, toileting, mobility, and repositioning Monitor & Report: Observe and report changes in the patients condition Mobility : Assist with ambulation, transfers, ROM exercises and safe equipment use Medication Assistance : Help with self-administered medications... 

M.C.Bass Electrical Contractor, Inc.

Experienced Journeyman Electrician Job at M.C.Bass Electrical Contractor, Inc.

 ...Join Our Team as an Experienced Journeyman Electrician! Are you looking for a challenging and rewarding career in the construction industry?...  ...contractor, we provide electrical services to industrial and commercial facilities across the United States. With a focus on safety... 

Opterra Solutions, Inc.

(116) Commercial Drone Pilot/Aerial Applicator Job at Opterra Solutions, Inc.

 ...and vegetation management company seeking a reliable and skilled Commercial Drone Herbicide Applicator to join our team. If you enjoy drone...  ...excellent opportunity. Seeking dependable, safety-focused pilots who enjoy flying, traveling, and working with cutting-edge drone... 

PW Retail Foods LLC

Meat Cutter Job at PW Retail Foods LLC

 ...Position Overview The Meat Cutter is responsible for handling meat and meat products. The Cutter will receive, process, cut, trim, scrape, package, tie, wrap, weigh, price, and label meat products The Cutter is responsible for setting an example in providing attentive... 

Integratedcooling

Independent Freight Agent Job at Integratedcooling

 ...Independent Freight Agent/Broker Resolve Logistics is eager to collaborate with remote seasoned Freight Brokers pursuing a flexible, remote commission-driven sales role. Our Freight Agents thrive with autonomy as their own boss, benefiting from generous commission splits...