Madman Entertainment is Australia’s leading independent theatrical and home entertainment distributor. We’re looking for a versatile Business Intelligence Analyst to join our Melbourne-based I.T. team.
This is an awesome opportunity in the film & entertainment industry with lots of scope and plenty of interesting challenges. We are looking for a data wizard, with a passion for technology who loves solving problems and working with new tools to view and explore data in all sorts of ways.
As a Business Intelligence Analyst, your responsibilities will be to:
Resolve internal and external client reporting enquiries via the reports service desk
Build and maintain reports and troubleshoot existing reports and queries
Ensure BI and royalty reports are delivered to internal and external stakeholders accurately and on time each month
Ad hoc data extraction, manipulation & analysis for the purpose of insights and recommendations.
Ensure successful completion of overnight ETL and SQL jobs, and troubleshoot any issues
Maintain current databases, reporting servers
Deliver accurate, ongoing analysis of data for Madman's home entertainment and distribution businesses from a variety of sources
Drive the collection, cleansing, merging and management of customer data from various sources across the business
Assist with resolving technical issues for users around the business
Our ideal candidate will have:
Strong SQL programming skills with the ability to write and troubleshoot queries (SQL Server, MySQL)
Outstanding data extraction and manipulation skills from a variety of sources
Experience maintaining and designing reports using a reporting tool such as Jaspersoft, Crystal Reports or SSRS
Proven ability to transform large, complex and raw datasets into clear and actionable insights
High attention to detail with strong organisational and problem-solving skills
Excellent written, verbal and interpersonal communication skills
Ability to quickly learn and apply new technologies
Be an interactive team player, who is also comfortable working autonomously with excellent time management skills
Degree in IT (i.e. Computer Science) or equivalent
Nice to have:
Knowledge of ETL solution design
Experience with SSIS and Visual Studio
Knowledge of C# Programming
Microsoft PowerBI experience
Why work with us?
We’re a passionate and motivated team who are real fans of the content and genuinely love working together. Expect an open and collaborative environment with plenty of fun perks and access to great resources in our East Melbourne office, a short walk from Melbourne CBD.