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

Preferred / Bonus

Why Join?