at Macquarie
Investment BankingPosted 15 days ago
No clicks
**Technical Business Analyst (Mid-level, Data Focus) - Job ID: 24645** Mid-level Technical Business Analyst required within Macquarie's Corporate Operations Group, focusing on data-centric initiatives. Key responsibilities include collaborating with stakeholders, analyzing enterprise data, defining technical requirements, and supporting data deliverables. Candidates should possess approximately 5-10 years of experience in similar roles, strong SQL skills, understanding of data integration, warehousing, and transformation methodologies. Proficiency in writing complex SQL queries, excellent stakeholder engagement skills, and a detail-oriented approach are essential. Collaborate with business, data engineers, and system owners to transform business requirements into scalable data solutions. Utilize PostgreSQL (AWS Redshift) and Oracle SQL for investigation, validation, and prototyping. Produce clear documentation and communicate impacts effectively. Based in Sydney, this role offers an opportunity to work within a global financial services group, supporting informed decision-making and improving financial data quality and governance. Macquarie encourages applications from diverse backgrounds, promoting an inclusive work environment.
- Compensation
- Not specified
- City
- Sydney
- Country
- Australia
Currency: Not specified
Full Job Description
-
Jobs
-
Featured jobs
- Back to search
Technical Business Analyst
What role will you play?
Press space or enter keys to toggle section visibility
What you offer
Press space or enter keys to toggle section visibility
- 5-10 years proven experience as a Technical Business Analyst, Data Business Analyst or in a similar role delivering data and technology initiatives, with the ability to translate business requirements into detailed technical solutions.
- Advanced SQL skills and a strong understanding of data integration, data warehousing, batch processing and data transformation methodologies, with experience working across large and complex datasets.
- Strong knowledge of data modelling, data quality, data lineage and relational databases, with the ability to investigate issues, validate requirements and identify practical solutions.
- Strong SQL development skills (PostgreSQL, Oracle or similar) and experience writing complex queries using joins, CTEs, window functions, aggregations, data reconciliations and transformation logic.
- Ability to produce clear requirements, data mappings, business rules, technical specifications and acceptance criteria.
- Excellent stakeholder engagement, communication and problem-solving skills, with experience working effectively with both technical and non-technical audiences in an agile delivery environment.
- Experience within financial services, investment banking, private capital, accounting or financial reporting environments would be advantageous, alongside a highly organised and detail-oriented approach to delivering outcomes through ambiguity.
About Technology
Press space or enter keys to toggle section visibility
Inclusion at Macquarie
Press space or enter keys to toggle section visibility
We are committed to providing an inclusive environment for all, where different experiences, skills and perspectives are valued and respected. Macquarie provides access to opportunities for all individuals regardless of race, colour, religion, sex, sexual orientation, national origin, age, disability, protected veteran status, genetic information, marital status, gender identity or any other characteristic or circumstance.
We provide reasonable adjustments to individuals who may need support during the recruitment process and employment. If you require an adjustment, please let us know during the application process.
