Engineer, Data Development (SSIS, SQL)

TransUnions Job Applicant Privacy Notice

What Well Bring:

Key Responsibilities:
Develop maintain and enhance Business Intelligence Solutions including database systems and Data Warehouses using SQL Server 2017 Integration Services Analysis Services Reporting Services and Master Data Management Microsoft Excel Power BI Fabric as appropriate.
Produce and run unit tests to ensure high quality of all changes and participating in the design and requirements capturing of new Business Intelligence initiatives
Problem solve and debug complex Business Intelligence systems including database systems and Data Warehouses to allow defect analysis and fixing
Collaborate across organization and be technical expert on Business Intelligence solutions.
Work with the team to ensure continuous process improvement
Mentor and train junior data engineers and guide them in understanding BI&DW best practices and standards.

Skills:
Must have a passion for programming and data analytics
Advanced knowledge of T-SQL SQL Server and SQL Server Integration Services (SSIS).
Advanced level familiarity with BI technologies (e.g. SSAS SSRS).
Experience in Microsoft Fabric.
Advanced experience using automated testing (e. g SQL Server database Unit Testing Specflow).
Modern development practices such as Agile source control coding standards for example
Plans organizes and manoeuvres obstacles to deliver results
Critical thinking skills to identify root cause and permanent resolution
Experience with REST based API
Experience in data warehouse design (e.g. dimensional modelling)
Experience with cloud technologies and Python would be considered as advantage.
Must be fluent in English with excellent written and verbal communication skills.

What Youll Bring:

Key Responsibilities:

• Develop maintain and enhance Business Intelligence Solutions including database systems and Data Warehouses using SQL Server 2017 Integration Services Analysis Services Reporting Services and Master Data Management Microsoft Excel Power BI Fabric as appropriate.
• Produce and run unit tests to ensure high quality of all changes and participating in the design and requirements capturing of new Business Intelligence initiatives
• Problem solve and debug complex Business Intelligence systems including database systems and Data Warehouses to allow defect analysis and fixing
• Collaborate across organization and be technical expert on Business Intelligence solutions.
• Work with the team to ensure continuous process improvement
• Mentor and train junior data engineers and guide them in understanding BI&DW best practicesand standards.

Skills:

• Must have a passion for programming and data analytics
• Advanced knowledge of T-SQL SQL Server and SQL Server Integration Services (SSIS).
• Advanced level familiarity with BI technologies (e.g. SSAS SSRS).
• Experience in Microsoft Fabric.
• Advanced experience using automated testing (e. g SQL Server database Unit Testing Specflow).
• Modern development practices such as Agile source control coding standards for example
• Plans organizes and manoeuvres obstacles to deliver results
• Critical thinking skills to identify root cause and permanent resolution
• Experience with REST based API
• Experience in data warehouse design (e.g. dimensional modelling)
• Experience with cloud technologies and Python would be considered as advantage.
• Must be fluent in English with excellent written and verbal communication skills.

Impact Youll Make:

Experience:

• Commercial experience of Business Intelligence development using SQL Server 2017 and higher version SSDT
• Including IS/ AS/ RS stored procedures views and functions
• Experience of SQL Server 2017 Analysis Services (Tabular)
• PowerPivot
• Experience of writing unit tests and using build systems in conjunction with database systems
• Experience with large databases

Qualifications:

• Education to degree level (or higher) in relevant discipline preferred
• Must have at least 3 years of experience working in a business intelligence data engineering or data related field.

This is a hybrid position and involves regular performance of job responsibilities virtually as well as in-person at an assigned TU office location for a minimum of two days a week.

TransUnion Job Title

Engineer Data Development