Role Overview
The Data Junior Partner is a foundational role within our data team, responsible for supporting the team by handling essential data tasks that ensure the accuracy and reliability of our client reporting and analytics. This role maintains our data visualisation platforms, prepares and cleans data for analysis, and supports the smooth operation of data pipelines to provide a data-driven foundation for agency solutions. This is a key support role that works closely with senior team members, offering an opportunity to learn and develop core data skills.
Responsibilities
* Act as the first line of support for the data team, triaging incoming requests and issues related to reporting dashboards and data quality.
* Maintain and troubleshoot Looker Studio dashboards, perform routine updates, fix data connection issues, and escalate complex problems as needed.
* Use SQL to perform data cleaning, preparation, and transformation to ensure data quality and integrity for reporting and analysis.
* Support the operation of data pipelines that extract information from marketing platform APIs, assisting with troubleshooting where necessary.
* Contribute to data quality assurance by proactively identifying and flagging anomalies in datasets and errors in data pipelines.
* Provide hands-on support to senior data team members across client projects and internal initiatives.
* Adhere to team best practices for data governance, documentation, and workflow management.
KPIs / Outputs
* Consistently high levels of data accuracy in all prepared datasets.
* Timely resolution of Looker Studio maintenance tickets and data requests within agreed SLAs.
* Positive feedback from senior team members on the quality and timeliness of support provided.
* Successful completion of assigned training modules in SQL and data visualisation.
Role Details
Reports to: Data Partner
Location: Manchester & Hybrid
Hours / Days: 37.5 hours, over 5 days per week.
Contract basis: Permanent.
To Be Successful In This Role
* You have a strong analytical and detail-oriented mindset with a passion for problem-solving.
* You are highly motivated to learn and develop technical data skills in a fast-paced environment.
* You are an excellent collaborator and communicator who can work effectively within a specialist team.
* You are proactive and organised, with a focus on delivering accurate work on time.
Must Have
* A degree in a technical or numerical field (e.g., Computer Science, Mathematics, Physics, Engineering) or equivalent practical experience.
* Strong problem-solving skills with exceptionally high attention to detail.
* Proficiency with Google Sheets or Microsoft Excel.
Desirable
* Proficiency in SQL for data querying, joining, and cleaning.
* Prior experience with Looker Studio or other data visualisation tools (e.g., Power BI, Tableau).
* Basic knowledge of Python for data manipulation.
* An interest in digital marketing and advertising.
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
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. We strive to always be smarter, faster, and better - upholding high standards of commercial and operational integrity.
#J-18808-Ljbffr