Senior Data Analyst

Pennington Choices Ltd; Warrington; On-site; GBP 40,000 - 50,000; Full time

Job summary

Join a forward-thinking company as a Senior Data Analyst, where you'll play a pivotal role in modernizing data intelligence and customer data delivery. In this hands-on position, you will design and develop business intelligence solutions using Power BI, SQL, and Python. Collaborating with diverse teams, you'll ensure data accuracy while delivering insightful dashboards that drive decision-making. With a commitment to employee growth and a supportive environment, this role offers a unique opportunity to shape your career while contributing to exciting projects. If you're passionate about data and innovation, this is the perfect opportunity for you.

Benefits

Competitive salary

Flexible working

37.5-hour working week

26 days annual leave plus 8 Bank Holidays

Enhanced pension contributions

Learning and Development opportunities

Company social events

Cycle to work scheme

Private healthcare access

Paid sick leave allowance

Qualifications

• 5 to 10 years of experience in BI reporting and dashboard development.
• Strong proficiency in Power BI and data transformation tools.

Responsibilities

• Design and deploy BI solutions using Power BI and SQL.
• Collaborate with teams to ensure accurate data delivery and insights.

Skills

Power BI

DAX

SQL

Python

Data Modelling

Analytical Thinking

Problem-Solving

Microsoft Excel

Tools

Azure

SharePoint

Azure Data Factory

Job description

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, we've been recognised by Best Companies as a very good employer each year since 2018.

If successful, you will be joining us at a very exciting time. The business has already been through a period of substantial growth, concluding its current 5-year business plan in April 2024 which will achieve a turnover of £17.5m. A further 5-year plan through to 2029 is being developed with a projected growth to £40m.

Ready to start your next chapter?

If this sounds like the job for you, complete the job application and attach your CV for consideration in the link below.

Apply to become a Senior Data Analyst here Our team will be reviewing all applications over the next couple of weeks. Unfortunately we are unable to respond to everyone individually, therefore if you have not heard from us within 14 days it means that we will not be progressing your application further on this occasion.

Explore

Hear directly from our teams across the UK about what life is like working for Pennington Choices.