SQL Data Engineer

Recruiter:

Praesignis (Pty) Ltd

Job Ref:

JHB000473/IS

Date posted:

Friday, July 29, 2022

Location:

Johannesburg, South Africa

Salary:

Market Related

JOB SUMMARY:
Our Client is looking for a SQL Data Engineer with AWS experience and knowledge of software engineering best practices across the development lifecycle, including agile methodologies, coding standards, code reviews, source management, build processes, testing, and operations.

JOB DESCRIPTION:

Responsibilities

Design, build and operationalize large scale enterprise data solutions and applications using one or more of AWS data and analytics services in combination with 3rd parties - Spark, EMR, DynamoDB, RedShift, Kinesis, Lambda, Glue, Snowflake.
Analyze, re-architect and re-platform on-premise data warehouses to data platforms on AWS cloud using AWS or 3rd party services.
Design and build production data pipelines from ingestion to consumption within a big data architecture, using Java, Python, Scala.
Design and implement data engineering, ingestion and curation functions on AWS cloud using AWS native or custom programming.
Perform detail assessments of current state data platforms and create an appropriate transition path to AWS cloud.
Design, implement and support an analytical data infrastructure providing ad-hoc access to large datasets and computing power.
Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using SQL and AWS big data technologies.
Creation and support of real-time data pipelines built SQL and on AWS technologies including Glue, Redshift/Spectrum, Kinesis, EMR and Athena
Continual research of the latest big data and visualization technologies to provide new capabilities and increase efficiency
Working closely with team members to drive real-time model implementations for monitoring and alerting of risk systems.
Collaborate with other tech teams to implement advanced analytics algorithms that exploit our rich datasets for statistical analysis, prediction, clustering and machine learning
Help continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers
Comfortable working with DevOps tools such as Git, Jenkins, CodeBuild, CodePipeline, CodeDeploy, GitLab pipelines, etc.

Qualifications

At least 5 years experience as a data engineer.Â
Strong knowledge of database structure systems and data mining.Â Excellent organizational and analytical abilities.Â Good written and verbal communication skills.
Bachelor's Degree in Computer Science, Information Technology or other relevant fields
Has experience in any of the following AWS Athena and Glue Pyspark, EMR, DynamoDB, Redshift, Kinesis, Lambda, Snowflake
Proficient in AWS Redshift, S3, Glue, Athena, DynamoDB, EMR
Knowledge of software engineering best practices across the development lifecycle, including agile methodologies, coding standards, code reviews, source management, build processes, testing, and operations

Work Experience

At least 5 years' experience as a data engineer.Â
Experience in database design and database management.Â
Experience in data analysis and business intelligence.Â
Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets
Experience working with distributed systems as it pertains to data storage and computing
Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
Strong analytic skills related to working with unstructured datasets.
Build processes supporting data transformation, data structures, meta data, dependency and workload management.
A successful history of manipulating, processing and extracting value from large disconnected data sets.
Working knowledge of message queuing, stream processing, and highly scalable Big Data, data stores.
Strong project management and organizational skills.
Experience supporting and working with cross-functional teams in a dynamic environment.
Experience in a Data Engineer or similar roles
Experience with big data tools: Hadoop, Spark, Kafka, etc.
Experience with relational SQL and NoSQL databases, including Postgres and Cassandra.
Experience with data pipeline and workflow management tools:
Experience with AWS cloud services: EC2, EMR, RDS, Redshift
Experience with stream-processing systems:
Experience with object-oriented/object function scripting languages: Python.
Experience in the implementation of data visualisation systems/technologies.Â
Experience in querying and manipulating data in data virtualization and data warehousing systems.Â
Experience in MS SQL, PostgreSQL, MySQL, Python, R, Redshift and especially PySpark

NB! This job is now closed. You can apply for other jobs by uploading your CV.

Similar jobs you might be interested in:

Software Implementation and Support Technician
Location: Johannesburg
Salary:
If you enjoy solving realâworld technical problems, working handsâon with sql, networking, and customer systems and don’t mind getting your boots dirty onâsite when needed this is a solid, longâterm opportunity to support and implement missionâcritical software across Africa and beyond.
Today

Senior Software Developer / Team Lead
Location: Johannesburg
Salary: Annually
Seeking a Senior Developer / Development Lead to join a software development function, reporting directly to the HOD. You will be responsible for technical contribution, designing, building and maintaining business-critical systems while also guiding and monitoring junior developers.
1 day ago

Full Stack Developer (Senior) 0866
Location: Menlyn
Salary:
Senior BackâEnd engineer – Kafka | Java (Quarkus) | CloudâNative PlatformsCore Tech: Kafka - Java (Quarkus) - Kubernetes - Cloud (Azure / AWS)
2 days ago

Junior BI Developer
Location: Johannesburg
Salary:
Are you detail-driven, curious, and eager to grow your career in Business Intelligence?Our client, a leading direct selling company, is seeking a Junior BI Developer to join their development team and help design, deliver, and maintain BI solutions that power smarter decision-making across the organisation.This is the perfect role for someone with foundational Microsoft data skills who is ready to...
4 days ago

Platform Engineer
Location: Johannesburg
Salary:
Our client is looking for a skilled Platform engineer to join their high-performing team. This is an exciting opportunity to work on modern cloud platforms, building scalable, resilient systems while collaborating with top-tier engineering talent.
7 days ago

Cloud Engineer
Location: Johannesburg
Salary:
We are seeking a specialised Cloud engineer to design, build, secure, and maintain the infrastructure powering our modern data platforms. Unlike a traditional Cloud engineer focused on general application hosting, this role is dedicated to the unique demands of large-scale data workload, spanning high-volume storage, high-throughput networking, and compute-optimised environments for Spark and sql-...
7 days ago

Principal Database Engineer
Location: Fourways
Salary: Market Related
We are looking for a Software Developer in a Principal database engineer position who has significant hands-on experience with Oracle Suite, for a Multinational company based int he Fourways area in Johannesburg.
7 days ago

Senior Software Developer
Location: Midrand
Salary:
Join a forward-thinking tech environment where your full stack expertise in C# and Python will directly shape scalable, high-performance applications. If you’re passionate about building robust systems and working with modern technologies in a collaborative Agile team, this opportunity offers the perfect balance of innovation, stability, and career growth.
8 days ago

Graduate/Junior Data Scientist
Location: Centurion
Salary:
Kickstart your career in data science within the financial services space. If you're passionate about machine learning, analytics, and solving real-world problems this is your opportunity to make an impact from day one.
10 days ago

Data Analyst
Location: Centurion
Salary:
Turn data into powerful financial insights at a leading analytics firm. If you thrive on uncovering trends, influencing strategy, and working with complex financial data, this opportunity is for you.
10 days ago

SQL Data Engineer

Similar jobs you might be interested in:

Create a free job alert for SQL Data Engineer in Johannesburg