1
Chicago, IL 60606, USA
Role Overview
We are seeking a highly skilled Power BI Developer with strong expertise in semantic modeling, data integration, and enterprise BI architecture. This role will own the end-to-end Power BI lifecycle—from data integration and modeling through dashboard development, deployment, and governance.
The ideal candidate combines hands-on Power BI development (70%) with data architecture and integration design (30%), and can deliver high-quality, user-centric dashboards backed by scalable, well-architected data models.
Key Responsibilities - Power BI Development & UX
Design and develop high-impact, executive-ready dashboards and reports with strong focus on usability and storytelling.
Build and maintain reusable Power BI semantic models (datasets) using best-practice dimensional modeling (star schema).
Develop advanced DAX measures, calculations, and time-intelligence logic.
Key Responsibilities - Data Integration & Pipeline
Integrate data from Azure Synapse, enterprise data warehouses, and reference data marts.
Design and contribute to ETL/data pipeline solutions using ADF, SSIS, and other integration tools.
Support data movement and integration patterns from systems such as Profisee into downstream reporting layers.
Key Responsibilities - Architecture & Performance
Define and implement end-to-end BI architecture across ingestion → modeling → reporting.
Optimize performance using techniques such as aggregations, incremental refresh, and query optimization.
Make design decisions around Import vs DirectQuery, composite models, and data latency tradeoffs.
Key Responsibilities - Power BI Platform & Governance
Architect and manage Power BI Service components including workspaces, datasets, and deployment pipelines (Dev/UAT/Prod).
Implement security and governance best practices (Row-Level Security, dataset certification, access controls).
Monitor and maintain reporting environments including data refresh, usage, and performance.
Key Responsibilities - Collaboration & Delivery
Partner with business and technology teams to translate requirements into scalable BI solutions.
Contribute to data modeling and architecture using ERwin or similar tools.
Ensure data quality, consistency, and alignment with enterprise data standards.
Required Qualifications
5+ years of hands-on experience with Power BI development and data visualization.
Strong expertise in Power BI semantic modeling, DAX, and dimensional modeling.
Experience with Azure Synapse, data warehouses, and data marts.
Hands-on experience with ADF and/or SSIS for data pipelines.
Strong SQL skills and understanding of relational data modeling.
Experience designing and supporting end-to-end BI/reporting solutions.
Preferred Qualifications
Experience with Power BI Service architecture (workspaces, pipelines, governance).
Exposure to Profisee or other MDM platforms.
Familiarity with Power BI DevOps and deployment automation.
Experience with large-scale / enterprise BI environments.
Exposure to Microsoft Fabric or modern Azure analytics stack.
Work Allocation
70% Development (Power BI reports, datasets, DAX, UX).
30% Architecture (data pipelines, modeling, platform design).
Peterson Technology Partners (PTP) is an Equal Opportunity Employer committed to creating a transparent, inclusive, and human-centered hiring experience.
For more than 28 years, PTP has operated as one of the top IT staffing and recruiting firms in the USA—built on trust, long-term partnerships, and technical excellence.
Based in the Chicago suburb of Park Ridge, IL, our team of more than 500 employees and consultants is dedicated to:
As part of that commitment, we believe in providing clear information about how our hiring technologies work and how your data is used. The following section outlines our AI-assisted interview process and your rights as a candidate.
To provide a consistent, fair, and flexible experience for all candidates, we use AI-assisted tools to support parts of the interview process. This includes our proprietary AI platform Pete & Gabi, which includes AI recruiter Rebecca.
These AI hiring tools help us:
Please note that:
If you prefer a non-AI interview format, we will gladly provide an alternative.
When applying for certain tech jobs, you may participate in:
We will always explain what to expect in advance so you can prepare with confidence.
Every candidate’s profile—including interviews, conversations, and assessments—is reviewed by experienced recruiters and hiring leaders.
AI insights may assist with organization and evaluation, but final decisions are always human-driven.
At PTP, every candidate has the right to:
Our goal is to ensure you feel respected, informed, and supported throughout your experience.
For more than 28 years, PTP has focused on putting people first—candidates, consultants, employees, and clients.
We’re committed to a hiring process that is:
Welcome to the future of hiring at Peterson Technology Partners.
We’re excited to learn more about you.
Peterson Technology Partners is an Equal Opportunity Employer. All qualified applicants will receive consideration without regard to race, color, religion, national origin, gender identity, sexual orientation, disability, veteran status, or any other protected characteristic.
Chicago, IL 60606, USA
Role Overview
We are seeking a highly skilled Power BI Developer with strong expertise in semantic modeling, data integration, and enterprise BI architecture. This role will own the end-to-end Power BI lifecycle—from data integration and modeling through dashboard development, deployment, and governance.
The ideal candidate combines hands-on Power BI development (70%) with data architecture and integration design (30%), and can deliver high-quality, user-centric dashboards backed by scalable, well-architected data models.
Key Responsibilities - Power BI Development & UX
Design and develop high-impact, executive-ready dashboards and reports with strong focus on usability and storytelling.
Build and maintain reusable Power BI semantic models (datasets) using best-practice dimensional modeling (star schema).
Develop advanced DAX measures, calculations, and time-intelligence logic.
Key Responsibilities - Data Integration & Pipeline
Integrate data from Azure Synapse, enterprise data warehouses, and reference data marts.
Design and contribute to ETL/data pipeline solutions using ADF, SSIS, and other integration tools.
Support data movement and integration patterns from systems such as Profisee into downstream reporting layers.
Key Responsibilities - Architecture & Performance
Define and implement end-to-end BI architecture across ingestion → modeling → reporting.
Optimize performance using techniques such as aggregations, incremental refresh, and query optimization.
Make design decisions around Import vs DirectQuery, composite models, and data latency tradeoffs.
Key Responsibilities - Power BI Platform & Governance
Architect and manage Power BI Service components including workspaces, datasets, and deployment pipelines (Dev/UAT/Prod).
Implement security and governance best practices (Row-Level Security, dataset certification, access controls).
Monitor and maintain reporting environments including data refresh, usage, and performance.
Key Responsibilities - Collaboration & Delivery
Partner with business and technology teams to translate requirements into scalable BI solutions.
Contribute to data modeling and architecture using ERwin or similar tools.
Ensure data quality, consistency, and alignment with enterprise data standards.
Required Qualifications
5+ years of hands-on experience with Power BI development and data visualization.
Strong expertise in Power BI semantic modeling, DAX, and dimensional modeling.
Experience with Azure Synapse, data warehouses, and data marts.
Hands-on experience with ADF and/or SSIS for data pipelines.
Strong SQL skills and understanding of relational data modeling.
Experience designing and supporting end-to-end BI/reporting solutions.
Preferred Qualifications
Experience with Power BI Service architecture (workspaces, pipelines, governance).
Exposure to Profisee or other MDM platforms.
Familiarity with Power BI DevOps and deployment automation.
Experience with large-scale / enterprise BI environments.
Exposure to Microsoft Fabric or modern Azure analytics stack.
Work Allocation
70% Development (Power BI reports, datasets, DAX, UX).
30% Architecture (data pipelines, modeling, platform design).
Peterson Technology Partners (PTP) is an Equal Opportunity Employer committed to creating a transparent, inclusive, and human-centered hiring experience.
For more than 28 years, PTP has operated as one of the top IT staffing and recruiting firms in the USA—built on trust, long-term partnerships, and technical excellence.
Based in the Chicago suburb of Park Ridge, IL, our team of more than 500 employees and consultants is dedicated to:
As part of that commitment, we believe in providing clear information about how our hiring technologies work and how your data is used. The following section outlines our AI-assisted interview process and your rights as a candidate.
To provide a consistent, fair, and flexible experience for all candidates, we use AI-assisted tools to support parts of the interview process. This includes our proprietary AI platform Pete & Gabi, which includes AI recruiter Rebecca.
These AI hiring tools help us:
Please note that:
If you prefer a non-AI interview format, we will gladly provide an alternative.
When applying for certain tech jobs, you may participate in:
We will always explain what to expect in advance so you can prepare with confidence.
Every candidate’s profile—including interviews, conversations, and assessments—is reviewed by experienced recruiters and hiring leaders.
AI insights may assist with organization and evaluation, but final decisions are always human-driven.
At PTP, every candidate has the right to:
Our goal is to ensure you feel respected, informed, and supported throughout your experience.
For more than 28 years, PTP has focused on putting people first—candidates, consultants, employees, and clients.
We’re committed to a hiring process that is:
Welcome to the future of hiring at Peterson Technology Partners.
We’re excited to learn more about you.
Peterson Technology Partners is an Equal Opportunity Employer. All qualified applicants will receive consideration without regard to race, color, religion, national origin, gender identity, sexual orientation, disability, veteran status, or any other protected characteristic.
