TransUnion's Job Applicant Privacy Notice
What We'll Bring
The focus of this role will be the design, maintenance, and programming of BI systems.
The role will be responsible for developing, maintaining, and enhancing Business Intelligence
Solutions for TransUnion using SQL Server, Microsoft Fabric and supporting BI tools.
Qualifications
What You'll Bring :
- Education to degree level (or higher) in relevant discipline preferred
- Microsoft Certification in relevant technology (MCP or higher) preferred
- Must have at least 5 years' experience working in a business intelligence, data engineering or data related field.
Skills
Must have a passion for programming and data analyticsAdvanced knowledge of T-SQL, SQL Server, and SQL Server Integration Services (SSIS).Advanced knowledge of Microsoft Fabric (Notebooks, Data flows, Pipelines)Advanced level familiarity with BI technologies (e.g., Power BI, SSAS, SSRS).Advanced experience using automated testing (e. g SQL Server database Unit Testing, specflow).Advanced experience with SQL Server 2008 R2 BI StackProficient in Microsoft ExcelModern development practices such as Agile, source control, coding standards for examplePlans, organizes, and manoeuvres obstacles to deliver resultsCritical thinking skills to identify root cause and permanent resolutionMust be fluent in English with excellent written and verbal communication skills.Strong people skills and ability to communicate with technical and non-technical staffExcellent documentation skillsManages time, responsibilities, and multiple priorities effectivelyPassion for quality excellence, methodical, thorough, and diligentMust be a initiative-taker with the ability to perform on a team or with minimal supervision.Must be highly organized with a strong diligence.Experience with REST based APIsExperienced with NoSQL databases, knowledge of MongoDBExperience in data warehouse design (e.g., dimensional modelling) and data mining.Experience with cloud technologies and Python would be considered as advantage.Coaching and mentoring skillsExperience
Commercial experience of Business Intelligence development using SQL Server 2008 R2, including IS / AS / RS, stored procedures, views, and functionsExperience of SQL Server 2012 Analysis Services, PowerviewExperience of Microsoft Fabric.PowerPivotExperience of SharePoint 2010 / 13Experience of writing unit tests and using build systems in conjunction with database systemsExperience with large databasesExperience of Microsoft ProClarityImpact You'll Make
Key Responsibilities :
Develop, maintain, and enhance Business Intelligence Solutions, including database systems and Data Warehouses, using SQL Server 2008 R2 Integration Services, Analysis Services, Reporting Services and Master Data Management, Microsoft Excel, and ProClarity as appropriateProduce and run unit tests to ensure high quality of all changes and participating in the design and requirements capturing of new Business Intelligence initiativesProblem solve and debug complex Business Intelligence systems, including database systems and Data Warehouses, to allow defect analysis and fixingCollaborate across organization and be technical expert on Business Intelligence solutions.Work with the team to ensure continuous process improvementMentor and train junior data engineers and guide them in understanding BI&DW best practices and standards.Key Tasks
Participate in requirements gatheringInvestigating and resolving errorsCreation and maintenance of technical documentationDevelops and implements methods and procedures for process control / improvements and testing to ensure products / systems are free of flows and function as designed.Designs, tests and / or implements products or systems.Solves a range of straightforward problems.Analyses viable solutions using standard procedures.Have exposure to, and the option to become experienced with an array of existing technologies.Maintains team process and procedures.Provides input into technical design documents / design / implementation.Adhere to department procedures and practices, including coding standards, build processes, source control and Agile development processThis is a remote position which may require occasional in-person attendance at work-related events at the discretion of management.
TransUnion Job Title
Engineer, Data Development
Skills Required
T-sql, Power Bi, Ssrs, Sql Server, Cloud Technologies, Data Mining, Automated Testing, Ssas, Mongodb, Microsoft Excel, Python