Principal Data Architect

Blue Cross of Idaho; Meridian (MS); On-site; USD 148,000 - 193,000; Full time

Benefits offered by this job

Paid time off

Paid holidays

Medical/dental/vision/pharmacy

401(k) matching

Life insurance

Short/long-term disability

Education reimbursement

Employee assistance plan (EAP)

Adoption assistance

Paid family leave

Job summary

Blue Cross of Idaho seeks a senior data platform architect to define multi-tenant enterprise data architecture and lead the data engineering practice on AWS/Snowflake. You will mentor teams, drive the data platform roadmap, and oversee migration from legacy warehouses to a unified Enterprise Data Platform.

Join a cross-functional team collaborating with Compliance, Marketing, Operations, and IT, delivering scalable data solutions with strong governance and security practices.

Qualifications

• Bachelor's degree in Computer Science or Information Systems or equivalent.
• 10+ years in Data & Analytics, with 3+ years AWS/Snowflake architecture.
• Strong SQL and ETL/ELT, data warehousing, data lake experience.
• Experience in DevSecOps and Agile projects; Jira/GitLab proficient.

Responsibilities

• Define multi-tenant enterprise data architecture for platforms.
• Lead data architecture practice and enterprise-level data Eng representation.
• Mentor teams via design & code reviews; foster DevSecOps.
• Oversee migration from legacy warehouses to EDP on AWS/Snowflake.
• Drive data platform roadmap; partner with Architects for APIs/integration.
• Collaborate with Compliance, Actuarial, Marketing, Ops, Clinicals teams.

Skills

AWS

Snowflake

Data Architecture

DevSecOps

Agile

Jira

GitLab

SQL

Education

Bachelor's degree in CS/IS

Tools

dbt

Airflow

Alation

Boomi/Fivetran

Tableau/Power BI/Sigma

Job description

Responsibilities:

• Define multi-tenant enterprise data architecture for the platforms
• Lead data architecture practice and represent Data Engineering at the enterprise level
• Technical subject matter expert in the data ecosystem, including AWS/Snowflake, providing input into architecture, platforms, and development strategies and methodologies – includes mentorship of engineering and platform teams via design reviews, code reviews, etc.
• Define data engineering and data platform integration framework and standards.
• Mentor, coach and build learning program to efficiently and quickly onboard new people in the team and ensure standards are understood and followed.
• Facilitate cross-team collaboration for defining and building enterprise data management architecture from principles to tools, oversee cross-functional adoption of the new architecture, and enable a new level of engineering efficiency when working with data.
• Direct the strategy and implementation for migration from the existing data warehouse platforms onto the new Enterprise Data Platform (EDP) on AWS/Snowflake.
• Lead technical direction of the team, driving the necessary changes and recommending appropriate technology choices working collaboratively with Architecture, Platform, DevOps, Security, and Project teams; influence technical direction with expert input into project decisions.
• Lead the shift towards DevSecOps processes for the Data & Analytics delivery functions, emphasizing continuous integration, release management, and automated testing to maximize development agility and improve time to market.
• As the data platform product manager, drive the data platform technical roadmap to prioritize and build new features that serve the business teams and standardize templates for technical work
• Interface with key business functions (i.e., Compliance, Actuarial, Marketing, Operations, Clinical, etc.) and IT Analysis teams to assess business functional requirements and translate them into data and integration requirements.
• Guide onsite/onshore/offshore technical resources from consulting partners, communicate architecture standards and best practices, establish a high impact development process, drive excellence in all deliverables.
• Establish daily cadence with project team to prioritize and execute work items through adoption of Agile principles and processes.
• Manage relationships with external vendors to determine technical competence and identify integration opportunities.
• Be a hands‑on practitioner for end‑to‑end delivery of AWS/Snowflake platforms, capabilities, and content.

Success Factors:

Ability to understand, drive, and deliver technology solutions in AWS and Snowflake. Demonstrated understanding of Data architecture and components, especially for Data Warehousing, including Snowflake, dbt Data transformations, Airflow, Data Cataloging tools like Alation; other key integration platforms like Boomi/Fivetran, BI tools like Tableau/Power BI/Sigma, and AI/ML tools like Dataiku/Cortex/Snowflake Intelligence. Demonstrated understanding of and experience with modern Data Warehouse concepts, including Data Lake/Data Warehouse/Data Mart implementations, SQL-based transformations, and ELT methodology. Understanding of Data Mesh principles, treating data as product, emphasizing domain specific data ownership and governance. Ability to foster/work in decentralized ownership of data. Solid understanding of DevSecOps and Agile methodology, comfortable with Jira and AWS DevOps and GitLab. Ability to lead project and technical teams and deliver solutions. Ability to partner with Data Solution Architects in building APIs and other integrations required. Ability to provide mentorship to Snowflake administrators in support of role/policy administration, replication, zero-copy clone etc. Ability to provide technical leadership to Snowflake-related project and support teams. Demonstrated planning, coordination, and execution skills. Ability to conduct POCs, and demonstrable work products when adapting new features. Ability to successfully collaborate with business partners. Knowledgeable and skilled in Snowflake-related technologies, including platforms and tools for meeting business use cases for all forms of analytics and AI/ML functionality. Ability to prioritize well, communicate clearly, and understand how to drive a high level of focus and excellence in deliverables. Communication is diplomatic, accurate and concise, across internal and external organizations. Ability to collaborate, propose solutions, owning the data platform items related to architecture reviews and advise on the best course of action. Conscientious, reliable, and inquisitive with a keen desire to learn, not just gain the knowledge necessary for the job but also the underlying reasons and drivers.

