Milo Lee Email & Phone Number

Amsterdam Area

Principal Data AnalystTools & Technologies:SQL, Google Scripts, YAML, LookML, Python, Snowflake, Visual Studio Code, Gitlab, Looker, Google Studios, Coefficient, Zapier, Sheetgo, Jira, Confluence, Azure DevOps, Fivetran, Ops Genie, DBT, Docker, Data Vault, Dagster, Amazon S3, Reverse ETLs, Linting Tools, Jinja, JavaScript.Responsibilities:* Designed data warehouse architecture from Raw Vault to Information Marts using Data Vault methodology.* Developed and managed data pipelines with Dagster for efficient data processing.Implemented non-real-time reverse ETL for periodic data sync between warehouse and operational systems.* Managed S&P data warehouse, including infrastructure, data marts, and financial reporting models.* Utilized Amazon S3 for scalable and secure data storage.* Built advanced dashboards and automated tasks to enhance efficiency.* Established coding standards and quality assurance with linting tools and custom tests.* Created features in DBT and Looker to improve data accessibility and reporting.* Supported end users and engineering teams, led forecast/budget exercises, and integrated external data.Achievements:* Led design and implementation of data warehouse architecture and data migration to micro services.* Set up data infrastructure for S&P and managed integrations for M&A projects.* Developed complex models for financial reporting, including revenue recognition and budget forecasting.* Enhanced Looker and business intelligence tools with custom features.

Amsterdam, North Holland, Netherlands

Tools & Technologies SQL, Google Scripts, YAML, LookML, Python, Snowflake, Visual Studio Code, Gitlab, Google Developer, Looker, Google Studios, Coefficient, Zapier, Sheetgo, Jira, Confluence, azureDevOps, Fivetran, Ops Genie, DBT, Docker.Responsibilities Building & maintaining S&P data warehouse, infrastructure, marts & data modelsDevelop data models for Executive, GM, board level, WBR’s & MBR’s.Best in class dashboard developer including building new custom data fields, developing advanced models in DBT/DWH/Visual studio/Looker and creation of complex metrics.Standing up automations for company wide tasks.Creating new features in DBT & Looker.Supporting end user teams & Engineering team as data analyst with both engineering & business knowledge.Technical lead forecast and budget exercises. Technical lead external data integrations. Managing agile based workflows for model + feature development. Examples *Co-lead large scale data migration project from ETL models structure to self service data marts.*Set up data infrastructure for S&P department & larger org creating data marts, setting up dbt and gitlab project.* Technical leads for two large M&A’s. Leading the data/tech integration project, creating data ingestion process, data mapping, data framework as well as incorporating into large company wide reporting channels.* Setting up and managing automation tools and data ingestion for a wider team.* Developing complex models such as Carbon Emission (green analytics), churn reporting, intercompany reporting, revenue recognition, runrate calculations, cohort analysis, budget & forecast models among many more.* Developing new custom features in looker.

Amsterdam, North Holland, Netherlands

Direct Areas of responsibility * Running the monthly global forecast and market reviews * Executive/GM level governance and reporting * Running WBR reporting and governance* Development of dashboards including building new data sets developing advanced models in DBT/DWH/Visual studio and creation of complex metrics* Overseeing large scale ingestion processesSecondary responsibilities * Setting up automation tools and task sheets for account management and BPO teams* Analysis and quarterly reports for board level * 2022 Account management, Carrier Management and Commercial overview of predicted performance * Setting up tech integration with M&As* Managing automation tools and data ingestion for wider team* Helping automate data ingestion from tms platforms and combine with operational data in internal systems Languages SQLGoogle ScriptsYAMLLookMLToolsSnowflakeVisual studioGitlab Gsheet ExcelLookerGoogle studiosCoefficient Zapier SheetgoFivetranTeams typically worked withExecutive and General ManagersData PlatformBusiness Intelligence Strategy and GrowthFinance OperationsM&AAccount Management SalesAutomation

Amsterdam, North Holland, Netherlands

- Data Analysis- Developing Projections, Forecasts and financial models- Company business performance reporting- Dashboard and business tools creation- Creating playbooks and building out best reporting practices frameworks and guidelines

The Randstad, Netherlands

Main duties consisting of:- Project management- Process management- SQL/Python coding- Dashboard creation- Analysis & AutomationsExample of current projects- Setting up and managing Europe wide claims process- Automation campaign- Onboarding Sales Project management- Programme management and learning development campaigns

London Area, United Kingdom

Data Analysis:Analysing operational data to solve inefficiencies, optimise processes, and drive decision-making. Developing and implementing processes and procedures that result in operational excellence. Account Management:Collaborating internally with cross-functional teams, to ensure business strategies are met. Working with C level executives, Marketing, Legal, Finance, Engineers, Website Designers, Content Teams and Communications. Leadership:Leading a team of 17+ in the Central London Hub. Training and overseeing colleagues. Achievements:Project managing the development and launch of a major Partner training program for the private hire industry based Topographical exam. Consisting of website design and implementation - Corporate Video and Audio production and editing, developing and launching two separate LMS platforms. (Used by 17000 +) Co-founder and launcher of in hub partner training program (responsible for delivering sessions for 8000+).

London, United Kingdom

Writing and editing copy, online content, reviews and product launches. Writing and proof-reading articles, adding short videos and sourcing photography. Keeping tracks on related subjects in local and national media. Publicising new content through other social media platforms e.g, twitter, facebook etc.

Updating and maintaining VCH's Twitter and Facebook account. Interviewing organisations and volunteers to create a portfolio of case studies, for use on the website and in other publicity, including local press. Gathering statistics and data to show achieved outcomes, for use in fundraising. Effectively managing Communications and promotions campaigns. Analysing the competition to understand their strengths and weaknesses in order to better. understand what areas we can improve as an organisation.