Summary
Overview
Work History
Education
Skills
Work Availability
Work Preference
Software
Timeline
SeniorSoftwareEngineer
Jon Dickerson

Jon Dickerson

Montrose,CO

Summary

Results-driven data engineering professional with solid foundation in designing and maintaining scalable data systems. Expertise in developing efficient ETL processes and ensuring data accuracy, contributing to impactful business insights. Known for strong collaborative skills and ability to adapt to dynamic project requirements, delivering reliable and timely solutions.

Overview

25
25
years of professional experience

Work History

Data Engineer

MDclone.com
02.2022 - Current
  • Collaborated with 3 Large Health Care Providers (Hospitals) on development of data model's suitable for MDClone's proprietary self serve analytics software. Developed 46 events per customer (e.g., Demographics, Inpatient admissions, Emergency visits, Surgical details, Radiology, Labs, Measurements, etc) including upwards of 300,000,000 records depending on the event.
  • Analyzed data sources for suitability, completeness, duplication, conflicting data, missing data, and data integrity. Investigated various tables for appropriate fields to fulfill intended property requirements for events in MDClone self serve analytics software environment.
  • Developed views from the source data that fulfilled the intended purpose of the Events in MDclone and acted as the source for the ETL process into Impala datalakes.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
  • Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
  • Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
  • Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
  • Migrated legacy systems to modern big-data technologies, improving performance and scalability while minimizing business disruption.
  • Designed scalable and maintainable data models to support business intelligence initiatives and reporting needs.
  • Led end-to-end implementation of multiple high-impact projects from requirements gathering through deployment and post-launch support stages.
  • Collaborated with cross-functional teams for seamless integration of data sources into the company''s data ecosystem.
  • Conducted extensive troubleshooting to identify root causes of issues and implement effective resolutions in a timely manner.
  • Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.
  • Documented and communicated database schemas using accepted notations.
  • Planned and installed upgrades of database management system software to enhance database performance.
  • Utilized and aided in component design of Talend ETL Templates.

Business Intelligence Developer

CarbonHelix
10.2020 - 02.2022
  • Created and oversaw dashboards with Tableau, Knowi, Rest API, Mongo, MYSQL
  • Responded to specific BI requests from Executive personnel, creating data packets with requested information in easily understandable formats.
  • Designed customized data collection models for specific visualization tasks.
  • Automated BI reports for secure virtual server environment.
  • Directed implementation of new business intelligence tools, selecting appropriate solutions and created corresponding onboarding processes.
  • Adapted Python scripts to export Incident data into TheHive4py, creating common workspace for analysts and providing metrics of time on task for management.
  • Developed software applications for statistical modeling and graphic analysis to understand data and drive accurate insight.
  • Drafted technical documentation for internal business areas and processes, incorporating factors such as technical design, data manipulation, ETL and storage management.
  • Tracked and leveraged data trends, aggregate statistics and volume fluctuations to hone Cyber Security Posture performance metrics.
  • Improved data gathering, analysis, and visualization procedures with strategic optimizations.
  • Improved overall efficiency by automating manual reporting tasks through the development of dynamic BI tools.
  • Collaborated with cross-functional teams to gather requirements and create tailored BI reports for stakeholders.
  • Supported senior management with timely ad-hoc analyses, enabling agile responses to market changes.
  • Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
  • Proactively identified potential roadblocks during project implementation phases, working closely with team members to develop effective solutions.
  • Identified patterns and trends in complex datasets, enabling informed strategic decision-making for management.
  • Increased accuracy of forecasted trends by incorporating predictive analytics into business intelligence solutions.

Developer

Caresight.com
05.2019 - 03.2020
  • Researched new technologies, software packages and hardware products for use in website projects
  • Collaborated with other developers to identify and alleviate software errors and inefficiencies
  • Coordinated with project management staff on database development timelines and project scope
  • Tested programs and databases to identify issues and make necessary modifications
  • Analyzed complex project server issues and worked on large enterprise and business-critical applications
  • Made recommendations regarding information technology infrastructure overhauls
  • Supported multiple concurrent projects enabling delivery efficiencies and technical resolution
  • Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment
  • Designed and implemented TSQL queries for reporting and complex solution development
  • Applied knowledge from MS in Mathematics and 10 years of experience to develop custom database objects, stored procedures and application support
  • Implemented system enhancements to propose, design and develop solutions to fulfill requests and address problem reports
  • Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision
  • Developed and produced high-standard database solutions to meet stability, reliability and performance metrics
  • Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks
  • Authored code fixes and enhancements for inclusion in future code releases and patches

