Data Analyst

Anderson Knight; Hamilton; On-site; GBP 32,000 - 46,000; Full time

Job summary

Anderson Knight is partnering with a growing client to recruit a BI/Data Integration Analyst. You will design, develop, and maintain Power BI dashboards, reports, and data models, translating business needs into effective analytics.

Working with stakeholders across departments, you will support SQL Server databases, ETL processes, and data integrations while upholding data governance and quality standards. The ideal candidate has 1–2 years in BI or data development, strong Power BI experience,

Qualifications

• 1–2 years in BI, reporting or data development.
• Strong Power BI dashboard and report experience.
• Good SQL Server knowledge including T‑SQL, views and stored procedures.

Responsibilities

• Design, develop, and maintain Power BI dashboards, reports and data models.
• Gather requirements and translate into reporting solutions.
• Develop and support SQL Server databases and views.
• Build and maintain ETL processes and data integration solutions.
• Ensure data accuracy and governance standards.
• Support master data management and data quality initiatives.
• Collaborate with stakeholders to deliver insights and reporting.
• Identify opportunities to improve reporting and automation.

Skills

Power BI

SQL Server

SSIS

SSRS

SSAS

ETL

Data Governance

Data Quality

Stakeholder Engagement

Data Modeling

Tools

SSIS

SSRS

SSAS

Job description

Anderson Knight is delighted to be partnering with our client to recruit a BI/Data Integration Analyst. This is an exciting opportunity to join a growing team and play a key role in delivering Business Intelligence solutions that support data-driven decision-making across the organisation.

You will be responsible for designing, developing, and maintaining Power BI dashboards, reports, and data models that provide meaningful insight into business performance. Working closely with stakeholders across multiple departments, you will gather reporting requirements, recommend solutions, and deliver high-quality reporting while ensuring data accuracy and governance.

The role will also involve supporting SQL Server databases, ETL processes, and data integrations to ensure the efficient flow of information across business systems. In addition, you will contribute to master data management initiatives, helping to improve data quality, consistency, and governance across the business.

Key Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, and data models.
• Gather business requirements and translate them into effective reporting solutions.
• Develop and support SQL Server databases, stored procedures, views, and other database objects.
• Build and maintain ETL processes and data integration solutions.
• Ensure data accuracy, integrity, and compliance with governance standards.
• Support master data management and continuous data quality improvement initiatives.
• Collaborate with stakeholders across the business to deliver meaningful insights and reporting.
• Identify opportunities to improve reporting, automation, and business processes.

About You

• 1-2 years' experience within a Business Intelligence, Reporting, or Data Development role.
• Strong experience developing and supporting Power BI dashboards and reports.
• Good SQL Server knowledge, including T-SQL, stored procedures, views, and functions.
• Experience with Microsoft SQL Server technologies such as SSIS, SSRS, and SSAS.
• Experience developing ETL processes and supporting data integrations.
• Strong analytical, problem-solving, and communication skills.
• Ability to engage with stakeholders and translate business requirements into technical solutions.
• Experience supporting master data management and data governance initiatives.
• Comfortable managing multiple priorities and working independently.

Desirable

• Exposure to cloud ERP platforms such as Azure, SAP, or Infor M3.
• Experience using Python.
• An interest in AI, automation, and emerging technologies.

What's on Offer

This is an excellent opportunity to join a forward-thinking organisation where data is at the heart of decision-making. You will gain exposure to a broad range of technologies and business functions while contributing to key projects that drive operational and commercial performance