Job Details

ID #8464211
State California
City Irvine
Job type Permanent
Salary USD $115,000 - $135,000 115000 - 135000
Source LIBERTY Dental Plan
Showed 2021-01-22
Date 2021-01-11
Deadline 2021-03-12
Category Et cetera
Create resume

Data Warehouse Architect

California, Irvine, 92602 Irvine USA

Vacancy expired!

Summary (Including Minimum Essential Position Duties)

:

The Data Warehouse 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 Data Warehouse Architect must possess a collaborative attitude, strong oral/written presentation skills, excellent problem-solving skills, and solid analytical/critical thinking skills.
  • 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.

Vacancy expired!

Subscribe Report job