The Systems and Data Engineer (Neuropsychology) is responsible for developing and maintaining databases and tools supporting the clinical operations and research activities of the Neuropsychology Department. The position is jointly responsible to - and supervised by - both the Digital Transformation team and the Neuropsychology department. The incumbent will be subject to the governance and best practices established in the Information Systems department, but will work exclusively on assignments specified by the Neuropsychology department.

1. 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.
2. Design, develop, and deploy Integrated Epic ETL packages using SQL Server Data Tools (SSDT) and/or the Caboodle DMC wizard.
3. Define the data architecture framework, standards, and principles, including: modeling, metadata, security, reference data (e.g. departmental and 3^rd party data), and master data (e.g. patients, encounters, and departments). Assess database implementation procedures to ensure they comply with internal and external regulations.
4. Offer support to end users by responding to system problems in a timely manner.
5. Develop complex SQL queries against various data models.
6. Develop and maintain applications written using C#.NET, VBA, Python and other languages/libraries as appropriate.
7. 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.
8. 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.
9. Review report and application outputs for accuracy/validity.
10. 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.
11. 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.
12. Assess opportunities for integrating Neuropsychology data into enterprise databases and facilitate migration processes as appropriate.
13. 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.

Epic certification required in all applications in their area, as determined by the Neuropsychology and Digital Transformation teams, within 3 months of training.

• 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