Reinier Araya

Data Architecture & Analytics

Data Architecture and Analytics professional with 10+ years of experience designing scalable data solutions and driving governance, platform enablement, and business intelligence across MongoDB, Cosmos DB, Microsoft Fabric, and Databricks. Skilled in Power BI, Tableau, Python, SQL, semantic modeling, and process automation, with a strong focus on schema governance, platform observability, and analytics architecture.

Experience

Assistant Director, Reporting & Analytics

Moody's · 2025 – Present
  • Designed and evolved the target architecture for Transaction API/Jira data across MongoDB, Cosmos DB, Fabric, and Databricks, establishing the team's direction for event capture, hydration, and BI consumption.
  • Built a canonical event-envelope model for MongoDB/Cosmos DB ingestion, replacing fragmented endpoint-specific schemas with a single reusable ingestion contract.
  • Designed a Bronze+ schema-governance framework, gating new fields before promotion to Silver/Gold and preventing uncontrolled schema drift into Power BI semantic models.
  • Automated semantic model updates via XMLA/TOM, syncing approved fields into Power BI models while preserving existing DAX measures and Direct Lake behavior, eliminating manual model maintenance.
  • Designed and built the JSM Field Catalog, a Python-based metadata discovery platform integrating Jira APIs to support schema analysis and dashboard development while reducing manual field-mapping effort.
  • Built a Fabric pipeline observability portal using Azure and Fabric REST APIs, identifying a roughly two-hour pipeline bottleneck caused by full-refresh Jira pulls instead of incremental loads.

Data Reporting Analyst II

Experian, Belen · 2021 – 2025
  • Automated customer NPS data extraction, transformation, and visualization using Python, Playwright, Pandas, Power Automate, and Power BI, reducing manual effort, preventing errors, and enabling timely performance benchmarks.
  • Centralized operational and customer-experience data across eight business units, using Python and VBA for data preparation and Tableau to surface KPIs, trends, and actionable business insights.

Business Analyst

CWT, Santa Ana · 2019 – 2021
  • Analyzed traveler behavior and forecasted trends to optimize cost-saving strategies for a major American health services company.
  • Developed and analyzed key performance indicators to identify cost-saving opportunities while managing and auditing global data setup, processes, and distribution.

Data Analyst

DXC Technology, Heredia · 2015 – 2019
  • Managed and analyzed thousands of CIs across five databases, tracking $270M TCV in client assets for Nissan North America.
  • Automated complex data comparison reports, increasing leased Net Book Value by 3% ($3.4M annually) while reducing processing time by 300+ hours per year.
  • Created impactful dashboards and data trend charts using Excel and Power BI to display weekly and monthly metrics used in internal team and customer meetings.

Billing & Inventory Analyst

Cost Management Group, Heredia · 2013 – 2015
  • Developed automated templates to streamline mass invoicing for major clients such as Standard Parking (Verizon Wireless), Dunkin' Donuts (Verizon), and FTI (AT&T), reducing processing errors and manual workload.
  • Reduced invoice processing time by 12% per person by automating an existing phone invoice master load template using Excel VBA coding.

Mission Critical Remote Support Specialist

Hewlett Packard, Heredia · 2007 – 2013
  • Remote Support Specialist and Subject Matter Expert (SME), performing data analysis and creating customized operational reports for HP's Mission Critical customers.
  • Automated report-template formatting across multiple contract levels, standardizing content for the entire team and reducing manual effort.

Personal projects

Personal platform on a self-managed VPS

The site you are reading runs on a Linux VPS I administer: Docker Compose, Caddy with automatic HTTPS, key-only SSH, a firewall, and daily off-site backups to Amazon S3 using a write-only IAM policy, with versioning and lifecycle rules.

  • Docker
  • Caddy
  • Linux hardening
  • AWS S3 / IAM
  • DNS

Flight price tracker

A scheduled Python worker that queries a fares API for round trips from SJO across ten routes, stores the history in SQLite, filters out low-quality itineraries, and sends Telegram alerts when a price drops below its recent average or hits a new low. Currently paused after a successful validation run.

  • Python
  • SQLite
  • REST APIs
  • Telegram Bot
  • Scheduling

Transparency: the architecture, requirements, and design decisions of these projects are mine. Claude (Anthropic's AI assistant) helped me write much of the code.

Education & certifications

Skills

ArchitectureData Architecture · Schema Governance · ETL/ELT · Semantic Modeling
PlatformsMicrosoft Fabric · Databricks · Power BI · Tableau
Data storesMongoDB · Cosmos DB · Delta Lake · Direct Lake
Languages & toolsPython · SQL · DAX · Power Query · VBA · REST APIs
MethodsLean Six Sigma · ITIL