onsite
Software Engineer - Snowflake & Matillion Data Platform - Delta Dental Ins.
Software Engineer
Software Engineer responsible for administering, maintaining, and optimizing enterprise data platforms, focusing on Snowflake and Matillion, with strong troubleshooting, ETL development, and data modeling skills.
About the role
Key Responsibilities
- Administer and monitor Snowflake data warehouses to ensure performance, security, and cost efficiency.
- Design, develop, and maintain ETL pipelines using Matillion, integrating source systems and transforming data for analytics.
- Collaborate with data engineers, analysts, and business stakeholders to define data models and ensure data quality.
- Diagnose and resolve platform incidents, performance bottlenecks, and data integrity issues.
- Implement automation scripts (Python, Bash) for routine maintenance, provisioning, and backup tasks.
- Maintain version control and documentation using Git and internal wikis.
Requirements
- 3+ years of hands‑on experience with Snowflake and Matillion in an enterprise environment.
- Strong SQL proficiency and experience building complex queries and data models.
- Proficiency in Python or similar scripting language for automation and data processing.
- Solid understanding of ETL concepts, data warehousing, and cloud infrastructure (AWS or Azure).
- Excellent troubleshooting skills, ability to work independently, and strong communication with cross‑functional teams.
Skills
snowflakesqlpythonlinux