Senior Associate/AVP, Risk & Reporting

Responsibilities

• Build, extend, and maintain the ABF Power BI environment within the established architecture, with a primary focus on collateral performance, credit metrics, exposure analysis, and fund-level reporting
• Implement and evolve Power BI solutions in Microsoft Fabric using a template-based, reusable approach (common data models, common measures, standardized layouts, and consistent navigation), so that new pages and dashboards can be added without rebuilding from scratch
• Partner with the ABF deal team in working sessions and embedded engagements (including borrower calls and vendor data validation where relevant) to understand the decisions the dashboards need to support, validate outputs against business needs, and iterate based on live feedback
• Write efficient SQL queries, DAX measures, and Power Query (M) scripts to support analytical models, ad-hoc analyses, and recurring deliverables
• Develop PySpark notebooks within Microsoft Fabric and Azure environments for data transformation, automation, and large-scale data processing
• Build and maintain Fabric dataflows, pipelines, and Azure-based data engineering workflows (Azure Data Factory, Synapse, Data Lake Storage) to support scalable, secure, and high-performing data solutions
• Design and enforce semantic model security, including Row-Level Security (RLS) and Object-Level Security (OLS), to protect sensitive deal and investor data
• Balance flexibility with control by defining what each visual represents, scheduling appropriate refresh cadences, and constraining user interactions that could lead to misleading conclusions
• Ensure data integrity, accuracy, and consistency across reporting platforms, with a non-negotiable bar on data model foundations, data validation, and clear naming and documentation
• Contribute to BI strategy, governance standards, and adoption of best practices across the R&R function, partnering closely with the strategy lead to surface trade-offs and work through requests that may compromise scalability, maintainability, or correctness

Qualifications

• 4 to 8+ years of experience in data analytics and BI development on cloud platforms, ideally within asset management, financial services, or another data-rich domain with comparable rigor
• Exposure to alternative investments required; asset-based finance, structured credit, or private credit experience strongly preferred
• Proficiency in Microsoft Fabric for developing data pipelines, dataflows, Lakehouse, and data warehouse solutions
• Strong Power BI development skills, including DAX, Power Query (M), semantic modeling, and paginated reports
• Experience with SQL and SQL Server Management Studio (SSMS) for querying, data modeling, and performance optimization
• Proficiency in Python for data analysis, automation, and notebook-based development
• Hands-on experience with PySpark for distributed data processing within Fabric, Databricks, or Synapse Spark environments
• Working knowledge of the broader Azure data stack, including Azure Data Factory, Azure Synapse Analytics, Azure Data Lake Storage, and Azure DevOps
• Understanding of data governance, reporting standards, and compliance frameworks