General Position Information

Reports directly to (Title): Director or Senior Director, HR Transformation &

- Analytics

Matrix reports to (Title): As applicable based on HR Transformation &
- Analytics portfolio, platform, product, or functional alignment

Direct Reports: Individual contributor; may provide advisory direction, standards, and workstream guidance

Created / Last Revised: -

Job Code: -

Position Summary The Analyst II - Data Analytics serves as an enterprise technical authority for Power BI performance, shared semantic models, access architecture, and business intelligence engineering practices. Operating as part of an offshore analytics hub, this role is responsible for the performance, reliability, scalability, security, and maintainability of enterprise BI products and the semantic models that support them.

The role partners closely with the Consulting Data Architect at the interface between curated SQL data structures and the semantic layer. Together, these roles design and deliver reusable enterprise semantic models, define data and access requirements, resolve cross-layer performance and modeling issues, and ensure that data structures, relationships, calculations, security, refresh processes, and governed business metrics operate as an integrated solution.

The Consulting BI Developer also partners with the onshore BI Lead to develop, govern, and continuously improve the enterprise analytics design system, technical standards, reusable components, and development practices. The role provides advanced technical guidance, reviews complex solutions, resolves ambiguous or enterprise-impacting issues, and enables distributed development teams to deliver consistent, governed, secure, and high-performing analytics products.

Responsibilities

Consulting-Level Ownership &

- Enterprise Delivery Leadership

- Own the technical performance, reliability, scalability, security, and maintainability of enterprise Power BI products and shared semantic models.
- Lead complex or enterprise-impacting BI deliverables and technical workstreams with limited oversight, from architecture and solution design through development, validation, release, monitoring, enhancement, and retirement.
- Identify technical risks, performance constraints, security concerns, data limitations, architectural dependencies, and delivery issues early and recommend practical mitigation actions.
- Provide technical direction, peer review, coaching, and escalation support to BI developers and distributed delivery teams without direct people-management responsibility.

Enterprise Semantic Model Ownership

- Design, develop, optimize, govern, and maintain shared enterprise semantic models that support multiple analytics products, business functions, and stakeholder groups.
- Define and implement appropriate model grain, dimensions, relationships, hierarchies, measures, calculation groups, aggregations, partitions, row-level security, and object-level security.
- Develop and govern reusable DAX measures, calculation patterns, naming conventions, business terminology, and semantic-model components.
- Reduce duplicated models, inconsistent calculations, unmanaged measures, fragmented reporting logic, and inconsistent access rules through reusable and governed semantic-layer solutions.

Enterprise BI Performance &

- Platform Reliability

- Monitor and improve query performance, report responsiveness, refresh duration, model size, memory utilization, capacity consumption, concurrency, and overall user experience.
- Diagnose DAX formula-engine and storage-engine performance, model cardinality, relationship behavior, calculation dependencies, query patterns, and resource-intensive report interactions.
- Use DAX Studio, Power BI Performance Analyzer, VertiPaq Analyzer, Tabular Editor, ALM Toolkit, XMLA endpoints,



Microsoft Fabric monitoring capabilities, and comparable approved tools to inspect, troubleshoot, compare, optimize, and maintain semantic models.
- Establish performance baselines, monitoring practices, diagnostic procedures, alerting approaches, and service expectations for enterprise BI products.

Analytics Design System &

- Reusable Standards

- Partner with the onshore BI Lead to develop, govern, and continuously improve the enterprise analytics design system.

Data Architecture &

- SQL-Layer Partnership

- Partner with the Consulting Data Architect to define the interface between curated SQL data structures and the enterprise semantic layer.
- Collaborate on analytical model grain, conformed dimensions, fact structures, relationships, data contracts, lineage, aggregation strategies, metric logic, refresh design, security attributes, and performance optimization.

Enterprise Access Model &

- Security Governance

- Design and govern the enterprise Power BI access model using least-privilege principles and approved identity and entitlement standards.
- Define appropriate use of row-level security, object-level security, workspace roles, application audiences, build permissions, sharing controls, service principals, and self-service access.
- Establish reusable dynamic security patterns using governed identity, organizational hierarchy, role, population, geography, and entitlement data.

Enterprise Product Review &

- Release Readiness

- Establish and apply technical review criteria for enterprise BI products, semantic models, shared components, and access models.
- Test row-level security, object-level security, workspace access, application audiences, build permissions, and entitlement rules using representative user roles before release.
- Use controlled development, versioning, comparison, deployment, and rollback practices to reduce production risk.
- Support production deployments, post-release monitoring, incident investigation, root-cause analysis, and stabilization.

