Susan M.
Mid-Level Data Engineer
Open to offersNew to PlatformAbout
Susan R., a seasoned Data Engineer residing in Highland, IL, has built a notable career in transforming complex EHR and application data into actionable insights. With significant experience at Volunteers of America Ohio & Indiana, she excels in migrating Azure Hive pipelines to Snowflake and constructing datasets that bolster state and grant reporting accuracy. She is adept at managing scalable ETL pipelines and creating automated dashboards, ensuring data quality and improving reporting precision. Additionally, Susan's expertise includes support for the Qualifacts CareLogic EHR system and production of SQL-based reports utilizing Microsoft Power BI to streamline claim resolution processes. Her role as EHR Analyst involved configuring EHR modules that met clinical and billing compliance. Susan's foundational skills were honed in positions like Database/IT Manager, where she managed IT infrastructure supporting over 100 employees, and as a Software Configuration Manager at UnitedHealth Group, where she developed build scripts for legacy systems. She holds a Bachelor in Computer Science from Southern Illinois University and an MBA from Lake Forest Graduate School of Management.
Experience
Data Engineer
Volunteers of America Ohio & Indiana · 2023 — 2026Migrated an Azure Hive pipeline to Snowflake to enhance data ingestion and minimize maintenance efforts. Created documented datasets for state and grant reporting to ensure accuracy and repeatability. Worked collaboratively with DBAs and program staff to improve data entry processes and decrease the need for downstream cleanup.EHR Administrator
Volunteers of America Ohio & Indiana · 2022 — 2023Provided support for Qualifacts CareLogic EHR, serving approximately 70 users with a focus on billing accuracy and claim resolution. Generated SQL reports and developed a Power BI failed-claim dashboard to pinpoint causes and responsible parties, aiming to reduce claim failures.EHR Analyst
Volunteers of America Ohio & Indiana · 2021 — 2022Configured and deployed CareLogic EHR modules to meet clinical, billing, and grant requirements, ensuring compliance and encouraging user adoption. Streamlined the completion of prior-authorization forms using Pentaho Report Designer to cut down on manual data entry and expedite approval times.Database/IT Manager
Volunteers of America Ohio & Indiana · 2014 — 2021Oversaw network infrastructure, virtual servers, case-management and corrections databases, workstations, and telephony to support over 100 employees across eight locations, enhancing system stability and support responsiveness. Created a program template within the case-management system adopted by multiple Volunteers of America affiliates, including the national office, to standardize workflows and reduce program setup time.Donor Database Manager
Our Lady of Grace Monastery · 2013 — 2014Managed and maintained the donor database utilizing Blackbaud eTapestry, with an emphasis on ensuring data quality and accurate processing of fundraising pledges.Software Configuration Manager
Unitedhealth Group · 2010 — 2011Established a Microsoft Team Foundation Server 2010 build environment and created build scripts for integrating components from legacy systems. Maintained these build scripts to optimize compilation and deployment processes. Fostered improved communication and documentation across teams to keep testing and downstream teams informed about build statuses and readiness.
Skills & Expertise
Education
- MBA, ManagementLake Forest Graduate School of Management · 2002 — Present
- Bachelor, Computer ScienceSouthern Illinois University, Edwardsville · 1989 — Present