Data Engineer (SQL Server Developer/ BI Developer)

We'd Need You To Be As Committed As We Are To

As a Data Engineer (SQL Server Developer/ BI Developer), you're a critical part of the team.

• A strong and deliberate focus on ethical and accountable behaviours.
• Treating our staff, our colleagues, customers and merchant partners with care and respect.
• Good governance and leadership accountability.
• A culture that is transparent and authentic.
• Diversity and inclusion at all levels.
• Taking an active role in improving the wellbeing of the communities we operate in.
• Relevance and "insurgence" - being a challenger, prepared to break new ground.
• Building a rewarding, performance-based culture.
• Being a force for good

Data Engineer

Job Purpose

• The Data Engineer is primarily responsible for development, enhancement, troubleshooting
• and maintenance services on both on-premises (Microsoft SQL Server) and cloud data
• systems.
• You will need to have a sound understanding of relational database management
• systems, system analysis and design and data modelling. You will need to have working
• experience (3 years+) and competency with the Microsoft BI stack primarily SSIS, SSRS and
• T-SQL development. You will be required to upskill and learn the Google cloud services
• platform stack and assist with cloud migration of on-premise reports.
• Core skills and knowledge
• Key Responsibilities
• Responding to issues ickets related to support of existing systems
• Developing new reports on both on-premises and cloud systems
• Upskilling on cloud services used by the Data Engineering team
• Supporting on-premises system
• Developing high performing stored procedures using T-SQL
• Troubleshooting issues that arise on data systems (on-premises and cloud)
• Developing and automating complex ETL processes
• Adhering to development standards and naming conventions
• Update tasks on Jira
• Understanding SQL execution plan
• Optimizing code, developing indexes etc.
• Working well with team members within and outside of your team to deliver on tasks
• Communicating progress with Scrum master and other stakeholders
• Understanding payment processes and data
• Delivering within SLAs and agreed timelines

Qualifications

• Degree in Computer Science, Engineering, Informatics, Applied Mathematics, Statistics
• or Information systems.
• Optional - MCSA or MCSE in data platform, database development, data engineering
• Optional - Google Cloud Professional Data Engineer certification
• Personal Skills

Communication

• Communication skills (written and verbal) in English.
• Interpersonal / Relationship management skills

Negotiation and influencing

• Facilitation
• Presentation skills

Mind-set And Attitude

• Analytical, diagnostic and problem-solving skills
• Business acumen
• Process and organizational thinking
• Attention to detail.
• Adaptability to change.
• Willingness to take ownership and accountability.

Time Management

• Planning and organizing skills
• Ability to work under own initiative without guidance, cope well under sustained
• pressure and deliver to deadlines.
• Ability to deal with multiple projects at the same time.

Minimum Required Knowledge

• Understanding of Relational Database Management Systems (RDBMS)
• Understanding of concepts related to RDBMS (Atomicity, transactions, Isolation levels,
• concurrency, locking, blocking)
• System analysis and design
• Software development (any optional of Python, java, C# or C++)
• Good software development principles (abstraction, decomposition - modularizing code,
• developing for reuse, commenting appropriately, choosing appropriate data types, quantifying
• and managing complexity, writing simple readable code)
• Data modelling for OLTP system (normalization, ERDs, Interaction diagrams)

Experience

• At least 3 years of experience with the Microsoft BI Stack (SSIS, SSRS and SQL-server)
• At least 3 years of experience with T-SQL development
• Using SQL query execution plan
• Optimizing code using indexes, partitioning, refactoring code, redesigning tables etc.
• Normalizing de-normalized tables to 3NF
• Working in an Agile environment
• Creating complex ETL processes using SSIS or similar tool

Optional

• 3 years in banking or payments services industry
• At least 1 year of experience programming any of python, C#, java, C++ or C in a commercial
• environment
• Experience with cloud services (Azure, AWS, GCP)
• Dimensional data modeling for OLAP systems
• Experience working in a medium to large corporate environment.
• Jira, Confluence, slack

Desired Skills

• Data Engineer
• SQL Server Developer
• BI Developer

Desired Work Experience

• 2 to 5 years Data Analysis / Data Warehousing

Desired Qualification Level

• Degree