Data Architect Consultant

Intermountain Healthcare; Concord (CA); On-site; USD 125,000 - 150,000; Full time

Job summary

A leading healthcare organization is seeking a skilled Data Architect - Consultant to lead complex data infrastructure projects. This role requires deep expertise in cloud technologies, relational databases, and big data tools, along with strong leadership skills to mentor team members and guide data integration strategies. If you possess a Master's degree or equivalent experience in analytics and are ready to make a significant impact, we’d love to hear from you.

Benefits

Generous benefits package

Focus on well-being: mind, body, and spirit

Qualifications

• Expert proficiency with SQL and traditional RDBMS.
• Extensive experience with AWS, Azure, or Google Cloud.
• Knowledge of ETL processes and data governance frameworks.

Responsibilities

• Lead the design and management of complex data infrastructures.
• Mentor staff and implement enterprise-level data integration strategies.
• Manage multiple complex projects simultaneously.

Skills

Data architecture and design

Cloud infrastructure and data solutions

ETL/ELT development and data integration

Database and performance optimization

Coding/Programming

Data governance and security

Collaboration and stakeholder management

Leadership and project management

Education

Master’s Degree in an analytics-related field

Bachelor's degree in an analytics-related field

Tools

SQL

AWS

Azure

Google Cloud Platform

Databricks

Apache Spark

Kafka

Tableau

Power BI

Job description

**Job Description:**

The purpose of the Data Architect - Consultant role is to lead the design, implementation, and management of complex data infrastructures across multiple projects. This role combines deep expertise in relational databases, cloud technologies, and big data tools to create scalable, efficient, and secure data solutions. The Data Architect - Consultant also provides leadership and direction on enterprise-level data integration strategies and mentors staff and senior team members in developing high-quality data architectures and pipelines across cloud and on-premise systems

**Essential Functions**

+ Lead the design, implementation, and management of complex data infrastructures across multiple projects.

+ Combine deep expertise in relational databases, cloud technologies, and big data tools to create scalable, efficient, and secure data solutions.

+ Manage multiple complex projects simultaneously, working closely with senior and staff data architects/data engineers to ensure successful delivery.

+ Provides leadership and direction on enterprise-level data integration strategies and mentors staff and senior team members in developing high-quality data architectures and pipelines across cloud and on-premise systems.

**Skills**

+ Data architecture and design

+ Cloud infrastructure and data solutions

+ ETL/ELT development and data integration

+ Database and performance optimization

+ Data modeling and documentation

+ Coding/Programming

+ Data governance and security

+ Collaboration and stakeholder management

+ Leadership and project management

**Physical Requirements:**

**Qualifications**

**Minimum Qualifications**

+ Expert proficiency with SQL and extensive experience with traditional RDBMS (e.g., Oracle, SQL Server, PostgreSQL).

+ Extensive experience with cloud platforms such as AWS, Azure, or Google Cloud Platform for data architecture and storage solutions.

+ Mastery of programming languages such as Python and PySpark for data engineering tasks.

+ In-depth knowledge of ETL/ELT processes and tools, including both traditional (e.g., SSIS, Informatica) and cloud-native solutions (e.g., Azure Data Factory, Databricks).

+ Outstanding communication skills for collaborating with stakeholders and teams.

+ Expert understanding of Product Management, Project Management, or Program Management philosophies and methodologies, and capable of applying them to data architecture projects to ensure alignment with business goals and efficient execution.

+ Demonstrated ability to stay updated on industry trends and advancements.

+ Proven experience in providing mentorship and guidance to junior and senior architects.

**Preferred Qualifications**

+ A Master’s Degree in an analytics-related field such as information systems, data science / analytics, statistics, computer science, mathematics and 4 years of experience.

+ or

+ 8 years of professional experience in analytics role in an analytics-related field such as statistics, mathematics, information systems, computer science, data science / analytics.

+ or

+ Bachelors degree in an analytics-related field such as information systems, data science / analytics, statistics, computer science, mathematics. With 6 years of experience

+ Experience with Databricks, Apache Spark, and Delta Lake for real-time and batch data processing.

+ Proficiency in data streaming technologies such as Kafka, AWS Kinesis, or Azure Event Hubs.

+ Experience working with APIs to retrieve and integrate data from external systems.

+ Experience developing APIs to provide data as a product.

+ Familiarity with CI/CD pipelines for data engineering workflows.

+ Knowledge of data governance frameworks and compliance standards (e.g., GDPR, HIPAA).

+ Experience in a healthcare environment

+ Familiarity with business intelligence tools such as Tableau, Power BI, or Looker for delivering insights from data architectures

**Physical Requirements**

+ Remain sitting or standing for long periods of time to perform work on a computer, telephone, or other equipment.

**Location:**

Key Bank Tower

**Work City:**

Salt Lake City

**Work State:**

Utah

**Scheduled Weekly Hours:**

40

The hourly range for this position is listed below. Actual hourly rate dependent upon experience.

$59.47 - $93.64

We care about your well-being – mind, body, and spirit – which is why we provide our caregivers a generous benefits package that covers a wide range of programs to foster a sustainable culture of wellness that encompasses living healthy, happy, secure, connected, and engaged.

Learn more about our comprehensive benefits package here (https://intermountainhealthcare.org/careers/benefits) .

Intermountain Health is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

At Intermountain Health, we use the artificial intelligence ("AI") platform, HiredScore to improve your job application experience. HiredScore helps match your skills and experiences to the best jobs for you. While HiredScore assists in reviewing applications, all final decisions are made by Intermountain personnel to ensure fairness. We protect your privacy and follow strict data protection rules. Your information is safe and used only for recruitment. Thank you for considering a career with us and experiencing our AI-enhanced recruitment process.

All positions subject to close without notice.