Home / Data Architect (Full Time/ Day)

Data Architect (Full Time/ Day)


Your Department.
For Job Posting And Candidate Communication: Please Indicate Fte, Shift, Hours Needed, On-Call Or Holiday/Weekend Rotations And General Talking Points About Your Department.
1.0 FTE
40 hours weekly
Mon-Fri, 8-5 with some flexibility
Holiday/Weekend as needed (very rare)
Remote work position

* Work with Accountable Care Organization (ACO)
* Participate on a scrum team as a developer
* Experience with Epic healthcare ERM and Cogito a plus

Job Description

POSITION SUMMARY: The primary responsibility of the position will be the optimization of enterprise business intelligence tools to demonstrate the value to the organization by defining optimal and scalable architecture. Leverages knowledge of relational databases, interfaces and enterprise reporting engines to contribute to Lancaster General Health’s business intelligence effort. Develops and maintains system data marts and registries; troubleshoots and tunes databases and ETL process; assists in establishing development standards. Writes code for database access, modifications, and constructions, including stored procedures.

ESSENTIAL FUNCTIONS: Qualified individuals must have the ability (with or without reasonable accommodation) to perform the following duties:

  • Designs BI architecture plans and builds roadmaps for integration to the presentation layers for strategic projects.
  • Researches new technology and develops business cases to support enterprise wide business intelligence solutions.
  • Prepares simple specifications, designs, data models and diagrams from which databases can be developed.
  • Translates logical/physical data designs and models into data dictionaries.
  • Develops and maintains solutions for data integration into EHR from business intelligence tools.
  • Develops enterprise level relational and multidimensional data and object models that are related to metadata, metrics, transactions and data definition.
  • Communicates and documents data status/knowledge/issues with other members of IS including user Subject Matter Experts and System Administrators to resolve data requirements and participate in data conversion requirements definition.
  • Assists in the analysis, design and implementation of accurate, secure, and efficient Business Objects Universes.
  • Analyzes and assesses clinical workflows and processes and provides recommendations for improved design methods.
  • Keeps current with latest technology; regularly attends Epic training in order to maintain technical competency

SECONDARY FUNCTIONS: The following duties are considered secondary to the primary duties listed above:

  • Utilize database programming such as stored procedures to develop clinical or financial based data marts, and to develop extracts required by the business units.

  • Conducts research into new data warehouse applications and determines viability for adoption.
  • Interfaces with vendors to provide support and requirements definitions.
  • Other duties as assigned.



  •  High school diploma
  • Epic Certifications as required by Information Services to support the application.  Certification will be offered and provided by LGH and must be obtained within 6 months of role entry and within three (3) exam attempts
  • Three (3) to five (5) years experience In-depth knowledge of RDBMS systems, specifically MS SQL and management tools.
  • Strong SQL skills including the ability to write complex queries for performance improvement.
  • Three (3) to five (5) years experience working with database analysis & design tools; using reporting applications; or creating ad hoc reports.
  • In-depth knowledge of Data Modeling concepts and tools.
  • In-depth knowledge Data Mart design concepts.
  • In-depth knowledge of database programming including stored procedures using PL/SQL.


  • Bachelor’s degree in Computer Science, Business Administration or related field
  • Three (3) years experience with mainframe applications including interface engine support.
  • Knowledgedata warehouse systems or database administration.
  • In-depth knowledge of SAP Business Objects tool set.

Disclaimer: This job description is not intended and should not be construed to be an exhaustive list of all responsibilities, skills, efforts, or working conditions associated with the job.  It is intended to be a reflection of those principal job elements essential for recruitment and selection, for making fair job evaluations, and for establishing performance standards.  The percentages of time spent performing job duties are estimates, and should not be considered absolute.  The incumbent shall perform all other functions and/or be cross-trained as shall be determined at the sole discretion of management, who has the right to amend, modify, or terminate this job in part or in whole.  Incumbent must be able to perform all job functions safely.


Benefits At A Glance:

PENN MEDICINE LANCASTER GENERAL HEALTH offers the following benefits to employees:

  • 100% Tuition Assistance at The Pennsylvania College of Health Sciences
  • Paid Time Off and Paid Holidays
  • Shift, Weekend and On-Call Differentials
  • Health, Dental and Vision Coverage
  • Short-Term and Long-Term Disability
  • Retirement Savings Account with Company Matching
  • Child Care Subsidies
  • Onsite Gym and Fitness Classes


PENN MEDICINE LANCASTER GENERAL HEALTH is an Equal Opportunity Employer, committed to hiring a diverse workforce. All openings will be filled based on qualifications without regard to race, color, sex, sexual orientation, gender identity, national origin, marital status, veteran status, disability, age, religion or any other classification protected by law.


Search Firm Representatives please read carefully: PENN MEDICINE LANCASTER GENERAL HEALTH is not seeking assistance or accepting unsolicited resumes from search firms for this employment opportunity. Regardless of past practice, all resumes submitted by search firms to any employee at PENN MEDICINE LANCASTER GENERAL HEALTH via-email, the Internet or directly to hiring managers at Penn Medicine Lancaster General Health in any form without a valid written search agreement in place for that position will be deemed the sole property of PENN MEDICINE LANCASTER GENERAL HEALTH, and no fee will be paid in the event the candidate is hired by PENN MEDICINE LANCASTER GENERAL HEALTH as a result of the referral or through other means.

COMMERCIAL Full Time Posted on 09/05/2023