Data Engineer

Jon Dickerson

Montrose, CO ***** • 970-***-**** • ****************@*****.*** • www.linkedin.com/in/jonericdickerson

Professional Summary

Experienced Data Engineer skilled in designing and optimizing data pipelines and ETL workflows for healthcare datasets. Expertise in SQL development, data warehousing, and business intelligence, with a track record of delivering impactful solutions. Committed to data accuracy, performance tuning, and automation in enterprise environments.

Technical Skills

Databases: MS SQL Server, MySQL, PostgreSQL, Apache Hive, Impala, MongoDB, Cassandra

ETL Tools: Talend, SSIS, AWS Glue, Apache Spark, Data Pipeline Optimization, ETL Automation

Big Data: Hadoop, HDFS, Cloudera, AWS S3, Athena, Impala Data Lake, Big Data analytics,

Programming: Python, PySpark, VBA, JavaScript, REST APIs

BI & Analytics: Tableau, Power BI, Knowi, SSRS, Predictive analytics

Tools & Platforms: Excel (Advanced), Notepad++, JIRA, Qradar, TheHive, Citrix, OpenVPN, Linux, OLAP, ODBC

Professional Experience

MDclone.com – Remote

Data Engineer • Feb 2022 – Present

Developed 46+ event-driven data models per client for MDClone’s self-service analytics platform, including demographic, clinical, and procedural events.

Designed efficient ETL pipelines to integrate vast datasets into Impala data lakes.

Automated data validation using Python, reducing manual QA by 40%.

Profiled hospital system data to ensure completeness and consistency across various platforms including EPIC and MedeEcho.

Collaborated with cross-functional teams to enhance metadata documentation and improve onboarding efficiency.

CarbonHelix – Denver, CO (Remote)

Business Intelligence Developer • Oct 2020 – Feb 2022

Created dynamic dashboards using Tableau, Power BI, and Knowi; integrated data from MongoDB, MySQL, and IBM QRadar using REST APIs.

Automated reporting workflows and reduced report generation time by 60%.

Implemented predictive analytics models to support cybersecurity KPIs and management insights.

Developed Python scripts to integrate incident data into TheHive4py for real-time analyst collaboration.

Wrote python script that Reduced total (inclusive of all customers) time for REST API data refresh from over ten minutes down to under thirty seconds which greatly enhanced security analysts’ response time.

Caresight.com – Westport, CT (Remote)

Developer • May 2019 – Mar 2020

Built and maintained SQL procedures in a multi-database environment for healthcare analytics solutions.

Led initiatives to transition legacy databases to scalable, AWS architecture.

Montrose County School District – Montrose, CO

Business Intelligence Developer/Database administrator • Aug 2012 – Jun 2018

Designed and implemented district-wide data warehouse supporting 6+ years of student records and HR data.

Created nightly aggregation logic for multidimensional data cubes to deliver instant performance metrics.

Enabled actionable insights via self-serve dashboards and custom reporting tools.

Education

University of Northern Colorado – Greeley, CO

Master of Science, Mathematics • 2000

Graduated Magna Cum Laude

Colorado Mesa University – Grand Junction, CO

Bachelor of Science, Mathematics and Computer Science • 1990

Contact this candidate