Stellenbosch, South Africa

BI Developer

Entersekt is looking for an intermediate to senior level BI developer to help us construct and evolve our enterprise data warehouse from the ground up. The positioning is specifically aimed at using newer cloud technologies like Amazon Redshift, Azure DW, Data Factory & Power BI (along with a technical approach that is not strictly limited to the more classical, on-premise ETL mindset) to help achieve our goal of ingesting, preparing, transforming, analyzing, and publishing our ever-expanding data sources into a single source of truth for the business to consume.

The ideal candidate

  • Will help ensure the quality and data integrity of our BI artefacts
  • Interested in experiencing a cloud-first approach to the world of BI
  • Shows strong analytical and critical thinking, with clear articulation thereof
  • An ability to see things through to their positive conclusion
  • An ability to work well independently and as part of a team
  • Does not try to overcomplicate things
  • Takes pride and ownership in what they do
  • Is ready to pioneer and prove themselves

The role

You will use your BI expertise to interpret, extract, load, and transform data from disparate and unrelated source systems into cloud-based relational SQL technologies (like Azure SQL Data Warehouse and Amazon Redshift) using orchestration tools like Azure Data Factory (which is the cloud-based-version of SSIS) and Pentaho Data Integration (our Enterprise-level reporting tool is Microsoft PowerBI).

You are a critical thinker who is passionate about data and performing accurate statistical analysis, but also enjoys the ETL side of BI life and can hold your own in a highly technical environment. You have some experience in deriving system requirements and performing some of the business analysis needed to firm up technical requirements. Proficiency in writing SQL code and ensuring the undisputed quality of your work is a must.

Responsibilities

  • Design and build new data warehouse artefacts using cloud-based technologies
  • Help grow, adapt, scale, and evolve our existing (cloud-based) data warehouse footprints, currently based on Amazon Redshift and Azure DW
  • Ingest Amazon S3 (JSON files) and APIs from various cloud-based source systems into the data warehouse using proven ETL orchestration methods
  • Extract, load, and transform billions of transactions into our enterprise data warehouse
  • Contribute to, produce, and maintain processes, procedures, and operational and architectural documentation for our EDW environment and the administration thereof.
  • Work with scrum masters, product owners, and senior stakeholders to translate scope into internal technical requirements
  • Assist an MIS team to research and prototype front-end reporting mechanisms as we gear and steer our target audience towards automated BI self-service
  • Work with external consultants and internal product teams to achieve joint success in project deliverables

Skills & Experience

Successful candidates for the role will generally possess the following qualifications and skills:

  • A tertiary qualification in computer science or software development, or certification in relevant BI technologies
  • 5+ years’ business intelligence development experience, preferably full stack
  • A sound understanding of BI best practices, relational structures, star schemas, dimensional data modelling, denormalization processes, and reporting techniques, including MS Power BI
  • Prior experience in the full automation of back-end ETL processes (monitoring, scaling, error, exception handling, and the remediation thereof) using SSIS and similar tools

Experience in the following will be advantageous:

  • Exposure to the full SDLC, including solid understanding of Scrum/Agile methodologies
  • Exposure to Amazon Redshift
  • Exposure to Azure SQL Data Warehouse

Personality attributes

  • Attention to detail, ability to see projects through to the end, team player, good communicator, determined, problem-solver, challenge-lover, knowledge sponge

Apply for this position! Email your CV and cover letter to:

This email address is being protected from spambots. You need JavaScript enabled to view it.

logo entersekt

Entersekt is an international software development company based just outside of Cape Town, South Africa.

We are leaders in authentication, app security, and payments enablement technology, offering a highly scalable solution set with a track record of success across multiple continents.