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-11-25

Recommended Jobs

Senior SDET

RAPP
Chicago, IL

RAPP Chicago is looking for a Senior SDET to join our award-winning Technology team. WHO WE ARE: We are RAPP world leaders in activating growth with precision and empathy at scale. As a glob…

View Details
Posted 2025-11-23

Food Champion

Taco Bell - B&G Food Enterprises
Will County, IL

The Taco Bell Food Champion plays and important role in producing tasty food in a quick and efficient manner. YOU will set the tone for the Taco Bell customer experience and bring the great Taco Bell…

View Details
Posted 2025-10-07

Bookkeeper

LaSalle Network
Niles, IL

Title: Bookkeeper Location: Park Ridge, IL Salary: $25-/hr – $30/hr We are a mid-sized, high-precision components manufacturer serving clients in the automotive, aerospace, and industrial…

View Details
Posted 2025-11-24

Medical Aesthetician

Bloom Plastic Surgery
Chicago, IL

Experienced Medical Aesthetician Bloom Plastic Surgery is seeking a highly skilled and motivated Aesthetician with an existing book of business to join our growing practice. The ideal candidate i…

View Details
Posted 2025-11-15

Wheel Loader Operator

Lawn & Garden Midwest
Sauget, IL

Oldcastle® APG, a CRH Company, is North America’s leading provider of innovative outdoor living solutions that enable customers to Live Well Outside. The manufacturer’s portfolio of premier bui…

View Details
Posted 2025-11-14

HVAC Truck Based Service Manager

Johnson Controls
America, IL

Build your best future with the Johnson Controls team As a global leader in smart, healthy and sustainable buildings, our mission is to reimagine the performance of buildings to serve people, pl…

View Details
Posted 2025-11-03

Commercial Bank Testing Analyst

BMO US
Chicago, IL

Application Deadline: 11/27/2025 Address: 320 S Canal Street Job Family Group: Business Management The BMO Commercial Risk & Control Testing team is a dynamic group that conduc…

View Details
Posted 2025-11-24

2026 Summer Intern - Commercial Real Estate

CIBC
Chicago, IL

We're building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what's right for our clients. At CIBC, we embrace your st…

View Details
Posted 2025-11-24

Nurse Case Manager II

SGS Consulting
Illinois

Job Responsibilities: The Case Manager utilizes a collaborative process of assessment, planning, facilitation and advocacy for options and services to meet an individual's benefit plan and/or heal…

View Details
Posted 2025-11-14

Home Health Physical Therapist

Interim HealthCare
Chicago, IL

Interim HealthCare is seeking a compassionate and driven Home Health Physical Therapist to join our team. This role is ideal for someone dedicated to providing patient-centered services tailored to in…

View Details
Posted 2025-11-21