Lead HR Analytics & BI Developer/Applications Systems Analyst - HR Solutions & Analytics

University of Texas Medical Branch (UTMB)•Galveston, TX

13h•Hybrid

About The Position

This position provides advanced analysis and documentation, formulates logical statements of business and management problems, and develops solutions using more efficient operational procedures, workflows, and information technology solutions for institutional activities.

Requirements

Bachelor's degree or equivalent in a related field.
4 years of relevant experience.
Advanced Power BI development skills, including Power Query, DAX, data modeling, semantic models, security, refresh management, performance tuning, and deployment practices.
Strong Azure SQL and relational database skills, including complex querying, reusable database objects, troubleshooting, and query optimization.
Ability to administer Azure resources within assigned HR resource groups and apply Azure security and operational concepts, including resource configuration, role-based access control, Key Vault, managed identities, service connections, monitoring, diagnostic logging, cost awareness, change control, private connectivity concepts, environment separation, documentation, and compliance with enterprise cloud governance.
Strong knowledge of Azure Logic Apps and event- or workflow-based integration patterns, including connectors, triggers, actions, error handling, secure configuration, and operational monitoring.
Advanced Azure data engineering skills, including Azure Data Factory pipeline design, orchestration, scheduling, monitoring, troubleshooting, incremental data-loading patterns, and production support.
Strong knowledge of dimensional modeling, star schemas, slowly changing dimensions, conformed dimensions, data lineage, and enterprise data warehouse concepts.
Ability to manage competing priorities and deliver accurate work under short deadlines, especially for audits, state reporting, regulatory requests, and executive inquiries.
Ability to reconcile information across multiple systems, identify data-quality issues, document assumptions, and explain analytical results to technical and nontechnical audiences.
Knowledge of data security, role-based access, privacy, and responsible handling of sensitive employee and healthcare workforce information.
Strong written communication, stakeholder coordination, problem-solving, and documentation skills.

Nice To Haves

Experience with additional Azure services such as Azure Synapse Analytics, Azure Functions, Azure Storage or Data Lake, Key Vault, Azure Monitor, API Management, or comparable cloud data and integration platforms.
Experience developing Power Apps, Power Automate workflows, or other Power Platform solutions.
Working knowledge of Python, machine learning concepts, generative AI, and responsible AI practices; expert-level AI or data science experience is not required.
Experience supporting HR analytics, HR information systems, workforce reporting, payroll, talent acquisition, learning, timekeeping, or related HR processes.
Experience in a healthcare, academic medical center, higher education, public-sector, or similarly regulated environment.
Experience with source control, deployment pipelines, data governance, and formal testing or change-control practices.

Responsibilities

Leads the technical design and delivery of complex, cross-functional HR analytics and data solutions, coordinating dependencies and resolving significant technical or data issues.
Serves as the lead technical resource for HR analytics, Power BI, semantic modeling, Azure SQL, enterprise data warehouse development, and Azure data integration.
Designs, develops, tests, deploys, and maintains Power BI reports and dashboards that translate HR and workforce data into clear, actionable information for operational and executive audiences.
Develops and maintains governed Power BI semantic models, including dimensional structures, measures, calculations, hierarchies, relationships, row-level security, refresh processes, and performance optimization.
Designs and maintains HR data models within the Azure enterprise data warehouse using dimensional modeling practices, reusable business logic, conformed dimensions, data lineage, and documented metric definitions.
Writes, reviews, and optimizes advanced Azure SQL queries, views, stored procedures, and transformation logic supporting dashboards, recurring reports, audit extracts, and ad hoc analysis.
Designs, develops, schedules, monitors, and supports Azure Data Factory pipelines and Azure Logic Apps that securely ingest, transform, orchestrate, and route data and workflow events across HR, payroll, recruiting, learning, timekeeping, finance, shared mailboxes, files, APIs, and other approved enterprise sources.
Administers and monitors HR-specific Azure resource groups and services, including configurations, service connections, managed identities, access assignments, diagnostic settings, budgets, and resource utilization, in coordination with enterprise cloud, infrastructure, networking, identity, security, and governance teams.
Manages and supports the Azure-based HR data warehouse environment, including monitoring data loads, troubleshooting failures, improving performance, and maintaining reliable data availability.
Maintains deployment procedures, support runbooks, data-flow diagrams, resource inventories, and recovery instructions for the HR Azure environment and its production integrations.
Responds to complex and time-critical requests from leadership, state agencies, auditors, regulatory bodies, and other authorized parties; coordinates across teams to gather and reconcile data, document assumptions, validate results, and deliver complete submissions within required deadlines.
Performs data analysis to identify workforce trends, exceptions, risks, root causes, and opportunities and communicates findings, limitations, and recommended next steps.
Partners with stakeholders to translate business questions into sustainable, governed analytics solutions and communicates priorities, status, risks, and delivery expectations.
Develops user-friendly analytical tools and workflow solutions using Power Apps and related Power Platform capabilities when appropriate.
Performs related duties as assigned.