As a global and diversified mining business, we use the latest technologies to find new resources, plan and build our mines and mine, process, move and market our products to customers around the world.
For almost 100 years, we have been mining the minerals that society needs to develop and prosper. We provide our investors with a balanced portfolio of oppo...
Read more about this company
The Business Intelligence Specialist & ETL Developer is responsible for transforming data into insights that drive business value and facilitating the smooth operation and optimization of business intelligence (BI) processes.
This role involves designing, implementing, and managing ETL processes to efficiently extract, transform, and load data from various sources into a data warehouse or data repository.
Using data analytics, data visualization, and data modeling techniques, the specialist will turn data into critical information and knowledge that can be used to make sound business decisions.
This role plays a pivotal part in business operations, enabling the organization to make data-driven decisions that optimize processes, increase productivity, and ensure competitive advantage.
KEY TASKS
Design and Delivery of BI Solutions: Develop, deploy, and maintain BI interfaces, including query tools, data visualization, interactive dashboards, ad hoc reporting, and data modeling tools.
Data Analysis and Reporting: Perform detailed analysis of business data to identify trends, patterns, and insights. Present findings to internal and external stakeholders using various tools, facilitating data-driven decision-making.
Business Requirements Gathering: Collaborate with line management to understand data and data analysis needs. Translate business requirements into technical specifications, wireframes, or mock-ups, and develop and deliver BI reports and dashboards.
Data Quality and Integrity: Ensure data accuracy and consistency through regular validation and cleanup processes.
Data Integration and Transformation: Design and implement robust ETL processes to integrate data from various sources, ensuring accuracy, completeness, and consistency.
Data Cleansing: Apply techniques to clean and validate data, ensuring high-quality information for analysis and reporting.
Performance Optimization: Monitor, troubleshoot, and optimize ETL processes and queries for maximum efficiency and performance.
Collaboration and Support: Work closely with BI architects, data analysts, and business stakeholders to understand data requirements and deliver the necessary data infrastructure.
Documentation and Compliance: Create comprehensive documentation for ETL processes
Qualifications:
Degree in a relevant discipline
Microsoft Power BI or SAP Analytics Cloud – Advantageous
Certified Business Intelligence Professional (CBIP) - Advantageous
Certified Data Management Professional (CDMP) - Advantageous
EXPERIENCE
SAP Analytics Cloud (SAC) and Microsoft Power BI, data integration, modelling, and visualization within both platforms.
Proficiency in SQL, ETL processes, and data warehousing is crucial, along with skills in DAX for Power BI and scripting for SAC.
Knowledge of SAP Business Warehouse/Datasphere
Understanding cloud platforms and having experience with predictive analytics and security management will enable effective data-driven decision-making and optimization of business intelligence processes.
20 Initiatives to Boost Employee EngagementAre you struggling with improving employee engagement at work? This article covers everything from better communication to building a strong workplace culture.
30 Common Interview Mistakes to AvoidThis piece examines 30 of the most common mistakes applicants make at interviews, so you know how to better avoid them.