David McFarland-Porter
Denver,CO
Summary
I am a Versatile data professional with a proven track record in data development, backend data engineering, and data quality management in the health care and not for profit industries. Proficient in leveraging ETL tools such as DBT, Snowpipe, and Azure Data Factory to build and maintain robust data pipelines. Skilled in using SQL for data manipulation and analysis, with experience creating ad-hoc reports and automating data quality tests. Adept at collaborating with end-users to address data quality issues and deliver impactful data-driven solutions
Overview
6
6
years of professional experience
Work History
Data Quality Engineer
Bonterra Tech
Remote
08.2022 - 01.2024
- Spearheaded the implementation of a new Snowflake data warehouse, ensuring high-quality data extraction from databases across 10 business units by utilizing ETL tools
- Analyzed campaign donation data to rectify data quality issues affecting EA/NGPs donor score model increasing the models accuracy by 15%
- Developed and automated data quality tests and alerts using DBT and Looker
- Ensure all data stream outages were identified and rectified within 24 hours
- Crafted SQL queries to cleanse incoming data for Bonterra's data warehouse
- Generated ad-hoc SQL and DBT reports, contributing to data-driven decision-making
- Reviewed and evaluated new code prior to integration into the GitHub codebase.
Encounter and Claims Analyst
Productive Programming Inc. (PPI)
Verona, WI
11.2020 - 08.2022
- Fostered collaborative relationships with end-users to customize medical encounter submission processes according to healthcare plan requirements
- Produced data-driven insights through the creation of Ad-Hoc SQL reports
- Identified and resolved data discrepancies leading to medical encounter rejections, reducing rejections by 25% and significantly reducing end user frustration
- Conducted training sessions for end-users on encounter submission module operation and HL7 flat file creation to fulfill Medicare reporting requirements
- Collaborated with software developers to ensure compliance with annual regulatory changes
- Documented internal and external processes related to encounter submissions.
Application Support Analyst II
Productive Programming Inc. (PPI)
Verona, WI
11.2019 - 11.2020
- Addressed end user reported bugs through SQL-based triage development significantly reducing customer frustration
- Write a 10 page training manual with instructions for resolving common software issues
- Assisted junior Application Support Analysts in troubleshooting complex issues
- Communicated technical concepts to non-technical stakeholders
- Work through a 200 ticket backlog in 3 months.
Technical Solutions Engineer
Epic
Verona, WI
07.2018 - 09.2019
- Supported customers in achieving population health objectives by resolving technical inquiries
- Developed automation scripts and search queries to streamline internal processes and identify customers impacted by known issues
- Created presentations to document and present new features of the Healthy Planet platform.
Education
B.A. in Economics and Political Science -
University of Rochester
05.2017
Skills
- Programming Languages: SQL, SAS, M (MUMPS), HTML, Python, STATA
- Technical Writing
- Data Quality Analysis
- ETL Tools: DBT, Snowpipe, Azure Data Factory
- Data Visualization Tools: Looker, Tableau
- Databases: SQL Management Studio, Snowflake
- Quality Control
- Root Cause Analysis
- System Troubleshooting
- Healthcare Policy Knowledge
- Medical Condition Coding Software
- Epic Systems
- Data Validation
- Database Design
- Data Quality Management
- Data Mapping
- Data Warehousing
Timeline
Data Quality Engineer
Bonterra Tech
08.2022 - 01.2024
Encounter and Claims Analyst
Productive Programming Inc. (PPI)
11.2020 - 08.2022
Application Support Analyst II
Productive Programming Inc. (PPI)
11.2019 - 11.2020
Technical Solutions Engineer
Epic
07.2018 - 09.2019
B.A. in Economics and Political Science -
University of Rochester