Senior Associate - Data Engineer - Data Warehouse Solutions

Oaktree Capital Management, L.P.; Hyderabad; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Oaktree Capital Management, L.P. is seeking an Associate Data Engineer to join the Data Solutions team.

You will build, maintain, and support data warehouses, calibration of holiday calendars, GL accounting, holdings, transactions and performance attribution data within the investment management domain. The role requires hands-on data warehousing, dbt transformations, Azure job monitoring, and CI/CD release management, collaborating with US‑based teams.

Qualifications

• 6+ years of data engineering experience, preferably in the financial domain.
• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field.
• Hands‑on experience with data warehousing concepts, including dimensional modeling and reporting data marts.
• Experience with Azure Data Factory, dbt, and MS SQL Server.

Responsibilities

• Develop data warehouse solutions, including dimensional models and data marts.
• Monitor Azure jobs and pipelines, identify failures and performance issues.
• Fix data pipelines and perform root‑cause analysis for issues.
• Build transformations with dbt and validate transformed datasets.
• Develop data pipelines using Azure Data Factory and ETL/ELT tools.
• Write and optimize SQL queries and stored procedures in MS SQL Server.
• Maintain GitHub repository, manage PRs, reviews, and hygiene.
• Manage Jira tickets, sprint progress, estimation, and requirements.
• Support CI/CD pipelines and release management with Azure DevOps and Git.
• Perform unit/integration/regression testing and data validation.
• Own production support for attribution reporting and master data platforms.
• Collaborate with performance, attribution, analytics and operations teams.
• Prepare technical docs, runbooks, and release notes.
• Follow secure coding and data governance standards.

Skills

Data warehousing

Azure

dbt

MS SQL Server

GitHub

Jira

CI/CD

Azure DevOps

Education

Bachelor's degree

Tools

Azure Data Factory

Azure Functions

Job description

Our Company 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.

Key Responsibilities

• 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.

Required Qualifications

• 6+ years of professional software engineering / data engineering experience, preferably in the financial or investment management domain.
• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field.
• Hands‑on experience with data warehousing concepts, including dimensional modeling, fact/dimension tables, and reporting data marts.
• Experience monitoring and troubleshooting jobs/pipelines on Azure (e.g., Azure Data Factory, Azure Functions, Logic DBT transformations, triggers, Apps, or similar).
• Practical experience with dbt for data transformations, testing, and validation.
• Strong experience with MS SQL Server, including complex SQL, stored procedures, and query optimization.
• Experience maintaining GitHub repositories, including branching strategies, pull requests, and code reviews.
• Working knowledge of Jira for sprint tracking, estimation, and delivery in an Agile/Scrum environment.
• Experience with CI/CD and release management using Azure DevOps and Git.
• Strong troubleshooting, analytical, and issue/bug resolution skills.
• Good written and verbal communication skills, with the ability to collaborate with US‑based teams and business stakeholders.

Preferred Skills

• Prior experience in the investment/asset management or broader financial services domain.
• Exposure to performance attribution, benchmark/index data, or security master data.
• Experience with Power BI or similar tools for reporting and validation support.
• Familiarity with Azure cloud services such as Storage Account, Key Vault, or Service Bus.
• Experience with AI‑assisted development tools (e.g., GitHub Copilot, Claude Codex) to improve productivity and code quality.

Role Expectations

• Operate as a hands‑on associate engineer, with the majority of time focused on coding, monitoring, issue resolution, and technical implementation.
• Work from documented Jira requirements, proactively clarifying ambiguity and raising risks early.
• Maintain a strong production support mindset, including accountability for data accuracy, stability, and timely issue resolution.
• Collaborate effectively with distributed teams and provide overlap with PST morning hours( 1 PM – 10 PM IST) for US‑based stakeholder engagement.

At Oaktree, we focus on hiring individuals with intelligence, dedication, team spirit, integrity and a strong work ethic. We welcome the opportunity to speak with talented professionals who have relevant credentials and experience in investments, marketing and client relations, accounting, legal, compliance, information technology, administrative support and other relevant areas.

Equal Opportunity Employment Policy

Oaktree is committed to diversity and to equal opportunity employment. Oaktree does not make employment decisions on the basis of race, creed, color, ethnicity, national origin, citizenship, religion, sex, sexual orientation, gender identity, gender expression, age, past or present physical or mental disability, HIV status, medical condition as defined by state law (genetic characteristics or cancer), pregnancy, childbirth and related medical conditions, veteran status, military service, marital status, familial status, genetic information, domestic violence victim status or any other classification protected by applicable federal, state and local laws and ordinances. This policy applies to hiring, placement, internal promotions, training, opportunities for advancement, recruitment advertising, transfers, demotions, layoffs, terminations, recruitment advertising, rates of pay and other forms of compensation and all other terms, conditions and privileges of employment. This policy applies to all Oaktree applicants, employees, clients, and contractors. Staff members wishing to report violations or suspected violations of this policy should contact the head of their department or Human Resources.

Additional Note for Positions Based in Los Angeles

For those applying for a position in the city of Los Angeles, the firm will consider for employment qualified applicants with a criminal history in a manner consistent with applicable federal, state and local law.