Data Analytics & Reporting Specialist - Client Engagement

We are recruiting for a motivated Data Analytics & Reporting Specialist to deliver the reporting roadmap for our Marketing, Sales, and Customer Services teams at Control Risks.

This role requires close collaboration with stakeholders across multiple geographies including business owners, analysts and data engineers to translate business requirements into effective Power BI solutions.  Beyond dashboard creation, the role focuses on interpreting data trends, analyzing complex datasets and delivering actionable insights that directly influence decision-making.

You will be responsible for developing technical documentation, designing data solutions and delivering a mix of enhancing existing reports and entirely new dashboards to meet evolving business needs.

Requirements

What You'll Do:

Data Analysis & Insights

• Analyze large and complex datasets to uncover actionable trends, opportunities and risks.
• Translate raw data into meaningful insights that drive strategic decision-making across marketing, sales, and customer service teams.
• Collaborate with business stakeholders to identify reporting needs and proactively recommend improvements.

Data Analysis & Insights

• Analyze large and complex datasets to uncover actionable trends, opportunities and risks.
• Translate raw data into meaningful insights that drive strategic decision-making across marketing, sales, and customer service teams.
• Collaborate with business stakeholders to identify reporting needs and proactively recommend improvements.

Dashboard Development & Management

• Requirements Gathering: Collaborate with Product Owners and stakeholders to conceptualize, design,and deliver dashboards aligned with business objectives.
• Data Visualisation: Craft visually compelling and interactive Power BI dashboards and reports that effectively convey business-critical data.
• Documentation: Create and maintain comprehensive documentation for data models, report development processes and best practices.
• Optimisation: Periodically review and enhance dashboard performance, promoting swift data access and a user-friendly experience.
• Performance Tuning: Optimise Power BI reports and dashboards for speed and responsiveness, collaborating closely with business leaders to understand reporting requirements and deliver data-driven solutions.

Data Modelling

• Data Integration: Collaborate with the Data Architect to develop and maintain the common data model for Sales & Marketing (Silver) from raw D365 CRM data (Bronze).
• Identify additional Sales & Marketing data to ingest into Microsoft Fabric (e.g. Google Analytics and Hotjar) to augment our CRM data.
• Query Optimisation: Collaborate with the Data Engineering team and Data Architect to ensure appropriate indexes and optimisation of the Gold consumption models in Fabric.
• SSAS Cube Development: Maintain existing SSAS Cubes before migration to Microsoft Fabric.
• Data Modelling: Working with the Data Engineering team and Data Architect to develop Sales & Marketing curated consumption models (Gold) to support Sales and Marketing Business Intelligence and Reporting requirements (Power BI)

User Support & Best Practice

• Training & Support: Deliver training sessions for end users, ensuring high dashboard utilisation and to support data-driven decision-making.
• Data Queries: Support end users with data queries.
• Feedback Loop: Regularly collect user feedback on dashboard usability and data representation, refining based on this input.
• Collaboration: Work closely with the business intelligence team and analysts across different departments to ensure alignment across reports.
• Best Practices: Share best practices and improved ways of working with other business intelligence team members across the organisation.

Who You Are:

• Power BI: Proficient in creating complex Power BI dashboards and reports, utilising DAX for calculations and measures.
• SQL Server: Strong expertise in SQL Server development, capable of crafting bespoke SQL queries and managing/updating Database Views.
• Microsoft D365: Essential familiarity with D365 CE & D365 Finance and Objects, our core systems.
• Understanding of Microsoft Fabric and Lakehouse
• Data Modelling: Ability to create data models and define relationships for accurate reporting from KQL database or Lakehouse SQL endpoints.
• Marketing & Sales Acumen: Solid understanding of Marketing and Sales concepts, along with standard reporting metrics.
• MarTech: Understanding of MarTech tools and the typical data they provide.
• Communication: Strong communication skills to collaborate effectively with cross-functional teams and stakeholders.
• Problem-Solving: Excellent problem-solving skills to troubleshoot data issues and optimise reports.
• Team Player: Demonstrated ability to work collaboratively in a team environment.