At ForwardPMX, we help brands find the change to fuel business growth. We are an award-winning global brand performance agency, home to 1,000 talented people across 25 offices globally. We create unique data, technology and media solutions that enable faster and smarter problem solving and an inspired, collaborative workplace culture.
We're looking for a Data Analyst to aid in our vital and growing analytics team. You will help set the long-term vision and strategy for data-driven decision-making for our clients and with your team, deliver the datasets, models and analysis we rely on to drive our continued growth.
Reporting to our Data Team Lead and working closely with functional leads and managers across the global business, you will help drive a roadmap that unlocks greater performance and insight from our data. You’ll ensure that the data is reliable and up-to-date, and accessible through explores and dashboards. Then, you’ll increase the level of analysis within the Analytics team, and across the business.
Your Primary Duties:?
- Manage and respond to dataset requests in an agile amp; structured manner on the agreed-upon strategic direction provided by the Performance team.
- Ensuring that dashboards are up to date, helping the team in regular quality checks by backdating reports amp; additional data pulls.
- Setup dashboards including but not limited to daily performance, feed health amp; product performance.
- Generate bespoke performance alerts. eg: account spend missing for a market, DoD spend increasing, CPC increasing by X% every day.
- Assist in onboarding new clients to ForwardPMX tech platform Stage.
- Generation of data and business feeds using our in-house tool 'Forge'.
- Support teams with Excel, Stage training, and ensuring that teams can understand the data.
Requirements
- Excellent English language skills (both written and verbal) are essential as the role involves working and communicating with teams across the globe
- 1 year + of experience in writing and running SQL queries- ideally in and Athena/Presto - Hadoop framework.
- 1 year + of creating visualization using tools like Google Data Studio, Tableau, Power BI, or Looker.
- Strong Excel skills including formulas, filtering, pivot tables, and trending charts development.
- Have a basic to intermediate understanding of Digital marketing data including but not limited to google search ads and SEO.
- Expertise in identifying anomalies in data amp; flagging to the performance team
- Experience working with and consolidating multiple data sources (direct from engines, google sheets, FTP, HTTP etc).
Preferred Skills
- Able to create excel macros and introductory Visual Basic.
- Any additional coding or data management experience i.e. python, JavaScript or MATLAB.
Benefits
ForwardPMX is a place where careers genuinely flourish, rather than stifle due to a lack of development or resources; we’re a data-driven company that works agile with no unnecessary layers of management allowing our employees to drive innovation in their campaigns, teams and departments.
You’ll discover an autonomous and entrepreneurial culture at ForwardPMX and also a buzzing environment where bright, innovative and visionary people work in small teams that give them the freedom they need to thrive