Power BI Specialist

JOB SUMMARY:

Responsible for designing, developing, reporting and maintaining business intelligence solutions using Microsoft Power BI. Your role involves collaborating with internal stakeholders (client account managers) to create visually appealing and insightful marketing ROI dashboards, and ensuring data accuracy for effective decision-making.

Our client PowerBI dashboards pull data from various marketing data sources, e.g.: Websites (Google Analytics), Google Ads, CRM, Mailchimp, LinkedIn and other social media.
Our mining Industry Intelligence - Mine-Insight, pulls data from S&P Global Data (live data) and Microsoft Access.

Primary
• Collaborate with clients and Internal client account managers/stakeholders to understand reporting needs.
• Design and develop Power BI reports and dashboards based on business requirements.
• Ensure data accuracy and consistency by creating optimized data models.
• Implement and maintain data extraction, transformation, and loading (ETL) processes.
• Stay updated on Power BI features and best practices to continually enhance reporting capabilities.
• Regular (monthly) KPI reporting to all Clients.
• Collaborate with IT teams to integrate Power BI solutions with other systems.
• Perform troubleshooting and debugging of Power BI reports and dashboards.
• Contribute to the development and maintenance of data governance policies.
• Assist in evaluating and recommending new tools or technologies for BI improvement.

Marketing Support
• Support the Marketing Coordinator(s) to achieve the goals, strategies and outcomes relative to the Client’s marketing ROI reporting.
• Work closely with other internal staff (web developers, graphic-designers, animators, etc) as required to achieve all TEAM objectives.
• Ensure proper written implementation and adherence to Client data guidelines at all times.

General
• Present to work in a fit manner, including adhering to drug and alcohol, and fatigue policies.
• Behave in a manner that protects the safety of yourself, fellow workers, and visitors.
• Comply with all reasonable written and verbal instructions from direct supervisors (Marketing Coordinator) and senior management.
• Look after all company equipment and check for defects prior to use.
• Perform all works to your highest standard.
• Communicate appropriately and in timely fashion with all persons including management, co-workers and co-workers when required.
• Report all injuries and illnesses immediately to your direct supervisor.
• Attend and participate in all meetings and inspections where required.
• Participate in induction, training and review activities.
• Adhere to all TEAM policies and procedures.