Back to Jobs search

Data Warehouse Architect

Moda Health • United States, United States • 4h ago

Job Title

Data Warehouse Architect

Duration

Open until filled

Description

Let's do great things, together!

About Moda

Founded in Oregon in 1955, Moda is proud to be a company of real people committed to quality. Today, like then, we're focused on building a better future for healthcare. That starts by offering outstanding coverage to our members, compassionate support to our community and comprehensive benefits to our employees. It keeps going by connecting with neighbors to create healthy spaces and places, together. Moda values diversity and inclusion in our workplace. We aim to demonstrate our commitment to diversity through all our business practices and invite applications from candidates that share our commitment to this diversity. Our diverse experiences and perspectives help us become a stronger organization. Let's be better together.

Position Summary

The Data Warehouse Architect designs and oversees the architecture of enterprise data warehouse systems, ensuring scalability, performance, and security. This role also builds and optimizes data pipelines consistent with data engineering and analytics engineering best practices, contributing significantly to their development. This is a FT WFH position.

Pay Range

$110,750.29 - $160,000.00 ???annually (depending on experience)

*This role may be classified as hourly (non-exempt) depending on the applicant's location. Actual pay is based on qualifications. Applicants who do not exceed the minimum qualifications will only be eligible for the low end of the pay range.

Please fill out an application on our company page, linked below, to be considered for this position.

https://j.brt.mv/jb.do?reqGK=27769234&refresh=true

Benefits:

Medical, Dental, Vision, Pharmacy, Life, & Disability

401K- Matching

FSA

Employee Assistance Program

PTO and Company Paid Holidays

Required Skills, Experience & Education:

10+ years working with large data sets, preferably in healthcare data environments, using relational databases and data warehouses serving teams organization-wide, with Power BI, SAS Enterprise Guide, or other BI tool experience preferred.

10+ years of regular SQL use, with advanced knowledge of query optimization and performance management across on-prem SQL servers and SQL-based cloud data warehouses (Snowflake, Microsoft Fabric/Synapse, BigQuery, Redshift). Experience migrating on-prem databases to cloud data warehouses strongly preferred.

10+ years of experience with data transformation tools, including legacy methods (SSIS, T-SQL stored procedures) and modern tools (dbt, Coalesce, Azure Data Factory, Python).

5+ years of experience working in Agile methodology.

Experience with data pipeline orchestration tools such as SSIS, SQL Agent, Tidal, Airflow, and dbt.

Expert-level knowledge of data architecture principles, dimensional modeling, and enterprise data integration strategies.

Experience with programming languages commonly used for analytics such as Python or R preferred.

Experience working with Azure cloud technologies preferred.

Experience collaborating using source version control (SVC) systems like Git, with Azure DevOps experience preferred.

Demonstrated ability to identify opportunities, lead development, and implement data-driven solutions that solve real business problems.

Primary Functions:

Architect and design end-to-end data warehouse solutions, including data models, integration patterns, and ELT/ETL frameworks. Develop, test, and deploy code as needed.

Define architectural standards for ELT/ETL automation and scalability and implement processes leveraging modern orchestration tools.

Lead strategic planning and execution of data platform modernization, including cloud migration and hybrid architecture design.

Develop processes and systems to ensure data quality and accuracy.

Create enterprise-grade data architecture frameworks and guide adoption of next-generation data strategies across the organization.

Collaborate with business and technical teams to translate requirements into scalable long-term architectural solutions and support ongoing data infrastructure needs.

Support the Data Science team in implementing data solutions for complex machine learning problems.

Participate collaboratively in Enterprise Data Warehousing, Business Intelligence, and other Data Management projects.

Collaborate with the enterprise IT organization to integrate the Enterprise Data Warehouse into a Microsoft-heavy technology ecosystem.

Perform other duties as assigned.

Working Conditions:

Office environment with extensive close PC and keyboard use, constant sitting, and frequent phone communication. Must be able to navigate multiple computer screens. A reliable, high-speed, hard-wired internet connection required to support remote or hybrid work. Must be comfortable being on camera for virtual training and meetings. Work in excess of standard workweek, including evenings and occasional weekends, to meet business need.

Internally with Data Science, IT, and various data consumers and stakeholders. Externally with third-party providers of data and business solutions, data consumers, and various stakeholders.

Together, we can be more. We can be better.

??????

Moda Health seeks to allow equal employment opportunities for all qualified persons without regard to race, religion, color, age, sex, sexual orientation, national origin, marital status, disability, veteran status or any other status protected by law. This is applicable to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absences, compensation, and training.

For more information regarding accommodations, please direct your questions to Kristy Nehler & Danielle Baker via our humanresources@modahealth.com email.

Similar Jobs

Traveling Senior Mechanical Superintendent - MSG - Data Centers

Turner Construction Co Inc • Minneapolis, MN • 1h ago

IT & Engineering

Division: Critical Facilities-Data Centers Project Location(s): Minneapolis, MN 55401 USA Minimum Years Experience: Travel Involved: 100% Job Type: Regular Job Classification: Experienced Education: Job Family: Construct...

1h ago

Go to Apply

Traveling MEP Engineer - MSG - Data Centers

Turner Construction Co Inc • Minneapolis, MN • 1h ago

IT & Engineering

1h ago

Go to Apply

Traveling Senior Electrical Superintendent - MSG - Data Centers

Turner Construction Co Inc • Minneapolis, MN • 1h ago

IT & Engineering

1h ago

Go to Apply

Traveling Senior MEP Superintendent - MSG - Data Centers

Turner Construction Co Inc • Minneapolis, MN • 1h ago

IT & Engineering

1h ago

Go to Apply

IS Business Support Analyst HQ

Turner Construction Company • Cincinnati, OH • 1h ago

IT & Engineering

Division: Headquarters Project Location(s): New York, NY 10001 USA Minimum Years Experience: 5 Travel Involved: 0-10% Job Type: Regular Job Classification: Experienced Education: Associates Degree Job Family: Information...

1h ago

Go to Apply

IS Business Support Analyst HQ

Turner Construction • Denver, CO • 1h ago

IT & Engineering

Turner is an Affirmative Action and Equal Opportunity Employer - minorities/females/veterans/individuals with disabilities/sexual orientation/gender identity.VEVRAA Federal Contractor Apply at: http://ipc.us/t/E7792A7B7E...

1h ago

Go to Apply

Housing Technician

WEST CAP • Glenwood City, WI • 1h ago

IT & Engineering

JOB REQUIREMENTS: Join Our Team! West CAPan innovative, progressive organization dedicated to creating Strong, Secure Families, and Stable Communities since 1965, is hiring full-time Housing Technicians to join the produ...

1h ago

Go to Apply

Resident Engineer

MDM Solutions LLC • Rocky Mount, VA • 1h ago

IT & Engineering

Accepting Resumes The Resident Engineer is responsible for supervising the planning, coordination and implementation of construction projects. The Resident Engineer will work with the Project Manager, internal design eng...

1h ago

Go to Apply

Civil Engineer I

City of Syracuse • Syracuse, NY • 1h ago

IT & Engineering

Civil Engineer I- $58,878-$67,539 Position Summary The work involves responsibility for performing civil engineering duties of moderate difficulty in the investigation, design, & construction of public works projects...

1h ago

Go to Apply

Design Phase Engineer

Mortenson Construction • Minneapolis, MN • 1h ago

IT & Engineering

SUMMARY Mortenson is currently seeking an experiencedDesign Phase Engineer I andIIto translate owner's project expectations into design drawings, specifications, and schedules, and provide financial cost documentation.St...

1h ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.