Define requirements, mappings, and business rules for Fund Accounting data
Profile data and trace breaks with SQL to find root causes
Write test scenarios and coordinate UAT and release validation
Document data lineage, sources of truth, and data dictionaries
Define dashboard and reporting requirements for Centralized Reporting / BI
From the employer’s posting
Define field definitions, measures, calculations, dimensions, filters, hierarchies, business rules, mappings, acceptance criteria, and expected outcomes.
Use SQL and structured analysis to profile data, compare sources, identify anomalies, trace records, quantify breaks, and support root-cause analysis.
Develop and execute reconciliation, integration, regression, edge-case, reporting, and production-validation test scenarios as part of the broader delivery team.
Develop source-to-target mappings, data dictionaries, process flows, requirements, and traceability artifacts in collaboration with the teams responsible for implementation.
Convey agreed business requirements to Centralized Reporting / BI, which owns the technical build and delivery of scalable dashboards and reporting solutions using governed data.
Experience Required: 3 to 8 years in a technical data analyst, data-focused business analyst, financial data, accounting technology, or similar role in a controlled enterprise environment.
Strong SQL for profiling, joins, aggregations, reconciliation, anomaly detection, and root-cause analysis, preferably in SQL Server.
Experience defining requirements for dashboards, reports, extracts, downstream applications, operational workflows, or analytics.
Experience with Investran OR Geneva.
Experience defining business, data, reporting, and consumption requirements; mappings; measures; calculations; business rules; acceptance criteria; and test cases.
Ability to understand data models, ETL/ELT flows, APIs or file interfaces, reporting layers, and dependencies across source, data, and consumption layers.
Qualification wording
Experience Required: 3 to 8 years in a technical data analyst, data-focused business analyst, financial data, accounting technology, or similar role in a controlled enterprise environment.
Strong SQL for profiling, joins, aggregations, reconciliation, anomaly detection, and root-cause analysis, preferably in SQL Server.
Experience defining requirements for dashboards, reports, extracts, downstream applications, operational workflows, or analytics.
Experience with Investran OR Geneva.
Experience defining business, data, reporting, and consumption requirements; mappings; measures; calculations; business rules; acceptance criteria; and test cases.
Ability to understand data models, ETL/ELT flows, APIs or file interfaces, reporting layers, and dependencies across source, data, and consumption layers.
Education & alternatives
QUALIFICATIONS
Education: Bachelor's degree in Finance, Accounting, Information Systems, Computer Science, Engineering, Data Analytics, or a related discipline. Equivalent relevant experience will be considered.
Experience Required: 3 to 8 years in a technical data analyst, data-focused business analyst, financial data, accounting technology, or similar role in a controlled enterprise environment.
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
Python
SQL
Azure
Databricks
Excel
Power BI
SQL Server
PySpark
Where the posting names them
Strongly preferred
- Databricks, Python, PySpark, Power BI, Microsoft Fabric, Azure data services, or similar platforms.
- Fund Accounting, asset management, investor data, fund administrator, financial reporting, or investment operations experience.
Data investigation, reconciliation, and testing
- Use SQL and structured analysis to profile data, compare sources, identify anomalies, trace records, quantify breaks, and support root-cause analysis.
- Perform field-level and aggregate analysis to distinguish source, transformation, reference-data, integration, and reporting issues.
Must-have capabilities
- Strong SQL for profiling, joins, aggregations, reconciliation, anomaly detection, and root-cause analysis, preferably in SQL Server.
- Advanced Excel for structured analysis, including lookups, pivots, formulas, comparisons, and controlled validation workbooks.
- Strong SQL for profiling, joins, aggregations, reconciliation, anomaly detection, and root-cause analysis, preferably in SQL Server.
- Advanced Excel for structured analysis, including lookups, pivots, formulas, comparisons, and controlled validation workbooks.
- Experience with Investran OR Geneva.
Complete your application on aresmgmt.wd1.myworkdayjobs.com. The employer’s form will show what is required.
Applying through Workday
You create an account with each employer before you can upload anything. Every Workday employer has its own account, so one sign-up doesn’t carry over.
“Autofill with Resume” comes right after sign-in, before the My Information and My Experience steps. Check every field it fills in those steps, since that’s what recruiters see.
Your application status lives in that employer’s Candidate Home, under the same sign-in.
Over the last 20 years, Ares’ success has been driven by our people and our culture. Today, our team is guided by our core values – Collaborative, Responsible, Entrepreneurial, Self-Aware, Trustworthy – and our purpose to be a catalyst for shared prosperity and a better future. Through our recruitment, career development and employee-focused programming, we are committed to fostering a welcoming and inclusive work environment where high-performance talent of diverse backgrounds, experiences, and perspectives can build careers within this exciting and growing industry.
Job Description
PRIMARY FUNCTIONS & RESPONSIBILITIES
Business process and data understanding
Develop a detailed understanding of how Fund Accounting data is created, enriched, transformed, reviewed, reconciled, approved, and consumed.
Work with Fund Accounting, Data Governance, and Data Product Management to define business problems, intended outcomes, priorities, users, business rules, data ownership, and acceptance criteria.
Identify sources of truth, data owners, business definitions, transformation points, downstream consumers, dependencies, controls, and process handoffs.
Analyze current-state processes and data flows to identify manual work, duplicate logic, data issues, control gaps, and standardization opportunities.
Requirements and business rules
Translate Fund Accounting needs into clear business, data, integration, reporting, and broader consumption requirements for the appropriate delivery teams.
Define field definitions, measures, calculations, dimensions, filters, hierarchies, business rules, mappings, acceptance criteria, and expected outcomes.
Partner with Data Governance and Data Product Management on data ownership, definitions, quality expectations, lineage, control requirements, prioritization, and decision records.
Develop source-to-target mappings, data dictionaries, process flows, requirements, and traceability artifacts in collaboration with the teams responsible for implementation.
Frame requirements clearly enough for the Finance Technology Data Solutions Engineer, Enterprise Data Engineering, Centralized Reporting / BI, and application teams to design, build, test, and deliver solutions that meet business objectives.
Data investigation, reconciliation, and testing
Use SQL and structured analysis to profile data, compare sources, identify anomalies, trace records, quantify breaks, and support root-cause analysis.
Perform field-level and aggregate analysis to distinguish source, transformation, reference-data, integration, and reporting issues.
Partner with Fund Accounting, Data Governance, Data Product Management, engineering, and reporting teams to define validation rules, tolerances, exception categories, ownership, and remediation expectations.
Develop and execute reconciliation, integration, regression, edge-case, reporting, and production-validation test scenarios as part of the broader delivery team.
Create repeatable queries and validation packs that can be reused by the broader team.
Reporting and broader data consumption requirements
Understand the business question, intended consumers, decisions supported, frequency, level of detail, and delivery channel for each consumption need.
Define requirements for dashboards, reports, extracts, downstream applications, operational workflows, analytics, and other ways Fund Accounting consumes data and derives value from it.
Identify governed sources of truth and document measures, calculations, dimensions, filters, business rules, refresh expectations, control expectations, reconciliation needs, and validation criteria.
Convey agreed business requirements to Centralized Reporting / BI, which owns the technical build and delivery of scalable dashboards and reporting solutions using governed data.
Coordinate Fund Accounting review, business validation, UAT, release readiness, and post-production validation for reporting and other consumption solutions.
Delivery and stakeholder partnership
Act as the bridge between Fund Accounting business teams and Finance Technology while preserving important business and technical detail.
Coordinate with Data Product Management, Data Governance, the Finance Technology Data Solutions Engineer, Enterprise Data Engineering, Centralized Reporting / BI, application teams, and delivery partners throughout the delivery lifecycle.
Maintain traceability from the original business problem through requirements, design, testing, release, and validation of the delivered outcome.
Communicate issues clearly, including affected users and data, business impact, evidence, decisions needed, and recommended next steps.
Help convert recurring manual investigation into prioritized backlog items and governed, reusable, scalable data or consumption solutions.
QUALIFICATIONS
Education: Bachelor's degree in Finance, Accounting, Information Systems, Computer Science, Engineering, Data Analytics, or a related discipline. Equivalent relevant experience will be considered.
Experience Required: 3 to 8 years in a technical data analyst, data-focused business analyst, financial data, accounting technology, or similar role in a controlled enterprise environment.
Must-have capabilities
Strong SQL for profiling, joins, aggregations, reconciliation, anomaly detection, and root-cause analysis, preferably in SQL Server.
Advanced Excel for structured analysis, including lookups, pivots, formulas, comparisons, and controlled validation workbooks.
Experience with Investran OR Geneva.
Experience defining business, data, reporting, and consumption requirements; mappings; measures; calculations; business rules; acceptance criteria; and test cases.
Hands-on data-quality analysis, reconciliation, defect investigation, testing, business validation, and UAT.
Ability to understand data models, ETL/ELT flows, APIs or file interfaces, reporting layers, and dependencies across source, data, and consumption layers.
Ability to work effectively with Fund Accounting, Data Product Management, Data Governance, Finance Technology engineering, Enterprise Data Engineering, Centralized Reporting / BI, and application teams.
Strongly preferred
Databricks, Python, PySpark, Power BI, Microsoft Fabric, Azure data services, or similar platforms.
Fund Accounting, asset management, investor data, fund administrator, financial reporting, or investment operations experience.
Working knowledge of accounting balances, transactions, capital activity, reference data, hierarchies, controls, and period-end processes.
Experience defining requirements for dashboards, reports, extracts, downstream applications, operational workflows, or analytics.
Exposure to delivery tooling, structured defect triage, release management, lineage, metadata, governance, and auditability concepts.
How success will be measured
Business, data, reporting, and consumption requirements are clear, complete, testable, and aligned to business objectives.
Data issues are identified and resolved faster through repeatable analysis, clear evidence, and coordinated ownership.
Reconciliation, testing, business validation, and UAT produce reliable delivery outcomes.
Fund Accounting consumption needs are translated into governed, scalable solutions delivered through the appropriate Finance Technology, enterprise data, reporting, or application team.
Strong collaboration, traceability, and handoffs are established across the broader data and reporting operating model.
Reporting Relationships
There is no set deadline to apply for this job opportunity. Applications will be accepted on an ongoing basis until the search is no longer active.
About Ares Management
People
About 4,250 in 2025, up 33% from the year before.Annual report (SEC Form 10-K)
Company
Listed as ARES.
Demand for Analyst roles
New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.
August 17Last week
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
About the role
We file this job under Analyst, by the work the posting describes.
Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.
Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.
Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.