Data Warehouse/BI Architect

  • location: York, PA
  • type: Permanent
  • salary: $1 per year

job description

Data Warehouse/BI Architect

job summary:
Job Description:

Under general supervision, is responsible for the architecture, design, implementation and support of data warehouse and business intelligence solutions, including working with business and clinical teams to define requirements and translating them to operational tools using data warehouse best practices. Works in a team closely aligned with Population Health Services and a Data Analytics team.

location: York, Pennsylvania
job type: Permanent
work hours: 8am to 5pm
education: Bachelors
Duties and Responsibilities

Gathers requirements for data solutions by conversations with clinicians or administrators, either individually or as part of a design team.

Documents design using diagrams, matrices and prototype mock-ups. Develops logical data models in modeling software. Translates logical models to physical data models within the database development tools. Identifies conformed dimensions and opportunities for master data management and agree approach with peers. Specifies and/or develops Extract Transform and Load logic (ETL). Works with data source owners to specify and create extracts from their source. Documents data dictionaries including entities, attributes, processes and relationships of our applications/databases. Develops and supports OLAP cube solutions for aggregation type projects. Develops reporting solutions and extracts for external reporting solutions. Tests ETL and reporting; documents issues and status. Troubleshoots reported issues. Educates end users on the use of the warehouse via query and/or reporting tools. Promotes the use of the warehouse tools by end users and the data source owners. Participates in data governance activities. Optimizes queries and warehouse solutions. Works with the Database Administrator and Server teams to optimize the database technology. Participates in technology roadmap planning and warehouse growth planning. Maintains up to date knowledge of emerging and current data technology.


  • Minimum Experience:

    • 5 Years
  • Minimum Education:

    • Bachelor's Degree
Minimum Field Of Expertise:

    • Computer Science/Information Systems with data warehouse design experience
    • Python 3.x experience is a plus
    • Experience with Data Libraries a plus.
    • Experience with scripting utilities a plus
    • Other combinations of formal education, training and experience may be considered.
The essential functions of this role include:

  • working in a smoke free environment
  • Experience level: Experienced
  • Minimum 5 years of experience
  • Education: Bachelors
  • Data Warehouse
  • Business Intelligence
  • ETL
  • Data Modeling
  • Data Governance
  • Python

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

get jobs in your inbox.

sign up

related jobs

    Desktop Support

  • location: York, PA
  • job type: Contract
  • salary: $1 per hour
  • date posted: 3/3/2021

    Desktop Support

  • location: York, PA
  • job type: Contract
  • salary: $1 per hour
  • date posted: 3/3/2021