You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Pavel MakarchukPM

Pavel Makarchuk

Independent Economist & Data Consultant

€480/day
Berlin, DE
3-7 years

Average response time: 1 hour

About Pavel

Economist and data consultant helping organizations turn complex policy and financial data into clear, actionable insights.


Experienced in Python, SQL, and microsimulation modeling. I support NGOs, startups, and research teams with data automation, dashboarding, and impact analysis in English and German.
  • German

    Native or bilingual

  • English

    Native or bilingual

  • Russian

    Native or bilingual

  • Ukrainian

    Native or bilingual

  • French

    Fluent

  • Spanish

    Basic

Can work on-site
Berlin (up to 50km)

Experience

  • PolicyEngine
    Founding Economist
    RESEARCH
    May 2022 - Today (4 years and 1 month)
    New York City, United States
    Founding economist of an open-source think tank building microsimulation models for tax and benefit policy in the U.S. and abroad.


    • Designed and maintained reproducible microsimulation pipelines used by policymakers, researchers, and advocacy organizations to estimate fiscal and distributional impacts of reforms.


    • Audited and validated 500 + model updates, achieving < 1 ppt divergence from Census benchmarks and ensuring statistical reliability across 50 states.


    • Built automation tools and data-integration scripts (Python, SQL) that cut model-update turnaround by 40 %, improving delivery speed for partners and community users.


    • Produced policy explainers and visual dashboards reaching 15 000 + monthly readers, including materials cited in U.S. Congressional testimony.


    • Advised partner organizations and state agencies on integrating PolicyEngine APIs and simulations into their public-facing benefit calculators.


    • Presented results and technical methods at IZA Institute of Labor Economics, George Mason University, and Northwestern University, translating complex models for non-technical audiences.
    Python Economic Modeling Data analysis Data science Project Management
  • Germany Trade & Invest (GTAI)
    Economic Analyst
    BANKING AND INSURANCE
    March 2021 - May 2022 (1 year and 2 months)
    Berlin, Germany
    Federal economic-development agency supporting foreign investment into Germany.


    • Analyzed macroeconomic and sectoral data to identify investment trends and regional growth opportunities for international clients.


    • Developed SQL-based dashboards and cross-relational datasets that automated performance reporting and improved decision-making for senior analysts.


    • Authored market-intelligence briefs and investor memos used by trade commissioners and foreign executives evaluating expansion projects.


    • Delivered presentations and data visualizations in English and German using Tableau, PowerBI, and Excel, translating complex indicators into actionable insights.


    • Collaborated with state agencies and multinational firms to benchmark regional competitiveness and align investment outreach strategies.
    Data analysis Benchmark Business analysis Dashboards Forecasting
  • Allied Universal (MSA Security)
    West Coast Operations Manager
    DEFENSE AND MILITARY
    February 2022 - May 2023 (1 year and 3 months)
    New York City, United States
    Managed enterprise accounts and multi-site operations across the United States.


    • Oversaw €18 M+ client portfolio, including Google, Meta, and NFL, maintaining 98 % renewal rate through data-driven forecasting and proactive account management.


    • Coordinated cross-functional teams to launch new service lines in five markets, optimizing logistics and client reporting processes.


    • Produced quarterly performance dashboards and executive briefings to support contract negotiations and operational planning.
    Business analysis Project Management Operations Management customer service excel

Recommendations

Be the first to recommend Pavel

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Bachelors in Economics and International Business
    Marist University
    2022
    Focused on applied economics, quantitative analysis, and international markets. Developed strong foundations in micro- and macroeconomics, econometrics, and financial modeling, complemented by coursework in international trade, management, and global business strategy. Graduated with academic and athletic honors as a Division I team captain.

Certifications

  • Bloomberg Market Concepts (BMC)
    Bloomberg LP
    2021
  • MITx Micromasters: Data, Economics, and Design of Policy (in progress)
    MIT (edX)
    2023

Skill set

Categories