Data Architect-Consultant

Intermountain Healthcare Inc.; Murray (KY); Remote; USD 84,000 - 132,000; Full time

Job summary

Intermountain Health is seeking a Data Architect - Consultant to design, implement, and manage complex data infrastructures across multiple projects. The role combines expertise in relational databases, cloud technologies, and big data tools to deliver scalable, secure data solutions.

You will mentor staff, lead enterprise data integration strategies, and work across cloud and on-premise systems while supporting flexible remote work options.

Qualifications

• Expert SQL with Oracle/SQL Server/PostgreSQL experience.
• Cloud data architecture on AWS/Azure/GCP.
• Python/PySpark for data engineering.
• ETL/ELT tools including SSIS/Informatica and cloud-native options.
• Strong communication for stakeholder collaboration.
• Knowledge of PM/ agile methodologies in data projects.
• Keeps up with industry trends and mentors others.
• Experience mentoring junior/Senior architects.

Responsibilities

• Lead design, implementation, and management of complex data infrastructures.
• Leverage relational databases, cloud tech, and big data tools for scalable data solutions.
• Manage multiple projects with senior architects/data engineers.
• Provide leadership on data integration strategies and mentor staff.

Skills

Data architecture

Cloud infrastructure

ETL/ELT development

Database optimization

Data modeling

Coding

Data governance

Collaboration

Leadership

Education

Master's Degree in analytics

8 years analytics experience

Bachelors in analytics with 6 years

Tools

Databricks

Apache Spark

Delta Lake

Kafka

AWS Kinesis

Azure Event Hubs

APIs

CI/CD pipelines

Job description

Fully Remote

Vine Street Office Building

Full time

R183756

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

We are committed to offering flexible work options where approved and stated in the job posting. However, we are currently not considering candidates who reside or plan to reside in the following states: California, Connecticut, Hawaii, Illinois, Maine, Massachusetts, Minnesota, New York, Pennsylvania, Rhode Island, Virginia, Vermont, Washington.

This position is fully remote. | Schedule: Monday - Friday, 8AM - 5PM, MST, with 1 on call per quarter

Preferred skills: IRIS Intersystems tools and administration, Cache ObjectScript development, source-control tools and strategies, Angular development, real-time data integration strategies, Epic Bridges non-standard real-time integrations working across HIEs, external integrations

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

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:

Vine Street Office Building

Work City:

Murray

Work State:

Utah

Scheduled Weekly Hours:

40

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

$60.67 - $95.52

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) .

By applying for a position with Intermountain, I acknowledge that I will comply with all applicable Intermountain policies and expectations. If applying for a remote or hybrid role, this includes remote work expectations related to confidentiality, information security, work schedules, conflicts of interest, and use of company equipment. I further acknowledge that outside employment or activities may not interfere with job responsibilities or create a conflict of interest with Intermountain. Actual or reasonably perceived conflicts may be grounds for disqualification from consideration or, if hired, corrective action up to and including termination of employment.

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.

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 (https://intermountainhealthcare.org/careers/?utm_source=Workday&utm_medium=Redirect&utm_campaign=CareerHome_workday) .

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.

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 … (https://intermountainhealthcare.org/careers/working-for-intermountain/employee-benefits/peak-program/)

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.

Thanks for your interest in continuing your career with our team!