Senior Data Analyst

Full-time (permanent)
Office based in Warrington, Cheshire, located just 3 minutes from M56, Jct 10.
Salary from £40k to £50k dependent on experience/skills

We are seeking a Senior Data Analyst to become a valuable part of our IT department at Pennington Choices.

About this role The role will be a very hands-on position and requires a proficient data professional to play a leading role in modernising the business's data intelligence and customer data delivery programme.

• You will be responsible for designing, developing, and deploying business intelligence solutions using Microsoft Power BI and DAX script, SQL Script, Python.
• You will be responsible for working with all business service lines to ensure smooth data delivery to clients.
• You will collaborate closely with data analysts, business stakeholders, and other IT professionals to ensure data accuracy, optimize performance, and deliver insightful dashboards and reports that support decision-making processes to customers and colleagues alike.

In collaboration with the Head of IT, you will assist in the training/upskilling of other Data Analysts.

Responsibilities include

• Working with the wider data team to deliver customer data requirements on all our service lines.
• To provide BI dashboards and data sets to internal colleagues using Power BI or any other platform the company decides it needs.
• Perform data manipulation and transformations as required to meet customer and colleague data requirements.
• Assist the Head of IT in data related projects, for example the Data Warehouse.
• There is no management responsibility, however the person in this role will be expected to take a lead and ownership of company data issues in collaboration with the Head of IT.

Role requirements, skills and/or experience

• High proficiency with other BI tools and data transformation (Power BI).
• Minimum of 5 to 10 years of experience in designing and developing reports/dashboards using Power BI.
• Strong proficiency in DAX, Power Query, SQL script, Python and data modelling in Power BI.
• Experience with SQL and relational databases for data extraction and manipulation.
• Knowledge of integrating Power BI with other platforms such as Azure and SharePoint.
• Ability to transform business requirements into technical specifications and intuitive visualizations.
• Strong analytical thinking and problem-solving skills.
• Highly Proficient with Microsoft Office 365, especially Microsoft Excel.

Preferred Skills:

• Knowledge of Azure Data Factory or similar ETL tools.
• Experience in architecture of databases in data warehouses/lakes.
• Understanding of data warehousing concepts and best practices.
• Any scripting skill around data transformation platforms
• Familiarity with Agile development methodologies.

Pennington Choices has been recognised by Best Companies as being a very good employer each year since 2018. We offer a working environment that is stimulating, where our people are given the tools they need to help shape their careers. With approachable and supportive line management and a proven track record of promoting from within, we encourage our people to be the best they can be, and we provide them with training, variety and support to help them grow.

We also provide colleagues with:

We are seeking a Senior Data Analyst to become a valuable part of our IT department at Pennington Choices.

About this role The role will be a very hands-on position and requires a proficient data professional to play a leading role in modernising the business's data intelligence and customer data delivery programme.

• You will be responsible for designing, developing, and deploying business intelligence solutions using Microsoft Power BI and DAX script, SQL Script, Python.
• You will be responsible for working with all business service lines to ensure smooth data delivery to clients.
• You will collaborate closely with data analysts, business stakeholders, and other IT professionals to ensure data accuracy, optimize performance, and deliver insightful dashboards and reports that support decision-making processes to customers and colleagues alike.

In collaboration with the Head of IT, you will assist in the training/upskilling of other Data Analysts.

Responsibilities include

• Working with the wider data team to deliver customer data requirements on all our service lines.
• To provide BI dashboards and data sets to internal colleagues using Power BI or any other platform the company decides it needs.
• Perform data manipulation and transformations as required to meet customer and colleague data requirements.
• Assist the Head of IT in data related projects, for example the Data Warehouse.
• There is no management responsibility, however the person in this role will be expected to take a lead and ownership of company data issues in collaboration with the Head of IT.

Role requirements, skills and/or experience
Essential Skills:

• High proficiency with other BI tools and data transformation (Power BI).
• Minimum of 5 to 10 years of experience in designing and developing reports/dashboards using Power BI.
• Strong proficiency in DAX, Power Query, SQL script, Python and data modelling in Power BI.
• Experience with SQL and relational databases for data extraction and manipulation.
• Knowledge of integrating Power BI with other platforms such as Azure and SharePoint.
• Ability to transform business requirements into technical specifications and intuitive visualizations.
• Strong analytical thinking and problem-solving skills.
• Highly Proficient with Microsoft Office 365, especially Microsoft Excel.

Preferred Skills:

• Knowledge of Azure Data Factory or similar ETL tools.
• Experience in architecture of databases in data warehouses/lakes.
• Understanding of data warehousing concepts and best practices.
• Any scripting skill around data transformation platforms
• Familiarity with Agile development methodologies.

Benefits Pennington Choices has been recognised by Best Companies as being a very good employer each year since 2018. We offer a working environment that is stimulating, where our people are given the tools they need to help shape their careers. With approachable and supportive line management and a proven track record of promoting from within, we encourage our people to be the best they can be, and we provide them with training, variety and support to help them grow.

We also provide colleagues with:

• Competitive salary and transparent salary bands
• Commitment to super flexible and remote hybrid working where applicable
• 37.5-hour working week
• 26 days annual leave plus 8 Bank Holidays (pro rata)
• Additional leave for length of service up to 31 days each year
• Opportunity to buy additional annual leave or sell surplus leave
• Enhanced employer pension contributions of 4% when you contribute 6%
• Enhanced maternity and paternity pay
• Regular Learning and Development opportunities
• Regular company social events including an annual summer BBQ
• Cycle to work scheme, offering savings of at least 32% on a new bike and cycle safety accessories
• Electric Car salary sacrifice scheme, saving 30-60% on an electric car (subject to eligibility)
• Access to an online platform providing employee discounts on hundreds of high street brands
• Life insurance/Death in service offering 2 x salary cover from day one of employment
• Access to private healthcare, Employee Assistance Programme, and Wellness programmes including annual flu jab
• Paid sick leave allowance each year
• Free eye tests and contribution towards new glasses/frames
• Referral programme offering up to £2,000
• Option for personal use of company vehicle (subject to eligibility)
• Access to paid volunteering days in support of local charities/initiatives
• Length of service reward
• Welcome goodie bag
About us Pennington Choices is an Equal Opportunity Employer, and as such we recruit, hire, train, and promote persons in all job classifications without regard to race, colour, religion, sex, national origin, disability, age, marital status, sexual orientation, gender identity or expression, genetics, status as a protected veteran, or any other characteristics protected by law.

Pennington Choices provides property surveying and consultancy services to organisations nationwide. We have a wealth of experience working with more than 800 public and private sector organisations across social housing, NHS, education, and rail since 2000.

At the heart of what makes Pennington Choices special is our people. We live by our values of being fun, resilient, brave and treating each other with respect. We also know there's more to life than work, which is why we will encourage you to stay active, nurture your mental health, and create a fulfilling work/life balance.

Our head office is a converted barn in the picturesque Cheshire countryside, located just 3 minutes from M56 Jct10, and we have regional offices in Bromley, Kent and Sheffield. We are a close-knit organisation with people at our very core, and we strive for excellence in everything we do. As winners of Employer of the Year at both the Warrington Business Awards and the South London Business Awards . click apply for full job details