Power BI Architect (GCP | Python | dbt | Airflow | SQL | Low-Code) (Remote)
Posted 2025-08-15
Remote, USA
Full Time
Immediate Start
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 SQLable 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 Apply tot his job
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 SQLable 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 Apply tot his job