BI Developer reviewing data and metrics on insider and cyber risks for SMBC at a hybrid workplace. Building visualizations and reports to foster security within the organization.
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
Senior Manager driving business intelligence initiatives for Snap’s Small & Mid - sized Clients business. Leading analytics team to transform insights into data - driven actions across Go - To - Market and Sales strategies.
Lead PowerBI Developer managing analytics solutions for People Analytics unit at Novo Nordisk. Collaborate across teams to drive data quality and decision - making through insights.
Mid - Level Business Intelligence Analyst transforming data into actionable insights at Boeing. Collaborating with teams to improve business performance and validate data accuracy.
Business Intelligence Analyst creating strategic reports for a leading technology company. Collaborating cross - functionally to enhance business decision - making and performance metrics.
Power BI Consultant focused on designing and developing reports and dashboards. Collaborating with clients to transform data sets for business insights.
(Senior) BI Consultant leading and implementing advanced BI projects for diverse clients in Switzerland. Focusing on Microsoft technologies and cloud solutions with teamwork and problem - solving.
Business Intelligence Developer designing and implementing BI solutions for energy management provider in Bulgaria. Collaborating with stakeholders to shape architecture and support project lifecycles.
Business Intelligence Analyst at adjoe GmbH utilizing SQL and Python, improving APAC ad tech operations and collaboration across teams.
Business Intelligence Analyst designing dashboards and actionable insights for stakeholders in mobile games. Collaborating with teams to enhance data - driven decision - making.