Software Engineer (Snowflake & Matillion Data Platform)

Delta Dental of California; Rancho Cordova (CA); Hybrid; USD 81,000 - 174,000; Full time

Benefits offered by this job

Competitive base pay

401(k) with matching

Medical & dental benefits

Job summary

Delta Dental of California is seeking a Software Engineer to administer Snowflake, Matillion, and related enterprise data platforms. The role emphasizes platform health, access management, and incident resolution, with a focus on automation and AI-driven improvements.

Candidates should have strong SQL and Python skills and be comfortable supporting BI tools like Power BI. Hybrid work with 1–2 onsite days weekly in Rancho Cordova, CA or Alpharetta, GA is required.

Qualifications

• Bachelor's degree in a technical field or equivalent experience.
• 2+ years of professional experience with data platforms and BI tooling.
• Familiarity with enterprise environments (Dev, QA, UAT, Prod).
• Ability to document issues and maintain runbooks.

Responsibilities

• Administer Snowflake, Matillion and related enterprise data platforms.
• Monitor jobs, schedules, failures, and production execution issues.
• Assist with access management, deployments, and incident resolution.
• Develop AI-assisted workflows and automation to improve reliability.
• Support Power BI administration including workspaces and datasets.
• Maintain runbooks, SOPs, and knowledge base documentation.

Skills

Snowflake administration

Matillion administration

Power BI administration

SQL

Python

AI automation

Troubleshooting

Documentation

DevOps basics

Cloud platforms

Education

Bachelor's degree in Computer Science, Engineering or related technical field

Tools

ServiceNow

JIRA

Confluence

Power BI Service

Tableau/Dataiku (plus)

Job description

*This role does not offer visa sponsorship. Candidates must be authorized to work in the U.S. without current or future sponsorship (including CPT, OPT, TN or H1B).

**This is a hybrid position with an onsite requirement of 1-2 days per week in Alpharetta, GA or Rancho Cordova, CA. Candidates should be within a reasonable commuting distance (approximately 50 miles) of Alpharetta, GA or Rancho Cordova, CA to support onsite requirements.**

We are looking for a Software Engineer to support the administration, maintenance, and operational stability of enterprise data platforms, with primary focus on Snowflake & Matillion platform. This role is intended for someone with strong troubleshooting skills, a platform support mindset, and the ability to use automation and AI-driven approaches to improve operational efficiency.

The ideal candidate should be comfortable supporting data platforms , production jobs, access management, deployments, incident resolution, documentation, and platform health monitoring. In addition, the candidate should have interest and ability to use AI, automation, and agent-based solutions to optimize support processes, reduce manual maintenance activities, and improve proactive issue detection and resolution.

Key Responsibilities

• Provide day-to-day administration and platform support for Snowflake, Matillion and related enterprise data platforms. Responsibilities include monitoring platform health, supporting user access, troubleshooting production issues, assisting with deployments, maintaining operational documentation, and coordinating with Data Engineering, BI, Cloud, Security, Infrastructure, and business teams.
• Identify opportunities to automate repetitive support tasks, build AI-assisted workflows, and develop lightweight agents or automation scripts where applicable to improve platform reliability, reduce manual intervention, and enhance operational efficiency.

Primary Duties

• Provide administration, platform support, and maintenance for Snowflake, Matillion and other enterprise data platforms.
• Monitor Matillion jobs, schedules, failures, alerts, and production execution issues.
• Support Snowflake users, roles, warehouses, databases, schemas, permissions, access reviews, and platform usage monitoring.
• Support Power BI administration activities including workspaces, gateways, dataset refreshes, user access, capacity monitoring, and production support (Optional)
• Assist with incident triage, root cause analysis, resolution tracking, and post-incident documentation.
• Support deployment activities across development, test, UAT, and production environments.
• Maintain runbooks, SOPs, operational checklists, support guides, and knowledge base documentation.
• Work with Data Engineering and BI teams to troubleshoot ETL/ELT pipeline failures, report refresh issues, connectivity issues, and performance problems.
• Use AI tools and automation to optimize support processes, reduce repetitive manual tasks, and improve operational effectiveness.
• Build or support AI agents, scripts, or automated workflows where applicable to assist with monitoring, job failure analysis, report refresh validation, documentation, access reviews, and maintenance activities.
• Identify opportunities for proactive monitoring, automated alerts, self-service support, and preventive controls.
• Support platform upgrades, patches, configuration changes, environment maintenance, and vendor coordination.
• Monitor Snowflake performance, warehouse usage, cost trends, query history, and resource utilization.
• Monitor Power BI capacity, refresh failures, gateway health, workspace usage, and report performance issues.
• Support audit, compliance, vulnerability remediation, access certification, and change management activities.
• Be willing to support additional platforms as needed, including BI tools, data governance tools, data integration tools, and AI/ML platforms, with minimal training.

