Jihang Li

Location

New York City, NY
Education
    Washington University in St Louis
    August 2021 - December 2022
    degree
    Master's
    major
    Business Analytics
    Nankai University
Work Experience
    McKinsey
    Data Engineering Analyst
    New York, NY, US
    February 2023 - April 2024
    company
    McKinsey
    title
    Data Engineering Analyst
    overview
    - Utilized Snowflake, Matillion, Airflow, Databricks, PySpark, Azure Blob, DBT and Tableau to define medallion architecture - Analyzed and codified business models into production-ready data pipelines using Python, PySpark, Git and Databricks - Skilled in data QC, versioning, writing efficient I/O functions, ensured standardized commenting and documentation - Internal(agile): excelled in problem-solving, project scoping, and product development. Client-facing: skilled in co-working
    Reinsurance Group of America
    St. Louis, MO, US
    August 2022 - December 2022
    Asian Infrastructure Investment Bank
    Data Engineer Intern CEIU Data Center
    May 2022 - August 2022
    JD.com
    Data Analyst Intern E commerce Department
    Beijing, CN
    July 2020 - September 2020
    Didi Chuxing Technology
    Data Analyst Intern Platform Data Center
    Beijing, CN
    March 2020 - July 2020
Skills
A/B TestingAgile MethodologyAirflowAlgorithmsAlteryxAmazon S3Amazon Simple Queue Service (SQS)Amazon Web ServicesApache HadoopApache HiveArchitectureBass (Instrument)Big DataBusiness AnalysisBusiness LogicBusiness ModelCloud ComputingComputational StatisticsComputer SecurityConfluenceConsumer PrivacyCOVID-19 TestingC++ (Programming Language)Cross SellingCryptographyCustomer AnalyticsCustomer Relationship ManagementDashboardsData AnalysisDatabricksData CentersData ManagementData PipelinesData StoresData WarehousingDialectical Behavior TherapyE-CommerceExtract Transform Load (ETL)Forecasting SkillsGitGoogle AnalyticsInformation EngineeringInfrastructure ManagementIntranetInvestment BankingJava (Programming Language)JIRAKnowledge of EngineeringLinuxManagement of Software VersionsMarketingMetadataMetricsMicrosoft AzureMicrosoft ExcelMicrosoft SQL ServerMySQLNutrition and DieteticsOracle ApplicationsPower BIPresentationsProblem SolvingProduct DesignProject ManagementProject ScopingPulp (Tooth)PysparkPython (Programming Language)ReinsuranceRequirements AnalysisResource AllocationResponse RateRoot Cause AnalysisSales PromotionSimulationsSnowflakeSoftware DebuggingSPSS (Software)SQL DatabasesStrategic ThinkingStrategies of PricingTableau (Software)Team WorkingTerraformVba Programming LanguageVisualizationWeb PagesWeb ScrapingWorkflowsYAML