Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic
Trei Alexander

Trei Alexander

Los Angeles

Summary

Senior Data Engineer with 15+ years of experience architecting and delivering enterprise data warehouse, reporting, and analytics solutions across healthcare, government, enterprise, and national security environments. Skilled in SQL Server, Denodo, Python, Power BI, Tableau, ETL/ELT development, data virtualization, and enterprise data architecture. Experienced in designing scalable data models, semantic layers, reporting frameworks, and governed data assets that support executive reporting, operational analytics, and business intelligence initiatives. Proven track record of partnering with business stakeholders and technical teams to build reliable, high-performance data solutions that improve reporting accuracy, data accessibility, and organizational decision-making.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Senior Data Warehouse Architect (Subcontractor)

Mission Support and Test Services (MSTS) – Nevada National Security Site (NNSS)
Las Vegas, NV
03.2026 - Current
  • Contributed to the architecture and development of enterprise data warehouse solutions supporting finance, project controls, and operational reporting initiatives within a secure national security environment.
  • Helped design and build the organization's Denodo Data Marketplace, creating governed and reusable data assets that improved accessibility and consistency across enterprise reporting platforms.
  • Developed Denodo base views, integrated views, semantic layers, and user-facing datasets supporting business intelligence, self-service reporting, and operational analytics.
  • Designed SQL-based transformations, reporting models, and business logic across multiple enterprise data sources to support executive and operational decision-making.
  • Administered Denodo platform environments including metadata management, access provisioning, troubleshooting, production support, and reporting operations.
  • Built and supported Power BI reporting assets used across finance, project controls, and enterprise reporting functions.
  • Collaborated with business stakeholders, analysts, engineers, and project controls teams to translate reporting requirements into scalable enterprise data solutions.
  • Supported enterprise data governance, documentation standards, metadata management, and reporting best practices across cross-functional teams.

Senior Healthcare Data Analyst

HHUNY
Rochester, NY
06.2024 - 03.2026
  • Designed and maintained 20+ automated ETL pipelines using SQL Server, SSIS, and T-SQL supporting healthcare operations, compliance, and regulatory reporting.
  • Developed SQL stored procedures, transformation logic, and reporting processes integrating data from Netsmart, MAPP, and care management systems.
  • Built 15+ Tableau dashboards supporting enrollment tracking, outcomes reporting, care management operations, and executive decision-making.
  • Automated recurring reporting processes using SQL, Python, Excel, and Tableau Server, reducing manual effort and improving reporting reliability.
  • Investigated and resolved complex data quality issues through source-to-target validation, reconciliation, and root-cause analysis.
  • Supported reporting and analytics activities across healthcare programs serving thousands of member records.
  • Partnered with operational and technical teams to translate healthcare workflows into scalable reporting and analytics solutions.

VP of Data Operations / Senior Data Scientist

Rel8ed.to Analytics
Ontario, Canada
09.2021 - 01.2025
  • Led analytics and data science initiatives utilizing Python, SQL, Tableau, and Power BI across workforce development and client-facing projects.
  • Developed 25+ dashboards and reporting solutions supporting KPI tracking, operational performance, and business outcomes.
  • Designed data transformation processes and analytical workflows supporting enterprise reporting and decision-making initiatives.
  • Managed analytics delivery, reporting standards, and data operations across distributed teams.
  • Mentored analysts and technical staff on analytics, visualization, ETL concepts, and reporting best practices.

Clinical Informatics Data Analyst

Excellus
Rochester, NY
03.2022 - 03.2024
  • Analyzed healthcare datasets containing millions of clinical and claims records to identify reporting gaps, data quality issues, and operational opportunities.
  • Developed HIPAA-compliant reporting solutions utilizing SQL, HL7, FHIR, and EMR data sources.
  • Automated 15+ recurring reporting processes using SQL, Cognos, and Excel.
  • Collaborated with clinical, operational, and IT teams to troubleshoot reporting challenges and improve healthcare data workflows.
  • Supported overnight production reporting environments and independently resolved time-sensitive reporting and data integrity issues.

Director, Data Operations (Case Management Analytics)

