Intermediate BI ETL Developer

2 days ago

Cape Town, South Africa DataFin Full time

IT – Software Development
Cape Town – Western Cape

ENVIRONMENT:

BE responsible for the support, enhancement, and optimization of the current BI Data Warehouse by managing service requests from users and the support of internal data management tasks as the next Intermediate BI ETL Developer sought by a dynamic Financial Services Group. You will develop, maintain & improve ETL jobs and related data warehouse models/objects/systems using ETL tools and coding primarily in Transact-SQL. You will also provide a support service to users. The ideal candidate requires a suitable IT tertiary qualification or similar, a minimum of 5 years’ commercial Business Intelligence (Microsoft Stacks) development with Advanced proficiency in SQL, T-SQL & SSIS. Your other tech tools should include SSRS, SSAS, MDX and the Ralph Kimball methodology.

DUTIES:

Offer support to information delivery production environment –

- Understand the current production environment and relevant processes.
- Support the BI Team in maintaining the production environment, ensuring delivery of current information to the business on time, effectively collected, correctly transformed, audited, accurately published.
- Develop, maintain and improve ETL jobs and related data warehouse models/objects/systems using ETL tools and coding primarily in Transact-SQL.
- Work closely with the BI Architect and BI Administrator to streamline data flows between internal/external systems and the BIDW.
- Testing and reconciliation of warehouse data to source data to ensure data integrity.
- Efficient and effective resolution of production issues, and users’ requests for information.
- Monitor the environment to proactively engage in prevention activities and to maintain an environment that is easy to understand and troubleshoot.
- Recurring standby to support and resolve operational issues encountered in the day-to-day operations of the BIWH production environment.

User Support –

- Provide a support service to users on data and information to satisfy user needs.
- Analysis of new requirements and adjusting the design of existing star schemas or designing new star schemas to meet query / reporting requirements.
- Adapt ETL processes to accommodate changes in source systems and new business user requirements.

REQUIREMENTS:

Qualifications –

- Relevant tertiary qualification in Information Technology or similar.

Experience/Skills –

- At least 5 years’ commercial Business Intelligence (Microsoft Stacks) development.
- Intermediate to Advanced skill level in using MS-SQL/T-SQL and SSIS.
- SSRS, SSAS (multi-dimensional and tabular), MDX.
- Working understanding of the Ralph Kimball methodology including a good grasp of dimensional modeling and efficient ETL techniques with focus on MS SQL Server.

Other technologies utilised in the BI Division:

- ActiveBatch
- Visual Studio

Advantageous –

- Exposure to Self-Service BI using Power-BI.
- Experience in the Business Intelligence environment in Financial Services or Retail industry.
- Exposure in working within an Agile project environment.
- Experience in a SQL Database Administrator or BI Administrator role.
- Experience using a meta-data repository to manage ETL processes and data lineage.
- Experience using Team Foundation (or a similar product) as version control system.

ATTRIBUTES:

- Strong analytical, problem solving and conceptual thinking skills essential.
- Ability to take ownership of problems assigned and find innovative solutions.
- Attention to detail and commitment to delivery is important.
- A team player with a positive attitude.
- Must be able to work to and manage deadlines.
- Flexible, able to change focus when required.

