Job Summary

The Senior Analyst - Data Analytics serves as an enterprise technical authority for analytical data architecture, dimensional modeling, metric design, and the integration between curated BigQuery data structures and shared Power BI semantic models. Operating as part of an offshore analytics hub, this role partners with the Data Office to design, govern, and continuously improve enterprise analytical data models that support reporting, analytics, and data-product consumption.

The role partners closely with the Consulting BI Developer to ensure that SQL structures, model grain, relationships, dimensions, measures, security attributes, and refresh strategies are designed as an integrated solution.

The Consulting Data

Architect / Data Modeler determines how data and metric logic should be represented across BigQuery and the semantic layer and ensures that governed BigQuery datasets remain usable when direct SQL access is more appropriate than semantic-model consumption.

Responsibilities

- Own complex or enterprise-impacting data architecture and modeling deliverables from requirements and source assessment through design, validation, release, maintenance, and retirement.

- Identify model risks, source limitations, metric inconsistencies, architectural dependencies, data-quality concerns, and scalability issues and recommend practical resolution approaches.

- Provide architectural direction, technical review, mentoring, and escalation support without direct people-management responsibility.

- Partner with the Data Office to design, govern, and maintain conceptual, logical, dimensional, and physical analytical data models.

- Define model grain, facts, dimensions, hierarchies, keys, relationships, history requirements, conformed dimensions, reference data, and aggregation strategies.





- Design reusable curated datasets and data structures that support multiple enterprise analytics products, business functions, and consumption patterns.

- Reduce duplicated datasets, inconsistent structures, conflicting definitions, and fragmented transformation logic through governed enterprise modeling patterns.

- Own the technical definition and model representation of enterprise metrics and measures in partnership with Data Stewards, subject matter experts, the Data Office, and the Consulting BI Developer.

- Define metric grain, population, filters, dimensions, aggregation rules, effective dating, calculation logic, exclusions, and appropriate use.

- Determine whether calculations and business rules should be implemented in BigQuery, the Power BI semantic model, or another approved layer based on consistency, performance, reuse, and maintainability.

- Partner with the Consulting BI Developer on DAX implementation, semantic-model behavior, calculation performance, and presentation of governed measures.

- Design and review BigQuery tables, views, transformations, and curated analytical structures in service of enterprise semantic models and analytical use cases.

- Define clear data contracts between curated BigQuery structures and Power BI semantic models, including grain, keys, relationships, quality expectations, refresh requirements, and security attributes.

- Partner with the Consulting BI Developer to resolve issues involving SQL performance, query folding, aggregations,



partitions, relationships, refresh behavior, and semantic-model consumption.

- Provide governed BigQuery datasets, documented SQL patterns, and explicit usage guidance for advanced, detailed, or high-volume use cases that are not appropriately served by the shared semantic model.

- Define validation rules and quality controls for completeness, accuracy, consistency, timeliness, uniqueness, referential integrity, and fitness for use.

- Collaborate with the Consulting BI Developer to ensure identity, hierarchy, entitlement, and classification attributes support appropriate row-level security, object-level security, and dynamic access patterns.

- Investigate complex data discrepancies and model defects, identify root causes and downstream effects, and implement or coordinate durable corrective actions.

- Establish and reinforce standards for dimensional modeling, naming, data types, keys, effective dating, metric logic, documentation, lineage, testing, and model review.

- Review high-impact data models, SQL designs, mappings, measures, and data contracts for accuracy, scalability, consistency, maintainability, governance alignment, and semantic-model readiness.

- Apply established practices for version control, peer review, testing, deployment, release management, documentation, security, privacy, and data governance.

- Use approved AI-enabled tools to accelerate model documentation, SQL drafting, mapping analysis, metadata development, lineage summaries, test creation, and design evaluation.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Senior Analyst -? Data Analytics (Hyderabad)
🏢 HCA Healthcare UK
📍 Hyderabad