Senior Snowflake Database Administrator

Blue Cross and Blue Shield of North Carolina; Ohio; On-site; USD 100,000 - 183,000; Full time

Job summary

An established industry player is seeking an experienced Data Architect to join their Strategic Data Platform team. In this pivotal role, you will design and optimize Snowflake data architectures to support analytics and business intelligence initiatives. Your expertise in SQL, ETL processes, and cloud integration will be crucial in delivering scalable data solutions that enhance healthcare outcomes. This role offers the opportunity to make a significant impact in a collaborative environment, where your contributions will be valued and rewarded. If you're passionate about leveraging data to drive innovation, this is the perfect opportunity for you.

Benefits

Annual Incentive Bonus

401(k) with employer match

Paid Time Off (PTO)

Competitive health benefits

Wellness programs

Qualifications

• 5+ years of experience in data architecture or database administration roles.
• Proven experience in managing a Snowflake database management system.
• Strong understanding of cloud platforms and their integration with Snowflake.

Responsibilities

• Design and implement scalable Snowflake data architectures aligned with business requirements.
• Optimize Snowflake performance, cost management, and resource allocation.
• Collaborate with cross-functional teams to understand data needs.

Skills

Snowflake

SQL

ETL/ELT processes

Data architecture

Python

Data modeling

Cloud platforms

Data integration patterns

Security principles

Collaboration skills

Education

Bachelor's degree in Computer Science

7+ years in Database Administration

Tools

AWS S3

Teradata

Ab Initio

dbt

Qlik

Tableau

Power BI

Looker

Github

Job description

Job Description

IT is different here. Our work as technology specialists pushes the boundaries of what's possible in health care. You will build solutions that make a real difference in people's lives. Driven by the importance of their work, our team members innovate to elevate. We're encouraged to be curious, collaborate, and turn ideas into solutions that can make health care better for all.

Join our Strategic Data Platform team. In this role, you will design, implement, and optimize our Snowflake data architecture to support analytics, data science, and business intelligence initiatives across the organization. The ideal candidate will be responsible for the architecture and implementation of advanced Snowflake features, connectivity with other solutions, assisting in the design and performance of complex ETL processes, optimizing database performance, and working closely with cross-functional teams to deliver scalable data solutions. Specific focuses and responsibilities include:

If you are ready to make a career out of making a difference, then you are the person for this team.

What You Will Do

• Design and implement scalable, secure, and efficient Snowflake data architectures aligned with business requirements

• Establish Snowflake standards, security policies, RBAC, and access management protocols

• Integrate Snowflake with various third-party tools (e.g., AWS S3, Salesforce, Reltio).

• Optimize Snowflake performance, cost management, and resource allocation

• Perform SQL reviews and provide suggestions to both development teams and end-users for query optimization

• Assist in the data design and implement best practices for Snowflake environments

• Assist with the Design and optimizations ETL/ELT pipelines to extract, transform, and load data into Snowflake from various sources (e.g., APIs, databases, flat files). Assist with the optimization of data flows for performance and scalability.

• Collaborate with cross-functional teams to understand data needs and translate them into technical solutions

• Review, assist, and monitor SQL performance and make appropriate optimization recommendations

• Provide expert level consultation and mentoring to users on Snowflake technologies and best practices

• Implement monitoring, validation, and automation processes to effective administer the Snowflake system

• Implement the appropriate cost and consumption monitoring to identify inefficient and high cost queries

• Document architecture decisions, configurations, and operational procedures

What You Bring

• A bachelor's degree in Computer Science or related field, or 7+ years of experience in Database Administration.

• 5+ years of experience in data architecture or database administration roles

• 5+ years of experience with another database system such as Teradata would be helpful

• Proven experience in managing a Snowflake database management system, including creating databases, schemas, tables, stages, file formats, and virtual warehouses.

• Strong understanding of cloud platforms and their integration with Snowflake, particularly cloud storage services (e.g., S3).

• Proficiency in SQL and experience with data modeling techniques

• Experience with ETL/ELT processes and tools (such as Ab Initio, dbt, Qlik, or similar)

• Proficiency in scripting languages like Python for data automation, orchestration, and integration tasks.

• Knowledge of data modeling concepts (e.g., star schema, snowflake schema, normalization, denormalization).

• Knowledge of data integration patterns and data pipeline development

• Understanding of Security and RBAC principles

• Understanding of data governance principles and security best practices

• Excellent communication and collaboration skills

Preferred Qualifications

• Snowflake Specialty or Advanced Certifications

• AWS Cloud Certifications

• Experience with Python

• Knowledge of data visualization tools (Tableau, Power BI, Looker)

• Experience implementing CI/CD for data pipelines

• Experience with Github

• Experience with real-time data processing and streaming technologies

Salary Range

At Blue Cross NC, we take great pride in a fair and equitable compensation package that reflects market-price and our starting salaries are typically planned near the middle of the range listed. Compensation decisions are driven by factors including experience and training, specialized skill sets, licensure and certifications and other business and organizational needs.Our base salary is part of a robust Total Rewards package that includes an Annual Incentive Bonus*, 401(k) with employer match, Paid Time Off (PTO), and competitive health benefits and wellness programs.

*Based on annual corporate goal achievement and individual performance.

$100,500.00 - $182,700.00