Skip to content

William Josid Ridolfo

Analytics Engineer Open to relocating to London

josid@ridol.fo linkedin.com/in/josidridolfo github.com/josidridolfo

Profile

Analytics engineer with an MS in Computer Science and a decade of turning messy, high-stakes data into decision-ready reporting and automated pipelines. Builds clean, reliable data layers (SQL, dbt) and the pipelines that feed them (Python, Dagster), and turns them into self-serve dashboards business teams actually use. Communicates technical nuance and its business implications to department heads and executives, and drives decisions off the analysis. Comfortable owning ambiguous problems end to end, from scoping with stakeholders to shipping pragmatic, tested solutions.

Experience

Data Analyst / Analytics Engineer — JEGS High Performance

February 2026 – present Ohio, USA (Remote)

  • Built the company's first contribution-margin model end to end, retiring ≈30 manual spreadsheets and showing what each product actually earns once freight, fees, and vendor allowances are counted.
  • Built product-level returns and margin analytics that merchandising and vendor teams use without asking the data team. The returns dashboard turns raw return codes into readable reasons and groups vendors into comparable cohorts; it surfaced a product-quality decline I was consulted on, and its evidence backed multiple successful manufacturer renegotiations.
  • Rebuilt the company's internal product taxonomy and mapped it onto eBay's category system; channel sales rose 75% year over year after launch.
  • Created exception reports that reconcile records across the company's separate operational systems, flagging mismatches before bad data can cost sales.

Systems Engineer — State of Vermont

June 2025 – January 2026 Vermont, USA

  • Operated and maintained production data systems on an Adabas mainframe underpinning Medicare and Medicaid services, including monitoring, incident response, and issue resolution.
  • Held to strict information-security and access-control standards in a regulated environment handling sensitive personal data; worked across teams on data integrity and the continuity of essential public services.

Software Engineer (Freelance Consultant) — Syria Recovery Trust Fund

January 2024 – June 2025 Remote

  • Architected, built, tested, and deployed a bespoke vendors database application (Python / Django) for the SRTF Procurement Section; UAT-accepted and deployed to the client's private server in Amman.
  • Reduced the supplier-selection process from one week to one day by reworking the cross-team workflow; procurement cycles and execution delays shortened with it.
  • Created a company-wide single-source-of-truth dataset that replaced the separate spreadsheets each team kept on its own.
  • Hardened data integrity and auditability with input validation, output sanitisation, and role-based access control (RBAC), and covered the application with PyTest unit and integration tests.

Graduate Teaching Assistant — Northeastern University

January 2023 – December 2023 Boston, MA, USA

  • Led recitations and lab sections for 300+ first-year graduate students in Python and computer-science fundamentals, running sessions of up to 60, holding office hours, and providing 1:1 debugging and tutoring.
  • Recognised by faculty and peers as a lead TA for pioneering post-COVID in-person office hours and well-received recitations.
  • Built an inclusive learning environment: adapted explanations to students of varying backgrounds, and used feedback and feed-forward to build their skills and confidence.

Monitoring & Evaluation — progressive roles — Syria Recovery Trust Fund

June 2014 – December 2022 Jordan / Turkey / Remote

Eight years of progressively senior data, reporting, and analytics roles for a multi-donor conflict-recovery fund.

MEAL Advisor (Independent Consultant) January 2022 – December 2022

  • Held client-side oversight and contract management for a multi-subdistrict needs assessment and political economy analysis, driving the report from 200+ pages to 75 through data-visualisation and resolving inconsistencies between the report and its annexes before acceptance.

M&E Section Head (Manager) January 2019 – December 2021

  • Directed analytics for a portfolio of 35+ projects worth €140m; built the reporting pipelines and data-visualisation tools the fund's decisions ran on.
  • Consolidated the KPI framework from 100 indicators to 45 with no loss of insight, and saved ≈400 person-hours annually by automating recurring tasks and standardising protocols.
  • Overhauled the GIS workflow to cut redundancy while increasing the quality and volume of deliverables; led an in-house team and managed the third-party-monitor (TPM) contract.
  • Renegotiated the TPM contract, reducing costs by over 10%.

Operations / Programme / Editor June 2014 – December 2018

  • Founded the GIS mapping unit and produced thematic maps for donors and monitors; prepared quarterly and annual donor reports (USAID, KfW standards); built project logframes and M&E reporting.

Education

Master of Science in Computer Science — Northeastern University

January 2022 – December 2023

Master of Arts in Philosophy — Northern Illinois University

August 2011 – May 2013

Bachelor of Arts in Philosophy & Political Science — The University of Vermont

August 2004 – May 2009

Skills

Data Modelling and SQL
Advanced SQL (Postgres, PostGIS, MySQL); dbt modelling across layered staging, intermediate, and marts; dimensional modelling; modular CTE-based transformation; semantic/reporting layers; data quality, testing, and documentation.
Pipelines and Integration
Python (ETL, REST/GraphQL API integration), incremental loads with dlt; pipeline orchestration with Dagster; CI/CD with GitHub Actions; Celery.
BI, Dashboards, and Geospatial
Sigma Computing, dashboard design, self-serve metrics, data-visualisation; Jupyter; QGIS, GeoDjango, Leaflet.js, MapLibre GL for geospatial analytics.
Warehouse and Cloud
Snowflake (data modelling and transformations); Docker; DigitalOcean.
Engineering and Tooling
Python, Java, Bash, JavaScript, R; Django, PyTest, JUnit; Git / GitHub; code review; Pandas, NumPy; Python package management (uv, pip).
Teaching, Coaching, and Communication
Classroom, recitation, and 1:1 teaching; office hours and drop-in support; written, verbal, and on-camera communication; explaining complex concepts to technical and non-technical audiences; feedback, assessment, and feed-forward.
Mentoring and People Development
Developing individual and team capabilities; onboarding and upskilling colleagues; building inclusive, motivating learning environments; results-focused, proactive support.
Stakeholder and Relationship Management
Working with learners, managers, donors, and executives; progress reviews; translating needs across teams to keep work on track.