Data Warehouse Architect - CA
Job Details
LIBERTY Dental Plan of California - Irvine, CA
Full Time
Information Technology

**Fast-paced and growing corporate office seeks a Data Warehouse Architect.


The DW Architect must have extensive hands-on experience implementing data warehouses using the Microsoft stack with a focus on SSIS, SSAS tabular, DAX, Power BI, DevOps, and the Azure suite of products. The ideal architect will partner with team members, customers, and business owners in creating robust and scalable SQL Server stack solutions to accomplish the enterprise goals of the team. The DW Architect must possess a collaborative attitude, strong oral/written presentation skills, excellent problem-solving skills, and solid analytical/critical thinking skills.


Essential Duties:

  • Design and implement a flexible platform for operational data stores, data warehouses, data marts and data lakes using standard practices as well as documenting the systems of record, data dictionaries and data flow diagrams for strategic data management
  • Develop extracts, transforms, and loads with SSIS required. Python a big plus.
  • Drive Azure cloud data platform architectural decisions and development standards
  • Implement and govern a source control strategy through DevOps
  • Actively contribute towards data migration tasks from on-premises to cloud
  • Multi-task across several ongoing projects and daily duties of varying priorities as required
  • Ability to make good judgments, decisions, negotiate and problem solve
  • Create detailed technical specifications and release documentation for assigned ETL and reporting projects

Education and/or Experience:

  • Experience with Data Warehousing methodologies and concepts (Kimball)
  • Extensive experience with BI/DW lifecycle including source data analysis, ETL, data marts, reporting, dashboards, and analytics
  • 8+ years of experience working with MS SQL Server database. Mastery of SQL, specifically MS SQL Server 2012 and higher.
  • 8+ years of experience developing ETL processes with large scale data warehouses required
  • 8+ years of experience with Microsoft BI stack (SSIS, SSRS and SSAS). Python a big plus.
  • 2+ years working in DevOps, automating, and deploying packages between different environments
  • 2+ years of experience with Azure SQL Database, Azure Data Factory, Azure SQL Data Warehouse, Azure Synapse Analytics, and related Azure services is strongly preferred
  • Experience with NoSQL data (JSON, etc.) a big plus
  • Experience with Healthcare data not required, but highly desirable

Specific Skills/Knowledge:

  • High proficiency in dimensional modeling techniques and their applications including star schemas
  • Familiarity with Data Governance and Master Data Management principles
  • Strong verbal and written communication skills for collaboration with business stakeholders and technical peers

Environment and/or Physical Factors:

Work is generally performed within an office environment, with standard office equipment available. Sedentary work involves extensive sitting, typing, close range vision most of the time.


Sponsorship and Relocation Specifications:

LIBERTY Dental Plan is an Equal Opportunity Employer / VETS / Disabled.

No relocation assistance or sponsorship available at this time.