Locations: South Africa and Brazil
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