Senior Data Engineer (Analytics)

EMPLOYMENT TYPE:
Contract (12 months)

COMPANY:
A large financial services company

LOCATION:
Cape Town (Hybrid working model)

JOB OVERVIEW:
You will be responsible to establish new technology components and reusable solution patterns that can be leveraged by business-facing teams in their day-to-day solutions. You are regarded as a data engineering specialist with advanced analytical and technical skills who understands data modeling, data engineering, data visualizations, and analytical models.
You should be competent in communicating challenges and solutions to project and operational leadership. An understanding of data management solutions and a keen sense of the strategic value of information to an organization will be of importance. You will also be responsible for developing data pipelines, and data models, monitoring programme/ job performance, designing data warehousing blueprints, evaluating hardware and software platforms, and integrating systems; translating business needs into long-term solutions.
You possess the ability to orchestrate delivery with a complex series of stakeholders and able to conceptualize solutions built on a hybrid of technologies with no real scope at the get-go, i.e. create, navigate, and negotiate the scope on the fly.

DESCRIPTION OF POSITION:

• Define a structured approach to problem-solving and delivery against it.
• Assist and advise the planning and management of the workload of the team
• Collaborating with other data engineers and data modelers, you will design, implement, and manage the data pipeline to avail data in the information layer
• Create and automate reports for use by a large user base across our branch network
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing models for greater scalability
• Monitor and fine-tune the data pipeline, reports, and information layer for optimal performance
• Use modern development and modeling techniques and tools to implement BI and data management solutions, including data quality, metadata, and reference data
• Engage with a wide range of technical stakeholders including data scientists, data analysts, business analysts, other data engineers, and solutions architects

Competencies:

• Strong analytical & numerical ability
• Problem-solving skills
• Conceptual thinker
• Good communication / interpersonal skills
• Action/results orientation
• Quality Orientation
• Knowledge-seeking/learning orientation
• Strong analytical thinking and problem-solving abilities
• Ability to collect, organize, analyze, and disseminate significant amounts of information
• Strong technical and operational ability
• Deadline-driven, even in pressurized and fast-paced environments

KNOWLEDGE AND SKILLS

• IT Data Analysis
• Database Knowledge and Monitoring
• Data Security
• Risk Management
• Project Oversight
• Technology stack: SQL, Python, Hadoop, SAP HANA, WhereScape, GIT, Bamboo
• Strong understanding of data, data structures, and data sources.
• Application and data engineering background with a specific focus on staging high-quality data
• Knowledge of database management system (DBMS) physical implementation, including tables, joins, and SQL querying.
• Knowledge of structured data, such as entities, classes, hierarchies, relationships, and metadata.
• Ability to comply with and manage data assets under a strict governance framework
• Data warehousing (Kimball and Data Vault patterns) and dimensional data modeling
• A solid background in SQL, Information Architecture, and ETL procedures
• Data Management technologies (e.g. Informatica Data Quality (IDQ), Informatica Enterprise Data Catalog (EDC), Axon, EBX)

QUALIFICATIONS REQUIRED:

• Bachelor's degree in Computer Science, Statistics, Informatics, Information Systems, Engineering, or another quantitative field
• National Diploma in an Information Technology related discipline preferred

EXPERIENCE REQUIRED:

• 2 to 5 years of relevant experience in a similar environment working with the relevant tools and techniques
• Experience in Database technologies (e.g. SAP Hana and Web IDE, or similar) or Hadoop components including HDFS, Hive, Spark, Oozie, and Impala preferred and highly advantageous.
• Experience in data warehousing principles (e.g. Kimball and Data Vault).
• Experience in Agile development
• Experience in structured data, such as entities, classes, hierarchies, relationships, and metadata
• OLAP and MDX experience
• Experience with object-oriented/functional/scripting languages (e.g. Python, Unix Shell scripting, Java, Scala, etc.)

**Please note: If you have not heard from us within 2 weeks, please consider your application unsuccessful.