Data Architect - Associate

imh; Audubon (GA); On-site; USD 50,000 - 79,000; Full time

Benefits offered by this job

Benefits package

Job summary

Intermountain Health is seeking a Data Architect - Associate to design, implement, and maintain data infrastructures across on‑premise and cloud environments. You will build scalable data models, pipelines, and warehouses using SQL, Python, PySpark, and related technologies while collaborating with teams to align data solutions with business goals.

In this entry‑level role, you will be mentored by senior data architects/engineers on moderate to complex projects, focusing on data quality,

Qualifications

• Proficiency with SQL and RDBMS (Oracle, SQL Server, Postgres, Snowflake, Databricks).
• Introductory experience with AWS/Azure/GCP for data architecture and storage solutions.
• Familiarity with Python and PySpark for data engineering tasks.
• Foundational knowledge of ETL/ELT processes and tools (SSIS, Informatica, Azure Data Factory, Databricks).
• Python or PySpark or R programming proficiency.

Responsibilities

• Design, implement, and maintain data infrastructures (traditional and modern).
• Develop strategies to integrate enterprise data, ensure quality, and optimize access across cloud/on‑prem systems.
• Work on moderate to complex projects with mentorship from senior data architects/engineers.
• Deliver robust data models, pipelines, and warehouses using SQL, Python, PySpark, and RDBMS platforms.

Skills

Data architecture

Cloud infrastructure

ETL/ELT

Database optimization

Data modeling

Coding

Data governance

Stakeholder management

Project leadership

Education

Bachelor's degree in CS/DS/Engineering

Tools

Databricks

Apache Spark

Delta Lake

Kafka

AWS Kinesis

Azure Event Hubs

Job description

Job Description:

The purpose of the Data Architect - Associate role is to design, implement, and maintain both traditional and modern data infrastructures. This role combines expertise in relational databases, cloud technologies, and big data tools to create scalable, efficient, and secure data solutions. The Data Architect - Associate develops strategies for integrating enterprise data, ensuring data quality, and optimizing data access across both cloud and on-premise systems. They work on moderate to complex projects and are mentored by senior-level data architects/engineers to deliver robust data models, pipelines, and warehouses that meet organizational needs using technologies like SQL, Python, PySpark, and traditional RDBMS platforms

Essential Functions

• Responsible for designing, implementing, and maintaining both traditional and modern data infrastructures at an entry level.
• Combines expertise in relational databases, cloud technologies, and big data tools to create scalable, efficient, and secure data solutions.
• Develops strategies for integrating enterprise data, ensuring data quality, and optimizing data access across both cloud and on-premise systems.
• Works on moderate to complex projects and is mentored by senior-level data architects/engineers to deliver robust data models, pipelines, and warehouses that meet organizational needs using technologies like SQL, Python, PySpark, and traditional RDBMS platforms

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

Minimum Qualifications

• Basic proficiency with SQL programming and experience with traditional RDBMS (e.g., Oracle, SQL Server, Postgres, Snowflake, Databricks).
• Introductory experience with cloud platforms such as AWS, Azure, or Google Cloud Platform for data architecture and storage solutions.
• Familiarity with programming languages such as Python and PySpark for data engineering tasks.
• Foundational knowledge of ETL/ELT processes and tools, including both traditional (e.g., SSIS, Informatica) and cloud-native solutions (e.g., Azure Data Factory, Databricks).
• Basic proficiency with Python or PySpark or R programming
• Developing communication skills for collaborating with stakeholders and teams.
• Proficiency in 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.

Preferred Qualifications

• Bachelor's degree in Computer Science, Data Science, Engineering, or a related field from an accredited institution.
• 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).
• 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

Lake Park Building

Work City

West Valley City

Work State

Utah

Scheduled Weekly Hours

40

Hourly Rate

$35.99 - $56.68

Benefits

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.

Equal Opportunity Statement

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.

Recruitment Platform

At Intermountain Health, we usethe artificial intelligence ("AI") platform, HiredScore to improve your job application experience.HiredScore helps match your skills and experiences to the best jobs for you. WhileHiredScore assists in reviewing applications, all final decisions are made byIntermountain 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.