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

About Us

It's an exciting time to work at Blue Cross and Blue Shield of North Carolina (Blue Cross NC). Health care is changing, and we're leading the way. We offer more than health insurance our customers can count on. We’re committed to better health and better health care − in our communities and beyond. Our employees bring energy and creativity to the workplace, and it shows in our innovative approach to improving the health and well-being of North Carolinians.

Blue Cross NC is a fully taxed, not-for-profit company headquartered in Durham, North Carolina. We serve more than 4.3 million members, and we employ more than 5,000 people across the country who are passionate about making health care better for all.

Help us lead the charge for better health care by joining our award-winning team. Discover tremendous opportunities with us to do challenging and rewarding work. Opportunities that can lead you to a fulfilling career, work that can help others lead healthier, happier lives.

Authorization to Work in the United States

We use E-verify to confirm authorization to work in the United States. To learn more about E-Verify, including your rights and responsibilities, please visit E-Verify Overview (https://www.e-verify.gov/employees/e-verify-overview) for English or Visión General de E-Verify (https://www.e-verify.gov/es/empleados/vision-general-de-e-verify) for Español.

Request Accommodations

Blue Cross NC provides reasonable accommodations to applicants with disabilities. If you need a reasonable accommodation for any part of the application or hiring process, please notify HR at HR.Staffing@bcbsnc.com .

For most roles, you can choose where to work - fully remote in one of the states listed below, in the office, or a hybrid of the two:

Alabama, Arizona, Arkansas, Colorado, Florida, Georgia, Idaho, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maryland, Michigan, Mississippi, Missouri, North Carolina, Ohio, Oklahoma, Pennsylvania, South Carolina, South Dakota, Tennessee, Texas, Utah, Virginia, Wisconsin, and Wyoming