Business Intelligence Developer

Montrose County School District
08.2012 - 06.2018
  • Designed customized data collection models for specific visualization tasks
  • Designed and built district wide data warehouse using MS SQL Server Enterprise which included multiple years of students assessment data, down to item level granularity. Millions of records were accurately stored and made accessible for longitudinal studies using multi dimensional arrays that were aggregated each night providing instantaneous quantitative query results to complex, multiple criteria questions
  • Database housed 6 years of data for test scores, grades, attendance , and disciplinary incidents for over 6000 students and 400 employees
  • Created data analysis tools to allow teams and Teachers to query acquired information for unique details
  • Automated BI reports for secure virtual server environment
  • Collected data from wide-ranging sources, including Assessment, Teacher Grade books, Attendance, Discipline, Human Resources, Accounting and Facilities
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data
  • Responded to specific BI requests from Administrative personnel, creating data packets with requested information in easily understandable formats

Calculus Teacher

Montrose County School District
07.2000 - 06.2012
  • Incorporated exciting and engaging activities to reinforce student participation and hands-on learning.
  • Encouraged creative thinking and motivated students by addressing individual strengths and weaknesses based on standardized testing results.
  • Maintained required passing rate of 90% of students scoring 3, 4, or 5 on AP Calculus AB 4 years.

Education

Master of Science - Mathematics

University of Northern Colorado
Greeley, CO
06.2000

Bachelor of Science - Mathematics And Computer Science

Colorado Mesa University
Grand Junction, CO
05.1990

Skills

  • SQL Programmer (MSSSMS,Postgres, MySQl, Apache Impala, Apache Spark, etc)
  • ETL Development (Talend, Apache Hive,AWS Glue, Microsoft SQL Server Integration Services (SSIS))
  • Database technologies (MSSQL, MySQL, Postgres, Apache Impala datalakes)
  • Big data technologies (HDFS, Hadoop, Apache Hive, Apache Impala, Apache Spark, Cloudera, AWS S3, Lambda, Athena, Azure, Mongo, Cassandra)
  • Programming (Python Developer, Pyspark, MS Visual Studio-VBA, Javascript, Rest API)
  • Business intelligence tools (Tableau Developer, Power BI, MS Enterprise Business Intelligence, Knowi BI developer)
  • Accommodating tools ( Microsoft Excel Expert, CSV, IBM Qradar, TheHive Cyber Security Analytics Platform, Notepad , JIRA, Batch files, Windows Scheduler, Citrix GAteway, Linux, Open VPN, OLAP, ODBC )
  • Experienced Remote Data Engineer
  • Data quality management
  • Data modeling
  • Performance tuning
  • Teamwork and collaboration
  • Problem-solving
  • Analytical thinking

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Work Preference

Work Type

Full TimeContract Work

Work Location

Remote

Important To Me

Healthcare benefits401k matchStock Options / Equity / Profit SharingPaid time offWork from home optionWork-life balancePaid sick leaveCompany Culture

Software

SQL Developer

Python Programmer

Talend ETL Developer

Microsoft Excel Expert

MDClone self serve analytics software

Java script

Microsoft VB

Postgres

Apache Impala

Cloudera manager

Mysql

Apache Hive

PySpark

Notepad

Tableau Developer

Miscrosoft Business Intelligence (Power BI)

Linux server

Windows Server

Timeline

Data Engineer

MDclone.com
02.2022 - Current

Business Intelligence Developer

CarbonHelix
10.2020 - 02.2022

Developer

Caresight.com
05.2019 - 03.2020

Business Intelligence Developer

Montrose County School District
08.2012 - 06.2018

Calculus Teacher

Montrose County School District
07.2000 - 06.2012

Master of Science - Mathematics

University of Northern Colorado

Bachelor of Science - Mathematics And Computer Science

Colorado Mesa University

Similar Profiles

CREATE PROFILE
Jon Dickerson