Data Engineer Senior

Data Warehouse Architect

Responsible for the architecture, design, implementation, and support of data warehouse and data management solutions to support business intelligence, working with the Analytics Center of Excellence (ACoE) data engineering team. This position works closely with key business and clinical data source systems and designs data solutions by which information is loaded into and extracted from key clinical and business systems to the Enterprise Data Warehouse. This position leverages key development, database, reporting, analytic, and business intelligence skills across a diverse and multi-faceted application landscape. This position will be responsible for developing, modifying, and maintaining data marts, tabular data models in Microsoft data warehouse/BI environment, and other data models to support the reporting and analysis needs of the organization. This position maintains a comprehensive knowledge and understanding of relational database concepts, including data architecture, operational data stores, ETL/ELT processes, interface processes, data modeling, data warehouse concepts, master data management, and data manipulation.

Essential Functions:

• Provides support in requirements gathering for data solutions through collaboration with clinicians or administrators, either individually or as part of a design team.
• Strong ability to translate business requirements into design and development of data structure, data marts, along with physical and/or logical models within the designated data environments to support decision analysts.
• Experience with database design, dimensional model design, data warehouse, and building SSAS models and ETL process.
• Must have strong experience in writing SQL, DAX queries.
• Facilitates system wide data integrity, quality control, and standardization as identified by system leaders and/or system level teams.
• Understands and engages in agile methods of project and program management.
• Documents design using diagrams, and data modeling software to prototype mock-ups.
• Develops logical data models in modeling software.
• Translates logical models to physical data models within the database development tools.
• Identifies and collaborates on opportunities for conformed dimensions and master data management (MDM).
• Develops, tests, and maintains data flows like ETL/ELT (Extract Transform Load / Extract Load Transform).
• Works with data source owners to specify and create extracts from their source for data curation.
• Documents data dictionaries including entities, attributes, processes, and relationships of our applications/databases.
• Develops reporting solutions and extracts for external reporting solutions.
• Troubleshoots issues as needed for operational support and quality control.
• 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, cluster resources, and data warehouse solutions.
• Works with the Database Administrator and Server teams to optimize the database technology.
• Experience in technology roadmap planning and warehouse growth planning.
• Strong programing skills to support advanced ETL/ELT including languages such as Python.
• Experience programming and supporting Machine Learning (ML) and Artificial Intelligence (AI) algorithms using Python, R, SparkML to support Data Engineers.
• Experience with distributed file systems and storage architecture.
• Maintains up to date knowledge of emerging and current data technology.
• Participates in the definition of departmental standards, policies, procedures, and methodologies associated with knowledge management functions, including those used to measure and improve the quality and productivity of the customer's business unit.

Common Expectations:

• Enhances professional growth and development through participation in educational programs, current literature, in-service meetings, and workshops.
• Provides outstanding service to all customers; fosters teamwork; and practices fiscal responsibility through improvement and innovation.

Qualifications:

• Minimum Education: High School Diploma or GED Required, Masters Degree Preferred
• Work Experience: 8 years or more minimum experience in Computer Science/Information Systems with data warehouse design experience and 5 years in a data engineer role Required
• Knowledge, Skills, and Abilities: Excellent teamwork/communication/customer service skills.

Benefits Offered:

• Comprehensive health benefits
• Flexible spending and health savings accounts
• Retirement savings plan
• Paid time off (PTO)
• Short-term disability
• Education assistance
• Financial education and support, including DailyPay
• Wellness and Wellbeing programs
• Caregiver support via Wellthy
• Childcare referral service via Wellthy

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)

WellSpan Health is an Equal Opportunity Employer. It is the policy and intention of the System to maintain consistent and equal treatment toward applicants and employees of all job classifications without regard to age, sex, race, color, religion, sexual orientation, gender identity, transgender status, national origin, ancestry, veteran status, disability, or any other legally protected characteristic.