ETL & BI Solutions Developer X2 – Rosebank needed at Anglo American

Job Description:

• 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 and ensure.

Qualifications:

• Degree in a relevant discipline (e.g. data science).

Technical Knowledge:

• Data Visualization:Proficiency in tools like SAC, Power BI, or similar for creating dashboards and reports.
• Data Analysis and Query Languages:Strong skills in SQL and familiarity with Python for statistical programming.
• Data Modeling:Experience with data modeling principles to support high-quality data sources for BI.
• ETL Processes:Experience with ETL processes and tools for data integration and cleansing.
• Data Management:Strong understanding of database management systems, OLAP, and ETL frameworks.
• Business Acumen:Understanding of business operations and objectives to align BI solutions with company goals.
• ETL Tools Expertise:Proficiency with ETL tools.
• Database Management:Extensive knowledge of SQL and experience with relational (e.g., SQL) and NoSQL databases.
• Programming Skills:Familiarity with Python scripting and automation of ETL processes.
• Performance Tuning:Skills in optimizing ETL processes and SQL queries for better performance.
• Data Quality Management: Knowledge of data profiling, cleansing, and quality improvement techniques.