Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

Data Warehouse Architect (SSAS, Tabular, DAX, SSIS)

K

Kinetic Personnel Group

Data Warehouse Architect (SSAS, Tabular, DAX, SSIS)

Irvine, CA
Full Time
Paid
Similar Jobs
  • Responsibilities

    Job Description

    Kinetic Personnel Group is currently recruiting a Data Warehouse Architect for a healthcare company located in Irvine, California.

    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.

    Job 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

    Requirements: 

    • 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

    Company Description

    We are Kinetic Personnel Group! As our name implies, we are dedicated to keeping your career in motion by connecting exceptional candidates with great companies. We work with companies across a variety of industries both, locally and nationwide to keep their businesses moving forward. Our customers are established Organizations; large and small; in the private, public, and municipalities sectors. We partner with them to staff for a broad range of positions and across various functionalities, such as: Accounting/Finance Information Technology Healthcare Sales/ Customer Service Engineering Disciplines Manufacturing Administration Logistics