Data Architect (Full Time/ Day shift)

Summary 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.

LOCATION: Lancaster, PA (Local Remote)

HOURS : Full Time (1.0 FTE; 40hrs/wk) Day Shift 8AM-5PM (Flexible)

Holiday/Weekend as needed

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.
• nalyzes 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.
  

Job Requirements

MINIMUM REQUIRED QUALIFICATIONS:

• 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 T-SQL.
  

Preferred Qualifications

• Bachelor s degree in Computer Science, Business Administration or related field
• Three (3) years experience with mainframe applications including interface engine support.
• Knowledge of data warehouse systems or database administration.
• Knowledge of SSIS and SSRS
  

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
  

Disclaimer

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 10/28/2022

Apply