Moda Health · 1 day ago
Data Warehouse Architect
United States
Full-time
Remote
Senior Level, Lead/Staff
$111K/yr - $160K/yr
10+ years expModa Health is a company committed to quality healthcare and community support. The Data Warehouse Architect will design and oversee the architecture of enterprise data warehouse systems, ensuring scalability, performance, and security while building and optimizing data pipelines.
BankingHealth CareHealth InsuranceInsurance
Responsibilities
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
Qualification
Required
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
Demonstrated ability to identify opportunities, lead development, and implement data-driven solutions that solve real business problems
Preferred
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
Benefits
Medical, Dental, Vision, Pharmacy, Life, & Disability
401K- Matching
FSA
Employee Assistance Program
PTO and Company Paid Holidays
Company
Moda Health
Moda Health offers quality health coverage in Oregon, Washington, and Alaska.
1001-5000 employees
H1B Sponsorship
Moda Health has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (1)
2021 (1)
Funding
Current Stage
Late StageTotal Funding
$205MKey Investors
Delta Dental
2018-08-31Corporate Round· $155M
2014-12-18Debt Financing· $50M
Leadership Team
R
Robert Judge
Chief Client Office, Pharmacy Solutions
Recent News
2023-07-24
Business Journals
2022-10-06
Company data provided by crunchbase