Power BI Architect (GCP | Python | dbt | Airflow | SQL | Low-Code)

Ontrac Solutions is a leading technology consulting firm specializing in cutting-edge solutions that drive business transformation. We partner with organizations to modernize their infrastructure, streamline processes, and deliver tangible results.

Our client is a premier Google Cloud consulting partner that helps organizations modernize their data infrastructure and unlock insights through cloud-native technologies. For this engagement, our client is leading a high-impact data transformation initiative, integrating GCP with advanced analytics and visualization tools. As a Power BI Architect, you'll play a pivotal role in delivering elegant, insight-rich reporting solutions that empower enterprise decision-makers.

We are seeking a

Power BI Architect

with deep experience across

data visualization, cloud platforms, and modern data orchestration

to join a strategic enterprise transformation project. The ideal candidate is both a

technical leader and visualization expert , with proven hands-on experience in

Power BI ,

GCP , and tools like

dbt ,

Airflow , and

Python . This role requires a

strong design mindset ,

expert-level SQL , and the ability to work seamlessly across engineering and business stakeholders. Candidates with

Power BI certifications

and

exposure to low-code platforms

(e.g., Power Apps, AppSheet) will stand out. Key Responsibilities

Architect and deliver

scalable Power BI solutions

with rich, intuitive visual experiences

Lead

dashboard and report design

focusing on usability, storytelling, and insight generation

Build semantic models, shared datasets, and optimized dataflows for reusability

Work with

BigQuery

and GCP services to source and transform large-scale datasets

Write and optimize

advanced SQL

to support analytical workloads

Develop transformation pipelines using

dbt

and orchestrate workflows with

Airflow

Automate and extend data workflows using

Python

for ETL tasks and API interactions

Integrate Power BI with

low-code solutions

such as

Power Apps

or

AppSheet

when needed

Guide clients on governance, scalability, security, and lifecycle management of BI assets

Required Skills & Experience

8+ years in analytics, with 3+ years in

Power BI architecture and dashboarding

Deep visualization design

skills and a strong portfolio of polished Power BI reports

Expert-level

SQL —able to write complex, optimized queries across cloud data warehouses

Experience working in

Google Cloud Platform (GCP) , especially

BigQuery

and IAM

Proficient in

Python

for scripting and data workflow automation

Experience using

dbt

and

Airflow

in a production data environment

Familiarity or hands-on work with

low-code platforms

(e.g., Power Apps, AppSheet, or similar)

Prior consulting experience or ability to lead client-facing engagements

Preferred/Bonus

Power BI certifications

(e.g., Microsoft Certified: Data Analyst Associate)

Familiarity with Fivetran, Stitch, or cloud-native data ingestion tools

Knowledge of CI/CD pipelines for BI asset deployment

GCP certifications (e.g., Professional Data Engineer or Cloud Architect)

Why Join?

Lead a

modern data stack engagement

with cutting-edge tools and architecture

Work alongside a seasoned consulting team delivering mission-critical analytics

High visibility and autonomy in a fast-paced, data-driven environment

Make an immediate impact at the intersection of data, design, and cloud innovation

#J-18808-Ljbffr