Data Engineer
On-siteLondon, England, United Kingdom
Job Summary
Build and run data pipelines ingesting data from Oracle databases, APIs, and SFTP files into our Oracle data warehouse. Write and maintain SQL and PL/SQL for data processing, reporting, and analytics, while designing data models that support downstream applications. Develop dashboards and reports using Power BI, investigate data issues, and perform root-cause analysis to resolve reporting problems for stakeholders. Collaborate with diverse stakeholders to understand their needs and turn them into practical data solutions. Help support data platforms, including participating in on-call and incident handling on a rotation within an Agile team.
Required Qualifications
- Solid experience working with Oracle databases (19c+), using SQL and PL/SQL in production
- 5+ years working with large datasets in a data engineering or similar role
- Good understanding of data warehousing concepts, data modelling (Star/Snowflake/3NF), and ETL/ELT pipelines
- Experience tuning SQL/PLSQL queries and improving performance of reports and data extracts
- Hands-on experience with at least one cloud data platform, ideally AWS (e.g. Redshift, RDS, or similar)
- Exposure to modern data transformation tools such as dbt or similar frameworks
- Basic understanding of cloud concepts (networking, storage, security) and CI/CD for data pipelines
Desired Qualifications
- Experience with other reporting/BI tools such as Power BI or AWS QuickSight
- Experience with cloud data warehouses like AWS Redshift, Snowflake, or BigQuery
- Some knowledge of Kafka and a programming language (e.g. Python or Java) for building data workflows and automation
- Familiarity with AWS services such as S3, Glue, Lambda, EMR, or streaming tools like MSK/Kinesis
- Experience with basic data governance, data quality checks, and security practices (e.g. RBAC, encryption, handling PII)
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.