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.
- Other info: Be part of a team that values being smarter, faster, and better.
- 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.
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
Open Partners is an exceptional employer that fosters a dynamic and innovative work culture, perfect for Data Engineers looking to make a significant impact. With a focus on employee growth, we offer opportunities to lead cutting-edge data projects while collaborating with talented teams in a hybrid working environment in Manchester. Our commitment to best practices and continuous learning ensures that you will thrive in your role, contributing to meaningful marketing transformations for our diverse client base.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer Partner in Manchester
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Open Partners!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Engineer Partner at Open Partners.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Open Partners.
✨Apply Directly through Our Website
When you find a suitable opening like Data Engineer Partner at Open Partners, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Engineer Partner in Manchester
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Open Partners, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Open Partners. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Open Partners
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Open Partners!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
