Senior Snowflake Engineer Technical Lead

INFOBAHN SOFTWORLD INC
South San Francisco, CA, United States
1 day ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
4 years minimum
Working hours
Regular working hours
Job source

Tech stack

Query Performance Application Programming Interfaces (APIs) Artificial Intelligence Airflow Amazon Web Services Application Integration Architecture User Authentication Automation of Tests Cloud Computing Profiling Code Review Cyber Security
+34 more
Information Systems Continuous Integration Data as a Services Data Validation Information Engineering Data Governance Data Integration Extract Transform Load (ETL) Data Masking Data Security Data Sharing Github R (Programming Language) Python (Programming Language) Performance Tuning Role-Based Access Control Cloud Services Software Engineering SQL Databases System Testing Workflow Management Systems Data Logging Sql Optimization Snowflake Technical Debt Gitlab Git Pandas Pytest Containerization Information Technology Restful APIs GXP Docker

Job description

  • 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.

Requirements

  • 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.

Benefits & conditions

Duration: 18-Month Contract (Potential for FTE Conversion based on performance)

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…