John Dickson

John Dickson Email and Phone Number

Senior Data Engineer @ Prime Therapeutics
Pittsburgh, PA, US
John Dickson's Location
Greater Pittsburgh Region, United States, United States
John Dickson's Contact Details

John Dickson work email

John Dickson personal email

n/a
About John Dickson

Thanks for stopping by my profile! I’m an enthusiastic Lead Data Engineer with apassion for designing and enhancing data architectures. With a rich technical toolbox thatincludes Python, SQL, and cloud platforms like Google Cloud Platform, I thrive in dynamic,data-driven environments. Whether it’s streamlining data pipelines or collaborating oninnovative data strategies, I love working alongside diverse teams to solve complex challenges.Let’s connect and explore how we can drive data-forward solutions together! Feel free to dropme a message anytime.

John Dickson's Current Company Details
Prime Therapeutics

Prime Therapeutics

View
Senior Data Engineer
Pittsburgh, PA, US
John Dickson Work Experience Details
  • Prime Therapeutics
    Senior Data Engineer
    Prime Therapeutics
    Pittsburgh, Pa, Us
  • Highmark Health
    Lead Data Engineer
    Highmark Health Jul 2024 - Present
    Pittsburgh, Pennsylvania, Us
    • Led the design and implementation of scalable data architectures, developing ETL/ELT solutions and comprehensive data infrastructure using PostgreSQL, BigQuery, Oracle,Teradata, and Apache Hadoop, significantly improving data accessibility and supporting data-driven decision-making.• Collaborated with Data Architects, Data Scientists, and Business Analysts to implement scalable ETL/ELT solutions using Agile or Scrum methods with Apigee and Postman,optimizing data performance and aligning with enterprise strategies, achieving a data retrieval time of under 200 ms.• Built and maintained data infrastructure, integrating Google Cloud Storage, which reduced data retrieval times to under 5 seconds, and accelerated analytics projects, ensuringcompliance and enhancing system efficiency by 20% with predictive analysis and real-time data processing using Apache Kafka and Google Pub/Sub.• Developed analytical tools and interfaces using Python and Flask, applying REST APIs and scalable architecture to improve data analysis efficiency by 30%, and directed R&Dinitiatives to incorporate real-time data processing techniques, AWS integration with GCP, and Docker for innovative data modeling and extraction.• Guided a team of Engineers to align with best practices for ETL/ELT development and data infrastructure management, presented data engineering solutions to stakeholdersusing storytelling techniques to ensure understanding and alignment across the organization.
  • Highmark Health
    Senior Data Engineer
    Highmark Health Aug 2022 - Jul 2024
    Pittsburgh, Pennsylvania, Us
    • Orchestrated the migration of legacy ETL pipelines to Google Cloud Platform using BigQuery and Dataflow, optimized data warehousing, and implemented real-time streamingsolutions with Pub/Sub and Apache Beam, improving delivery times by 60% and reducing data transfer costs by 30%.• Engineered scalable REST APIs with Flask incorporating asynchronous programming, and built and supervised dynamic ETL pipelines with Apache Airflow, improving errorhandling and increasing pipeline visibility by 30%.• Improved infrastructure using Terraform, streamlined GCP management, and established a data governance framework with compliance protocols like GDPR and HIPAA,reducing deployment times by 60% and training junior engineers in Python and data engineering
  • Highmark Health
    Senior Data Analyst
    Highmark Health Mar 2021 - Sep 2022
    Pittsburgh, Pennsylvania, Us
    • Optimized data warehouse workflows in Teradata, improving query performance and data accessibility by integrating MultiLoad and FastLoad, and developed ETL pipelinesintegrating Apache Hadoop, Python, and SAS to reduce data retrieval times.• Integrated siloed data from various systems into a centralized solution with Teradata Data Warehouse, facilitating actuarial analysis and end-user reporting, enhancing dataanalysis quality.• Created and led a training program for new analysts and engineers on ETL Best Practices and workflow automation with Bash Scripting, cutting onboarding time by 10 days.
  • Highmark Health
    Data Analyst
    Highmark Health Feb 2020 - Mar 2021
    Pittsburgh, Pennsylvania, Us
  • Highmark Health
    Business Intelligence Engineer
    Highmark Health Oct 2019 - Feb 2020
    Pittsburgh, Pennsylvania, Us
  • Hm Health Solutions
    Technology Administrator
    Hm Health Solutions Jul 2018 - Oct 2019
    Pittsburgh, Pa, Us
    • Managed business intelligence platforms on Windows Server and Linux, automated tasks with Bash scripts reducing administrative overhead by 20%, and developed datamodels to support business decision-making.
  • Hm Health Solutions
    Associate Technology Administrator
    Hm Health Solutions Jan 2017 - Jul 2018
    Pittsburgh, Pa, Us
    Administrator BI corporate reporting tools including IBM Cognos and SAP Business Objects.
  • Yellets Landscaping
    Supervisor
    Yellets Landscaping May 2012 - Jan 2017
    • Supervise team of 5-7 laborers while serving clients• Train new employees to perform essential functions for business• Prepare invoices on Excel for new and existing cliental• Maintain inventory supplies and order when necessary• Ability to troubleshoot issues that arise during work day
  • Allied Barton Security Services
    Security Officer
    Allied Barton Security Services Dec 2015 - Jul 2016
    • Provided the required reports for necessary incidents• Monitored premises through CCTV system• Worked in high pressure situations in a professional manner
  • Ups
    Stock Handler
    Ups Apr 2015 - Aug 2015
    Atlanta, Ga, Us
    • Managed inventory brought in by trucks• Achieved large goals daily within a short time frame• Troubleshoot problems fast to keep work flowing

John Dickson Skills

Data Integration Data Virtualization Windows Server Linux Motivated Computer Hardware Denodo Computer Repair Cognos Computer Maintenance Network Design Data Analysis Data Governance Load Data Architecture Data Security Data Modeling Time Management Critical Thinking Customer Service Business Intelligence Extract Sql Computer Science Database Design Vmware Transform

John Dickson Education Details

  • Colorado Technical University
    Colorado Technical University
    Computer Science
  • Columbia Southern University
    Columbia Southern University
    Information Technology
  • Indiana University Of Pennsylvania
    Indiana University Of Pennsylvania
    Criminology

Frequently Asked Questions about John Dickson

What company does John Dickson work for?

John Dickson works for Prime Therapeutics

What is John Dickson's role at the current company?

John Dickson's current role is Senior Data Engineer.

What is John Dickson's email address?

John Dickson's email address is jo****@****lth.org

What schools did John Dickson attend?

John Dickson attended Colorado Technical University, Columbia Southern University, Indiana University Of Pennsylvania.

What skills is John Dickson known for?

John Dickson has skills like Data Integration, Data Virtualization, Windows Server, Linux, Motivated, Computer Hardware, Denodo, Computer Repair, Cognos, Computer Maintenance, Network Design, Data Analysis.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.