Minimum Qualifications

• 2+ years professional experience with Bachelor's degree in Computer Science, Engineering or related technical field; Additional experience may be accepted in lieu of education or degree

Required Skills

• Hands-on experience or strong working knowledge of Snowflake administration.
• Experience with Matillion (Maia) preferably in administration, platform support, or production operations.
• Working knowledge of Power BI administration or support, including workspaces, gateways, refresh failures, access management, and capacity usage.
• Strong SQL & Python skills and understanding of data warehousing, ETL/ELT concepts, BI platforms, and cloud data platforms.
• Ability to troubleshoot job failures, report refresh failures, access issues, connectivity issues, configuration issues, and performance problems.
• Understanding of enterprise environments such as Dev, QA, UAT, and Production.
• Experience with production support, incident management, change management, and release management processes.
• Ability to document issues clearly, create support runbooks, and maintain operational procedures.
• Interest and practical ability to use AI tools, automation, and scripting to improve support and maintenance processes.
• Ability to learn and support additional platforms quickly with minimal training.
• Strong analytical, communication, ownership, and collaboration skills.

Preferred Skills

• Experience with Snowflake warehouses, resource monitors, role-based access control, query history, masking policies, and performance tuning.
• Experience with Matillion DPC or Matillion ETL administration.
• Experience with Power BI Service, Power BI gateways, Premium/Fabric capacity, dataset refreshes, workspace governance, and access controls.
• Exposure to AI-assisted engineering tools, automation frameworks, workflow agents, or support bots.
• Ability to build small automation utilities using Python, shell scripting, APIs, PowerShell, or similar tools.
• Exposure to Git, CI/CD, DevOps practices, deployment automation, or release management.
• Knowledge of cloud platforms such as AWS, Azure, or GCP.
• Experience supporting platforms in healthcare, insurance, financial services, or other regulated enterprise environments.
• Familiarity with tools such as ServiceNow, JIRA, Confluence, monitoring tools, and alerting platforms.
• Exposure to additional platforms such as Tableau, BusinessObjects, Collibra, Dataiku, EBX, Data Virtualization, or other enterprise data tools is a plus.

Base Pay Information

The national base pay range at the end is a good-faith estimate of what Delta Dental may pay for new hires. Actual pay may vary based on Delta Dental's assessment of the candidate's knowledge, skills, abilities (KSAs), related experience, education, certifications and ability to meet required minimum job qualifications. Other factors impacting pay include prevailing wages in the work location and internal equity.

Pay Grade 21. $80,500 - $174,300

Behind the smile! We are dedicated to safeguarding the health and financial stability of our employees and their loved ones. This commitment extends beyond the workplace to foster personal growth and holistic wellbeing. Our life-changing rewards package includes:

• Competitive base and incentive pay
• 401(k) with robust matching and non-matching contributions
• Rich medical & pharmacy benefits
• 100% employer-paid dental and vision benefits
• Holistic wellbeing program with deep financial incentives
• Generous paid time off plus 12 paid holidays and your birthday off
• Culture of growth and learning: career development; tuition reimbursement; recognition program
• Family support: adoption assistance, fertility treatment, child, elder & pet care assistance
• Social responsibility and volunteer opportunities
• Employee discount program

Fair Chance Ordinances and Criminal Background Considerations

This position requires that the applicant undergo a background check. Qualified applicants with arrest or conviction records will be considered for employment in accordance with any applicable federal, state or local laws, including, but not limited to, the California Fair Chance Act, the Los Angeles County Fair Chance Ordinance, the City of Los Angeles Fair Chance Initiative for Hiring Ordinance, the San Francisco Fair Chance Ordinance, and/or New York Corrections Law Article 23-A.

Important Work Authorization Information

Please note, Delta Dental will not sponsor applicants for work visas for this position.