Documentation, Governance &

- Security

- Apply and reinforce standards for version control, peer review, modular development, testing, deployment, release management, monitoring, documentation, security, privacy, and data retention.
- Protect confidential and restricted information through approved access controls, data-handling practices, privacy requirements, security standards, and least-privilege principles.

AI-Enabled Engineering &

- Responsible Analytics

- Use approved AI-enabled tools to accelerate DAX and SQL drafting, technical documentation, metadata analysis, test development, diagnostic investigation, quality review, and solution evaluation.
- Independently validate AI-assisted code, calculations, recommendations, interpretations, security logic, and documentation before use or release.

Education &

- Experience

- Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Engineering, Statistics, Mathematics, Business, or a related field; an equivalent combination of education and experience may be considered.
- 7+ years of progressively responsible experience developing, optimizing, supporting, or governing business intelligence and enterprise analytics solutions.
- Advanced experience with Power BI, DAX, Power Query, semantic models, reusable measures, calculation groups, security, deployment pipelines, and performance optimization.




- Experience designing and supporting enterprise Power BI access models, including row-level security, object-level security, dynamic security, workspace roles, application audiences, semantic-model permissions, build permissions, and governed self-service access.
- Experience using semantic-model development and diagnostic tools such as DAX Studio, Tabular Editor, ALM Toolkit, VertiPaq Analyzer, Power BI Performance Analyzer, XMLA endpoints, or comparable tools.
- Advanced SQL experience and demonstrated experience working with cloud-based analytical platforms, distributed databases, or large and complex enterprise datasets.
- Solid knowledge of dimensional modeling, model grain, relationships, conformed dimensions, aggregation strategies, lineage, and semantic-layer design.
- Experience leading complex technical deliverables or defined workstreams across multiple products, teams, systems, or business functions.
- Experience reviewing technical solutions, resolving ambiguity, managing dependencies, communicating risk, and recommending scalable approaches.
- Experience providing technical guidance, peer review, mentoring, or enablement to developers and technical delivery teams.

Nice To Have Skills

- Experience with Microsoft Fabric, Fabric capacities, Fabric monitoring, semantic-link capabilities, gateways, deployment pipelines, and Power BI Service administration.
- Experience developing or governing enterprise analytics design systems, Power BI themes, reusable visual components, accessibility standards, or report-development frameworks.
- Experience with Microsoft Entra ID, security groups, service principals, identity mapping, entitlement management, or comparable enterprise identity and access-management capabilities.
- Experience with Git, Azure DevOps, automated testing, release management, continuous integration and deployment practices, Jira, Confluence, or comparable delivery tools.
- Experience in healthcare, shared services, global capability centers, or another highly regulated enterprise environment.

Licenses, Certifications &

- Training

- None required.
- Preferred: Microsoft Certified: Power BI Data Analyst Associate or comparable advanced Power BI certification.
- Preferred: Microsoft Fabric, Azure data, SQL, cloud architecture, data modeling, identity and access management, or analytics engineering certification.
- Preferred: Responsible AI, data privacy, data security, or enterprise data-governance training.

Knowledge, Skills, Abilities, Behaviors

- Advanced knowledge of Power BI architecture, DAX, semantic modeling, data visualization, deployment, security, monitoring, and performance optimization.
- Advanced knowledge of Power BI identity, access, and security capabilities, including row-level security, object-level security, dynamic security, workspace roles, application audiences, build permissions, sharing controls, and entitlement models.
- Ability to diagnose complex performance and reliability issues across reports, semantic models, capacities, gateways, refresh processes, security rules, access configurations, and underlying data structures.
- Ability to determine whether an issue should be resolved in the SQL layer, semantic layer, report layer, platform configuration, access model, or through a coordinated cross-layer solution.
- Ability to design scalable semantic models, dynamic security patterns, and reusable BI components that support multiple enterprise products and audiences.
- Ability to communicate complex technical issues, risks, options, access implications, and recommendations clearly to technical and nontechnical audiences.
- Ability to collaborate effectively with the onshore BI Lead, Consulting Data Architect, data engineers, security and privacy teams, analysts, product teams, and enterprise stakeholders.

📌 Senior Analyst - BI Development (Hyderabad)
🏢 HCA Healthcare - India
📍 Hyderabad