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

Copper Studio Manager

Renaissance Historic Exteriors
Belvidere, IL

Key Results Area – Sheet Metal Studio Manager   Working Hours: 8:00 am to 5:00 pm Reports to: COO Working Days: Monday thru Friday, Saturdays as required by schedule demands   Objective: …

View Details
Posted 2025-08-07

Optometrist - Champaign, Illinois

Eyetastic Services
Champaign, IL

We are on the lookout for a passionate Optometrist to join this dynamic team, whether you're a recent graduate eager to embark on your professional journey or a seasoned expert looking for a new chal…

View Details
Posted 2025-09-28

Sr Rep, Customer Accounts

Planet Group
Alton, IL

Role Purpose: Responsible for the collection activities surrounding a receivable portfolio Essential Job Functions: Responsible for higher/complex monthly collection of the cash deemed necessa…

View Details
Posted 2025-10-26

Bartender/Server

The Dandy Crown
Chicago, IL

The Dandy Crown is a neighborhood spot that focuses on craft cocktails and serving delectable bites. We want to make sure that we can give our neighbors and visitors a memorable experience when th…

View Details
Posted 2025-10-23

Explore Toluca: Your Next Adventure Awaits!

NurseRecruiter
Toluca, IL

Physical Therapy Assistant job in Toluca, IL As a Physical Therapist Assistant in Toluca, you'll have the unique opportunity to provide essential care to patients in an acute care setting, making a s…

View Details
Posted 2025-07-30

Temporary Support Associate

Coach
Orland Park, IL

Coach is seeking a Temporary Support Associate in Orland Park, IL, to assist in maintaining store standards and supporting the sales team. The role involves ensuring merchandise is well-stocked, provi…

View Details
Posted 2025-09-30

Underwriter Credit & Surety

Swiss Re
Chicago, IL

Underwrite and manage an assigned territory within the Continental U.S.  Overall responsibilities include approving all commercial and commercial contract surety bonds within your authority, mana…

View Details
Posted 2025-07-31

SailPoint Engineer

Chicago, IL

SailPoint Engineer Salary: Open + Bonus Location: Coppell, TX or Chicago, IL Hybrid: 3 days onsite, 2 days remote *We are unable to provide sponsorship for this role* Qualifications B…

View Details
Posted 2025-10-22

Medical Technician

The Cori Group Inc
Lombard, IL

Job Description Job Description PHS on behalf of Reign-Bow Treatment Center is a provider of Transcranial Magnetic Stimulation (TMS Therapy). We are seeking a Medical Assistant to become a part o…

View Details
Posted 2025-10-23

RN - Float Pool (CIA Option S)

Carle Health
Urbana, IL

Overview: This position is intended for candidates seeking a more structured self-scheduling position or a set schedule possibly    The staff Registered Nurse (RN) is a professional caregiver who …

View Details
Posted 2025-08-19