Data Warehouse BI Developer

  • Sector: Monroe Medical Devices (CPO & CRO)
  • Contact: Cherry Anne Santos
  • Contact Email: cherry@monroeconsulting.com.ph
  • Location: Makati City
  • Salary: PHP100000 - PHP120000 per month
  • Expiry Date: 03 December 2021
  • Job Ref: BBBH225674_1635935027


Executive recruitment company Monroe Consulting Group is recruiting on behalf of a respected Medical device company. Our client is seeking a Data Warehouse BI Developer that will be responsible for growing the current data offerings and facilitating data collection/management to meet future requirements. In this key role he/she will work with internal business stakeholders to design, develop and implement data warehousing solutions to assist with the evolution of end to-end business intelligence and analytical solutions including the administration of Power BI Premium. The job is based in Makati City, Philippines.
Key job responsibilities include:

  • Accountability 1 - Support and Maintain existing data warehouse solutions.
    • Supporting the Data Warehouse infrastructure including but not limited to SSAS, SSIS, SSMS etc.
    • Extraction of data out of the warehouse where required.
    • Ensure all development meets with global standards and are fully documented.
    • Communicate with stakeholders on all levels, roles and experience across the business when needed.
  • Accountability 2 - Update and Optimise data warehousing solutions.
    • Provide consulting to the local business for addition of new data into the Data Warehouse.
    • Work with global team members to manage and optimise addition of new data into the Data Warehouse from changes to the global application stack.
    • Continued focus on performance optimisation for all data environments.
    • Work with our global team to develop and work towards global standards of data warehousing and governance.
    • Ensure all development meets with programming standards and is fully documented as per development procedures.
  • Accountability 3 - Enhance business measures and support business reporting.
    • Work with stakeholders and BI team members to understand business requirements.
    • Identification, delivery and communication of new/or improved business measures ensuring clear documentation, ownership and definitions.
    • Continually challenge and review measures and reports to ensure they remain in line with our changing business environments and/or systems.
  • Accountability 4 - Represent BI in multiple forums.
    • Champion BI initiatives within IT
    • Represent BI in local, reginal and global meetings and workshops providing not only knowledge regarding data but also insights and observations of improvement opportunities.


Job Requirements:

  • (3years+) Technical experience with BI tools in the Microsoft Stack - Power BI, SSMS, SSIS, SSAS.
  • (3years +) Technical experience with the SQL language and scripting techniques.
  • Data Warehousing design, build & implementation experience.
  • Cloud solutions experience such as Azure/AWS (nice to have)
  • Understanding of conceptual, logical, and physical model design, operation of data warehouses
  • Technical Skills & Abilities (must have):
    • Microsoft SQL Server BI stack up to, and including, the latest release (SSMS, SSIS, SSAS etc.)
    • Demonstrated experience in Business Intelligence and Data Warehousing Concepts
    • Proficiency in ETL development process
    • Excellent troubleshooting skills for identifying and resolving ETL issues
    • Experience with BI environment performance tuning
  • Other Skills & Abilities (must have):
    • Excellent planning and organisational skills
    • Proactive and with a high level of initiative
    • Ability to adapt within a dynamic environment
    • Seeks feedback with the ability to constructively provide it to others
  • Working Knowledge of the following (like to have):
    • Microsoft AX, CRM and related systems
    • Project Management methodologies
    • Power BI Premium administration & management
    • Visual Studio Database Projects
    • Azure DevOps CI/CD and GIT source control