Pasig City, Philippines

Reports Data Engineer

Full-time / part-time
Full-time
Level
Associate
Department
Operations
Address
Ortigas Center
Pasig City
Philippines

Job description

  • Understand & analyse existing reporting data sources and review against current operational and management reporting needs
  • Design and update ideal future proof data models to support current & evolving reporting requirements
  • Coordinate with the required groups to establish the needed connections from the identified primary & interim data sources
  • Setup and maintain reporting data repositories on various development, staging, and production environments
  • Develop and execute routine Data Extraction, Transformation, and Loading (ETL) to reporting repositories
  • Identify tuning & optimisation, data caching & replication design opportunities to improve reporting performance, ensure data integrity, and enforce the needed controls.
  • Participate in the resolution of any ETL/database related issues that will occur within the assigned reporting domain
  • Initiate development and update of related technical documentations (data models, integration process, metadata, etc.)  
  • Propagate data engineering best practices through conduct of training, mentoring, and knowledge content development

Qualifications

Desire:

  • Degree in Computer Science, Information Technology, Data Science, or Engineering
  • Knowledgeable in open source ETL Technologies
  • Knowledgeable in code versioning tools (Git)
  • Experience in PowerBI preferred
  • Pro-active, independent, accurate, flexible, and customer oriented
  • Keen in updating oneself in current technology trends and is willing to learn new related technologies as needed
  • Amenable to work in UK Shift (2PM- 11PM)

Must have:

  • At least 1-2 years of prior experience directly related to Reporting Automation, Data Warehousing, and/or Business Intelligence Projects.
  • Hands on experience in creating and maintaining production grade data models (both relational and dimensional)
  • Proficiency on Microsoft ETL, Database, Data Integration, and Reporting Technology Stack (MS SQL, T-SQL)
  • Understanding of VB scripts and ability to translate it to T-SQL
  • Able to converse to business users to understand requirements and effectively convey solution options and technical approaches
  • Highly analytical and has a good grasp on the principles of data modelling and architecture of master, transaction and derived analytical data

Additional information

At IQ-EQ we want you to reach your full potential. We offer an inclusive and diverse environment to support your career aspirations. With a strong emphasis on continuous learning and a holistic approach to your professional and personal development. We also offer opportunities across our service lines and our international network of offices.

Company description

IQ-EQ is a leading Investor Services group which combines global expertise with an unwavering focus on client service delivery. We support fund managers, global companies, family offices and private clients operating worldwide.

Apply now

To apply, please enter your details into the below form. If you experience any issues with this form, please click here to apply via our provider SmartRecruiters directly.

Personal
CV
Allowed document formats are PDF, Word, RTF, JPG or PNG. Maximum file size 2MB.
Current
Do you have the right to work in the location of the vacancy?

If you haven't uploaded a CV, please detail your experience and education.

Experience
Education