At a Glance
- Tasks: Develop and maintain data pipelines and architecture for automated reporting.
- Company: Join Open Partners, a forward-thinking agency focused on marketing transformations.
- Benefits: Enjoy a competitive salary, hybrid work options, and opportunities for professional growth.
- Why this job: Make an impact by leading innovative data engineering solutions in a dynamic environment.
- Qualifications: 5+ years in data engineering with strong SQL and Python skills.
- Other info: Be part of a team that values being smarter, faster, and better.
The predicted salary is between 36000 - 60000 £ per year.
Role Purpose
The Data Engineer is responsible for developing and maintaining the infrastructure behind our data pipelines and data warehouses. You will lead the design and delivery of internal and external data engineering solutions, managing the development of transformation pipelines across our data architecture.
Role Responsibilities
- Develop the tech stack and data architecture behind the agency's automated reporting infrastructure.
- Research, analyze, and help implement technical approaches for solving complex development and integration problems to support the strategy roadmap.
- Build and maintain ETL/ELT pipelines to create high-performance data feeds for reporting suites across organic & paid media.
- Lead the process on troubleshooting data feeds, understanding and solving problems across various data platforms and technologies (e.g., API failures, data discrepancies).
- Work closely with the AI & automation team to ensure that clean and structured data can be successfully imported from key systems and applications around the business.
- Champion best practice, governance, and security in all data-led projects.
- Support the AI team to scope out new opportunities for utilizing Artificial Intelligence in product development and engineering workflows.
- Speak directly with clients regarding technical data requirements and manage high-level stakeholder expectations regarding data feasibility.
Your KPIs / Outputs
- Design and maintain a scalable data architecture and tech stack to power automated reporting.
- Ensure high-quality, normalized data availability by building and stabilizing ETL/ELT pipelines.
- Minimize data feed downtime and troubleshooting requirements through robust engineering.
- Champion data governance, security, and best practices across all data-led projects.
- Enable faster delivery of client solutions by automating complex data integration from key platforms.
- Drive the technical roadmap for integrating data pipelines & warehousing across the wider business.
Role Details
- Reports to: Harry Smith (Data Senior Partner)
- Responsible for: Architecture, development, and maintenance of our reporting pipelines, data warehousing, and database structures.
- Location: Manchester & Hybrid.
- Hours / Days: 37.5 hours, over 5 days per week.
- Contract basis: Permanent.
To Be Successful In This Role
- 5+ years of experience in data engineering and building data pipelines/architecture.
- Good strategic thinkers, with the ability to undertake strategic planning for data infrastructure and roadmaps.
- Able to take the lead of a function (Data Engineering) and make it your own, championing governance and security.
- Self‑motivated and proactive in researching and implementing new technical approaches.
- Confidence in translating technical concepts, with the ability to communicate complex integration problems to non‑technical stakeholders clearly.
Must Have Skills & Experience required
- Advanced SQL & Python.
- Cloud Engineering (e.g., AWS, Azure, GCP).
- Database design and architecture principles.
- High level of Microsoft Excel / Google Sheets skills.
- Intermediate AI / prompt engineering knowledge.
Desirable
- Experience with Google Cloud Platform (GCP) and BigQuery.
- Experience in marketing (offline and online) data.
- Advanced coding/version control skills (e.g. GitHub).
- Experience with marketing API management tools (e.g., Adverity, Fivetran, Funnel).
Expectations For All Open Partners Employees
- Follow our Employee Handbook.
- Live by our values: Smarter – Aim high, train hard, embrace next; Faster – Learn fast, adapt fast, act fast; Better – Think, say and do what’s best.
About Open Partners
Open Partners was founded in 2017 to be The Agency of Next. Designed to be constantly focussed on the future, we think ahead for our clients, quickly pivoting them to new areas of opportunity as they arise. Delivering marketing transformations for over 50 clients, Open Partners’ integrated Media, Data and Creative capabilities drive more accountable and effective returns for international performance advertisers. We strive to always be smarter, faster, and better – all the while upholding the very highest standards of commercial and operational integrity.
Seniority Level: Mid‑Senior level
Employment Type: Full‑time
Job Function: Information Technology
Industry: Advertising Services
Data Engineer Partner in Manchester employer: Open Partners
Contact Detail:
Open Partners Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer Partner in Manchester
✨Tip Number 1
Network like a pro! Reach out to current employees at Open Partners on LinkedIn or other platforms. A friendly chat can give you insider info and might just get your application noticed.
✨Tip Number 2
Prepare for the interview by brushing up on your technical skills. Make sure you can confidently discuss your experience with SQL, Python, and cloud engineering. We want to see how you tackle real-world data challenges!
✨Tip Number 3
Showcase your problem-solving skills! Be ready to share examples of how you've tackled complex data integration issues in the past. This will demonstrate your ability to lead and innovate in the role.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets into the right hands. Plus, it shows you’re genuinely interested in joining the Open Partners team.
We think you need these skills to ace Data Engineer Partner in Manchester
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Engineer Partner role. Highlight your experience with data pipelines, ETL/ELT processes, and any relevant tech stacks you've worked with. We want to see how your skills align with what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data engineering and how you can contribute to our team. Be sure to mention specific projects or experiences that relate to the responsibilities outlined in the job description.
Showcase Your Technical Skills: Don’t forget to highlight your technical skills, especially in SQL, Python, and cloud engineering. We love seeing examples of how you've used these skills in past roles, so feel free to include links to projects or GitHub repositories if applicable!
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and you'll be able to submit all your materials in one go. Plus, it shows us you're serious about joining our team!
How to prepare for a job interview at Open Partners
✨Know Your Tech Stack
Make sure you’re well-versed in the tech stack mentioned in the job description, especially SQL and Python. Brush up on your cloud engineering skills too, whether it’s AWS, Azure, or GCP. Being able to discuss your experience with these technologies will show that you’re ready to hit the ground running.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've tackled complex data integration problems in the past. Think about specific challenges you faced with ETL/ELT pipelines and how you resolved them. This will demonstrate your strategic thinking and ability to lead in data engineering.
✨Communicate Clearly
Since you'll be dealing with non-technical stakeholders, practice explaining technical concepts in simple terms. Prepare to discuss how you’ve successfully communicated complex ideas in previous roles, as this is crucial for managing client expectations.
✨Emphasise Governance and Best Practices
Be ready to talk about your approach to data governance and security. Share any experiences where you championed best practices in your previous roles. This will highlight your proactive nature and commitment to maintaining high standards in data-led projects.