Data Architect - Associate

11400 Information Systems; Audubon (GA); On-site; USD 50,000 - 79,000; Full time

Job summary

Intermountain Health is seeking an Data Architect - Associate to design and maintain modern data infrastructures. You will work on data models, pipelines, and warehouses using SQL, Python/PySpark, and traditional RDBMS platforms across cloud and on-premise environments.

The role emphasizes data quality, integration strategies, and secure data access, with mentorship from senior data architects. Strong collaboration with stakeholders is essential for aligning data solutions with business goals.

Qualifications

• Minimum Qualifications: Basic SQL with traditional RDBMS (Oracle, SQL Server, Postgres)
• Introductory cloud experience (AWS, Azure, GCP) for data architecture
• Python or PySpark for data engineering tasks
• Foundational ETL/ELT knowledge (SSIS, Informatica, Azure Data Factory, Databricks)
• Basic Python/PySpark/R knowledge
• Developing stakeholder communication skills
• Exposure to PM/PMO methodologies in data projects

Responsibilities

• Designs, implements, and maintains data infrastructures
• Collaborates on data integration across cloud and on-premise systems
• Mentors and works with junior staff on data models, pipelines, and warehouses

Skills

Data architecture

Cloud infrastructure

ETL/ELT

Database performance

Data modeling

Coding

Data governance

Stakeholder mgmt

Leadership

Education

Bachelor's degree

Tools

Databricks

Apache Spark

Delta Lake

Tableau

Power BI

Looker

Azure

AWS

GCP

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

Qualifications

• 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

• 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

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

$35.99 - $56.68

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.

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.

Headquartered in Utah with locations in six primary states and additional operations across the western U.S., Intermountain Health is a nonprofit system of 34 hospitals, 400+ clinics, a medical group of more than 4,800 employed physicians and advanced care providers, a health plan division called Select Health with more than one million members, and other health services. Helping people live the healthiest lives possible, Intermountain is widely recognized as a leader in clinical quality improvement and efficient healthcare delivery. Join our world-class team and embark on a career filled with opportunities, strength, innovation, and fulfillment. To find out more about us, head to our career site here.

Intermountain Health strives to make the application process accessible to all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact 1-800-843-7820 or email [e-mail]. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.

Introduce yourself to our Talent Acquisition team and we will get in touch if there is a role that seems like a good match.

Intermountain Health’s PEAK program supports caregivers in the pursuit of their education goals and career aspirations by providing up-front tuition coverage paid directly to the academic institution. The program offers 100+ learning options to choose from, including undergraduate studies, high school diplomas, and professional skills and certificates. Caregivers are eligible to participate in PEAK on day 1 of employment. Learn more.

The primary intent of this job description is to set a fair and equitable rate of pay for this classification. Only those key duties necessary for proper job evaluation and/or labor market analysis have been included. Other duties may be assigned by the supervisor. All positions subject to close without notice. Thanks for your interest in continuing your career with our team!