MW Partners is currently seeking a Business Intelligence Sr. Analyst to work for our client who is a global leader in the media and entertainment industry.
Responsibilities and duties:
- Foster data-informed decision making throughout the Client marketing organization
- Delivery analysis to inform marketing decision making using Cross-Platform and Clean Room analytics platforms
- Gather data requirements from marketing activation and strategy to design automated data pipelines or build new tables into Google BigQuery data warehouse for reliable and scalable reporting across business uses.
- Partner with data engineers to ensure design development and solution builds are tested and validated for signal resilience.
- Clearly provide statuses and project timelines with operational and technical teams as needed.
- Collaborate with team members to ensure dimensions and metrics in data pipelines are compliant with business workflows powering Client reporting.
- Support development of auditing tools of existing data sets to check for anomalies and irregularities; leverage tools to escalate data inconsistencies using SQL and Google Cloud Service suite features.
- Partner with data engineers to optimize speed performance of BigQuery tables in supporting dashboards and reports.
- Build dashboards (using Tableau Python and other BI tools) that illustrate how key performance indicators (KPIs) and metrics are changing over time. Provide color and insights from the findings and make recommendations to the business.
- Build data workflows for Client marketing data that ensures consistent data integrity.
- Stay current with emerging trends in data science AI and marketing analytics and apply them to business challenges
Requirements:
- BA/BS. 2 years experience in digital marketing and analytics web analytics online media industry.
- Proficient in SQL with a thorough understanding of data and systems infrastructures; experience extracting cleaning and transforming data within databases using SQL
- Experience or coursework in media measurement including cross platform web native app video measurement technology and standards
- Proficient with analytical tools and languages supporting data analysis reporting and visualization - Excel Microsoft Office Google Collaborative Apps (Docs Sheets Slides) Tableau R Python
- Strong detail-orientation with a penchant for data accuracy and good grammar
Additional Skills
- Strong mathematics statistics background
- Strong solutions-oriented and critical thinking mindset
- Experience using Google Cloud Platform (BigQuery)
- Experience translating requirements into actionable instructions and documentation
- Experience in working independently to meet deliverables with some oversight
- Experience using project management tools like those from Atlassian (JIRA Confluence)
For a confidential discussion or to find out more contact Itishree Mohanty on or apply now.