Develop, maintain, and enhance BI solutions and data warehouses using SQL Server, SSIS/SSAS/SSRS and Microsoft Fabric. Write and run unit tests, debug complex BI systems, capture requirements, implement DW design (dimensional modeling), collaborate cross-functionally, and mentor junior data engineers to improve BI processes.
TransUnion's Job Applicant Privacy Notice
Team Overview
Summary of Role:The role will be responsible for developing, maintaining, and enhancing Business Intelligence solutions for TransUnion using SQL Server 2017, supporting BI tools and Microsoft Fabric.
Qualifications:
• 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.
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, GCP 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. 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.
Role Overview And Core Responsibilities
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.
Required Knowledge And Experiences
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 5 years of experience working in a business intelligence, data engineering or data related field.
TransUnion Overview:
At TransUnion, we encourage and are committed to creating a real, positive impact and shared sense of purpose within our Workforce for Good, which empowers our people to grow, innovate and contribute to a better future for our communities and customers. We strive to build an environment where our associates are in the driver’s seat of their professional development— while having access to help along the way. We recognize that success comes when our associates thrive both professionally and personally; that’s why we prioritize work/life flexibility and offer resources for our teams across the globe to collaborate and drive excellence.
Be a part of our Workforce for Good – you’ll work with great people, pioneering products and cutting-edge technology.
TransUnion Job Title
Engineer, Data Development
TransUnion Chennai, Tamil Nadu, IND Office
DLF IT SEZ 8th, 9th, and 10th floor Block 2, Chennai, India, 600089
Similar Jobs at TransUnion
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Processes and fulfills transactional, batch, and self-service data requests within service-level agreements. Validates inputs, system setups, data extraction, cleansing, outputs, and reports using Ab Initio on UNIX. Coordinates with customer engagement and sales teams, resolves data concerns and complaints, ensures quality and turnaround targets, follows documented procedures, and identifies process improvements. The role requires SQL and Python expertise, attention to detail, problem-solving ability, and willingness to work US shifts.
Top Skills:
Ab InitioAutosysMS OfficePythonSQLUnix
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Leads the design and delivery of automated QA frameworks, data quality checks, regression testing, and operational excellence capabilities for the OneTru platform and US market products. Builds scalable business-rule validation across datasets, integrates services and APIs, provides technical leadership, partners on architecture and requirements, and documents production workflows. Applies cloud technology, AI/ML, and automation to support reliable data processing and customer data expectations.
Top Skills:
Ai/MlAirflowAPIsGCPJavaLogging And MonitoringMapreducePythonSpark
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Lead and maintain highly available, optimised database platforms (primarily MS SQL Server), build CI/CD pipelines and automation for deployments, support migrations/upgrades, troubleshoot data issues, ensure security/compliance, provide technical leadership and UK business-hours/on-call support.
Top Skills:
Always On Availability GroupsAzure Devops ServerCi/Cd (Pipelines)Database MirroringMs Sql Server (2014+)Octopus DeployPciPostgresPowershellSource Control (Database Projects)SoxSql AgentT-SqlTfsTransactional Replication
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
