Business Intelligence Engineer at Yoco

The role will be pivotal in the data space and you’ll have the freedom to design the optimal frameworks, using your in-depth knowledge of SQL and data warehousing principles. Further, you’ll be set to build and grow the cloud-based warehouse in the following three areas:

• Setting up a high performing data warehouse: You will be setting up a new, scalable Business Intelligence warehouse at Yoco, using cutting edge cloud technology, with the ability to shape the future of analytics in a rapidly growing Fintech company.
• Building a world-class, scalable warehouse: Key responsibilities are building robust ETL, reliable scheduling, and structuring a performant data warehouse to enable reporting and analysis across all business areas. Beyond simply preparing data you will be involved in design decisions and supporting the business through detailed knowledge of the data.
• Building and maintaining technical systems: You will be working closely with the Engineering and Data Science teams to manage and maintain the data pipeline end-to-end. You will be responsible for setting up and scheduling batch jobs to aggregate raw data into facts and dimensions and marts. You will also identify gaps, errors, and inconsistencies in data tracking and work with Engineering to rectify these, you will need to understand the complete picture of all data within Yoco.

IDEAL CANDIDATE | WHAT WE ARE LOOKING FOR?

General capabilities:

• At least 5+ years of experience in Business Intelligence Engineering (ETL, Scheduling, Optimisation)
• Strong communication skills, and an ability to work well with other teams
• Strong database and pipelining skills
• Strong integrations and API experience
• Very fast learner and keen to get your hands dirty early on with experiments and hacks

Technical capabilities:

• SQL technologies: PostgreSQL, Redshift
• Python
• AWS stack- S3, Glue, Athena, Spectrum, Lambda
• Tableau/Data Studio/Periscope

Bonus points:

• Experience with Airflow.
• Experience with CRMs: Salesforce & Zendesk.
• Experience with data tracking tools: Segment, Stitch