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

Bachelor's degree or equivalent in a related field. 4 years of relevant experience.

Preferred Qualifications:

• 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.

Job Summary:

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.

Job Duties:

• 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.

Knowledge/Skills/Abilities:

• Advanced Power BI development skills, including Power Query, DAX, data modeling, semantic models, security, refresh management, performance…