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 ResponsibilitiesArchitect and deliver scalable Power BI solutions with rich, intuitive visual experiencesLead dashboard and report design focusing on usability, storytelling, and insight generationBuild semantic models, shared datasets, and optimized dataflows for reusabilityWork with BigQuery and GCP services to source and transform large-scale datasetsWrite and optimize advanced SQL to support analytical workloadsDevelop transformation pipelines using dbt and orchestrate workflows with AirflowAutomate and extend data workflows using Python for ETL tasks and API interactionsIntegrate Power BI with low-code solutions such as Power Apps or AppSheet when neededGuide clients on governance, scalability, security, and lifecycle management of BI assetsRequired Skills & Experience8+ years in analytics, with 3+ years in Power BI architecture and dashboardingDeep visualization design skills and a strong portfolio of polished Power BI reportsExpert-level SQL-able to write complex, optimized queries across cloud data warehousesExperience working in Google Cloud Platform (GCP), especially BigQuery and IAMProficient in Python for scripting and data workflow automationExperience using dbt and Airflow in a production data environmentFamiliarity or hands-on work with low-code platforms (e.g., Power Apps, AppSheet, or similar)Prior consulting experience or ability to lead client-facing engagementsPreferred/BonusPower BI certifications (e.g., Microsoft Certified: Data Analyst Associate)Familiarity with Fivetran, Stitch, or cloud-native data ingestion toolsKnowledge of CI/CD pipelines for BI asset deploymentGCP certifications (e.g., Professional Data Engineer or Cloud Architect)Why Join?Lead a modern data stack engagement with cutting-edge tools and architectureWork alongside a seasoned consulting team delivering mission-critical analyticsHigh visibility and autonomy in a fast-paced, data-driven environmentMake an immediate impact at the intersection of data, design, and cloud innovation