Associate Business Intelligence Analyst enhancing credit risk decision - making through analysis and reporting. Developing dashboards and preparing risk management reports for lending businesses.
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 BI Specialist developing Power BI reports, dashboards, and KPI scorecards for Brillio. Collaborating with users to gather requirements and ensure data accuracy.
Senior Business Intelligence Analyst at TD supporting risk management and compliance initiatives. Delivering BI solutions and collaborating with stakeholders for informed decision - making.
Junior Teamlead BI Consultant leading Data & Cloud consulting projects in Switzerland. Managing responsibilities for enterprise clients and collaborating with international teams in the BI sector.
Intermediate BI Developer maintaining BI solutions and delivering BI development initiatives in managed services team. Collaborating with clients to enhance BI environments and ensure data quality.
BI Specialist designing and developing data integration and reporting solutions using Microsoft BI tools. Collaborating with stakeholders in Bangalore to deliver enterprise - level analytics and dashboards.
BI Specialist developing Power BI reports and dashboards for business intelligence solutions. Collaborating with clients and internal teams to deliver effective analytics.
Lead Developer for Business Intelligence at Transamerica, spearheading database solutions and analytics product development. Directing BI projects with a focus on data warehousing and visualization tools.
Commercial Excellence BI Analyst responsible for designing Power BI solutions and transforming data into insights for strategic business decisions. Collaborating with teams to enhance sales productivity and analytics.
Power BI Developer transforming complex data into actionable insights at Allucent. Collaborate with analysts to develop Power BI dashboards and reports for the biopharmaceutical industry.