SYSTEMS AND DATA ENGINEER

• Design multi-dimensional data warehouse and ETL processes to integrate data from multiple sources, to include: Universes, SSAS Cubes, extracts, SlicerDicer, and reports to query the Caboodle Data Warehouse. Translate business requirements into technical specifications, including data streams, integrations, transformations, databases, and data warehouses.
• Design, develop, and deploy Integrated Epic ETL packages using SQL Server Data Tools (SSDT) and/or the Caboodle DMC wizard.
• Define the data architecture framework, standards, and principles, including: modeling, metadata, security, reference data (e.g. departmental and 3rd party data), and master data (e.g. patients, encounters, and departments). Assess database implementation procedures to ensure they comply with internal and external regulations.
• Offer support to end users by responding to system problems in a timely manner.
• Develop complex SQL queries against various data models.
• Develop and maintain applications written using C#.NET, VBA, Python and other languages/libraries as appropriate.
• Collaborate with the Digital Transformation team regarding data engineering, data management, application development, deployment, and project management for the Neuropsychology department’s needs. Work with data engineers, data architects, and other team members in the development and implementation of projects to reach project milestones and deadlines. Create tracking documentation for Neuropsychology’s needs within the project and ticket tracking solutions the Digital Transformation team uses as appropriate.
• Create and manage the output/reports created from questionnaires and maintain the process for making them available in Epic and CPR (Central Patient Repository). Develop reports for Neuropsychology using the Digital Transformation team’s internal tools such as Power BI, Azure DevOps and other tools as they are available and appropriate.
• Review report and application outputs for accuracy/validity.
• Manage Neuropsychology questionnaire interfaces and all the parallel internal process to make sure that questionnaires are sent, downloaded, stored in the database, and that reports are generated. Enhance and maintain questionnaire data flows to ensure that all related processes are occurring without error and that all data are present and accurate.
• Review and adjust incoming and outgoing data extracts (e.g. removing duplicates, correcting errors, etc.), as well as data at rest in the Neuropsychology databases. Create and/or manage processes to back up Neuropsychology data into the appropriate database in a manner that is consistent and automated.
• Assess opportunities for integrating Neuropsychology data into enterprise databases and facilitate migration processes as appropriate.
• Assist with the migration from older technologies and legacy systems (such as Microsoft Access) to newer technologies (such as Power Apps), systems, and/or databases for the Neuropsychology department.

• Bachelor’s degree in computer sciences, math or information systems required.
• Master’s degree preferred.

• Minimum 5 years of applicable experience required, to include:

• at least two years of experience writing and troubleshooting SQL queries
• at least two years of experience writing and troubleshooting Python scripts
• Experience creating applications using an object oriented language, C# preferred

Kennedy Krieger Institute