Senior Associate - Data Engineer - Data Warehouse Solutions

As a part of Brookfield’s $416B credit platform, Oaktree is a premier credit manager emphasizing an opportunistic, value-oriented, and risk-controlled approach to investing across credit, equity, and real estate.  Oaktree is committed to cultivating an environment that is collaborative, curious, inclusive and honors diversity of thought. Providing training and career development opportunities and emphasizing strong support for our local communities through philanthropic initiatives are essential to our culture.  Oaktree is wholly owned by Brookfield, a leading global investment firm with more than $1 trillion in assets under management. Brookfield owns and operates high-quality businesses and real assets that provide essential services and form the backbone of the global economy. It invests on behalf of institutions and individuals around the world across infrastructure, renewable power and transition, private equity, real estate, and credit. For additional information, please visit Oaktree’s website at http://www.oaktreecapital.com/ Work Mode: Hybrid (3/2) Shift timings: 1PM-10PM or 2PM-11PM Role Summary The Associate - Data Engineer – Data Solutions, will join the Data Solutions team and contribute to building, maintaining, and supporting static data such as holiday calendar, GL accounting, Holdings, transactions, performance attribution reporting and index/master data platforms within the investment management domain. The role requires hands-on experience with data warehousing, Azure job monitoring, dbt-based transformations and data validations, issue/bug fixing, GitHub repository maintenance, Jira-based agile delivery, and CI/CD release management. The candidate should be comfortable working from documented requirements, resolving production issues, and collaborating closely with US-based teams and business stakeholders in the financial domain.

Develop data warehouse solutions, including dimensional models, fact/dimension structures, reporting data marts, and historical data handling. Monitor Azure jobs and pipelines on a regular basis, proactively identifying failures, delays, or performance issues and driving them to resolution. Perform issue and bug fixing across data pipelines, reporting components, and platform applications, including root-cause analysis and permanent fixes. Build and maintain data transformations and validation logic using dbt, ensuring accuracy, consistency, and reliability of transformed datasets. Develop and support data pipelines using Azure Data Factory and internal/custom ETL/ELT tools . Write and optimize SQL queries, stored procedures, and data processing logic in MS SQL Server. Maintain and administer the GitHub code repository, including branching, pull requests, code reviews, merge conflict resolution, and repository hygiene. Manage day-to-day work using Jira, including updating tickets, tracking sprint progress, estimating effort, and clarifying requirements with stakeholders. Support CI/CD pipelines and release management activities using Azure DevOps and Git , including build/deployment automation and environment coordination. Perform unit testing, integration testing, regression testing, data validation, and reconciliation checks; support UAT with business users. Own production support activities for attribution reporting and index/master data platforms, including troubleshooting, data issue resolution, and release support. Interact with business teams such as performance, attribution, portfolio analytics, and operations to clarify requirements and resolve data issues. Prepare and maintain technical documentation, runbooks, production support procedures, and release notes. Follow secure coding practices, data governance standards, and audit/control requirements appropriate for financial and investment reporting platforms.

6+ years of professional software engineering / data engineering experience, preferably in