Senior Snowflake Engineer Technical Lead
INFOBAHN SOFTWORLD INC
South San Francisco, CA, United States
1 day ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
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
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