Data Infrastructure Engineer
Data engineer on MA Financial Group's tech team building and maintaining Redcape's Enterprise Data Warehouse: ETL pipelines, SQL Server/SSAS processes and data models that feed Power BI reporting for hospitality venues and retail sites. Requires strong SQL Server/SSIS skills and 3+ years in a data engineering or EDW role.
- Compensation
- Not disclosed
- Location
- Philippines
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 3+ years
- Category
- Devops
- Posted
Skills
Must have
- Strong hands-on experience with Microsoft SQL Server, SSIS (or equivalent ETL tools) and enterprise data warehouse design
- Solid understanding of data modelling, schema design and performance optimisation for large, multi-entity datasets
- 3+ years of experience in a data engineering, database development or EDW role, ideally in a multi-site or multi-venue environment
- Working knowledge of Power BI or similar BI/reporting tools
- Experience in API services to support data loading and integrations to the data warehouse
- High level of accuracy and attention to detail, with the ability to take ownership of technical work
- Ability to work autonomously in an offshore capacity, communicating clearly and proactively with an onshore team
- Excellent written and verbal communication skills to work across technical and non-technical stakeholders
Nice to have
- Experience integrating data from disparate operational systems (POS, gaming, membership or similar)
- Experience in hospitality, retail or similar high-transaction-volume, multi-site environments
Full description
Job Description:
About us
MA Financial Group is a global alternative asset manager specialising in private credit, real estate and hospitality.
We lend to property, corporate and specialty finance sectors and provide corporate advice. We invest and manage $13.3 billion on behalf of our clients, have $165 billion in managed loans and have advised on over $125 billion in advisory and equity capital market transactions.
We have a team of over 900 professionals across locations in Australia, China, Hong Kong, New Zealand, Singapore, United States and the Philippines.
MA Financial is a place of opportunity and unlimited potential. It’s a place that empowers you to think, collaborate, and help create something truly valuable.
About the role
Working as part of the technology team supporting Redcape's venues and retail sites, the Data Infrastructure Engineer is responsible for the development, integration and performance of Redcape's Enterprise Data Warehouse (EDW), ensuring reliable, high-quality data flows that underpin reporting, analytics and decision-making across the business.
Role Responsibilities
- Build, maintain, and optimize the Enterprise Data Warehouse (EDW), including ETL pipelines, SQL Server/SSAS processes, and data models to ensure accurate, scalable, and high-performing data infrastructure.
- Manage data integration and onboarding for new venues, retail sites, and acquisitions, ensuring reliable data feeds from source systems such as POS, gaming, and membership platforms.
- Monitor data quality, troubleshoot integration issues, and maintain documentation and governance standards to ensure data integrity and system reliability.
- Enable business reporting by delivering a well-structured, high-performance data layer that supports Power BI and analytics initiatives.
- Collaborate with internal stakeholders and vendors to align data infrastructure with business needs, while supporting ad hoc projects, AI, and automation initiatives.
Pre-Requisite Knowledge and Experience
- Strong hands-on experience with Microsoft SQL Server, SSIS (or equivalent ETL tools) and enterprise data warehouse design.
- Solid understanding of data modelling, schema design and performance optimisation for large, multi-entity datasets.
- 3+ years of experience in a data engineering, database development or EDW role, ideally in a multi-site or multi-venue environment.
- Working knowledge of Power BI or similar BI/reporting tools, including how the data layer supports report development.
- Experience in API services to support Data loading and integrations to the data warehouse