BI Data Warehouse Architect

Location: Pittsburgh, PA

Cardiac Management Solutions

The Cardiac Management Solutions division of ZOLL Medical Corporation develops products to protect and manage cardiac patients, including the LifeVest® wearable cardioverter defibrillator (WCD), the ZOLL cardiac monitor, and associated technologies.

Heart disease is the leading cause of death for both men and women in the U.S. At ZOLL, your work will help to ensure cardiac patients get the life-saving therapy they need. To date, the LifeVest WCD has been worn by hundreds of thousands of patients and saved thousands of lives.

ZOLL has been Pittsburgh’s Manufacturer of the Year, one of Western PA’s Healthiest Employers, and even one of Pittsburgh’s Coolest Offices. But it’s our unique opportunity to impact people’s lives that makes ZOLL the ideal place to build your career.

Position Summary: The BI Data Warehouse Architect is responsible for being a key member of our Business Intelligence team, focusing on data architecture, dimensional modeling, platform architecture, solution breakdown, and evangelism of BI best practices and standards. This role is responsible for the design and architecture of the overall BI solution and associated data structures.

Essential Duties and Responsibilities

  • Define technical principles, vision, and standards for data within our BI platforms
  • Effectively and objectively research BI technology concepts and tools, making recommendations to relevant stakeholders
  • Develop and evangelize standards used within BI, including Data Warehouse(DW) best practices and design patterns, frameworks and templates, naming conventions and coding standards
  • Develop dimensional modeling best practices, and act as subject matter expert and guide for data models across all areas of the business
  • Ensure the OW design can scale to handle additional data demands and can adapt to new business questions and data sets
  • Understand and make recommendations on the underlying hardware and software platforms that host all layers of BI
  • Define and recommend ETL processes and associated timings
  • Lend technical expertise to dimensional modeling activities
  • Support the development and execution of system design reviews and query/code review processes
  • Help with project-level technical estimates and timelines
  • Help to establish and improve data governance methodologies
  • Performs other duties as assigned by Management

Supervisory Responsibilities: No direct reports; however, may lead and direct the technical work of other engineers, including their day-to-day tasks.


Qualifications: The qualifications listed below are representative of the knowledge, skills and experience required to satisfactorily perform the essential job duties.  Accommodations and exceptions may be made on an individual basis.

  • Requires B.S. degree in computer science and a minimum of 5 years of relevant experience i n the BI space
  • Experience with Azure, AWS, V MWare or other Cloud/Virtualization technologies is a plus
  • Proven Azure BI stack hands-on experience at an enterprise level is a huge plus
  • Proven DW analysis, design, and data-modeling experience
  • Expert-level SQL Server experience
  • Experience working with SSIS, SSRS, SSDT for Visual Studio and related tools
  • Experience with DAX queries is a plus
  • Experience with data warehouse/decision  support modeling
  • Experienced at leading dimensional modeling activities, helping to populate the bus matrix, and defining conformed dimensions that will work across multiple data marts
  • Experience supporting and troubleshooting data flow into front-end BI dashboards
  • Experience with Agile development methodologies as they apply to BI project


  • "MCSE: Cloud Platform and Infrastructure" and/or MCSD: Azure Solutions Architect" certifications are a huge plus
  • Bachelor's or Master 's degree in computer engineering or related field
  • Experience using SQL Server 2016, PowerBI Pro, DQS and MOM 2016
  • Experience providing data support for predictive analytics projects
  • Ability to work with C#/.NET

Language Skills:  Ability to read and interpret documents of advanced technical complexity.  Ability to write reports and research findings of a technical nature.  Ability to speak and present effectively one-on-one as well as in small and large groups of professionals including customers, clients and collaborators, both inside and outside the organization.

Mathematical Skills:  Ability to apply advanced mathematics principles while performing essential job duties.

Reasoning Ability:  Advanced reasoning skills required.  Must have the ability to solve complex problems and weigh possible solutions to determine rank options to deliver optimal outcomes.  Ability to assess problems involving several variables in changing situations.

Computer Skills:  To perform this job successfully, an individual should be proficient in Microsoft Office Suite.

Physical Demands:  

  • The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
  • While performing the duties of this Job, the employee is regularly required to sit and talk or hear.  The employee is occasionally required to stand and walk.  The employee must occasionally lift and/or move up to 25 pounds.

Work Environment: 

  • The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
  • The noise level in the work environment is usually quiet.

Equal Opportunity Employer-Disability and Veteran