Job Description
Job Summary
- This role is responsible for ensuring the integrity and speed of reporting data, monitoring ETL jobs, designing cubes, data visualisation/dashboard development and extrapolating insights from the data to support business and sales decision-making
Key Responsibilities:
Strategic Perspective
- Collaborates with business owners, Divisional agile and products teams, GST team, Operations team and other BI champions to develop automated solutions to meet rapidly changing market, business and customer data demands
Operations
- Develop, monitor and maintaining ETL jobs and resolve production issues
- Use ETL tools to load data store(s)/ data warehouse(s)/ data mart(s).
- Create and execute queries for data
- Translate business requirements into specifications that will be used to drive data store/data warehouse/ data mart design and configuration
- Knowledge of Big-data tools such as Spark, Hadoop, NoSQL, Python, R, etc
- Tableau & PowerBI developer with an expertise to create visualizations that provide business insights.
- Deliver high quality and timely dashboards, reports, visualizations, data models, and self-service reporting capabilities
- Be one of the key builders of our BI Data Marts for supporting the business reporting requirements.
- Collaborate with stakeholders across the division to understand business drivers, gaps, and issues to create relevant data strategies and BI capabilities
- Ensure Data integrity and Optimized speed for data insert/retrieval operations.
- Manipulating/mining data from database tables (TSQL, Oracle, Data Warehouse)
- Research and implement standards to ensure data integrity, efficient coding, data validation, product testing, clear documentation, and maintenance practices
- Troubleshoot production issues; identify root cause and fixes
- Collaborate with other teams to provide end user documentation and training
- Elicit requirements from stakeholders and translate them into specifications for business intelligence solutions and processes.
- Monitors the availability of business intelligence servers, and ensures the smooth running of all services
- Investigate data to extract intelligence and insights to support business decision making •
- Provide analytics and insights to support data-driven performance management
Academic Qualification(s):
- Minimum of Bachelor’s Degree in Computer/System/ Electrical/ Electronic Engineering/ Applied physics/ Computer Science or a related discipline
Professional Qualification(s):
- Relevant certification such as Business Intelligence Certification, Certified Business Intelligence Professional (CBIP) will be an advantage
Experience (Number of relevant years):
- 8 years functional experience, including minimum of 2 years in team leadership role