Data Analyst

Allscreens Nationwide Ltd; Gainsborough CP; On-site; GBP 35,000 - 45,000; Full time

Benefits offered by this job

25 days annual leave

Pension contributions up to 10%

Professional training funded

One day volunteering leave

Health and wellbeing benefits (Paycare

Acis Perkz discount scheme

Cycle to work scheme

Employee assistance programme

Job summary

Acis is seeking a Data Analyst to turn complex datasets into actionable insights. You will blend on-premise systems, hosted SaaS, and direct SQL sources to create dashboards (Power BI preferred) and meaningful analyses.

Your insights will support decision-making across operational teams and national data returns. You will collaborate with IT and the Data Performance Lead to define MIS requirements, promote self-service reporting, and help drive Data Lake/MI projects while ensuring data quality

Qualifications

• Higher education qualification or substantial equivalent relevant work experience in management information development and reporting.
• Excellent analytical skills and attention to detail, creative at problem solving.
• Experience with large database systems analysis / administration and business intelligence reporting software.
• Experience with data architecture, data warehouse and data lakes and reporting across multiple group-wide business systems.
• Comprehensive understanding of SQL server databases, table and field structures; able to create SQL views.
• Experience creating or working on Power BI management information dashboards to provide KPIs.
• Advanced MS Excel/VBA skills.
• Understanding of GDPR and cyber security.
• Ability to manage a busy workload and meet deadlines.
• Open to cross-skilling and developing new data streams.

Responsibilities

• Provide high quality management information via reporting from on-premise systems, hosted SAAS solutions and direct SQL for dashboards (Power BI preferred).
• Interpret performance and operational data to produce dashboards and insights for colleagues across the organisation.
• Attend meetings to present performance data and insights.
• Conduct trend and pattern analysis, undertake research and produce reports and presentations.
• Collaborate with business operations to translate requirements into data-led solutions.
• Determine MIS requirements with Data Performance Lead and IT colleagues.
• Assist with completion of national data returns.
• Promote self-service reporting culture and data quality across teams.
• Use Power BI, SQL, SSRS, ETL, Power Automate, Advanced Excel and Crystal Reports for bespoke reporting.
• Feed back to Systems Team to improve data collection and processes.
• Lead new systems reporting requirements and potential Data Lake/MI stream projects.
• Maintain data integrity and accuracy to support management decisions, ensuring GDPR compliance.

Job description

If you’re driven by turning complex data into clear, actionable insight, this is your chance to shape decisions that impact entire communities. As our Data Analyst, you’ll blend information from on‑premise systems, hosted SaaS platforms and direct SQL sources to create powerful management dashboards and meaningful analysis—ideally using Power BI. You’ll interpret performance trends, uncover patterns and present insights that help colleagues across the organisation operate smarter and faster. From attending meetings to share your findings, to partnering with operational teams to translate their needs into data‑led solutions, your work will influence everything from national data returns to future reporting strategies. You’ll support a culture of self‑service, champion data quality, and contribute to emerging projects such as new reporting requirements or potential Data Lake/MI developments. With your strong understanding of large database systems, reporting methodologies and regulatory responsibilities, you’ll help maintain data integrity, improve processes and strengthen how we use information across Acis. You’ll also collaborate closely with IT colleagues—sharing expertise, building capability and ensuring our data foundations stay robust.

As a Data Analyst, a typical day might include:

• Providing high quality management information via reporting directly from on premise systems, hosted SAAS solutions along with direct SQL to produce management information dashboards (preference for using Power BI) . Also providing context and analysis to these. This will often involve blending data from different but connected business systems.
• Interpreting performance and operational data to produce dashboards and insightful management information to colleagues across the organisation, to help them operate and make decisions effectively.
• Attend meetings to present performance data and insights.
• Conduct trend and pattern analysis, undertake research and produce reports and presentations.
• Engage both proactively with the business operations teams and assist in the translation of their business requirements into
• Working with the Data Performance Lead and colleagues across the business to determine Management Information requirements.
• Assistance with the completion of national data returns.
• Supporting the business to use system reporting packages available within the main Acis IT business systems and promoting a culture of self‑service.
• Using reporting methodologies such as Power BI, SQL, SSRS, ETL, Power Automate, Advanced Excel, Crystal reports, etc. for bespoke data reporting requirements and assisting with complex queries.
• Assist and feed back to the wider Systems Team to develop a culture of data quality, data recording and improved processes to enhance data collection and improve system use.
• Lead on new systems reporting requirements and potential Data Lake/MI stream projects.
• Using your excellent knowledge and understanding of large database systems and reporting methodologies to help maintain data integrity and accuracy to support management decisions.
• Follow system statutory and regulatory requirements ensuring Acis Group is compliant with its responsibilities on data protection regulations.
• Collaborate, Provide and share expertise to develop colleagues within the IT Services team, ensuring a shared knowledge and

Your role is all about staying up to date awareness of industry and sector best practice relating to IT systems.

Some of the experience/skills we need to consider you:

• Higher education qualification or substantial equivalent relevant work experience with a suitable professional qualification in management Information development and reporting.
• Excellent analytical skills and attention to detail, creative at problem solving.
• Experience of large database systems analysis / administration and business intelligence reporting software
• Experience of data architecture, data warehouse and data lakes and reporting across multiple group wide business systems.
• Comprehensive understanding of SQL server databases, table and field structures. Able to create SQL views from databases
• Experience of creating or working on Power BI management information dashboards to help provide Key Performance Indicators.
• Detailed technical skills and abilities in MS Applications including advanced Excel/VBA.
• A solid understanding of user interface / interaction design as applicable to enterprise software and web‑based applications.
• Demonstrable practical experience of at least some of the following:
• 1. Power BI, SQL Developer, SSRS, Data Manipulation, Batch Processing
• 2. SQL, Oracle, Database Administration
• 3. Web, C#, HTML,
• Comprehensive understanding of GDPR and cyber security.
• The ability to handle a busy diverse workload and operate to deadlines.
• Resilience. Working in social housing is a challenging but rewarding career. You’ll be helping to bring real change to our
• Willing to learn new work streams – we’re all about cross‑skilling our people.

What will make you stand out from the crowd:

• Experience or knowledge of business social housing sector business systems,
• Understanding of requirements gathering, system workflow and system process design.
• Experience of working from and developing a data warehouse / building data lakes.
• Technical knowledge of server operating systems and Active Directory.
• An organised individual who is comfortable with working flexibly in a busy environment

Being part of the Acis team, you’ll get:

• Generous holiday entitlement –25 days annual leave rising by 1 per year to a max of 30 plus bank holidays
• Pension contributions up to10%
• The opportunity to undertakeprofessional training, funded by us.
• One days paid leave a year for volunteering work (in addition to your Annual leave entitlement)
• Staff benefits with Paycare –A health and benefits scheme giving you support and contributions towards various health benefits such as counselling, eye tests, vaccinations and much more
• Benefits with Acis Perkz –a discount scheme giving you savings off hundreds of schemes including discounts on your coffee, weekly shop, days out and much more!
• Employee recognition scheme, where we celebrate and award our Stars within Acis, including gift vouchers
• Long service awards for our loyal employees
• Cycle to work scheme
• Employee Assistance Programme to give you confidential advice and support, when you need it
• Professional membership subscription to support your continuousprofessional development
• Death in service benefit as part of ourpension scheme

Acis are committed to equality and diversity, are a proud member of disability confident and welcome applications from any applicant who feel they hold the essential skills to fulfil the role.

We recognise that people need flexibility in their role and we’re happy to discuss flexible working options with the successful candidate in addition to any aid with interviewing that you