Associate - Data Engineer - Data Warehouse Solutions

Oaktree; Hyderabad; Hybrid; INR 800,000 - 1,400,000; Full time

Job summary

Oaktree, part of Brookfield, seeks an Associate - Data Engineer for the Data Solutions team. You will build and maintain data platforms including holiday calendars, GL accounting, holdings, and performance reporting.

The role emphasizes hands-on data warehousing, Azure job monitoring, dbt transformations, and CI/CD in a collaborative, US‑facing setting. You will work with performance, attribution, portfolio analytics, and operations teams, ensuring data accuracy and reliable production support

Qualifications

• 6+ years of professional software/data engineering experience.
• Bachelor's degree in Computer Science, Engineering, Information Systems, or related field.
• Hands-on experience with data warehousing concepts and dimensional modeling.
• Experience monitoring/troubleshooting Azure data jobs/pipelines.
• Practical experience with dbt for data transformations and validation.
• Strong MS SQL Server experience including advanced queries and stored procedures.
• Experience maintaining GitHub repositories and code reviews.
• Working knowledge of Jira for Agile delivery.
• Experience with CI/CD and release management using Azure DevOps and Git.
• Strong troubleshooting and communication skills.

Responsibilities

• Develop data warehouse solutions with dimensional models and data marts.
• Monitor and optimize Azure data jobs and pipelines.
• Fix issues across data pipelines and reporting components with root-cause analysis.
• Build and maintain data transformations using dbt.
• Develop data pipelines using Azure Data Factory and ETL/ELT tools.
• Write and optimize SQL queries and stored procedures.
• Maintain GitHub repository hygiene and PR reviews.
• Collaborate with stakeholders and manage sprint work in Jira.
• Support CI/CD and release management with Azure DevOps and Git.
• Perform unit/integration testing and data validation; support UAT.
• Provide production support for attribution reporting and data platforms.

Skills

Data warehousing

Azure Data Factory

dbt

MS SQL Server

GitHub

Jira

CI/CD

Azure DevOps

SQL

Production support

Education

Bachelor's degree in CS/Engineering

Tools

Azure

Git

Power BI

Job description

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/

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.

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.

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.

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.

Requirements: