Business Intelligence Developer (SSIS / SQL / PBI) FULL TRAINING ON AZURE DATA FACTORY- REF 998

Interface Recruitment UK; Leeds; On-site; GBP 40,000 - 70,000; Full time

Job summary

An established industry player is seeking a Business Intelligence Developer to join their dynamic team. In this pivotal role, you will leverage your expertise in SQL, SSIS, and PowerBI to develop and maintain data solutions that drive impactful business decisions. You'll have the opportunity to work on diverse projects across various sectors, including Finance and Health & Safety. With a strong emphasis on collaboration and communication, you'll engage with stakeholders to refine reporting processes and transition to a pure Azure Data Factory environment. This innovative firm is committed to your growth, offering full training on Azure Data Warehouse products, making this an exciting opportunity for those passionate about data and business intelligence.

Qualifications

• Experience in BI roles with SQL and SSIS is essential.
• Strong communication skills and ability to work under tight deadlines.

Responsibilities

• Develop and maintain data ingestion and processing.
• Design data integrations into the Azure Data Platform.
• Support and enhance existing data solutions.

Skills

SQL

SSIS

PowerBI

Data Engineering

Azure Data Factory

Python

CI/CD

Databricks

Azure DevOps

Agile Development

Education

AZ DP 200, 201 or 203 Certification

Tools

Azure Data Factory

SQL Server

Azure Data Warehouse

ServiceNow

Job description

Business Intelligence Developer (SSIS / SQL / PBI) FULL TRAINING ON AZURE DATA FACTORY- REF 998

Previous experience in a Business Intelligence (BI Developer) role is essential working with SQL and SSIS predominantly. PowerBI is a requirement and a small part of the role will include using this.

Skills:

• Expertise in using data tools including but not limited to SQL
• SSIS – SQL Server Integration Services (ETL)
• PowerBI
• The ability to design and implement well written code, following industry best practices, easily scalable and clearly documented.
• Responsible for creating reusable and scalable data pipelines.
• Commercial expertise in building end-to-end data products.
• A passion for building high-quality products which drive business change.
• A results-oriented mindset with an eye for detail and a passion for data.
• Confident and concise communication skills, with the ability to drive alignment, collaboration, and efficiency within teams.
• Ability to work to tight deadlines.
• Ability to test the data from source to the presentation layer.
• Ability to support/troubleshoot data pipelines.
• Experience with Databricks / Lake / Python.
• Proven cloud data expertise with Azure.
• Experience using Azure Data Factory (ADF), Analysis services, and SQL Server.
• Experience building efficient CI/CD tools and processes.
• Experience working with an engineering mindset (Agile development, Git, ServiceNow).
• Experienced in working with Azure DevOps.
• AZ DP 200, 201 or 203 Certified or working towards certification.
• Experience of building Power BI reports.

Responsibilities

We have an opportunity for an all-rounder with strong SQL, SSIS, and some PowerBI skills. The role will form part of a small team, providing opportunities to get involved with a variety of projects (Finance, Health & Safety, Shop Floor data to name just a few), engaging with stakeholders and re-factoring reporting processes. You will also work on a large project moving the company from a hybrid SSIS / ADF to a pure Azure Data Factory. The company is happy to provide full training on the Azure Data Warehouse product set.

Responsibilities:

• Data Engineering: Develop, maintain data ingestion and processing of data.
• Data modelling: Design well-structured tables that are at the correct grain and structured for widespread use.
• Design and implement data integrations into the Azure Data Platform, build data pipelines for data throughout the Azure Data Platform stages, and develop data sets which are optimized for their given use case.
• Software engineering mindset: Automate tasks and deploy production standard code (with unit testing, continuous integration, versioning, etc.).
• Stakeholder influence: Clearly communicate your work and provide confidence to drive change.
• Business insight: Understand complex business processes and break down requirements into actionable segments.
• Support and enhance existing data solutions.
• Work closely with software developers, QA, and Business analysts to assist with new solutions to meet new business requirements.
• Conform to and adopt industry standards and best practices, system updates, and fixes.
• Share knowledge in the education of others and usage of these IT systems.
• Excellent verbal, presentation, and written communication skills.
• Strong team skills including the ability to lead at times, but mainly be a team player.