onsite
Data Engineer 12 Month Fixed Term Contract - Kingsley Napley LLP
Data Engineer
Early‑career Data Engineer to build and maintain a firm‑wide data platform, focusing on SQL‑based data modeling, ETL pipelines, and cloud services such as AWS.
About the role
Key Responsibilities
- Design, develop, and optimise relational data models to support analytics and reporting across the firm.
- Build, schedule, and maintain ETL pipelines using tools like Apache Airflow and Python scripts.
- Collaborate with data analysts, scientists, and business stakeholders to translate requirements into scalable data solutions.
- Implement data quality checks, monitoring, and performance tuning for SQL queries and data flows.
- Assist in migrating on‑premise data assets to cloud platforms (AWS) and ensure security and governance compliance.
Requirements
- Strong foundation in SQL and relational database design.
- Experience with data modeling concepts and best practices.
- Hands‑on experience building ETL pipelines, preferably with Python and Airflow.
- Familiarity with cloud services, especially AWS (S3, Redshift, Glue).
- Ability to work independently and as part of a cross‑functional team in a fast‑moving environment.
Skills
sqlpythonawsairflow