Jun 2023 – Oct 2023 · 4 mos

• Served as Technical Lead for integrating PARTNER sources (Electronic Health Records directly from agilon-affiliated practices) into Membership and consulted with Claims team
• Cooperated with leadership and stakeholders, from pre-planning onwards, to write and prioritize engineering stories
• Led development team in consuming data from numerous EHRs and dealing with complexities of conflicting information from established PAYOR/Insurance sources, delivering into production env
• Introduced dbt as a transformation tool to improve build testing (for Data Quality team), simplify code from procedure wrappings, and bulk process more efficiently, serving as SME across agilon

Jul 2021 – Oct 2023 · 2 yrs 3 mos

• Acclimated brand new cloud team to Snowflake, from agilon veterans' prior experiences with SQL Server
• Established agile methodology and ceremonies, best contributions to team culture through Retrospectives
• Designed and implemented inline mastering of agilon patients, creating unique IDs per data source and PII to match and assign internal PATIENT_IDs
• Architected schemas separating purposes/levels of landing data, standardizing it, enriching it, presenting to downstream users
• Co-implemented unit testing framework for the procedure-based data pipeline
• Designed evolving database framework for multiple databases and co-implemented our CI/CD pipeline in Jenkins and flywaydb
• Led teams developing code of new PAYOR/Insurer Membership, Funding, and Claims pipelines
• Principal peer reviewer for our department, using opportunities to demonstrate best practices kindly and encourage others to participate in reviews

Nov 2016 – Jun 2021 · 4 yrs 7 mos · Greater Boston Area

• Ensure quality control and deidentification for monthly datasets of healthcare provider and claims data.
• Automate testing for Hadoop and Oracle SQL datasets, primarily using SQL, Python, BASH, and Spark (Scala and Pyspark).
• Create new business processes, including for SOC2 audits (see projects section of LinkedIn).
• Also routinely utilize regular expressions, the JIRA API, Zeppelin, and some Elasticsearch & WebAnno.
• (Formerly IT Data Analytics Analyst and Associate Data Engineer)

Sep 2015 – Feb 2016 · 5 mos · Greater Boston

• Consulted for startup on organizational strategies, product development, alternative revenue models, information processes, and team management.
• Primary deliverables included organizational analysis based on executive employee interviews, site and user flowcharts, and financial projection changes

Nov 2014 – Nov 2016 · 2 yrs · Framingham, MA

• I immerse myself in SQL databases every day and assist hospitals across the country to identify and deliver data for financial and patient metrics as well as transfer data.
• MEDITECH is an established leader in developing, implementing, and supporting healthcare organizations with its comprehensive EHR (electronic health record) solution.

Jan 2014 – May 2014 · 4 mos · Greater Jackson Area

• Drafted Michigan’s first law for making City data publicly available, adopted with minor revisions May 27
• Organized meetings to discuss data sharing policies with the City Council, City Attorney, department heads, business and nonprofit leaders, and individual citizens

Jun 2013 – Aug 2013 · 2 mos

• Researched and wrote 7 case studies on open policy implementations, identifying important actors, rhetoric, policy language, political channels, and funding.
• Representative case studies include:
• NIH Public Access Policy
• Australia's AusGOAL framework
• Open Educational Resource (OER) legislative efforts in Sao Paulo, Brazil
• World Bank "Access to Information" and "Open Access" policies
• http://openpolicynetwork.org/resources/

May 2013 – Aug 2013 · 3 mos · Ann Arbor, MI

• Conducted 22 in-depth interviews with researchers, administrators, librarians, and academic publishers about the research, legal, and business sides of academic publishing
• Analyzed stakeholder positions and extensively outlined findings and institutional “next steps” for open access, represented these to colleagues
• https://umichsi.digication.com/open_michigan1/Internship/published

Aug 2012 – May 2014 · 1 yr 9 mos · Ann Arbor, MI

• Took minutes for faculty senate committees tackling complex issues including diversity, finances, and governance
• Researched best practices related to sexual harassment claims, governance issues, and more
• Collected materials, such as tenure considerations from all UM schools, vital to faculty committee deliberations
• The SACUA Office

Feb 2012 – Jun 2012 · 4 mos · Sarasota, FL

• Developed the beta Terms of Service for Teachbuzz affiliate site, housing open educational resources (OER)
• Posted 250 lesson plans and exercises on Teachbuzz, with an emphasis on relevance to developing countries
• Wrote weekly articles on education and open content news for Open Equal Free news blog:
• http://www.openequalfree.org/author/jonathan-davidson