Job Description
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 Now