Analyst

Job Description

The Pilot Group- AnalystToday’s world runs on critical infrastructure and technology. Pilot Group are dedicated to improving people’s lives and the environment. We lead the way in SMART, SAFE and SUSTAINABLE infrastructure solutions. With combined experience over 5 decades spanningacross electronics, electrical, heating and lighting markets, we pride ourselves in working in partnership with organisations world-wide to deliver integrated technology to improve working environments and transport systems.Our businesses cover energy management, EV charging, traffic control systems, and Electrical Wholesale working across a wide range of commercial and industrial applications.Main Duties/Responsibilities Analyst:

• Development of management information packs to support accounts team and analysis of financial performance, including monthly P&L and cash flow analysis.
• Act as a finance business partner to the operational teams (including purchasing, logistics, sales) to provide meaningful insight and drive both short- and long-term initiatives.
• Support management team to provide clear view of actuals vs forecast with clear analysis as appropriate.
• Work closely with Data Strategy & Analytics Lead to support business requirements and prioritise workload.
• Design and deliver deep-dive analysis to aid commercial leads in understanding historical/current business performance, across functions, to promote commercial opportunities across sales and supply chain.
• Deliver ad hoc metrics and insights to support Finance and Operational teams, promote use of data for decision making, where possible
• Manipulate and analyse large data sets for ad-hoc and routine reporting.
• Additional project work to support expansion plans.
• Ad-hoc tasks as required by senior finance and operational team.

Analyst - Ideal Requirements

• Professional experience with BI dashboarding & visualisation tools (preferably Power BI).
• Proven experience with financial modelling.
• Proficiency with Microsoft Excel for data preparation, financial modelling & data visualization.
• Experience with a Cloud Data Warehouse, such as Google BigQuery (ideally), Redshift, Snowflake, Azure Data Warehouse.
• Proficiency with SQL for data wrangling, cleaning, preparation & summarisation.
• Strong financial modelling and analytical skills, with advanced skills in excel.
• Experience with PowerPoint for presenting insights to business stakeholders.

Person specification - Analyst

• A proven ability to plan and prioritise own workload to meet tight deadlines.
• A high standard of accuracy with financial and statistical data.
• An ability to organise own work and to take initiative by being proactive.
• An ability to determine insightful observations from detail for management attention.
• Strong communicator - written and verbal.
• Organised with excellent time management skills
• High levels of drive and enthusiasm
• Flexible and adaptable
• Able to prioritise, and work to deadlines
• Excellent interpersonal skills and a relationship builder
• Ability to challenge and say no when needed.

Desirable requirements/experience - Analyst

• 2-3 years experience in this environment
• Experience using Python (ideal) or R to aid development of more complex analyses and production of data pipelines.
• Some knowledge of Microsoft SQL Server.

Location Head Office, Manchester (Short walk from Manchester Victoria train station)Commutable from: Manchester, Greater Manchester, Oldham, Rochdale, Warrington, Widnes, Runcorn, Preston, St Helens, Altrincham, Stockport, Bury, Bolton, Leigh, Wigan, WilmslowCultureThe Pilot Group are a blue-sky thinking, entrepreneurial, family-run, small to medium enterprise with big ambitions. No job too small, no task too big, our teams help and support each other across our sectors. Our employees are a collaborative, inclusiveteam that lead the way in the development of smart, safe, and sustainable technologies. Our company values its greatest asset - the people it employs. Be part of the solution with Pilot Group.BenefitsHealthshield - Healthcare, Dental, OpticalLife Assurance (after 3 months) 4 x annual salary25 days holiday P.A plus bank holidaysRecruitment AgenciesThe Pilot Group operates a strict PSL and will not accept any unsolicited CVs sent to any member, employee, representative or business unit of the Pilot GroupRequired skills

• Analysis
• Analyst
• Data