PurposeBuilt Brands · 1 month ago
Sr. BI Analyst & Data Infrastructure Dev
Gurnee, IL, US
Full-time
Hybrid
Senior Level
$132K/yr - $147K/yr
5+ years expPurposeBuilt Brands is a pioneer in crafting top-tier products for specialty surfaces. The Sr. BI Analyst & Data Infrastructure Developer role involves designing and maintaining a unified data architecture to support enterprise reporting and analytics, utilizing strong data engineering and SQL skills.
CommercialConsumer Goods
Responsibilities
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
Build and troubleshoot ETL/ELT processes using SSIS and Fabric dataflows
Understand when to materialize data in the warehouse vs. using views
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 discussions across business and technology teams 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
Qualification
Required
5-7 years of experience in business intelligence, data architecture and consolidation, ETL/ELT, SQL (CTEs, Stored procedures, dynamic SQL)
DAX: Intermediate to advanced proficiency for model design and performance tuning
ERP Systems: Experience integrating data from any major ERP (Syspro experience a plus)
Expert level knowledge and understanding of Power BI (certification preferred) dashboard creation and customization
AI / ML: Conceptual understanding of agent-based and predictive models preferred
Cloud and Data platforms experience – Microsoft Fabric, Azure Data Services
Bachelor's degree in Data Science, Analytics or a related field with Finance and Accounting background (Master's/MBA is a plus)
Proven ability to collaborate effectively with senior finance and business leaders
Preferred
Power BI certification
MS Fabric certification
Benefits
Flexible work options (fully remote, hybrid, onsite)
Generous paid time off
Competitive salaries and bonus incentives
401K company match
Competitive medical, dental, & vision insurance
Pet insurance
Annual fitness stipend
Unmatched employee discount on all products
Summer Hours
LinkedIn learning membership
Company
PurposeBuilt Brands
PurposeBuilt Brands is a leading consumer and commercial brands whose products are built to tackle tough challenges on specialty surfaces.
201-500 employees
Funding
Current Stage
Growth StageTotal Funding
unknown2022-02-02Secondary Market
Leadership Team
Michael Ragen
CFO / COO
Chad Hansen
Chief E-Commerce, Innovation, and New Ventures Officer
Recent News
Company data provided by crunchbase