BI & Data Integration Analyst: Power BI, SQL & ETL

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 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,