Reporting Analyst

Job Description

Summary In this role, you will be a part of the centralised global office based in India and work closely with each of our markets globally to understand the clients communication objectives, access multiple data sources and visualise it using Tableau / Datorama, support on of ETL process using MSSQL / Alteryx Flow and has sound knowledge of Excel VBA. Key responsibilities Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards on the key drivers of our business Partner with operations/business teams to consult, develop and implement KPIs, automated reporting/process solutions and data infrastructure improvements to meet business needs Enable effective decision making by retrieving and aggregating data from multiple sources and compiling it into a digestible and actionable format Manage on-time delivery of regular client reports including: o Building reports from data warehouse o Review of completed reports for anomalies & discrepancies o Troubleshooting data issues/discrepancies o Ensure formatting & delivery parameters are met Updating Tableau dashboards and Excel Dashboard as required for daily/weekly client reporting. Investigate and understand the opportunities of new data sources in the context of integration into Tableau. Updating Tableau/Excel/ or any similar dashboards for daily/weekly client reporting. Support data cleansings & manipulation process including but not limited to: o Taxonomy classification o Conversion re-naming, grouping o Removal of test/ghost impressions Desired Skills:- • Minimum 2.5+ years of experience in Analytics • Strong verbal/written communication and data presentation skills, including an ability to effectively communicate with both business and technical teams. • Hands-on experience in creating complex Excel reports, SQL Queries joining multiple datasets • Data Visualization tools such as Quick Sight / Tableau / Power BI / Datorama • Minimum 1+ years of experience in working in JavaScript. • An ability and interest in working in a fast-paced, ambiguous and rapidly-changing environment • Experience in developing requirements and formulating business metrics for reporting, familiarity with data visualization tools, e.g. Tableau, Power BI