PurposeBuilt Brands
Sr. BI Analyst & Data Infrastructure Dev
PurposeBuilt Brands, Gurnee, Illinois, United States, 60031
Sr. BI Analyst & Data Infrastructure Dev
Join to apply for the
Sr. BI Analyst & Data Infrastructure Dev
role at
PurposeBuilt Brands .
PurposeBuilt Brands, rooted in a legacy dating back to Weiman, is a pioneer in crafting top‑tier products for specialty surfaces. Our beloved brands include Weiman, Goo Gone, Green Gobbler, Biokleen, Gonzo, Magic, Wright’s, Stone Care International, Urnex, Five Star, and Micro‑Scientific.
At PBB, we hire employees with engagement, drive, and performance that push business forward. We work together and are motivated by positive results while thriving in a scrappy environment. Our greatest assets are talented, passionate employees motivated by purposeful work.
The Role
This role designs, builds, and maintains a unified data architecture within Microsoft Fabric to support enterprise reporting and analytics. It combines strong data engineering, SQL, and Power BI skills to integrate diverse data sources into a single, trusted model. The individual develops ETL pipelines, optimizes semantic models, and collaborates with finance and business teams to deliver accurate, scalable insights that drive data‑informed decision‑making across the organization.
What You Will Do
Design and implement a unified data model consolidating seven existing semantic models into a single Microsoft Fabric‑based architecture.
Analyze legacy data structures and define optimal integration and migration strategies.
Develop and manage measures, facts, and dimensions aligned with business needs.
Define partitioning, refreshing, and performance optimization strategies.
Maintain metadata, data dictionaries, and data lineage documentation.
ETL/ELT Development & Maintenance
Build and troubleshoot ETL/ELT processes using SSIS and Fabric dataflows.
Determine when to materialize data in the warehouse versus using views.
SQL Development
Write, debug, and optimize complex SQL queries, including stored procedures, CTEs, unions, and dynamic SQL.
Maintain and evolve SQL views supporting downstream analytics and reporting.
Partner with business stakeholders to enhance and scale custom financial and operational reporting solutions.
Translate finance and executive reporting requirements into scalable, technical data solutions.
Support cross‑team discussions to align with long‑term goals.
Develop, maintain, and optimize Power BI semantic models and datasets.
Deploy BI solutions using Visual Studio Code, Tabular Editor, and Azure DevOps pipelines.
Support Power BI paginated reports and advanced DAX calculations.
What You Will Bring
5–7 years of experience in business intelligence, data architecture and consolidation, ETL/ELT, SQL (CTEs, stored procedures, dynamic SQL).
Intermediate to advanced proficiency in DAX for model design and performance tuning.
Experience integrating data from major ERP systems (Syspro experience a plus).
Expert knowledge of Power BI (certification preferred) for dashboard creation and customization.
Conceptual understanding of AI/ML agent‑based and predictive models.
Experience with Microsoft Fabric and Azure Data Services.
Education & Qualifications
Bachelor’s degree in Data Science, Analytics, or a related field with Finance and Accounting background (Master’s/MBA is a plus).
Power BI certification.
Microsoft Fabric certification.
Proven ability to collaborate effectively with senior finance and business leaders.
Compensation Range
$132,300–$147,000
What We Offer
Flexible work options (fully remote, hybrid, onsite).
Generous paid time off.
Competitive salaries and bonus incentives.
401(k) company match.
Annual fitness stipend.
Unmatched employee discount on all products.
Summer Hours.
LinkedIn Learning membership.
You are an equal opportunity employer. PurposeBuilt Brands is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other characteristic protected by law.
Seniority level : Mid‑Senior level
Employment type : Full‑time
Job function : Research, Analyst, and Information Technology
Industries : Manufacturing
#J-18808-Ljbffr
Sr. BI Analyst & Data Infrastructure Dev
role at
PurposeBuilt Brands .
PurposeBuilt Brands, rooted in a legacy dating back to Weiman, is a pioneer in crafting top‑tier products for specialty surfaces. Our beloved brands include Weiman, Goo Gone, Green Gobbler, Biokleen, Gonzo, Magic, Wright’s, Stone Care International, Urnex, Five Star, and Micro‑Scientific.
At PBB, we hire employees with engagement, drive, and performance that push business forward. We work together and are motivated by positive results while thriving in a scrappy environment. Our greatest assets are talented, passionate employees motivated by purposeful work.
The Role
This role designs, builds, and maintains a unified data architecture within Microsoft Fabric to support enterprise reporting and analytics. It combines strong data engineering, SQL, and Power BI skills to integrate diverse data sources into a single, trusted model. The individual develops ETL pipelines, optimizes semantic models, and collaborates with finance and business teams to deliver accurate, scalable insights that drive data‑informed decision‑making across the organization.
What You Will Do
Design and implement a unified data model consolidating seven existing semantic models into a single Microsoft Fabric‑based architecture.
Analyze legacy data structures and define optimal integration and migration strategies.
Develop and manage measures, facts, and dimensions aligned with business needs.
Define partitioning, refreshing, and performance optimization strategies.
Maintain metadata, data dictionaries, and data lineage documentation.
ETL/ELT Development & Maintenance
Build and troubleshoot ETL/ELT processes using SSIS and Fabric dataflows.
Determine when to materialize data in the warehouse versus using views.
SQL Development
Write, debug, and optimize complex SQL queries, including stored procedures, CTEs, unions, and dynamic SQL.
Maintain and evolve SQL views supporting downstream analytics and reporting.
Partner with business stakeholders to enhance and scale custom financial and operational reporting solutions.
Translate finance and executive reporting requirements into scalable, technical data solutions.
Support cross‑team discussions to align with long‑term goals.
Develop, maintain, and optimize Power BI semantic models and datasets.
Deploy BI solutions using Visual Studio Code, Tabular Editor, and Azure DevOps pipelines.
Support Power BI paginated reports and advanced DAX calculations.
What You Will Bring
5–7 years of experience in business intelligence, data architecture and consolidation, ETL/ELT, SQL (CTEs, stored procedures, dynamic SQL).
Intermediate to advanced proficiency in DAX for model design and performance tuning.
Experience integrating data from major ERP systems (Syspro experience a plus).
Expert knowledge of Power BI (certification preferred) for dashboard creation and customization.
Conceptual understanding of AI/ML agent‑based and predictive models.
Experience with Microsoft Fabric and Azure Data Services.
Education & Qualifications
Bachelor’s degree in Data Science, Analytics, or a related field with Finance and Accounting background (Master’s/MBA is a plus).
Power BI certification.
Microsoft Fabric certification.
Proven ability to collaborate effectively with senior finance and business leaders.
Compensation Range
$132,300–$147,000
What We Offer
Flexible work options (fully remote, hybrid, onsite).
Generous paid time off.
Competitive salaries and bonus incentives.
401(k) company match.
Annual fitness stipend.
Unmatched employee discount on all products.
Summer Hours.
LinkedIn Learning membership.
You are an equal opportunity employer. PurposeBuilt Brands is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other characteristic protected by law.
Seniority level : Mid‑Senior level
Employment type : Full‑time
Job function : Research, Analyst, and Information Technology
Industries : Manufacturing
#J-18808-Ljbffr