We are seeking a proactive Junior Reporting and Business Analyst to join our expanding media company.
In this role, you will collaborate with various departments, including account management, finance, and marketing, to create, develop, manage, maintain, and enhance campaign reporting.
Additionally, you will contribute to reporting efforts across different departments, ensuring accuracy, timeliness, and clarity.
This position is an excellent fit for an organized and customer-focused self-starter who thrives in a dynamic and fast-paced environment.
If you're looking to gain experience within a growing organization, this role offers an exciting opportunity.
Responsibilities: Assist the Account Manager in creating, tracking, and maintaining client reporting suites.
Conduct regular reviews of existing reports to identify areas for improvement, correct errors, enhance formulas, and improve style/formatting.
Generate ad-hoc reports upon request.
Leverage raw data and summary statistics to expand metrics, analyses, and forecasts.
Maintain confidentiality and adhere to commercial sensitivity guidelines for all reports.
Fulfill other assigned duties as required.
Requirements: Proficiency in Google Suite and Google Drive, particularly Google Sheets and Google Apps Script (equivalent experience in Microsoft Excel will be considered).
Intermediate to strong knowledge of advanced spreadsheet formulas and applications, including lookups, filters, and array formulas.
Familiarity with data warehousing, APIs, and SQL is advantageous but not mandatory.
Strong affinity for numbers, mathematical operations, and meticulous attention to detail.
Prior reporting experience within a media campaign environment is a valuable asset (though not a strict requirement).
Interpersonal Skills: Exceptional organizational, time management, and project management skills.
Effective written and verbal communication abilities.
Strong attention to detail and commitment to documentation.
Capability to work both independently and collaboratively within a team.
Familiarity with privacy and security protocols for safeguarding confidential and personal information.