Experience: 10–14 years Primary skill: Power BI Secondary mandatory skill: GCP (Google Cloud Platform) Work arrangement: Bengaluru, 3 days per week from office

1. Technical requirements

- Power BI — Primary requirement: Strong hands-on experience and expertise in Power BI.
- GCP — Mandatory: Working knowledge of GCP, including relevant data technologies and cloud migration experience.
- Big Data: Understanding of big data technologies and their application in data engineering environments.
- GCP migration: Preferred due to existing business integrations; the discussion indicates GCP is mandatory for these roles.

2. What the hiring team is looking for The ideal candidate should have strong Power BI expertise alongside practical GCP knowledge. The business is open to candidates whose current designation is not “Architect,” provided they possess the required skills and relevant experience. Candidates should be able to explain their technical experience confidently without requiring the interviewers to teach them the fundamentals of GCP.

Experience: Typically 10+ years in BI/data engineering, including 5+ years hands-on Power BI and 3+ years in architecture or technical leadership; equivalent delivery experience considered.

THE ROLE

We are hiring a hands-on Power BI Architect to migrate our analytics data foundation to Google Cloud Platform (GCP), with Power BI as the reporting platform and using LookML for governed business semantics. You will personally design, build, debug and optimize complex integrations, models and production reports. Deep Power BI tool expertise is the primary requirement, supported by practical BigQuery and LookML engineering. This is not a dashboard-only or advisory-only role.

KEY RESPONSIBILITIES

Engineer Power BI solutions. Build advanced DAX using filter/row context, context transition,



calculation groups and time intelligence; develop Power Query M with query folding. Design star schemas, relationships, reusable semantic models and thin reports. Select Import, DirectQuery, composite models, aggregations and incremental refresh only where the connection, capacity and licensing support them. [4]

Lead the GCP migration. Assess existing reports, models, M queries, DAX, refresh schedules, security and source dependencies. Define migration waves, source-to-target mappings and remediation plans. Rebind or refactor integrations, reconcile business calculations, run parallel validation and user acceptance testing, and own cutover, rollback and stabilization.

Build and validate integrations. Implement BigQuery SQL and Power Query integration with enterprise databases, APIs and files. Evaluate BigQuery and BigQuery (Microsoft Entra ID) connectors, including ADBC Implementation 2.0 versus legacy ODBC, alongside the Looker connector. Track releases, preview status and compatibility; prove upgrades before rollout. Partner with data engineering on ingestion, CDC and orchestration. [2,3]

Govern LookML semantics. Develop LookML models, views, Explores, dimensions, measures and joins. Define grain, primary keys, relationships and symmetric aggregates; use persistent derived tables, datagroups and aggregate awareness appropriately. Establish ownership of business logic across BigQuery, LookML and DAX,



with automated metric reconciliation and version-controlled changes. [5]

Deliver performance at scale. Diagnose DAX, VertiPaq, query plans, folding and visual bottlenecks using Performance Analyzer, DAX Studio and Tabular Editor. Optimize cardinality, generated SQL, BigQuery partition pruning and pre-aggregation. Benchmark realistic concurrency, p95 report latency, refresh duration, memory, capacity and query cost; validate cache behavior and cross-cloud transfer overhead. [4,6]

Own security, delivery and operations. Design workspaces, apps, row-/object-level security and least-privilege access across Power BI, Looker and GCP. Validate identity and credential handling by connection path. Establish Git, automated tests, deployment pipelines, monitoring and recovery runbooks; evaluate PBIP/TMDL and API automation within supported releases. Lead code reviews, mentor developers and own production handover.

REQUIRED EXPERIENCE

Production ownership in Power BI Desktop and Service, including refresh/gateway operations and workspace governance, plus at least one cloud migration or major source-platform change. Demonstrable BigQuery and LookML engineering is essential; dashboard-only exposure is insufficient.

Advanced SQL, DAX and Power Query M; practical Python/automation, Git, CI/CD and systematic troubleshooting. Explain your own implementation decisions with data volumes, concurrency, refresh timings and before/after performance evidence. Relevant degree or equivalent skilled experience.

PREFERRED EXPERIENCE

Dataflow, Datastream, Pub/Sub, Cloud Storage, Composer/Airflow and Dataform/dbt; integrations with SQL Server, Oracle/SAP, Snowflake/Databricks or REST APIs; XMLA/REST automation, paginated reports and capacity planning. Certifications are beneficial, not a substitute for delivery.

📌 Senior Solution Architect (Bengaluru)
🏢 Geektrust
📍 Bengaluru