This role is directly responsible for designing, building, and optimizing the data infrastructure that powers Northleaf’s analytics and reporting capabilities. This role is hands-on and execution-focused, requiring deep technical expertise in Azure and Microsoft data platforms to deliver scalable, secure, and high-performing solutions. This role is a critical enabler of Northleaf’s data-driven transformation, directly supporting its growth strategy and commitment to delivering differentiated insights.

Data Architecture & Solution Design

• Design and deploy analytics solutions that are tightly integrated within the Enterprise Data warehouse architecture, ensuring performance, security, and scalability across Microsoft and cloud-native platforms.
• Construct and evolve enterprise data models using Kimball, Data Vault, or 3NF to support analytical and operational needs.
• Apply and implement architectural frameworks (e.g., Zachman) and modeling methodologies (e.g., Inmon) in real-world scenarios.
• Build and manage multi-layered data environments (Raw, Curated, Business) that enable efficient data flow and usability.

Data Integration

• Develop and maintain robust, reusable data pipelines using Azure Synapse, Data Factory, Fabric, Logic Apps, and SQL Server.
• Implement and monitor logging frameworks to proactively detect and resolve data reliability issues.
• Collaborate directly with business and technical stakeholders to onboard new data sources and fine-tune ingestion processes for performance and scalability.
• Ensure alignment of data integration efforts with enterprise data modeling standards and warehouse architecture to support analytics, reporting, and regulatory needs.

Dashboard Development & Optimization

• Build and deliver secure, high-performance Power BI dashboards using composite and semantic models tailored to business needs.
• Tune and refactor data models and DAX measures to enhance performance and ensure reusability across reports.
• Apply and enforce security protocols (RLS, OLS, data masking), access controls, and auditing mechanisms.
• Manage and troubleshoot Power BI datasets, refresh schedules, and service reliability.
• Mentor junior developers and stay current with Power BI advancements.

Data Security and Compliance

• Implement and enforce sensitive data handling protocols, including row, column, and object-level security.
• Apply and maintain access control policies, encryption standards, and data loss prevention (DLP) measures to ensure compliance and data integrity.

Qualifications

• 10+ years in data analytics and architecture, with 7+ years in hands-on data/solution architecture roles focused on data modeling, integration, metadata/master data management, and the design of business intelligence and analytics solutions.
• Expertise in Azure services (Synapse, Data Factory, Key Vaults, Power BI, Dev Ops, Fabric, Logic Apps, SQL Server) and Microsoft SQL Stack (TSQL, Power Query, MDX, DAX).
• Extensive experience troubleshooting and resolving complex issues related to Power BI reports, dashboards, and semantic models. Proven ability to write complex measures in DAX and optimize data models.
• Excellent problem-solving, analytical, and communication skills.
• Bachelor’s or Master’s degree in Computer Science, IT, or related field.
• Preferred Qualifications: finance knowledge/background; experience with other BI tools (Tableau, Qlik); certification in Power BI or related technologies

What Sets Us Apart

At Northleaf Capital Partners, you’ll be joining a leading global private markets investment firm with a differentiated platform across mid-market private equity, private credit, and infrastructure. Our integrated approach and long-term perspective have made us a partner of choice to a global base of institutional investors – and that begins with our exceptional team of professionals.

At our core, our culture is built on the foundation of trust, openness, respect, integrity, and professionalism. These values guide every interaction with our investors, our partners, and one another. We are focused on building long-term relationships and creating a collaborative, professional environment where everyone feels supported and valued.

We foster a collegial and non-hierarchical workplace where ideas are valued, decision-making is grounded in data, and individuals are empowered to contribute meaningfully. Our success depends on an engaged and inclusive workforce, and we invest in fostering that culture. We celebrate the diverse backgrounds, perspectives, and experiences of our team members and are committed to ensuring a workplace built on inclusion and shared success.

We celebrate achievements, encourage teamwork, and work hard to cultivate a sense of community to achieve strong results. Our competitive total rewards package features an employer-funded benefits plan, an attractive retirement offering, which includes a group retirement plan and the ability to invest in Northleaf funds on a no fee/no carry basis, and a range of valuable perks such as fitness and wellness reimbursement, charitable donation matching, and tuition assistance. We also support flexible working arrangements, with up to two remote days per week and the option for fully remote for up to two weeks per year.

Location

Toronto, Canada.

Contact

Interested candidates are asked to apply on Northleaf Careers. Only those selected to be interviewed will be contacted.

Northleaf Capital Partners is committed to providing an inclusive and accessible candidate experience. Should you require accommodations during the selection process, please do not hesitate to let us know and suitable arrangements will be made.

About Northleaf Capital Partners

Northleaf is a global private markets investment firm focused on mid-market companies and assets. With more than US$28 billion in capital commitments raised to date, Northleaf has an established, long-term track record as an investor in private equity, private credit and infrastructure globally.

Northleaf’s 275-person team, located in Toronto, Chicago, London, Los Angeles, Melbourne, Menlo Park, Montreal, New York, Seoul and Tokyo, is focused exclusively on sourcing, evaluating and managing private markets investments. Northleaf manages closed and open-end funds across a range of global private markets strategies and a series of separately managed accounts with customized investment strategies tailored to meet the specific needs of leading institutional investors and family offices. As part of its ambitious growth strategy, Northleaf is also developing specific private markets products and investment solutions for insurance and wealth management clients.