#J-18808-Ljbffr

  • Intermediate Business Intelligence Developer

    2 weeks ago

    Cape Town, Western Cape, South Africa Dimension Data Full time

    Job Title: Intermediate BI DeveloperAt Dimension Data, we are seeking an experienced Intermediate BI Developer to join our team. As a key member of our Business Intelligence team, you will be responsible for developing and maintaining daily, weekly, and monthly MIS reports as well as data flows.Main Responsibilities:Support clients with ad-hoc reports and...

  • BI Tester

    4 months ago

    Cape Town, South Africa iOCO Full time

    JOBNUMBER **iOCO02790** - CONTRACT TYPE **Contract** - STATE/PROVINCE **Western Cape** - CONTRACT TYPE: **Hybrid** **The Role**: **Skills and Experience**: **What you’ll do**: The **Business Intelligence Tester** will join the QA team and work closely with the business analysts, developers, and project managers in the business intelligence delivery...

  • BI Analyst/Developer

    3 weeks ago

    Cape Town, South Africa Adzuna ZA B C2 Full time

    The BI Analyst/Developer will be responsible for the successful delivery of complex BI/Data projects. The role involves collaborating with senior stakeholders, designing and implementing data management solutions, and ensuring the quality and integrity of data. This individual will use agile methodologies to drive project success and provide insights that...

  • BI Analyst/Developer

    3 weeks ago

    Cape Town, South Africa PBT Group Full time

    The BI Analyst/Developer will be responsible for the successful delivery of complex BI/Data projects. The role involves collaborating with senior stakeholders, designing and implementing data management solutions, and ensuring the quality and integrity of data. This individual will use agile methodologies to drive project success and provide insights that...

  • BI Analyst/Developer

    3 weeks ago

    Cape Town, South Africa PBT Group Full time

    The BI Analyst/Developer will be responsible for the successful delivery of complex BI/Data projects. The role involves collaborating with senior stakeholders, designing and implementing data management solutions, and ensuring the quality and integrity of data. This individual will use agile methodologies to drive project success and provide insights that...

  • BI Analyst/Developer

    3 weeks ago

    Cape Town, South Africa PBT Group Full time

    The BI Analyst/Developer will be responsible for the successful delivery of complex BI/Data projects. The role involves collaborating with senior stakeholders, designing and implementing data management solutions, and ensuring the quality and integrity of data. This individual will use agile methodologies to drive project success and provide insights that...

  • BI Developer

    2 days ago

    Cape Town, South Africa Digital Outsource Services Full time

    Kick-start your career in the online gaming world and experience the very latest in technology and innovation. The Department: Enterprise Risk Support owns a diverse set of products with multiple capabilities. To effectively support these products, our teams require a diverse set of software development skills and strong product knowledge geared for...

  • BI Developer

    2 months ago

    Cape Town, South Africa ABC Worldwide Full time

    SummaryOur Client in the Travel and Tourism industry has an exciting opportunity for a BI Developer to join their Business Intelligence Team.As the ideal candidate, you will take ownership of ensuring the integrity of all information within the data warehouse as well as the accuracy of the processes used to populate the warehouse daily. You will be...

  • ETL Developer

    2 months ago

    Cape Town, South Africa TMF Group Full time

    DISCLAIMER TEXT We never ask for payment as part of our selection process, and we always contact candidates via our corporate accounts and platforms. If you are approached for payment, this is likely to be fraudulent. Please check to see whether the role you are interested in is posted on  our career website. We never ask for any kind of payment...

  • Senior Power BI Developer

    3 weeks ago

    Cape Town, Western Cape, South Africa PBT Group Full time

    PBT Group Seeks Senior Power BI DeveloperPBT Group is seeking a highly skilled Senior Power BI Developer to join our team. As a Senior Power BI Developer, you will be responsible for designing and developing business intelligence solutions using Power BI.Key Responsibilities:Data Modeling: Understand business requirements and design data models to transform...

  • BI Developer

    2 months ago

    Cape Town, South Africa Adzuna ZA B C2 Full time

    We are seeking a talented BI Developer to join our dynamic AI, Data, and Analytics team at iOCO, based in Cape Town with a hybrid working model. In this role, you will use your expertise in Databricks and other BI tools to design, develop, and maintain business intelligence solutions that empower data-driven decision-making. You will play a crucial part in...

  • BI Developer

    2 months ago

    Cape Town, South Africa IOCO Full time

    We are seeking a talented BI Developer to join our dynamic AI, Data, and Analytics team at iOCO, based in Cape Town with a hybrid working model. In this role, you will use your expertise in Databricks and other BI tools to design, develop, and maintain business intelligence solutions that empower data-driven decision-making. You will play a crucial part in...

  • BI Developer

    2 months ago

    Cape Town, South Africa IOCO Full time

    We are seeking a talented BI Developer to join our dynamic AI, Data, and Analytics team at iOCO, based in Cape Town with a hybrid working model. In this role, you will use your expertise in Databricks and other BI tools to design, develop, and maintain business intelligence solutions that empower data-driven decision-making. You will play a crucial part in...

  • Data Engineer with Power BI

    3 weeks ago

    Cape Town, Western Cape, South Africa PBT Group Full time

    Job Title: Data Engineer with Power BIPBT Group is seeking a highly skilled Data Engineer with expertise in Power BI to join our team.Job Summary:We are looking for a talented Data Engineer to design, develop, and deploy ETL processes for ODS and data mart projects, as well as application and management reports. The ideal candidate will have strong knowledge...

  • Data Engineer with Power BI

    1 month ago

    Cape Town, Western Cape, South Africa PBT Group Full time

    About the RolePBT Group is seeking a highly skilled Data Engineer with Power BI to join our team. As a key member of our Business Intelligence team, you will be responsible for designing, developing, and deploying ETL solutions for our Operational Data Store (ODS) and data mart projects.Key ResponsibilitiesBack-end DevelopmentDesign, develop, test, and...

  • BI Consultant

    4 weeks ago

    Cape Town, South Africa Parvana Full time

    About our client:Over the past 20 years our client has built a stellar reputation in the development and system integration space. Through their extremely ethical values they have earned the trust and respect of their clients. They prioritise finding effective solutions over being proficient in any particular technology making each project unique and...

  • Data Engineer

    1 month ago

    Cape Town, Western Cape, South Africa PBT Group Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our team at PBT Group. As a Data Engineer, you will play a critical role in designing, developing, and deploying ETL solutions for our data mart projects, as well as application and management reports.Key ResponsibilitiesDesign and Development: Design, develop, test, and deploy ETL solutions...

  • BI Data Analyst

    3 weeks ago

    Cape Town, South Africa PBT Group Full time

    Duties / Responsibilities: - Work with the team to design and implement data models and BI solutions. - Interpret and map complex data sets to existing BI data models. - Support the ETL process, ensuring data accuracy and quality. - Use SAP BI tools and SQL to perform data extraction and analysis. - Create comprehensive reports using Excel and other BI...

  • Data Engineer with Power BI

    1 month ago

    Cape Town, South Africa PBT Group Full time

    JOB SPECIFICATIONS:PBT Group has a requirement for a Microsoft BI Developer who knows SSIS, SSAS, SSRS and Power BI. REQUIRED SKILLS:- Microsoft BI: Strong SQL, SSIS, SSAS, SSRS and Power BI- Strong modular system design skills.- Conventional and data warehouse modelling skills are required, in order to understand the various data models and to define the...

  • Data Engineer with Power BI

    1 month ago

    Cape Town, South Africa PBT Group Full time

    JOB SPECIFICATIONS: PBT Group has a requirement for a Microsoft BI Developer who knows SSIS, SSAS, SSRS and Power BI. REQUIRED SKILLS: - Microsoft BI: Strong SQL, SSIS, SSAS, SSRS and Power BI - Strong modular system design skills. - Conventional and data warehouse modelling skills are required, in order to understand the various data models and to...