Business Intelligence Solutions Developer

Join our team as a BI Solutions Developer, where you will play a key role in designing, developing, and supporting business intelligence and data solutions across the Firm. This role works across the BI lifecycle, including data transformation, data modeling, reporting, visualization, automation, and AI-enabled solutions.

You will work closely with business departments and technical teams to transform trusted enterprise data into intuitive, visually compelling solutions that tell a story with the data and make information easier to understand and use. Using Microsoft Fabric, Power BI, and related technologies, you will support the Firm’s enterprise data strategy while promoting BI standards and enabling departments to develop effective solutions through citizen development.

RESPONSIBILITIES Business Intelligence & Data Visualization
• Design and develop intuitive, visually compelling Power BI reports and dashboards that tell a story with the data, clearly communicate key insights, and support business decision-making.
• Translate business requirements and trusted enterprise data into practical BI solutions that make complex information easy to understand and use.
• Develop and maintain semantic models, DAX calculations, Power Query transformations, and reusable reporting components.
• Apply strong visual design, user experience, and attention to detail to create polished, consistent, and professional BI solutions.
• Maintain, modernize, optimize, and support new and existing reports, dashboards, semantic models, refresh processes, and data connections.

Microsoft Fabric & Data Transformation
• Use Microsoft Fabric as the primary low-code platform for developing data transformation, integration, analytics, and BI solutions.
• Develop and maintain Dataflows Gen2 and related Fabric components to prepare, cleanse, combine, and transform enterprise data for reporting and analytics.
• Create downstream Fabric data solutions, including lake houses and reusable transformations, using trusted data from the Firm’s Enterprise Data Model.
• Use Fabric pipelines, One Lake, Lakehouse, Warehouse, and related capabilities as appropriate to develop scalable and maintainable BI solutions. Apply data quality and validation practices and identify transformations or business rules that should be transitioned to Data Engineering for implementation within the enterprise data layer.

Enterprise Data & Integration
• Use the Firm’s Enterprise Data Model as a primary source of trusted, consistent data for BI, analytics, AI, and reporting solutions.
• Maintain a strong working understanding of enterprise data architecture, including Azure Data Lake, data pipelines, integration, transformation, dimensional modeling, and related data engineering concepts.
• Collaborate closely with Data Engineers and application developers to understand enterprise data structures and define data requirements for BI and analytical solutions.
• Recognize when data requirements extend beyond the BI and low-code layer and work with Data Engineering to develop appropriate enterprise-level solutions.
• Integrate data from enterprise applications, databases, APIs, SharePoint, files, and other approved sources when required to support business solutions.

AI & Automation
• Develop and support AI-enabled BI and data solutions using Microsoft Fabric, Copilot, Data Agents, and related technologies.
• Develop and support data agents that allow users and business solutions to interact with trusted enterprise data through intuitive, AI-enabled experiences.
• Collaborate with Data Engineers, developers, and business teams to identify and prepare the data required for AI and agent-based solutions.
• Develop workflow and data automation solutions using Power Automate,…