OverviewTransUnion's Job Applicant Privacy NoticeWhat We'll Bring:We Are TransUnion: TransUnion is a major credit reference agency, and we offer specialist services in fraud, identity and risk management, automated decisioning and demographics. We support organisations across a variety of sectors including finance, retail, telecommunications, utilities, gaming, government and insurance.What You'll Bring:We’re looking for a Senior Engineer to join our growing team.Day to Day You’ll BeDevelop, 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 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.Essential Skills & ExperienceEducation to degree level (or higher) in relevant discipline preferredMust have track record years of experience working in a business intelligence, data engineering or data related field.Must have a passion for programming and data analyticsAdvanced knowledge of T-SQL, SQL Server, and SQL Server Integration Services (SSIS).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).Modern 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 resolutionExperience with REST based APIExperience with PowerBIExperience in data warehouse design (e.g., dimensional modelling)Experience with cloud technologies and Python would be considered as advantage.Commercial experience of Business Intelligence development using SQL Server 2017 and higher version, SSDTIncluding IS/ AS/ RS, stored procedures, views, and functionsExperience of SQL Server 2017 Analysis Services (Tabular)PowerPivotExperience of writing unit tests and using build systems in conjunction with database systemsExperience with large databasesImpact You\'ll MakeWhat’s In It For You?At TransUnion you will be joining a friendly, forward thinking global business. As well as an excellent salary and bonus scheme or commission scheme (if joining our sales teams) our benefits package comes with:26 days’ annual leave + bank holidays (increasing with service)Global paid wellness days off + a bonus day off to celebrate your birthdayA generous contributory pension scheme + access to the TransUnion Employee Stock Purchase PlanPrivate health care + a variety of physical, mental and financial fitness wellbeing programmes such as access to mindfulness toolsAccess to our diversity forums and communities so you can get involved in causes close to your heartTransUnion – a place to growIf there’s something on the list of essential / desirable skills that you can’t quite tick off, don’t let that put you off applying. We are open to exploring training and development opportunities for the right candidate to ensure you are successful.We know imposter syndrome is real, lets confront it so we can continue to grow and thrive togetherFlexibility at TUWe recognise that our people need the freedom to balance their day-to-day lives with their work. This is why we’ve set out to create inclusive and flexible policies and practices for you to accommodate all your responsibilities and needs: children, family and beyond. If the role is advertised as full time, don’t let this stop you from applying. Let us know if you’re looking for a part time or flexible working arrangement and we can discuss this with you.Additional supportAt TransUnion, we’re committed to fostering an inclusive and diverse workplace where all individual’s talents and perspectives are valued. When you apply for a position with us, you’re not just joining a team, you’re becoming part of a community that celebrates differences and embraces equality. We understand that everyone has different needs, which is why we offer a range of reasonable adjustments to our recruitment process. Please let us know if you require any reasonable adjustments to help you through the application process or to attend an interview with us by contacting ukrecruitment@transunion.comInterview & Hiring ProcessMost of our recruitment processes are virtual, so you’ll get to know our hiring managers and teams over the phone and through video. If we need you to attend a physical in person interview your recruiter will inform you of this.We do not accept any unsolicited CV’s from recruitment agencies. If you are a recruitment agency on our PSL our talent team will contact you directly should we require any assistance.#LI-HybridFind out more about Life At TU UK:https://twitter.com/TransUnionUKhttps://www.linkedin.com/company/transunion/life/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 TitleEngineer, Software Development #J-18808-Ljbffr