Job Description
This is a key role that will elevate ZWW’s analytics capabilities to be truly agnostic of BI tool and will democratise data for all within the agency.
The BI Developer is a new and vital role that will escalate ZWW’s analytics capability in automating repetitive workflows for an existing team of analysts, building automated reporting solutions on a modern analytics stack, and supporting Publicis Enterprise Analytics platform.
The BI Developer role will be responsible, but not limited to the following:
1. Lead the development of the Open Titan model of BI/Automated reporting (stack based on Funnel, Azure, Snowflake, BI tools be determined by client needs budge).
2. Liaising with Data Engineering to build data streams from client advertising platforms.
3. Design and build of internal analytics datamart for Luxury goods client
4. Act as a support to Senior BI Developer supporting Zenith WW’s existing BI projects
Qualifications
To be successful in this role you will need:
5. Advanced technical knowledge in PowerBIaggregation tables/user-defined aggregationsincremental refreshrow level securityembeddingDAXdata model designdata extractionpower queryperformance tuningdataflow and data mart
6. Hands-on experience with enterprise business intelligence solution data modelling, data mart, and data warehouse development
7. Exposure to Snowflake: building stages, creating schemas and scheduling tasks would be a distinct advantage
8. Understanding of ETL/ELT best practices
9. Exposure in some form of Project Management methodology, existing team work to a version of agile
10. Understanding of Data visualisation principles and exposure to common data visualisation tools would be useful (Tableau, Power BI, Looker)
11. Experience working with large scale media campaign data and familiarity with media language would be a distinct advantage