Data Warehouse/BI Architect

York, PA | Information Systems and Technical Support | Tracking Code: 66110

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.


Duties and Responsibilities


  1. Gathers requirements for data solutions by conversations with clinicians or administrators, either individually or as part of a design team.
  2. Documents design using diagrams, matrices and prototype mock-ups.
  3. Develops logical data models in modeling software.
  4. Translates logical models to physical data models within the database development tools.
  5. Identifies conformed dimensions and opportunities for master data management and agree approach with peers.
  6. Specifies and/or develops Extract Transform and Load logic (ETL).
  7. Works with data source owners to specify and create extracts from their source.
  8. Documents data dictionaries including entities, attributes, processes and relationships of our applications/databases.
  9. Develops and supports OLAP cube solutions for aggregation type projects.
  10. Develops reporting solutions and extracts for external reporting solutions.
  11. Tests ETL and reporting; documents issues and status.
  12. Troubleshoots reported issues.
  13. Educates end users on the use of the warehouse via query and/or reporting tools.
  14. Promotes the use of the warehouse tools by end users and the data source owners.
  15. Participates in data governance activities.
  16. Optimizes queries and warehouse solutions.
  17. Works with the Database Administrator and Server teams to optimize the database technology.
  18. Participates in technology roadmap planning and warehouse growth planning.
  19. Maintains up to date knowledge of emerging and current data technology.



  • Notes:
    • Other combinations of formal education, training and experience may be considered.


  • 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


James Kane
James Kane
Sr. Talent Acquisition Consultant
Similar Opportunities

Why WellSpan Health?

WellSpan Health is an integrated health system that serves the communities of central Pennsylvania and northern Maryland. The organization comprises a multispecialty medical group of more than 1,600 physicians and advanced practice providers, a regional behavioral health organization, a home care organization, eight respected hospitals, more than 20,000 employees and 200 patient care locations. WellSpan is a charitable, mission-driven organization committed to exceptional care for all, lifelong wellness and healthy communities. We are committed to transforming the health of the communities we serve and to educating the next generation of clinicians, staff and leaders.

Employment Benefits

  • Sign-on incentives for new employees (click here for details)
  • Medical, dental and vision insurance
  • Life and accidental death insurance
  • Supplemental life insurance
  • Retirement savings plan
  • Paid time off (PTO)
  • PTO bridging
  • Short-term disability
  • Educational assistance
  • Forgivable loan
  • Flexible spending
  • Credit union
  • Employee recreational activities
  • Childcare
  • Complimentary medicine discounts

Diversity & Inclusion

Welcome. Respect. Value.

Wellspan Health believes that diversity includes all the human characteristics that make each of us similar as well as different. We strive to make every person feel welcomed, respected, and valued while creating a safe and inclusive environment where we all have the individual freedom to express our uniqueness in a respectful manner.

WellSpan Health is an equal opportunity employer. Employment selection and related decisions are made without regard to sex, race, age, disability, religion, national origin, color or any other protected class. WellSpan Health does, however, have a tobacco-free/nicotine-free hiring policy.

Quality of Life

Founded in 1741, the city of York is considered by many as the first capital of the United States. The Articles of Confederation were signed by the Second Continental Congress here in 1777. Its beautifully restored historic district is an architectural treasure. While York retains its farming and manufacturing heritage, at its heart York is a thriving cultural community that has attracted creative talent and innovative entrepreneurial investors from across the nation.

Life in York County offers affordable housing, options for higher education, a thriving arts and cultural community, historical attractions, parks and recreational resources, semi-professional baseball team, fine dining and more — within an easy drive of major East Coast cities.

York County residents can find local employment in healthcare, manufacturing, technology, agricultural and service sectors. (Patient population: 445,000)