Commercial Data Analyst

Anderson Knight is delighted to be partnering with a market-leading manufacturing organisation to recruit a Commercial Data Analyst. This is an excellent opportunity to join a well-established business where data and business intelligence play a critical role in driving commercial performance and strategic decision-making.Our client is seeking a commercially minded Commercial Data Analyst to take ownership of Business Intelligence reporting, analytics, data integration and reporting solutions across the organisation.This position offers a unique blend of stakeholder engagement, technical development and strategic data management, making it ideal for someone who enjoys transforming complex datasets into valuable business insights.Working as part of a growing data and analytics function, you will be responsible for developing and enhancing Power BI dashboards, SQL reporting solutions, ETL processes and cloud-based Business Intelligence platforms. You'll work with modern technologies including Microsoft Azure, Microsoft Fabric, SQL Server and Python, helping to shape the organisation's data capability and reporting landscape.Key ResponsibilitiesDesign, develop and maintain interactive Power BI dashboards, reports and data models that support commercial and operational decision-making.Engage with stakeholders across multiple business functions to gather reporting and analytics requirements.Translate business needs into scalable Business Intelligence and reporting solutions.Develop, optimise and maintain SQL Server databases, stored procedures, views and functions.Build, manage and enhance ETL processes and data integration solutions.Leverage Microsoft Fabric, Azure Data Services and cloud technologies to improve reporting capabilities and data accessibility.Ensure the integrity, accuracy and security of business data through robust governance practices.Support Master Data Management (MDM) initiatives and continuous data quality improvements.Deliver actionable insights through advanced analytics and reporting.Drive automation across reporting processes and identify opportunities to improve business performance through data-led decision-making.Skills & ExperienceMinimum of 2-3 years' experience within a Business Intelligence, Data Analytics, Reporting or Data Development role.Strong hands-on experience developing Power BI dashboards, data models and DAX measures.Advanced SQL Server and T-SQL skills, including database development, stored procedures and performance optimisation.Experience designing and supporting ETL processes, data migrations and system integrations.Strong understanding of SSIS, SSRS and SSAS.Knowledge of data governance, data quality frameworks and Master Data Management principles.Excellent analytical and problem-solving abilities.Strong communication skills with the ability to engage both technical and non-technical stakeholders.A commercially focused mindset with the ability to turn data into meaningful business recommendations.DesirableExperience with Microsoft Azure, Microsoft Fabric or cloud-based data platforms.Python experience for data analysis, automation or reporting.Exposure to data warehousing environments and modern BI architectures.What's on Offer?Hybrid working environment.Opportunity to work with the latest Microsoft Data & BI technologies.Exposure to Microsoft Fabric and cloud-based analytics projects.Broad stakeholder engagement across a complex and evolving business.Excellent career development and progression opportunities.A collaborative and supportive team environment.Competitive salary and benefits package.Convenient South Lanarkshire location with easy access from Glasgow and the wider Lanarkshire area.If you're passionate about data, analytics and Business Intelligence and want to play a key role in helping a leading organisation make smarter, data-driven decisions, we'd love to hear from you.