Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Joshua Lee

Joshua Lee

Data Analyst
Frederick

Summary

As a Data Analyst with over five years of experience, I specialize in creating interactive Power BI dashboards and optimizing ETL pipelines using SQL, Python, R, and Power BI at LCG, Inc. I deliver actionable insights by designing robust data models and automating workflows for accuracy and efficiency. My previous roles at Cardinal Health and DMI honed my skills in SQL, Tableau, Python (Pandas Library), GCP, and communication strategy, enabling data-driven decisions and process improvements. I am passionate about transforming complex data into intuitive visuals and driving success through continuous innovation.


Overview

7
7
years of professional experience
2027
2027
years of post-secondary education
1
1
Certification

Work History

Data Analyst

LCG, Inc.
11.2022 - 06.2025
  • Develop and design interactive and visually appealing Power BI dashboards to present key performance indicators (KPIs) and trends for effective decision-making.
  • Leverage MySQL, Python, AWS Glue, and PySpark to extract, transform, and load (ETL) data from various sources, creating efficient workflows for big data processing and analysis.
  • Perform in-depth data analysis using advanced Excel functionalities, including pivot tables, charts, and formulas, to extract meaningful insights from large datasets.
  • Establish robust data models within Power BI, defining relationships between different datasets to create a comprehensive and cohesive view of organizational data.
  • Design and optimize ETL pipelines to automate data workflows, ensuring seamless integration, accuracy, and timely delivery of critical datasets.
  • Implement best practices in data visualization, ensuring that reports and dashboards are user-friendly, intuitive, and aligned with industry standards.

Data Analyst

Cardinal Health
10.2020 - 11.2022
  • Analyze and interpret logistics data using SQL and Google Cloud Platform, identifying trends and actionable insights to improve client experiences and operational efficiency.
  • Develop and maintain dynamic dashboards and data visualization tools in Tableau, enabling teams to make informed, data-driven decisions.
  • Create and optimize cloud-based data querying and manipulation techniques, ensuring seamless access to reliable and accurate data for strategic planning.
  • Collaborate with cross-functional teams, including Digital Solutions and OptiFreight, to share best practices and foster a culture of continuous improvement.
  • Stay ahead of industry trends by mastering emerging data analytics technologies and integrating them into Cardinal Health's logistics operations.
  • Translate complex data into compelling narratives that resonate with stakeholders, ensuring clarity and alignment with organizational goals.
  • Identify and solve logistics challenges by leveraging advanced analytics to unlock opportunities for cost savings and client satisfaction.

Communications Analyst

DMI (Digital Management, LLC)
07.2018 - 10.2020
  • Coordinated and managed communication workflows for scheduling and tracking medical referrals and appointments, ensuring timely and efficient support for military service members.
  • Designed and implemented strategies to streamline information sharing and clinic requirements, enhancing accessibility and improving communication processes for appointment bookings.
  • Collaborated with cross-functional teams, including medical staff and training facility personnel, to ensure consistent and effective communication of service updates and requirements.
  • Maintained and organized detailed records and reports, ensuring accurate and compliant documentation of all communications and referrals.
  • Utilized strong interpersonal and communication skills to engage with military personnel, medical staff, and other stakeholders, ensuring clarity and transparency in all processes.
  • Proactively identified areas for improvement in communication strategies, driving efficiency and optimizing coordination between all parties.
  • Ensured alignment with organizational policies and standards by developing effective messaging frameworks to support the coordination process.

Education

Associates - Business and Technology

Frederick Community College
Frederick, Maryland

Skills

  • Power BI
  • MySQL
  • Tableau
  • Google Cloud Platform
  • Python
  • Leadership
  • Excel
  • Decision making
  • Detail oriented
  • Presentation Skills
  • Data Analysis

Certification

Google Data Analytics Certificate

Timeline

Google Data Analytics Certificate

12-2024

Data Analyst

LCG, Inc.
11.2022 - 06.2025

Data Analyst

Cardinal Health
10.2020 - 11.2022

Communications Analyst

DMI (Digital Management, LLC)
07.2018 - 10.2020

Associates - Business and Technology

Frederick Community College

Similar Profiles

CREATE PROFILE
Joshua LeeData Analyst
Resume profile built at Zety.com