New York State Department of Health
New York City, NY
04.2020 - 02.2022
  • Led statewide data operations supporting COVID-19 case management and public health response initiatives.
  • Managed reporting and operational activities supporting 100+ remote staff members across multiple teams.
  • Developed 20+ Power BI and Excel dashboards used to monitor productivity, service levels, operational performance, and workforce management.
  • Standardized reporting workflows and quality assurance procedures, improving consistency and accuracy across statewide operations.
  • Collaborated with leadership teams and stakeholders to support reporting, compliance, and performance management initiatives.

Business Analyst (Revenue & Operations)

Bowlero
New York City, NY
09.2017 - 03.2020
  • Analyzed sales and operational data supporting corporate event planning, revenue forecasting, and business performance initiatives.
  • Developed reporting solutions and performance metrics supporting executive decision-making.
  • Supported more than $850K in corporate event revenue through operational reporting and business analysis.

Technical Support Operations Manager (Network & Systems)

Verizon
Rochester, NY
05.2014 - 08.2017
  • Led Tier 1 and Tier 2 support operations within a high-volume technical services environment.
  • Partnered with engineering teams to improve service reliability and reduce operational disruptions.
  • Managed escalations, service incidents, and customer-impacting technical issues using Salesforce and enterprise support platforms.

Systems & Data Analyst

Big Brothers Big Sisters Of Greater Rochester
Rochester, NY
06.2009 - 03.2014
  • Maintained organizational databases supporting grants management, donor reporting, compliance requirements, and program operations.
  • Developed reporting solutions and automated processes that improved operational visibility and reporting efficiency.
  • Supported data migration and CRM modernization initiatives.

Education

Master of Science - International Business and Computer Science

University of Nevada, Las Vegas (UNLV)
Las Vegas, NV
06-2020

Bachelor of Science - International Business and Computer Science

SUNY Empire State University
Rochester, NY
06-2016

Associate of Applied Science - International Business and Mass Communication

Monroe Community College
Rochester, NY
06-2012

Skills

    Data Engineering & Architecture:
    SQL Server, T-SQL, Denodo, SSIS, ETL/ELT, Data Warehousing, Data Modeling, Data Virtualization, Semantic Layer Design, Metadata Management, Data Governance, Enterprise Reporting

    Business Intelligence & Analytics:
    Power BI, Tableau, IBM Cognos, Excel, Dashboard Development, Executive Reporting, KPI Reporting, Operational Analytics

    Programming & Development:
    Python, Git, Query Optimization, Data Transformation, Automation, Scripting

    Cloud & Platforms:
    Azure, AWS, ServiceNow, Salesforce, Active Directory, VDI, Enterprise Infrastructure

    Healthcare & Enterprise Data:
    HL7, FHIR, EMR Systems, Claims Data, Clinical Data, Healthcare Analytics, HIPAA Compliance, Netsmart, MAPP

Certification

  • AWS Certified Solutions Architect – Associate
  • Google Data Analytics Professional Certificate
  • CompTIA A+ & Network+
  • SAS Programming for R Users (Parts 1 & 2)
  • Microsoft Certified: Data Analyst Director

Timeline

Senior Data Warehouse Architect (Subcontractor)

Mission Support and Test Services (MSTS) – Nevada National Security Site (NNSS)
03.2026 - Current

Senior Healthcare Data Analyst

HHUNY
06.2024 - 03.2026

Clinical Informatics Data Analyst

Excellus
03.2022 - 03.2024

VP of Data Operations / Senior Data Scientist

Rel8ed.to Analytics
09.2021 - 01.2025

Director, Data Operations (Case Management Analytics)

New York State Department of Health
04.2020 - 02.2022

Business Analyst (Revenue & Operations)

Bowlero
09.2017 - 03.2020

Technical Support Operations Manager (Network & Systems)

Verizon
05.2014 - 08.2017

Systems & Data Analyst

Big Brothers Big Sisters Of Greater Rochester
06.2009 - 03.2014

Master of Science - International Business and Computer Science

University of Nevada, Las Vegas (UNLV)

Bachelor of Science - International Business and Computer Science

SUNY Empire State University

Associate of Applied Science - International Business and Mass Communication

Monroe Community College
Trei Alexander