Data and Reporting Analyst

Job Description

This role spans the full analytics lifecycle—from ingesting structured and unstructured data into our Microsoft Data Warehouse and Fabric Lakehouse, modelling trusted datasets and business facts, through to developing high-quality Power BI dashboards that provide meaningful insights into profitability, cost control, operational performance and emerging business opportunities.

Working closely with stakeholders across the business, from dealership teams through to Executive Leadership, you will translate business requirements into practical data solutions that drive informed decision-making and continuous improvement.

RESPONSIBILITIES:

• Design, build and maintain data ingestion pipelines into Microsoft Warehouse and Microsoft Fabric / One Lake.
• Integrate structured and unstructured data from Dealership Management Systems (DMS), finance systems, marketing platforms, lead management systems and external data sources.
• Develop reusable datasets, semantic models and curated data layers to support enterprise reporting.
• Define and maintain trusted business facts, dimensions and key data entities across the organisation.
• Build enterprise-grade Power BI dashboards and reports that deliver meaningful insights into profitability, operational performance, cost control and business growth.
• Implement and maintain Row-Level Security and optimise report performance and usability.
• Engage with stakeholders across dealerships, functional business units and Executive Leadership to understand reporting requirements and translate business challenges into data-driven solutions.
• Identify reporting gaps and proactively recommend new analytics opportunities.
• Analyse data to identify profit improvement opportunities, cost inefficiencies, operational bottlenecks, revenue leakage and emerging business trends.
• Support strategic initiatives through data modelling, reporting and analytical insights.
• Ensure data quality, accuracy and consistency across reporting solutions.
• Maintain documentation of data models, business definitions and reporting logic.
• Promote best practice data governance and enterprise reporting standards.

SKILLS & EXPERIENCE:

• 4+ years’ experience in Data Analytics, Business Intelligence or Data Engineering.
• Hands-on experience with Microsoft Fabric, Azure Data Services or similar Lakehouse platforms.
• Advanced SQL skills and strong data modelling expertise.
• Extensive Power BI development experience, including DAX, semantic models and performance optimisation.
• Experience working with structured and semi-structured datasets.
• Demonstrated ability to translate business problems into practical data solutions.
• Strong communication skills with both technical and non-technical stakeholders.
• Commercial mindset with the ability to identify opportunities that drive business outcomes.
• Curious, analytical and proactive approach to solving business problems.
• Collaborative team player with a focus on delivering practical solutions

Are you interested in this position?
Apply by clicking on the “Apply Now” button below!
#GraphicDesignJobsOnline
#WebDesignRemoteJobs
#FreelanceGraphicDesigner
#WorkFromHomeDesignJobs
#OnlineWebDesignWork
#RemoteDesignOpportunities
#HireGraphicDesigners
#DigitalDesignCareers
# Dynamicbrand guru