Ontrac Solutions
Power BI Architect (GCP | Python | dbt | Airflow | SQL | Low-Code)
Ontrac Solutions, Chicago, Illinois, United States, 60290
Power BI Architect (GCP | Python | dbt | Airflow | SQL | Low-Code)
Join to apply for the
Power BI Architect (GCP | Python | dbt | Airflow | SQL | Low-Code)
role at
Ontrac Solutions Power BI Architect (GCP | Python | dbt | Airflow | SQL | Low-Code)
Join to apply for the
Power BI Architect (GCP | Python | dbt | Airflow | SQL | Low-Code)
role at
Ontrac Solutions 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 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
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
Seniority level
Seniority level Director Employment type
Employment type Contract Job function
Job function Business Development and Sales Industries IT Services and IT Consulting Referrals increase your chances of interviewing at Ontrac Solutions by 2x Get notified about new Business Intelligence Architect jobs in
Chicago, IL . Data Solutions Architect | Splunk (Remote)
Chicago, IL $160,000.00-$190,000.00 1 week ago Principal Solutions Architect | Data Security/XDR (Remote)
Chicago, IL $125,000.00-$185,000.00 2 weeks ago Technical Data Analyst/Engineer (MicroStrategy)
Chicago, IL $115,000.00-$140,000.00 1 week ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Join to apply for the
Power BI Architect (GCP | Python | dbt | Airflow | SQL | Low-Code)
role at
Ontrac Solutions Power BI Architect (GCP | Python | dbt | Airflow | SQL | Low-Code)
Join to apply for the
Power BI Architect (GCP | Python | dbt | Airflow | SQL | Low-Code)
role at
Ontrac Solutions 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 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
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
Seniority level
Seniority level Director Employment type
Employment type Contract Job function
Job function Business Development and Sales Industries IT Services and IT Consulting Referrals increase your chances of interviewing at Ontrac Solutions by 2x Get notified about new Business Intelligence Architect jobs in
Chicago, IL . Data Solutions Architect | Splunk (Remote)
Chicago, IL $160,000.00-$190,000.00 1 week ago Principal Solutions Architect | Data Security/XDR (Remote)
Chicago, IL $125,000.00-$185,000.00 2 weeks ago Technical Data Analyst/Engineer (MicroStrategy)
Chicago, IL $115,000.00-$140,000.00 1 week ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr