Open to opportunities

maricia alleman

@mariciaalleman

Senior data engineer and analytics builder specializing in SQL pipelines, Snowflake/SQL Server architectures, and Power BI governance.

United States

Message

What I'm looking for

I’m looking to build and modernize data platforms in greenfield environments—designing governed SQL/ETL pipelines and Power BI models that turn messy, multi-vendor data into reliable, decision-ready analytics.

I’m a hands-on data engineer and analytics builder with 20+ years designing SQL pipelines, ETL/ELT workflows, data warehouse architectures, and Power BI reporting solutions from the ground up. I thrive in greenfield environments, wrangling inconsistent, multi-vendor data into governed, reliable models when there’s little existing infrastructure.

As Director of District Data Analytics at Ector County ISD, I recruited to build a district-wide data platform from scratch and architected ETL pipelines integrating 6+ inconsistent, multi-vendor data sources into centralized SQL Server reporting models serving 30,000 students across 49 campuses. I’ve designed and deployed 10+ Power BI semantic models and dashboards for attendance, graduation, CCMR, STAAR, TELPAS, and A–F accountability reporting.

I also built mission-critical logic and automation—implementing TEA-aligned CCMR classification rules (bucket assignments, IBC tier classification, and weighted scoring) and developing a Python/Tkinter “SDR Sorter” that processes 2,000–4,000 assessment files per cycle, cutting processing time from 4–6 hours to under 30 minutes per month. I’ve led end-to-end State Data Reporting and SIRS reconciliation workflows, including TIDE uploads, extractions, crosswalks, and quality checks.

Before that, as Chief Technology & Information Security Officer at Eastern New Mexico University, I directed enterprise infrastructure and information security operations while building business-facing Power BI solutions and automation using Power Automate/Power Apps. Earlier, I designed ETL packages and SSRS reporting at UT Permian Basin and supported ERP, SQL-based reporting, and ASP.NET applications in my prior roles—always focused on data integrity, governance, and practical outcomes.

Experience

Work history, roles, and key accomplishments

Current

Director of District Data Analytics

Current

Ector County ISD

Jan 2023 - Present (3 years 5 months)

Recruited to build a district-wide data platform from scratch, architecting ETL pipelines that integrate 6+ inconsistent, multi-vendor data sources into centralized SQL Server reporting models serving 30,000 students across 49 campuses. Built 10+ Power BI semantic models and dashboards for attendance, graduation, CCMR, STAAR, TELPAS, and A–F accountability reporting, including TEA-aligned CCMR cla

SQL Server ETL ELT Data Modeling Tkinter Data Governance Power Automate

Chief Tech & InfoSec Officer

Eastern New Mexico University

Jan 2021 - Jan 2023 (2 years)

Directed enterprise technology infrastructure, including servers, networking, Hyper-V virtualization, Cisco Meraki wireless, Active Directory, Office 365, and information security operations. Built internal BI and workflow solutions including a Power BI computer inventory app and Power Automate/Power Apps phone directory integrated into Teams-based reporting, while managing SQL Server and enterpri

Power BI Power Automate Active Directory Office 365 Hyper V Cisco Meraki Information Security Disaster Recovery

System Analyst II

University of Texas Permian Basin

Jan 2014 - Jan 2020 (6 years)

Designed and maintained SSIS/Visual Studio ETL packages to load 79 extracts from two PeopleSoft databases into a Microsoft SQL Server data warehouse. Built SSRS and SharePoint-integrated BI reporting systems and ensured data integrity, quality, and security for academic and administrative enterprise reporting.

SSIS SQL Server ETL Microsoft SSRS SharePoint Peoplesoft Data Warehouse Data Integrity

Programmer Analyst & Network Comms

Odessa College

Jan 2009 - Jan 2014 (5 years)

Administered Ellucian Colleague ERP and WebAdvisor, managing security provisioning, user access, UniData programs, file dictionaries, and enterprise reporting processes. Automated ERP user creation and security assignment workflows and supported SQL-based institutional reporting and enterprise backup/disaster recovery operations.

WebAdvisor UniData SQL Reporting File Dictionaries Workflows Disaster Recovery

PC Support Specialist

City of Odessa

Jan 2005 - Jan 2009 (4 years)

Developed and maintained client/server applications, intranet systems, and SQL-based web applications using ASP.NET across municipal departments. Maintained SharePoint Server SQL databases, supported business continuity and disaster recovery planning, and provided hardware, software, and network troubleshooting.

ASP.NET SQL Database Management SharePoint Disaster Recovery Planning Network Troubleshooting

Signal Support Specialist

U.S. Army

Jan 1993 - Jan 2001 (8 years)

Installed, maintained, and troubleshot communications systems, signal support equipment, and data distribution systems while providing technical training for communications and automation equipment operations. Maintained readiness documentation to support mission support and operational continuity.

Troubleshooting Signal Support Equipment Technical Training Automation