Required Education:

Bachelor’s degree in Computer Science, Information Systems, or equivalent work experience is required (Two years’ relevant work experience is equivalent to one-year college; lieu of degree, 8 years' experience + required years' experience will be considered). Certifications such as Snowflake Pro and/or AWS-related are highly preferred.

Required Experience:

10/+ years of experience in Data & Analytics field, to include: 2/+ years' working with hybrid (onshore + offshore) data teams. 5/+ years designing and building data storage capabilities, such as data warehouse or data lake. This should include 3/+ years in AWS/Snowflake-specific architecture, development, or support capacity. Overall experience should also span: Understanding of large-scale computing solutions, including software design and development, and database architectures. Implementation involving batch, streaming, event-driven and API integrations on the data platform. Knowledge of AWS/Snowflake cloud security, orchestration, management, data management (in particular metadata management and data quality checks), role-based access controls, and policy-based access controls. Knowledge of FinOps, preferably involving Snowflake. Ability to build data pipelines as part of integrations design. Strong knowledge of ELT, ETL, CDC, API, messaging, streaming, and all forms of data ingestion techniques applicable to cloud-based Data & Analytics. Strong skills in SQL DevSecOps and Agile projects No-SQL; relational & non-relational platforms; multiple file formats, including Parquet, AVRO, JSON, XML, CSV, etc.

Preferred Experience:

dbt Boomi, Mule or other integration platforms Python, Snowpark, Sage Maker, Snowflake Intelligence Tableau, Power BI or Sigma Data science platforms, such as Dataiku Designing and building frameworks, API interfaces for efficient data extraction Working in environments where data privacy and protection is critical (Healthcare, HIPAA, etc.).

Applicants must be legally authorized to work in the United States at the time of application and throughout employment. The company does not provide employment-based visa sponsorship for this position now or in the future.

As of the date of this posting, a good faith estimate of the current pay range is: $147,983 - $192,969.

The position is eligible for an annual incentive bonus (variable depending on company and employee performance).

The pay range for this position takes into account a wide range of factors including, but not limited to, specific competencies, relevant education, qualifications, certifications, relevant experience, skills, seniority, performance, shift, travel requirements, internal equity, geography, business or organizational needs, and alignment with market data.

At Blue Cross of Idaho, it is not typical for an individual to be hired at or near the top range for the position. Compensation decisions are dependent on factors and circumstances at the time of offer.

We offer a robust package of benefits including paid time off, paid holidays, community service and self-care days, medical/dental/vision/pharmacy insurance, 401(k) matching and non-contributory plan, life insurance, short and long term disability, education reimbursement, employee assistance plan (EAP), adoption assistance program and paid family leave program.

• paid time off
• paid holidays
• community service and self-care days
• medical/dental/vision/pharmacy insurance
• 401(k) matching and non-contributory plan
• life insurance
• short and long term disability
• education reimbursement
• employee assistance plan (EAP)
• adoption assistance program
• paid family leave program

We will adhere to all relevant state and local laws concerning employee leave benefits, in line with our plans and policies.

Reasonable accommodations To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.

The requirements listed above are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.

Blue Cross of Idaho has taken our role as an Idaho-based health insurance company to heart since 1945.

As a not-for-profit, we are driven to help connect Idahoans to quality and affordable healthcare while building strong networks and services. We aim to create a brighter future for all with the help of customer‑centric professionals.

Your Health and Wellness Matters At Blue Cross of Idaho, we care about the health and well‑being of our employees. Our benefits aim to help make your life easier, healthier and more balanced.

Your Career Development Matters We believe in employee growth, which is why we offer training, tools and numerous resources to assist with professional development.

Your Community Matters Our employees care deeply about Idaho. We work together to positively impact communities throughout Idaho, and contribute our time through volunteering.

Blue Cross of Idaho will extend reasonable accommodations to qualified individuals with disabilities who are otherwise not able to fully use electronic and online job application systems.

For assistance, please send an email to [e-mail]. Equal Opportunity is the Law EEO is the Law Supplement E-Verify Pay Transparency