BI Developer - Banking - SSIS, SQL

BI Developer - Banking - SSIS, SQL

Posted 2 days ago by Rothstein Recruitment

Apply
Negotiable
Undetermined
Undetermined
London Area, United Kingdom
Apply
Agile Methodology Automation Banking Business Intelligence Business Intelligence Development Business Requirements Cloud Computing Cloud Technology Continuous Integration and Continuous Delivery Data Integrity Data Mapping Data Migration Datamodel Data Modeling Data Profiling Data Quality Data Warehousing Mapping Software Microsoft 365 Microsoft Business Intelligence PL/SQL Profiling (Computer Programming) Software Development SQL (Programming Language) Ssas Tabular System Requirements Systems Integration Technical Documentation Test Automation Unit Testing

Summary: The BI Developer role focuses on building and maintaining technical data solutions to support evidence-based decision-making, particularly through data migration from Legacy systems to a new ERP platform. The position requires collaboration with both business and technical teams to ensure data integrity and traceability during the systems modernization program. Key responsibilities include designing solutions across the Microsoft BI stack and driving performance improvements in data quality and reliability. The role demands strong analytical skills to interpret complex data sets and translate business requirements into technical specifications.

Key Responsibilities:

  • Build and maintain technical data solutions for evidence-based decision-making.
  • Lead data migration from Legacy systems to a new ERP platform.
  • Collaborate with business and technical teams to analyze, map, transform, and validate data.
  • Design, develop, and maintain solutions across the Microsoft BI stack (SSRS, SSIS, T-SQL).
  • Drive performance improvements, process automation, and enhancements to data quality and reliability.
  • Translate complex business requirements into clear technical specifications.
  • Support the migration of data from Legacy source systems to a new target system.
  • Analyze complex data sets within Legacy systems to understand structure, content, and usage.
  • Interpret target system requirements and perform detailed source-to-target data mapping.
  • Define and validate data transformations, calculations, and derivations for aligning Legacy data to the target model.
  • Perform data profiling on source systems to identify data quality issues.
  • Interpret data models and entity relationship diagrams for both source and target systems.
  • Administer, maintain, and provide support for data analytics platforms.
  • Perform unit testing and resolve issues through effective troubleshooting.
  • Collaborate with cross-functional teams to ensure seamless system integration.
  • Create, maintain, and update comprehensive technical documentation.

Key Skills:

  • Design, develop, and maintain solutions using Microsoft BI stack (SSRS, SSIS, SSAS, T-SQL).
  • Experience with agile delivery, test automation, and CI/CD.
  • Knowledge and experience of ETL/ELT, data warehousing, BI, and Cloud.
  • Knowledge and experience of data migration from Legacy systems to target data model.
  • Advanced SQL (T-SQL or PL/SQL).
  • Self-starter, able to work autonomously and as part of a wider team.

Salary (Rate): undetermined

City: London Area

Country: United Kingdom

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

BI Developer - Banking - SSIS, SQL

As the Data Developer you will build and maintain technical data solutions that drive evidence-based decision-making. A primary focus of this role is leading the data migration from Legacy systems to a new ERP platform. You will collaborate with business and technical teams to analyse, map, transform, and validate data, ensuring integrity and traceability throughout our systems modernisation program. You will also work on the following;

  • Design, develop, and maintain solutions across the Microsoft BI stack (SSRS, SSIS, T-SQL).
  • Drive performance improvements, process automation, and enhancements to data quality and reliability.
  • Translate complex business requirements into clear technical specifications.
  • Support the migration of data from Legacy source systems to a new target system, ensuring accuracy and completeness.
  • Analyse complex data sets within Legacy systems to understand structure, content, and usage, particularly where documentation is limited.
  • Interpret target system requirements and perform detailed source-to-target data mapping.
  • Define and validate data transformations, calculations, and derivations required to align Legacy data to the target model.
  • Perform data profiling on source systems to identify data quality issues and support remediation activities.
  • Interpret data models and entity relationship diagrams for both source and target systems.
  • Administer, maintain, and provide support for data analytics platforms.
  • Perform unit testing and resolve issues through effective troubleshooting.
  • Collaborate with cross-functional teams to ensure seamless system integration.
  • Create, maintain, and update comprehensive technical documentation.

Skills

  • Design, develop, and maintain solutions using Microsoft BI stack (SSRS, SSIS, SSAS, T-SQL).
  • Experience with agile delivery, test automation and CI/CD.
  • Knowledge and Experience of ETL/ELT, data warehousing, BI and Cloud.
  • Knowledge and Experience of data migration from Legacy systems to target data model.
  • Advanced SQL (T-SQL or PL/SQL).
  • Self-starter, able to work autonomously and as part of a wider team.

Bank Banking BI Dev BI Developer Business Intelligence developer data developer

Apply
Similar Jobs
Loading data...