Macildowie Recruitment & Retention - Data, BI & MI Analytics Data Analyst (PowerBI / SQL) - Up to 50,000 - Pontefract Monday - Friday, 9am - 5pm - Hybrid Working Available - Permanent Macildowie Data Analytics is proud to collaborate with an organisation in Pontefract to recruit a Data Analyst (PowerBI / SQL) to join our client's growing Data & BI function. The key objective is to understand commercial analytics whilst building and nurturing positive relationships with internal stakeholders to create user-engaging BI/MI through running an ETL process involving SQL and PowerBI, reporting on key customer trends, customer buying patterns, budgeting and forecasting. Main Responsibilities Confidently collaborating with internal stakeholders to construct appropriate value-adding commentary ensuring that the BI/MI you're reporting is user engaging and tells a story. Extracting data from core systems whilst partnering and cooperating with finance and the wider teams to identify trends creating new purposeful BI/MI on customer sales, customer buying patterns, customer returns, forecasting, budgeting and overseas / competitor trends, creating dashboards on a weekly, monthly basis using Excel and PowerBI. Creating financial performance reports against forecast working to identify tactical areas of growth. Transforming complex data into actionable insights that drive business growth and optimise performance. Cooperating with stakeholders to provide appropriate value-adding commentary helping our client identify gaps and explore. Working with raw data from our clients data warehouse, running a full ETL process including coding SQL data through to building stakeholder PowerBI reports. Identify opportunities to automate data processes and implement data quality control measures. Build a comprehensive and context driven, understanding of returns rates for use in modelling by income stream, adapting attributes to consumer returns behaviour and adjusting to numerous markdown events. The Candidate Previous experience operating as a Commercial Analyst, Data Analyst, Data Engineer or in a similar position. Ability to create meaningful, clear dashboards with appropriate value-adding commentary. Proficient in using data reporting tools such PowerBI including DAX and Excel. Excellent communication skills. Able to commute to Pontefract. Comfortably able to query and code SQL data. The ability to convey complex data sets to stakeholders, ensuring the BI/MI tells a story and is user engaging. Benefits Bonus scheme - dependent on profit performance. Employee ShareSave Scheme. Electric Car Scheme - salary sacrifice. Staff discounts. Free parking on site. Opportunity to work with Python. The first stage of the application process is to apply online. If you would like any more information about this vacancy before applying, please get in touch with Tom Whitsey. Please put your home postcode on your CV when applying. Our recruitment tech uses this to make sure your CV is reviewed by the relevant consultant, for the relevant job(s), in the relevant geography. Macildowie are a recruitment business working on behalf of a client to recruit this role. Your personal data may be forwarded to that client company as part of the application process. If you would like information on how we will process your data please go to our website (macildowie.com) and view our fair processing notices which are located at the bottom of the page under privacy policies. Within the fair processing notice for Candidates there is guidance on how to amend your contact preferences or exercise your rights relating to personal data. We can't provide direct links as email address and website urls within our job adverts are removed by some of the websites on which we advertise. Macildowie is a specialist recruitment consultancy with a rich history of enhancing the careers of professionals across the Midlands and the Northern Home Counties. We have an unrivalled understanding of the local market place and recruit for the majority of the region's premier employers. To search for all of our live jobs please visit us at macildowie.com.