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

Ontrac-solutions-llc
Chicago, IL

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.



  • 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




  • 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




  • 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)




  • 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


Posted 2025-09-14

Recommended Jobs

Food Prep Worker - Triad School District

Aramark
Troy, IL

Job Description The Food Prep Worker prepares, and portions food items and performs various duties in accordance with production requirements and Aramark sanitation standards. Uses daily worksheet…

View Details
Posted 2025-09-07

Automotive Parts Counter Associate

Aston Martin of Chicago
Downers Grove, IL

The Ed Napleton Automotive Group is looking for our next Automotive Parts Counter Associate. This is an exciting opportunity in a growing, fast-paced industry. Located at Aston Martin of Downers Grove…

View Details
Posted 2025-09-03

Trial Attorney

Chicago, IL

Job description: A dynamic and rapidly growing personal injury and property damage law firm, seeks a highly motivated and passionate Trial Attorney to join their team POSITION SUMMARY: In …

View Details
Posted 2025-09-10

Pediatric Speech Language Pathologist

STEPS FOR KIDS INC
Yorkville, IL

Job Description Job Description Description: STEPS for Kids is now hiring for part-time SLP positions with flexible scheduling from 6 to 20 hours per week. Located in our recently renovated prof…

View Details
Posted 2025-07-26

CNC Applications Engineer- 5 Axis

Swift Placement & Consulting
Schaumburg, IL

Job Description Job Description Position Summary: The 5-Axis Product Applications Engineer reports to the 5-Axis Product Manager and is responsible for sales and customer support for Sodick 5…

View Details
Posted 2025-08-09

Master Merchandiser

Driveline Retail Merchandising
Pontoon Beach, IL

Retail Merchandisers Needed! Earn $15.75 / hour - Flexible Hours and Workdays – Make Your Own Schedule! This is a flexible, variable hour position with hours that depend on business and project nee…

View Details
Posted 2025-09-01

Principal Research Scientist - Peptide Analytical Chemistry

AbbVie Inc.
North Chicago, IL

Company Description AbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We striv…

View Details
Posted 2025-08-07

Full Time Urgent Care Physician Job IN

Enterprise Medical Recruiting Enterprise Medical Recruiting
Chicago, IL

Non-for profit system has urgent care opportunities within an hour of Chicago, Illinois. Position Highlights Well-established Immediate Care opportunity one hour from downtown Chicago Acce…

View Details
Posted 2025-09-10

Board Op / Sports Producer / Radio Announcer

Talley Broadcasting Corporation
Hillsboro, IL

Job Summary: The part-time Board Operator / High School Sports Producer / Radio Announcer at Talley Broadcasting Corporation will be responsible for airing high school sport broadcasts, scores and inf…

View Details
Posted 2025-08-28

Join Our Caring Medsurg RN Team in Lawrenceville!

NurseRecruiter
Lawrenceville, IL

Medsurg RN in Lawrenceville, IL If you're a compassionate Registered Nurse, consider joining the Medsurg RN team at Lawrence County Memorial Hospital. As a full-time night shift nurse, you’ll have th…

View Details
Posted 2025-08-07