Junior Data Engineer

Capital Economics is one of the world's leading independent economic research companies. Our goal is to provide our clients with original, timely and insightful analysis supported by solid economic thinking. We are hiring a Junior Data Engineer for our Economics Data and Modelling team. You will help us build the database and pipelines that power our research, dashboards, and a growing commercial data product used by our clients. This role is based in our London office, with hybrid working available. We will also consider applications from candidates who are able to work from our Toronto office. You will be joining a small, collaborative team where you will learn new skills, own your work, and help shape the development of the database and wider data infrastructure.

Key responsibilities

• Designing and implementing ETL pipelines to fetch and process data from a range of external sources.
• Deploying and scheduling pipelines on our cloud infrastructure using Prefect and AWS.
• Supporting the ongoing development and maintenance of the databases that underpin our interactive dashboards and economic research.
• Building data quality checks into pipelines and carrying out periodic reviews to identify anomalies, gaps and unexpected revisions.
• Supporting the rollout of new interactive dashboards by building the data layer behind them, including writing efficient queries and preparing data so dashboards run quickly and reliably.
• Presenting your work to technical and non-technical stakeholders.

Capital Economics is committed to equality, inclusion and diversity. We encourage applications from all candidates regardless of ethnicity, religion or belief, gender, sexual orientation, age, disability or gender identity. If you need reasonable adjustments to be made to the application process to ensure you are not at a disadvantage to other candidates, please include this in your cover letter. This is applicable if you have a disability or if you are neurodiverse/hold neurodiverse traits. Capital Economics has been recognised as Great Place to Work UK. We are an equal opportunities employer with an active DE&I programme. We recognise the importance of a diverse workforce and are dedicated to building a culture where everyone feels valued and empowered to bring their whole selves to work. We strive to foster a workplace that values diversity and promotes mutual respect and understanding. Our hiring practices are based on business needs, merit and qualifications. Capital Economics ensures that all employment decisions are made without bias, and we continuously work to eliminate discrimination and harassment in all forms.

Essential

• Coding experience in Python, particularly for data manipulation and working with APIs (pandas, requests or similar);
• Knowledge of relational databases such as PostgreSQL / MySQL / SQL Server;
• Familiarity with SQL and query optimisation;
• Experience using Git for version control;
• Understanding of Linux;
• A good undergraduate degree in computer science, economics, or a related quantitative subject.

Desirable

• Exposure to cloud environments (AWS or Azure) and containerisation (Docker);
• Familiarity with workflow orchestration tools such as Prefect or Airflow;
• Understanding of how to structure and optimise data for use in visualisation tools such as Plotly or Dash;
• Experience with Power BI;
• An interest in macroeconomics.

Benefits

• Good annual leave (Including your birthday & 1 volunteer day) & sick package
• Life assurance
• Health Assured (Employee Assistance Programme)
• Hybrid working
• Flexible working policy
• Training & development
• Good additional maternity and paternity policies
• Thriving social committee.