Ayric Dierenfeld

About Ayric Dierenfeld

I am a data and analytics leader who builds teams and modern data platforms that organizations adopt and leaders can trust.My work tends to land where there is ambiguity, legacy processes, and high expectations. The focus stays consistent: gather requirements, simplify the system, tighten governance, and deliver insight that holds up under real business pressure.At Compex Legal Services, I took over company-wide reporting from a single long-tenured owner and rebuilt it into a scalable team-and-platform function. We replatformed 160 recurring reports onto a governed Microsoft Fabric lakehouse and Power BI. Sprint-based delivery in Jira made the work visible and measurable (1,576 items tracked over about 18 months; 74% completed; 41 days median resolution time).My leadership style is direct, calm, and supportive. Clear priorities, high standards, and coaching that helps people grow into bigger scope. Strong partnerships with stakeholders matter as much as the data solutions we create.AI is an essential part of my toolkit. GitHub Copilot and Claude accelerate prototyping, refactoring, iteration, and documentation, with mandatory human review and secure data handling. Currently pursuing the PMI Certified Professional in Managing AI (PMI-CPMAI), with testing planned for Spring 2026.Keywords: Business Intelligence, BI Director, Analytics Director, Data and Analytics, People Leadership, Stakeholder Management, Executive Reporting, KPI Design, Metrics Strategy, Data Governance, Data Quality, Data Modeling, Semantic Models, Lakehouse, Data Warehouse, Microsoft Fabric, OneLake, Power BI, Power BI Embedded, Embedded Analytics, Tabular Model Definition Language (TMDL), JSON, DAX, SQL, Python, Excel, Power Query, ETL, ELT, VS Code, Azure Repos, Source Control, CI/CD, Pipelines, YAML, Jira, Confluence, Agile, Scrum, Sprint Planning, Backlog Refinement, Story Points, Retrospectives, UI/UX for Analytics, Reporting Modernization, Platform Migration, Process Improvement, Lean Six Sigma, Process Improvement, PMP, PMI-CPMAI, GitHub Copilot, ChatGPT, Prompt Engineering, AI Assisted Development, GenAI

Experience

1. Senior Data & Analytics Manager

   Compex Legal Services

   Jun 2024 — Present · Torrance, CA, US

   Compex Legal Services helps law firms and insurance claims teams get medical records and litigation support through record retrieval, record summarization, and court reporting.• Formed a four-person team across Fabric data engineering, analytics, and BI engineering, professionalizing a function that was previously a single-owner operation.• Built Git-based source control and CI/CD pipelines in Microsoft Fabric, formalizing version-controlled BI engineering standards for the team.• Designed a branded Power BI template and style guide for internal and external users, building consistency and trust.• Migrated 160 recurring Excel reports and stored-procedure workflows into a Microsoft Fabric lakehouse and 5 core Power BI reports, replacing fragile manual processes with an auditable reporting foundation.• Designing an embedded BI reporting suite for legal clients, replacing over 30 bespoke per-client reports with a single governed, scalable Fabric & Power BI solution.• Implemented sprint-based delivery in Jira, reducing ad hoc escalations by 80% and establishing a governed request model with senior leadership as the primary intake channel.

Education

• Oregon State University

  Bachelor of Science - BS, Human Development, Minor in Interactive Multimedia

Skills

• Microsoft Excel
• Business Process Automation
• Documentation
• Web Design
• Microsoft Sql Server
• Program Management
• Process Analysis
• Vba
• Collaborative Problem Solving
• Team Leadership
• Leadership
• Html
• Business Process Improvement
• Technical Training
• Management
• Sql Server
• Process Improvement
• Project Management
• Integration
• Business Intelligence
• Document Management
• Excel
• Software Documentation
• Social Media
• Onenote
• Business Analysis
• Mentoring
• Data Analysis
• Pivot Tables
• Six Sigma
• Html + Css
• Sales Support
• Microsoft Office
• Customer Service
• Training & Development
• Sharepoint
• Training
• Media Production
• Analysis
• Forecasting