Data Warehouse/Business Intelligence Architect (Associate)

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

Position Summary:

General Summary


Under general supervision, is responsible for the architecture, design, implementation and support of data warehouse and business intelligence solutions, including working with business, clinical teams and senior architects 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.

Required Skills

Minimum Education

Bachelor's Degree



Minimum Experience

5 Years



Min Field Of Expertise

Computer Science/Information Systems with data warehouse development experience

Quality of Life

WellSpan Health is an integrated health system that serves the communities of central Pennsylvania and northern Maryland. The organization is comprised of a multispecialty medical group of more than 1,500 physicians and advanced practice clinicians, a regional behavioral health organization, a home care organization, eight respected hospitals, more than 19,000 employees, and 170 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.

Quality of Life
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)

Equal Opportunity Employment

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.

Similar Opportunities