Senior Data Architect


On Site
USD 126,000.00 - 140,000.00 per year
Full Time


Change data capture
Data warehouse
Data marts
Data integration
Data modeling
Project development
Project coordination
Information management
Data governance
Business intelligence
Computer science
Information systems
Cloud architecture
Microsoft SQL Server
Data security
Use cases
Health care
Data Lake
Business requirements
Data architecture
Data profiling
Data quality
Meta-data management
Data dictionary
Data cleansing
People skills
Computer literacy
Problem solving
Time management
Organizational skills
Attention to detail
Data extraction
Augmented reality
Information assurance
Marketing operations
Analytical skill
Microsoft Azure
Microsoft SSIS
Cloud computing
Snow flake schema
Microsoft Power BI
Regulatory Compliance
Microsoft Outlook
Value engineering

Job Details

We offer remote work opportunities (AK, AR, AZ, CA, *CO, FL, *HI, IA, ID, IL, KS, LA, MD, MN, MO, MT, NE, NV, NM, NC, ND, OK, OR, SC, SD, TX, UT, VA/DC, *WA, WI & WY only)

Our Department of Defense contract requires ship and a favorably adjudicated DOD background investigation for this position.

Veterans, Reservists, Guardsmen and military family members are encouraged to apply!

Job Summary

The Sr Data Architect will be responsible for design and implementations of data strategy as it relates to data lakes, data warehouse, and data marts. The primary responsibility will be a focus on data sourcing, data integration, and data modeling to ensure systems meet the analytical needs of business users. The role will work closely with the project development teams and project support teams to ensure the right architecture is implemented across multiple work streams. The role will also develop standards (data definition, tools, and platforms) as related to information management, data warehouse, data governance, and business intelligence.

Education & Experience


Bachelor's Degree in Computer Science, Information Systems, or related experience
Minimum of 5 years of experience in Data Warehousing
Minimum of 5 years of experience as a Data Architect
Minimum of 10 years in a data driven environment with relation to migration and conversions
Minimum of 5 Years ETL experience preferably in Azure (Datafactory / Databricks)
Strong knowledge of Azure Cloud Architecture Minimum of 5 Year ETL development preferably SSIS
Proficient with SQL Server (On Prem and Azure Cloud)
Knowledge or change data capture tools (CDC)
Strong knowledge of data warehouse design and architecture (Kimball / Inmon)
Experience with ERwin, ER/Studio, or other data modeling tool
Strong knowledge of data protection tools and use cases (Encryption / Masking / De-Identification)


Experience with data related to health care
Experience with Snowflake
Experience with Tableau / PowerBI
Experience with Oracle Databases
Experience with Salesforce Healthcloud

Key Responsibilities

Architect data lake, data warehouse and data marts to meet online efficiency requirements.
Act as an advisor to Director of Data Services on data strategy. Represent data services in Data Governance efforts. Research, Review and Recommend new technologies. Work closely with Enterprise Data Architect to ensure strategies align and mentor and collaborate with other data architects to ensure consistency across the enterprise.
Create conceptual, logical, and physical data models for online application transactions.
Translate enterprise or business requirements into long-term online information and data architecture solutions.
Collaborate with users, business analysts, developers, database administrators, and project managers.
Perform data profiling and data quality validation processes.
Develop and implement metadata management, data dictionary, data quality, data profiling, data security, shared data usage, and data cleansing standards.
Ensures compliance with TriWest HIPAA, privacy, and government security policies.
Performs other duties as assigned.
Regular and reliable attendance is required.


Communication / People Skills: Ability to influence or persuade others under positive or negative circumstances; adapt to different styles; listen critically; collaborate.

Computer Literacy: Ability to function in a multi-system Microsoft environment using Word, Outlook, TriWest Intranet, the internet, and department software applications.

Coping / Flexibility: Resiliency in adapting to a variety of situations and individuals while maintaining a sense of purpose and mature problem-solving approach is required.

Information Management: Ability to manage large amounts of complex information easily, communicates clearly, and draws sound conclusions.

High Intensity Environment: Ability to function in a fast-paced environment with multiple activities occurring simultaneously while maintaining focus and control of workflow.

Multi-Tasking / Time Management: Prioritize and manage actions to meet changing deadlines and requirements within a high-volume, high-stress environment.

Organizational Skills: Ability to organize people or tasks, adjust to priorities, and learn systems within time and/or resource constraints; detail-oriented.

Problem Solving / Analysis: Ability to solve problems through systematic analysis of processes with sound judgment; has realistic understanding of relevant issues.

Technical Skills: Strong knowledge of online data stores design; advanced data modeling skills; proficiency with SQL; some experience with data extraction, transformation, and loading (ETL); working knowledge of SQL Server databases; working knowledge of Oracle databases; familiarity with Kimball and Inmon design paradigms.

Working Conditions

Working Conditions:

Works non-standard hours as required
Works within a standard office environment with limited travel
Extensive computer work with prolonged periods of sitting

Company Overview

Taking Care of Our Nation's Heroes.

It's Who We Are. It's What We Do.

Do you have a passion for serving those who served?

Join the TriWest Healthcare Alliance Team! We're On a Mission to Serve !

Our job is to make sure that America's heroes get connected to health care in the community.

At TriWest Healthcare Alliance, we've proudly been on that important mission since 1996.

DoD Statement

Our Department of Defense contract requires ship and a favorably adjudicated DOD background investigation for this position.


We're more than just a health care company. We're passionate about serving others! We believe in rewarding loyal, hard-working people who are willing to learn as they grow. TriWest Healthcare Alliance values teamwork. Join our team, fulfill your responsibilities, and you may also be considered for frequent pay raises, overtime opportunities to earn even more, recognition and reward programs, and much more. Of course, we also offer a comprehensive and progressive compensation and benefits package that includes:
  • Medical, Dental and Vision Coverage
  • Generous paid time off
  • 401(k) Retirement Savings Plan (with matching)
  • Short-term and long-term disability, basic life, and accidental death and dismemberment insurance
  • Tuition reimbursement
  • Paid volunteer time

*Annual base salary for Colorado, Hawaii and Washington State residents: $126,000- $140,000 depending on experience*

Equal Employment Opportunity

TriWest Healthcare Alliance is an equal employment opportunity employer. We are proud to have an inclusive work environment and know that a diverse team is a strength that will drive our success. To that end, TriWest strives to create an inclusive environment that cultivates and supports diversity at every organizational level, including hiring and retaining a diverse workforce, and we highly encourages candidates from all backgrounds to apply. Applicants are considered for positions without discrimination on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or any other consideration made unlawful by applicable federal, state, or local laws.

About TriWest Healthcare Alliance