Senior Associate - Data Engineer - Data Warehouse Solutions

Overview

Join Oaktree's Data Solutions team as an Associate Data Engineer, building and supporting static data (holiday calendar, GL accounting, holdings, transactions, performance attribution reporting and index/master data platforms) within the investment management domain.

What you'll do

• Develop data warehouse solutions, including dimensional models, fact/dimension structures, reporting data marts, and historical data handling.
• Monitor Azure jobs and pipelines regularly, 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, integration, and 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.

What you'll need

• 6+ years of professional software engineering or 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 Apps, triggers, 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.

Nice to have

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

Details

• Location: Hyderabad.
• Work mode: Hybrid (3 days in office / 2 days remote).
• Shift timings: 1PM–10PM or 2PM–11PM IST.
• Overlap with PST morning hours (1 PM – 10 PM IST) for US-based stakeholder engagement.