BI Developer

Trades Workforce Solutions; Bury St Edmunds; Hybrid; GBP 45,000 - 60,000; Full time

Job summary

A long-established organization in Bury St Edmunds seeks an experienced Business Intelligence Developer. The role involves designing SQL Server data warehouses, developing ETL processes with SSIS, and providing engaging reporting solutions using SSRS and Power BI. Ideal candidates should possess strong skills in SQL, data analysis, and BI tools. The position offers hybrid working, career development, and excellent benefits including pension contributions and generous holidays.

Benefits

Hybrid working

Strong development pathways

Annual pay reviews

Excellent pension contributions

Generous holiday and family-friendly benefits

Qualifications

• Strong experience in SSRS, SSIS, SSAS, and Power BI.
• Advanced SQL Server capabilities including T-SQL.
• Experience designing and building data warehouses.

Responsibilities

• Design and develop SQL Server data warehouses.
• Build and maintain SSIS ETL processes.
• Create reporting solutions using SSRS and Power BI.

Skills

SSRS

SSIS

SSAS

Power BI

T-SQL

Data Warehousing

ETL

Analytical Skills

Communication Skills

Customer Focus

Tools

Visual Studio

Microsoft BI Development Tools

Job description

Job: Business Intelligence Developer

Location: Bury St Edmunds

I’m working with a long-established organisation that continues to grow and invest in its data capabilities. They are now looking for an experienced Business Intelligence Developer to join their team and play a key role in delivering high‑quality reporting, analytics and data warehouse solutions.

In this role, you will design and develop SQL Server data warehouses, build and maintain SSIS ETL processes, and create engaging reporting solutions using SSRS and Power BI. You’ll support data analysis across the business, ensure data integrity, manage BI system controls, and help drive the adoption of business intelligence tools across new areas of the organisation.

This opportunity offers hybrid working, strong development pathways, annual pay reviews, excellent pension contributions, and generous holiday and family‑friendly benefits.

Skills & Requirements

Essential:

• Strong experience with SSRS, SSIS, SSAS, and Power BI
• Advanced SQL Server capabilities: T‑SQL, stored procedures, and performance tuning
• Experience designing and building data warehouses and star schemas
• Strong ETL experience using SQL Server SSIS
• Proficiency with Power BI, including DAX and Power Query
• Experience with Visual Studio and Microsoft BI development tools
• Familiarity with source control systems and deployment processes
• Strong analytical and problem‑solving skills
• Excellent communication skills with both technical and senior stakeholders
• Customer‑focused approach and strong data analysis capabilities

Desirable:

• Knowledge of MySQL, PostgreSQL, or Oracle
• Experience working with APIs
• Exposure to Power Apps
• Experience training end users or developers in BI tools

If you’re interested in this role, please reach out to Fintan at TEC Partners for more details.