Manager – Business Intelligence & Data Warehousing

Role Purpose:

Design, model and implement corporate data management and reporting solutions

Accountabilities:

ETL

• Design & Develop complex ETL projects in SSIS and implement Framework model.
• Monitor and fix errors, performance optimization and quality testing of SSIS packages.
• Migrate, re-design & Test ETL packages in Data Manager.
• Deploy and Implement Projects in PROD.
• Prepare Technical and Operational Document.

Databases, SQL & Data warehouse

• Design & develop complex T-SQL/PL-SQL queries and stored procedures.
• Optimize SQL queries.
• Develop data models Star Schema, Snowflake Schema, implement databases, and analyse content and quality of packages

BI Reporting

• Design, develop and maintain business intelligence solutions.
• Craft and execute queries upon request for data.
• Present information through reports and visualization

Project Management

• Coordinate with various stakeholders across multiple functions to better understand their processes, data flows and priorities to manage projects related to data management and reporting
• Collaborate with various IT teams for infrastructure and service readiness and continuity

Skills Required

• Data Integration tools
• ETL processes
• Data Modelling
• SQL Script development
• BI Reporting
• OLAP
• Cognos
• Tableau

Bachelor’s Degree in Computer Science or MIS