|
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
|
Blue Cross and Blue Shield of North Carolina
paid time off, 401(k)
Mar 01, 2025