Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Cardamom HealthPrincipal Data Engineer
Jun. 2024
TegriaSenior Analytics Consultant
Feb. 2022Kansas City, Kansas, United StatesManchester University Foundation Trust, Manchester, UK Data Warehouse and Business Intelligence Developer (April 2022 – Present)
Incisive ConsultantsAnalytics Consultant
Oct. 2021 - Jan. 2022Kansas City, Kansas, United States
The Royal Melbourne HospitalBusiness Intelligence Developer
Nov. 2020 - Jul. 2021Melbourne, Victoria, AustraliaDesign and develop custom data integrations and dimensional models from multiple healthcare sources Provide modeling and analytics capabilities for integration of hospital encounters, consult orders, inpatient documentation, medications, discharge planning, rapid response events
Bluetree NetworkAnalytics Engineer
Jun. 2017 - Jul. 2020Madison, Wisconsin AreaConfluence Health, Wenatchee, WA Data Warehouse Strategy Advisor and Developer (July 2017 – Present) Develop and optimize ETL in SQL and SSIS o Develop custom data integrations with data from multiple healthcare sources o Design custom data marts and dimensional models Design and create integrated Python and SQL data solutions: o Adaptable file handling routines to simplify file loading processes for volatile file formats o Custom data lineage database to integrate data warehouse and ETL metadata from SQL server, SSIS, and Tableau, including an interactive developer dashboard o ETL schedule automation to monitor source system ETLs and dynamically generate SQL agent jobs for daily, weekly, and monthly schedules Advise, mentor, and train o Development and modeling best practices o Beginner and advanced ETL and visualization techniques
Huron Consulting GroupManager, Data Warehouse and Data Discovery
Jun. 2015 - Jun. 2017Developed innovative solutions for data management, including reporting processes, data governance, and tool selection. Coordinated Caboodle Data Warehouse strategy and implementation, including planning for data warehouse modeling and extension, development of custom ETL processes in SSIS, development of reports and extracts, remote support of ETL processes, as well as report development, scheduling, and maintenance. ~~~~~~~~ Technical Advisor and Project Manager: Enterprise data strategy and data governance •Conducted a technical assessment of reporting processes and data warehouse needs, including evaluation of perceptions and experiences from business, clinical, and IT leadership throughout the organization. •Provided best practice recommendations for data governance, including reporting processes, data warehouse, health information exchange, and population health management. •Collaboratively developed an organizational data strategy, including detailed project plans for system-wide education and data governance implementation. •Advised on and coordinated data governance implementation, including governance structures, process, and tool usage. ~~~~~~~~ Business Analyst/Report Developer: Patient Access Summary productivity metrics •Developed SQL queries and Crystal reports for front end registration optimization, including executive summaries and detail reports of preregistration, authorization, insurance verification, and financial counseling productivity. ~~~~~~~~ Business Analyst/Report Developer: Epic Clarity reporting for Tapestry, EpicLink, and MyChart ~~~~~~~~ Epic Cogito Data Warehouse extension
Huron Consulting GroupSenior Consultant
Jun. 2014 - May. 2015Business Analyst/Report writer: Epic Clarity report and extract development
Lawrence UniversityVisiting Assitant Professor of Psychology
Jan. 2010 - Jun. 2014Appleton, Wisconsin
Meriter HospitalSenior Programmer/Analyst
Jan. 2003 - Dec. 2010Madison, WisconsinCoordinated report development from specification through testing and maintenance for Epic Clarity and Reporting Workbench reports including integrated reporting across multiple Epic applications throughout the hospital Example reporting areas: Revenue statistics, Charge masterfile audit, Diagnosis/procedure usage and masterfile audits, Outpatient clinic statistics (visit type utilization, check-in to check-out turnaround times), Preadmission Report Card, Readmissions, Emergency Services case management, Pharmacy drug utilization, Operating Room procedures and materials usage, Surgical infection prevention compliance, Restraints compliance, Pain Management, Chart deficiency tracking, Medical records storage audits Communicated and collaborated regularly with executives, departments managers, application specialists, and business analysts to design and build application functionality (e.g., clinical flowsheets, custom fields) that meet technical requirements of future report development, report on project progress, and manage expectations Standardized reporting development process, including report request specifications, standard report formatting and coding/design for export to pdf, excel and character-delimited formats, and ftp delivery Optimized Business Objects scheduling conventions to manage on-time delivery of hundreds of daily, weekly, and monthly reports Managed major Clarity database upgrade, including planning for test database, testing and modification of hundreds of reports Performed ongoing audits of reports to determine the cause of long-running reports, optimize SQL queries, and index key database fields Developed and maintained data files including measures for Medicare/Medicaid, Joint Commission core measures, internal auditing, and workflow optimization Implemented report customizations allowing reporting super-users to select parameters and schedule or run reports on demand Conducted in-house trainings on integrated data models and SQL
EpicProject Manager
Jan. 2001 - Dec. 2003Implemented integrated systems as a member of a project team with domestic and international health care organizations; Managed long-term projects with responsibilities including developing and maintaining detailed project plans, consulting business process redesign strategies, managing development projects, conducting high level as well as detailed corporate training, writing financial and operational reports
Intch is a Professional Networking App for the Future of WorkSee more people like Jeremy on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
1022956 people
17
Application Developer @ Nile27
16
Manager Solution Consulting @ Alkami Technology
16
Program Manager @ DISH Network
83127 people
15
Data Scientist
15
Data Analyst
17
Software Design Engineer @ Huntsman Cancer Institute