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