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

Minimum Qualifications: 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: The Lead HR Analytics and Business Intelligence Developer designs, develops, and supports enterprise HR data and analytics solutions. The position builds Power BI reports and governed semantic models; develops and supports Azure Data Factory pipelines, Azure Logic Apps, and related integrations; manages and enhances the Azure-based HR enterprise data warehouse; and administers HR-specific Azure resource groups and services in partnership with enterprise technology, cloud, security, and infrastructure teams. The role also responds to complex and time-sensitive data and analysis requests and partners with HR, Information Services, Finance, operational leaders, audit teams, and other stakeholders to deliver accurate, secure, and decision-ready workforce information in a healthcare environment. This is a lead-level individual contributor position with technical ownership for complex HR analytics and data solutions.

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