Erik
(Him/He)Senior Data Analyst @ Hallmark HCS | Views are my own
Senior Data Analyst at Hallmark - Healthcare Workforce Technology
Activity
Loading activity...
Career: 23
Senior Data Analyst
Hallmark - Healthcare Workforce Technology
Atlanta, GA
Apr 2026 - Present
Senior Data Analyst
Hallmark - Healthcare Workforce Technology
Atlanta, GA
Consultant BI Analyst
The Southeast Permanente Medical Group
Marietta, Georgia, United States
May 2023 - Apr 2026
Consultant BI Analyst
The Southeast Permanente Medical Group
Marietta, Georgia, United States
Created reporting in Tableau and Power BI for business partners to investigate clinical operations. Helping to align financial and clinical data for better insights into value and budget. Developed Shiny application (Rhino framework) to allow for self-service of ad hoc data requests from business partners. Utilized Quarto sites to publish technical documentation, wikis, and data dictionaries to open data access throughout wider organization and improve data literacy. Analytic lead on care pathway work within organization. Helping to pilot data concierge approach to service requests with an aim to improve analytic resource towards more strategic use in the organization.
Solutions Analyst
Northside Hospital
Atlanta, Georgia, United States
Oct 2022 - May 2023
Solutions Analyst
Northside Hospital
Atlanta, Georgia, United States
Create and maintain a suite of reports across 5 hospital sites and multiple physician practices ranging from financial to clinical using Visual Studio, HTML, JavaScript, Power BI, Netezza, R and Spotfire. Help to maintain database system for the hospital spanning raw to production databases. Investigating ML models for trends within the hospital system. Developed python scripts to complete data warehouse migration validation (validate records matched across old and new databases) and generation of report to investigate discrepancies. Created R script for web scraping hospital diversion status and import to database to combine with an ML model to better understand and attempt to predict emergency room capacity. Taught R to team of analysts to improve skills in the team and work towards integration with Spotfire and Power BI.Included topics in R basics, Posit Studio, Forecasting, Visual Studio Code, and R markdown. Created geospatial analysis animation to look at patient location against emergency room locations for hospital system over time. Reworked revenue forecasting model using the fable package. Updated script to utilize the purrr library and decrease code and improve efficiency of scripts. Data was extracted from Netezza data warehouse through automatedPython script which then called rpy2 to automatically run the forecasting methods in R (due to better statistical assurance of models) and sent results back to Python to be inserted back to the data warehouse for consumption by Spotfire.
Senior Data Analyst
UK Health Security Agency
Home based
Sep 2021 - Oct 2022
Senior Data Analyst
UK Health Security Agency
Home based
Led data analytics for a COVID-19 response cell. Reviewed and proposed plan for transitioning from spreadsheet data capture to relational database. Acquired server space for data storage and maintenance. Produced psuedonymized and and identifiable databases for external and internal research to add to global intelligence on SARS-CoV-2 management and national intelligence aiding policy decisions. Produced Power BI reports available to internal team members for accessing and manipulating operational and research data sans coding. Developed quality assurance processes to check database updates were accurate and drove use of GitLab and version control to ensure continuity and open sourcing of scripts. Sourced national datasets and linked to study specific data to answer research questions. Quality checked complex deduplication and matching methods within R. Contributed to pandemic response paper which is currently being submitted for publication. Helped with other national outbreaks including data linkage, ad hoc analyses, operational report production and new study ethics applications and approval process. Conducted various viral prevalence analyses to compare over years and produced paper quality charts as well as living Power BI report to estimate and monitor prevalence through national surveillance methods. Deputized by cell lead for various meetings to act as cell representative working with internal and external stakeholders of all grades. Led cell shift from shared drive storage to SharePoint storage and implemented the use of Kanban boards and collaborative working through Teams and the Office 365 Suite.
Information Analyst
NIHR (National Institute for Health Research)
Exeter, England, United Kingdom
Dec 2020 - Sep 2021
Information Analyst
NIHR (National Institute for Health Research)
Exeter, England, United Kingdom
Working within the Business Intelligence Unit (BIU) in the South West Peninsula (SWP) Local Clinical Research Network (LCRN) for the NIHR. My role is to help measure and report on the LCRNs performance against nationally defined high-level objectives, urgent public health priorities, and overall recruitment across the SWP portfolio. I work across all delivery teams to provide up-to-date data on recruitment and performance. I also produce analyses on public data sets to identify areas of disease prevalence for specialties to target recruitment and identify areas of improvement for inclusive recruitment. Completed the production a new and more efficient monthly and quarterly report template that is automated to ease team pressures and increase awareness of data within the LCRN for internal teams and external directors. Also continuing development on Qlikview dashboards to facilitate independent data review and interrogation for recurring requests. Conduct training on Qlikview dashboards to support teams in where to find and how to use information available for recruitment, performance and data quality. Worked on a repurposing an internal solution for the SWP team to automate research site selection steps. Completed the update of internal trackers to automatically refresh with up-to-date information to stop data losing meaning and remove manual time-consuming processes for teams. Created an agile workforce management process designed for a team of 20 flexibly working nurses to identify hours spent by location and study with ad little input as possible and linked to a continuously updating and interactive Google Data Studio report.
GP Engagement Manager/Project Manager
InHealth Intelligence
Exeter, England, United Kingdom
Mar 2020 - Dec 2020
GP Engagement Manager/Project Manager
InHealth Intelligence
Exeter, England, United Kingdom
Management of stakeholder relationships for the South West Child Health Information Service ( SW CHIS) including: General Practitioner staff (clinical and administrative), Local Medical Committee Leads, CCGs, PHE and NHS Commissioners. Led the creation of social media platforms during the COVID-19 pandemic to achieve engagement with stakeholders. Platforms generated a wide audience and enabled new means of contact and opened new connections with the wider healthcare industry (i.e. NHS England through immunisation campaigns and NHS Digital for NEMS implementation). Tracked analytics across Facebook, LinkedIn and Twitter to see which types of posts elicited highest engagement and views to direct what content should be shared and how best to encourage interaction with the SW CHIS. Utilised a CRM to track issues across 300+ practices in the South West and ensure resolution. This helped to achieve the culture shift from manual submission of data (.pdf, handwritten, etc.) to electronic methods (system generated reports, direct extraction). These changes helped decrease administrative load on practices and increase accuracy due to reduction of transcription errors. Held online sessions to increase education and awareness of services and address issues affecting multiple practices. Helped with implementation and updating of extraction methods to include SNOMED CT codes alongside Read2 and Read3. Helped review data issues and internal processes relating to SNOMED extractions. Led an improvement project to review all internal processes relating to the SW CHIS. The goal was to ensure proper documentation and end-to-end procedures were in place to clarify task owners. This included: assembly of steering and working groups with members from all teams engaged with SW CHIS tasks, documentation of standard operating procedures, and a baseline code review for the service. This was led across the SW, North East London and South West London CHISs.
Transport Planner & Modeler
Jacobs
Exeter, United Kingdom
Nov 2016 - Mar 2020
Transport Planner & Modeler
Jacobs
Exeter, United Kingdom
Consultant in Transport Planning & Modelling. Office Lead for BeyondZero and Co-Lead for South West BeyondZero Region. Led local team with coordinating events among all Jacobs Networks and bolstered attendance and office participation in events. Ensured global and local events were covered and assisted in office planning to maintain an inclusive and diverse culture that promoted safety, mental health & well being. Active Positive Mental Health Champion and coordinated Exeter Office efforts with the local PMH team. Drove efforts to gauge staff mental health throughout my year on the team & put forward initiatives to improve office. Coding of large city network for a Large Local Majors (LLM) and Major Road Network (MRN) scheme consisting of updating a previously existing SATURN model to a 2018 base year and conducting the calibration and validation exercise to meet TAG standards. Completed Appraisal Specification Reports (ASRs) for schemes and assisted in writing the Data Collection Report (DCR) and Local Model Validation Report (LMVR). Also aided in planning forecast model development and checks to be employed on the forecast network. Acted as project manager on a variety of projects. Projects were rolled over to new PMs upon move but at time of departure, all projects were on budget and on time for delivery or for extension and handover to new company at the end of contract period. Management consisted of weekly finance monitoring, check of non-billed versus billable events and monthly forecasting tasks to ensure projects stayed on budget and on margin. Management of real time information system for coaches throughout Devon County. Manage data input and contact between data management company and coach operators. Complete detailed analyses for use within scheme approval reports and technical notes for government and public use. Model user benefits, traffic flows, junctions, and more in line with clients' needs. Proficient in Excel, SATURN, ArcGIS, and TUBA.
Chief Editor
6med
Exeter, United Kingdom
Jun 2016 - Nov 2017
Chief Editor
6med
Exeter, United Kingdom
Managing team of 5 other writers. Organization of topics and deadlines as well as final edits and reivew of articles. Publication of Articles online. Authoring articles on healthcare news and medical topics for aspiring physicians and current medical students.
Owner
Erik Renz Photography
Exeter, United Kingdom
May 2015 - Jan 2017
Owner
Erik Renz Photography
Exeter, United Kingdom
Wedding photographer specializing in reportage-style photography. Creative and unique perspective to wedding photography, capturing the traditional memories and searching out the lesser-known moments of a wedding day.
Customer Support Representative
Hearst Health
Exeter, United Kingdom
Nov 2015 - Nov 2016
Customer Support Representative
Hearst Health
Exeter, United Kingdom
Help clients on queries related to the Hearst Health portfolio in the UK, including: Drug Knowledge Database; Optimise RX; and Map of Medicine. Undergoing training to help field technical support queries.
Healthcare Assistant
Nurse Plus UK Ltd
May 2016 - Jul 2016
Healthcare Assistant
Nurse Plus UK Ltd
Assist in nursing and care homes including: personal care, medications. Full training in Manual Handling, CPR, Medications, and Mental Health/Learning Disabilities.
Honorary Research Fellow Associate
University of Exeter Medical School
Exeter, United Kingdom
Jun 2015 - Jul 2016
Honorary Research Fellow Associate
University of Exeter Medical School
Exeter, United Kingdom
Working with Dr. David Llewellyn in Neuroepidemiology. Performed Scoping of dementia research library as a part of large scale meta-review on dementia risk factors. Partook in a Stata course to develop new statistical analysis skills alongside SPSS knowledge.
Clinical Researcher
Hearst Health
Exeter, United Kingdom
Mar 2015 - Oct 2015
Clinical Researcher
Hearst Health
Exeter, United Kingdom
Research drug formularies for International clients including: medications brands/generic names, interactions, allergic reactions, indications & contraindications, and strengths. Prepare data in system and review entered data for specificity before sending database for production. Functional Lead for new International development projects for FDB International including resource planning and estimation, project management and data analysis. Lead on ESN Implementation. I coordinate with a group of 4 other employees to identify solutions provided by the implementation and use of an Enterprise Social Network (ESN; Yammer) as well as integration with Sharepoint. Developed clinical team Sharepoint site to coordinate and aid in the restructuring of the clinical team.
Financial Analyst
Northside Hospital
Greater Atlanta Area
Jun 2014 - Jan 2015
Financial Analyst
Northside Hospital
Greater Atlanta Area
Conduct biweekly update meetings for providers attesting to the Meaningful Use Affordable Care Act (ACA) incentive. Contribute solutions to clinical and technical causes of non-adherence to the incentive. Developed tracking spreadsheets to account for a variety of measures and stages of the program. Performed analytics on different measures inside Meaningful Use to pinpoint problem areas for practices and where to target improvements. Provided guidance and implementation on function of over 15 different Electronic Health Record (EHR) applications. Research ACA for current and upcoming changes to financial impacts on the hospital; run analytics on these programs and how they impact hospital revenue and provider payment.
Research Asistant
Atlanta VA Medical Center
Sep 2011 - Jan 2015
Research Asistant
Atlanta VA Medical Center
Volunteer for Dr. Madeleine Hackney on the effects of Tango dance on individuals with Parkinson’s disease. Assisted participants to learn steps and complete pre-, post-, and follow-up testing. Taught a six week tango course to a group of 20+ participants. Co-authoring a paper on differences between mono monofocal and multifocal intraocular lenses. Ran statistical analyses and interpreted results. CITI training completed. Presented research at the 7th Annual Emory DOM Research Day and placed 3rd out of 121 poster presentations.
Medical Assistant
Internal Medicine Practice of Northside
Alpharetta, GA
May 2012 - Apr 2014
Medical Assistant
Internal Medicine Practice of Northside
Alpharetta, GA
2 years of hands-on medical experience: patient history collection, history of present illness summaries, collection of vital signs, CLIA-waived testing, intramuscular and intradermal injections. Informed patients of lab results and facilitated resolve of prescription related issues. Actively manage provider schedules and acting office manager during times of manager absence. Placed over hiring, training, and management of three new medical assistants. Initiated office change from ICD-9 to ICD-10 coding systems. Placed over the Medicare EHR incentive including: setup of electronic health record and practice management systems to record and track measures, attestation and preparations for the 2014 incentive. These incentives have a potential gain of +$30,000 in total. Assisted in merge from a privately owned PCP to a practice under Northside Hospital, including: inventory, quality assurance, coordinating meetings, and meetings safety and Joint Commission standards.
Instructor
Adapted Tango for Parkinson's
Atlanta, GA
May 2012 - Aug 2012
Instructor
Adapted Tango for Parkinson's
Atlanta, GA
Taught bi-weekly Adapted Tango classes for a study on the effects of Tango dance on individuals with Parkinson’s disease. Choreographed and directed class. Managed and paired partners to individuals with PD.
Specialist
Apple Retail
Sep 2010 - Apr 2012
Specialist
Apple Retail
Sold Apple products, ranging from iPod Touch to iMac desktops. Learned important computing skills and how to incorporate a wide variety of Apple products in a business environment. Knowledge of operational systems and logistics in regards to stock. Worked daily on SAP: stock overviews, cycle counts, and good receipt & delivery. Placed over RAM upgrade returns and correcting variances linked to this process.
Work Study Associate
Dance 101
Apr 2010 - Sep 2010
Work Study Associate
Dance 101
Participated in a Work Study program with Dance 101 Studio in Atlanta, GA
Lab Technician
North Metro Pool and Spa
May 2009 - Sep 2010
Lab Technician
North Metro Pool and Spa
Tested water samples for pools and spas. Gained proficiency in titration labs and working quickly and accurately in a laboratory environment. Acquired valuable knowledge of chemical products and usage in a practical manner.
G.I.T. FIT Instructor
Georgia Institute of Technology, Campus Recreation Center
Jan 2008 - May 2010
G.I.T. FIT Instructor
Georgia Institute of Technology, Campus Recreation Center
I taught two dance classes centered around cardiovascular exercise at the Recreation Center on campus.
Waiter/Host
Olde Towne Café on Main
May 2008 - Dec 2008
Waiter/Host
Olde Towne Café on Main
Sat customers at tables as well as handled reservations. Took orders and also helped with food preparation in the kitchen.
Bagger/Cashier
Publix Super Markets
Aug 2005 - May 2007
Bagger/Cashier
Publix Super Markets
Started as a bagger and helped with customer service tasks. Became a cashier after 6 months. Began basic Customer Service tasks.
Education: 4
University of South Florida
MS of Health Sciences
2013 - 2014
University of South Florida
MS of Health Sciences
Studied an M.S. in Health Sciences. Included: Histology, Biochemistry, Immunology, Medicinal Ethics, Anatomy, Genetics, Microbiology, Pathology, Physiology, and Pharmacology.
Georgia Institute of Technology
Bachelors of Science
2007 - 2012
Georgia Institute of Technology
Bachelors of Science
B.S. in Chemical Engineering with a focus in Biotechnology. Relevant coursework included: Cellular Biology, Biochemistry I, Biochemistry II, Biopsychology, and Bioprocess Engineering, Unit Operations, and Design. The design project focused on the production of 1,3-propanediol, including: selection of most cost-effective and efficient process; plant logistics; material and energy balances; plant design and modeling; unit specifications; optimization; and scheduling for plant production. Reports available upon request.
Activities / Societies: Georgia Tech: For the Kids (VP of External Activities), DanceTech (Vice President), Parish School of Religion Teacher
Blessed Trinity Catholic High School
High School
2003 - 2007
Blessed Trinity Catholic High School
High School
Voted "Most Creative" for Senior Superlative, AP Student (starting Sophomore year)
Activities / Societies: National Honors Society, Kiwanis Club, Dance Team (Captain for 1 year), Track and Field (Captain for 1 year), Parish School of Religious Education Teacher
St. Ursula's School
Primary School
1999 - 2002
St. Ursula's School
Primary School
Courses: 37
Chemical Process Control
ChBE 4300
Separation Processes
ChBE 3225
AP World History
AP Chemistry
General Chemistry and Lab
CHEM 1311
Chemical Engineering Thermodynamics I
ChBE 2110
Chemical Engineering Numerical Methods
ChBE 2120
Organic Chemistry I
CHEM 2311
Cell Biology
BIOL 3340
Organic Chemistry II
CHEM 2312
General Psychology
PSYC 1101
Intro to Cognitive Psychology
PSYC 3012
Biopsychology
PSYC 3020
Transport Processes I
ChBE 3200
Chemical Engineering Thermodynamics II
ChBE 3110
Kinetics & Reactor Design
ChBE 4300
Transport Processes II
ChBE 3210
Bioprocesses Unit Operations
ChBE 4210
Biochemistry I
CHEM 4511
Biochemistry II
CHEM 4512
Bioprocess Design & Economics
ChBE 4525
Chemical Process Safety
ChBE 4515
Bioprocess Engineering
ChBE 4310
Basic Medical Biochemistry
GMS 6201
Basic Medical Anatomy
GMS 6605
Basic Medical Histology
GMS 6630
Basic Medical Genetics
GMS 6012
Basic Immunology/Microbiology
GMS 6141
Basic Medical Neuroscience
GMS 6706
Health Sciences Ethics
GMS 6871
Clinical Correlations in Molecular Medicine
MCB 6433
Basic Medical Pathology
GMS 6111
Basic Medical Physiology
GMS 6440
Basic Medical Pharmacology
GMS 6505
Biological Principles
BIOL 1510
Drug Design, Development, & Delivery
ChBE 4765
Inorganic Chemistry and Lab
CHEM 1312
Projects: 3
Preact Health
Jan 2026 - Present
Preact Health
Describing your overall health is tough. Made an algorithmic that compiles all the complexity and gives a number from 0-100 to describe your current health snapshot.
Renz Nest
Feb 2025 - Present
Renz Nest
Personal blog leveraging public datasets to provide clear analysis on topics mixed with some op-ed writing. Purpose is to show the complexity of interpreting data and drawing accurate conclusions.
Spring Dance Show 2012
facebook.com/media/set/?set=a.328273950556791.92059.144314752286046&type=1
Feb 2012
Spring Dance Show 2012
facebook.com/media/set/?set=a.328273950556791.92059.144314752286046&type=1
Photography done for the marketing of the Blessed Trinity 2012 Spring Dance Show.
Credentials: 45
Eleiko Weightlifting Level 1
Eleiko
Health Service Modelling Associates 5
Health Services Modelling Association (HSMA)
Intermediate Python for Data Engineering Course
Dataquest.io
Dataquest.io
Programming Concepts in Python Course
Dataquest.io
Introduction to Algorithms Course
Dataquest.io
Command Line for Data Science Course
Dataquest.io
Text Processing for Data Science Course
Dataquest.io
Introduction to Git and Version Control Course
Dataquest.io
Intermediate SQL for Data Engineering Course
Dataquest.io
PostgresSQL for Data Engineering Course
Dataquest.io
Optimizing PostgreSQL Databases Course
Dataquest.io
Dataquest.io
American Red Cross
NumPy for Data Engineering Course
Dataquest.io
Processing Large Datasets In Pandas Course
Dataquest.io
Introduction to Data Structures Course
Dataquest.io
Probability: Fundamentals in R Course
Dataquest.io
Conditional Probability in R Course
Dataquest.io
Hypothesis Testing in R Course
Dataquest.io
Dataquest.io
Shiny Applications in R Path Part
Dataquest.io
Dataquest.io
Statistics Fundamentals in R Course
Dataquest.io
Dataquest.io
Dataquest.io
Data Cleaning in R: Advanced Course
Dataquest.io
Linear Regression Modeling in R Course
Dataquest.io
Dataquest.io
Dataquest.io
Machine Learning Fundamentals in R Course
Dataquest.io
Dataquest.io
Introduction to Data Analysis in R Course
Dataquest.io
Data Visualization with R Path
Dataquest.io
Data Visualization in R Course
Dataquest.io
Spanish
Duolingo
American Heart Association | American Stroke Association
Publications: 3
Protection from infection and reinfection due to the Omicron BA.1 variant in care homes
Frontiers in Immunology
The Lancet Child & Adolescent Health
Biomechanics of Navigating Stairs in Older Adults with Mono versus Multifocal Intraocular Lenses
Journal of Rehabilitation Research and Development
Volunteering: 3
Street Pastor
Exeter Street Pastors
Feb 2017 - Present
Street Pastor
Exeter Street Pastors
Currently in training to become an Exeter Street Pastor. Help to maintain a peaceful and safe environment for Exeter night economy by building relationships with purveyors and providers of services of nightlife and engaging with and helping the customers of those facilities (providing water/sandals, calling for help when required, ensuring safe travel home, etc.)
Chaplaincy Ward Volunteer
Royal Devon and Exeter NHS Trust
Oct 2015 - Jan 2017
Chaplaincy Ward Volunteer
Royal Devon and Exeter NHS Trust
Began training to do visitation rounds on various wards throughout the hospital as a member of the Chaplaincy Team. Main duty involves being an avid and engaged listener to help with the psychological/spiritual well-being of patients during their stays in hospital.
Student Volunteer
Grady Health System
Aug 2011 - Dec 2011
Student Volunteer
Grady Health System
Rewarding and eye-opening to see what hospital life is like and how big of an impact little things can make on people.
Awards: 2
3rd Place Clinical Poster Presentation
Presented findings on a study describing the effects of monofocal and multifocal intraocular lenses on minimum stair clearance in the elderly at the 7th Annual Emory University Department of Medicine Research Day. Out of 121 poster presentations, including those presented by graduate students, post-doctoral students and junior researchers, my presentation received 3rd place. Presentations were grades on scientific content, abstract submission, oral presentation and communication, and poster aesthetics.
National Honors Society Member