Data Business Intelligence (BI) & Power BI Analyst driving decision - making with data insights. Develop dashboards and reports while collaborating with stakeholders for effective data solutions.
About the role
- BI Analyst designing data architecture using Microsoft Fabric for PurposeBuilt Brands. Responsible for building ETL pipelines and optimizing reporting solutions with Power BI.
Responsibilities
- Lead Data Architecture Initiatives: 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.
- Understand when to materialize data in the warehouse vs. 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.
- Collaboration & 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.
- Semantic Model Management: 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.
Requirements
- 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)
- 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).
- Power BI certification
- MS Fabric certification
- Proven ability to collaborate effectively with senior finance and business leaders
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
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Business Intelligence Analyst identifying trends and opportunities to increase profits and efficiency for Cayuse. Collaborate with teams to develop and maintain data - driven insights and dashboards.
Senior Business Intelligence Developer at C.H. Robinson modernizing data solutions for Global Forwarding. Collaborating with cross - functional teams to develop actionable insights and advance analytics capabilities.
Data Intelligence Analyst supporting data - driven decision - making for business expansion at Kovi. Collaborating on BI solutions to drive strategic insights across different cities.
Business Intelligence Analyst leveraging analytics to support decision - making at FCC. Developing risk - focused analytics using credit risk and portfolio data across various teams.
Technical BI Consultant building modern BI platforms and data solutions for clients at NORRIQ. Collaborating to translate business requirements into effective technical solutions with a focus on delivery and quality.
Sr. Business Intelligence Analyst at BECU, shaping data solutions for decision - making. Collaborating across teams to deliver robust enterprise BI solutions and improve member experience.
BI Developer coordinating IT projects and analyzing requirements in an engineering firm. Flexible remote work options and strong benefits in a family - driven environment in Italy.
Business Intelligence Analyst at HPE transforming data insights into business solutions. Collaborating with teams for data analysis and developing automated workflows.
Business Intelligence Analyst managing analytics initiatives to support manufacturing and operational needs at Applied Materials. Building dashboards and converting business needs into analytic strategies.