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