TransUnion Logo

TransUnion

Engineer, Data Development (SSIS, SQL)

Reposted 9 Hours Ago
Be an Early Applicant
Hybrid
Chennai, Tamil Nadu
Mid level
Hybrid
Chennai, Tamil Nadu
Mid level
Develop, maintain, and enhance Business Intelligence Solutions using various SQL Server technologies. Collaborate across the organization and mentor junior data engineers while ensuring high quality through testing and problem-solving.
The summary above was generated by AI

TransUnion's Job Applicant Privacy Notice

What We'll 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 You'll 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.

Impact You'll 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

Top Skills

Microsoft Fabric
Power BI
Python
Sql Server 2017
Ssas
Ssis
Ssrs
T-Sql

TransUnion Bengaluru, Karnataka, IND Office

Primeco Towers - 5th floor, Bannerughatta Rd., Arekere MICO Layout, Main Rd. Panduranga Nagar, Bengaluru, India, 560076

Similar Jobs at TransUnion

9 Hours Ago
Hybrid
2 Locations
Senior level
Senior level
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
The Sr. Analyst, TPRM will manage a portfolio of vendors, oversee risk assessments, and implement the TPRM framework while collaborating with stakeholders and maintaining compliance.
Top Skills: CoupaIvrmExcelMicrosoft PowerpointOnspringRiskrecon
2 Days Ago
Hybrid
2 Locations
Senior level
Senior level
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
The role involves supporting cloud tenant setup, GCP infrastructure, database architecture, and CI/CD pipeline automation while collaborating with cross-functional teams.
Top Skills: Ai/MlAnsibleCi/CdGCPHelmKubernetesTerraform
2 Days Ago
Hybrid
Chennai, Tamil Nadu, IND
Entry level
Entry level
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
The Back Office Operations Representative handles email responses, identity verification, consumer disclosures, and dispute resolution while maintaining knowledge of T&E products and processes.
Top Skills: Microsoft Applications

What you need to know about the Bengaluru Tech Scene

Dubbed the "Silicon Valley of India," Bengaluru has emerged as the nation's leading hub for information technology and a go-to destination for startups. Home to tech giants like ISRO, Infosys, Wipro and HAL, the city attracts and cultivates a rich pool of tech talent, supported by numerous educational and research institutions including the Indian Institute of Science, Bangalore Institute of Technology, and the International Institute of Information Technology.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account