Senior Engineer, Data Warehouse
TransUnion · pune, Maharashtra, India
IT Services and IT Consulting · 10,001+ employees
About the role
The role involves designing, deploying, and maintaining large-scale data ecosystems and analytics pipelines to support transactional and analytical workloads. You will lead the development of data engineering standards, ensure platform scalability, and provide operational support for production-grade systems.
What they look for
Requirements
Candidates must have 5-8 years of experience in data engineering with deep expertise in SQL, Python, and data pipeline architecture. A bachelor's degree in Computer Science, Data Engineering, or a related field is required to support the technical and analytical demands of the role.
Benefits
Full description
TransUnion's Job Applicant Privacy Notice
Team Overview
The Enterprise Data Warehouse team within TransUnion Consumer Interactive is responsible for designing, deploying, and maintaining a large-scale data ecosystem and associated data marts that support both transactional and analytical workloads. The platform processes billions of records and enables decision-making for executive stakeholders. This team plays a critical role in ensuring data availability, reliability, and scalability across enterprise products and analytics.

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
- Evolve the technology stack, including ETL orchestration, data modeling, and BI tooling (e.g., Apache Superset), ensuring performance, scalability, and reliability
- Architect and lead the end-to-end design of scalable analytics pipelines, integrating data from diverse sources including RDBMS, APU, and DataLake (S3).
- Define, implement, and enforce engineering standards for data ingestion, transformation, and reporting to ensure consistency and quality across teams
- Lead deployment, monitoring, and operational support of production-grade pipelines, improving uptime, performance, and adaptability to upstream changes
- Translate complex business requirements into scalable technical solutions, ensuring alignment with strategic objectives and measurable business outcomes
- Establish and maintain governance frameworks, including data documentation, lineage, and reproducibility standards to support audit and compliance needs
- Assist junior engineers and analysts, promoting best practices in data engineering, development, and operational excellence
- Identify and implement improvements in pipeline efficiency, data quality, and platform scalability through automation and tooling enhancements
Required Knowledge And Experiences
Required Knowledge and Experiences
What You’ll Bring:
- 5-8 years of experience in data engineering, analytics engineering, or related roles; required to lead architecture and delivery of enterprise-scale solutions
- Deep expertise in data pipeline design and platform development; required to build scalable, high-performance data systems
- Strong understanding of data architecture and infrastructure; required to optimize storage, compute, and data access patterns
- Bachelor’s degree in Computer Science, Data Engineering, Analytics, or equivalent practical experience; required for foundational and advanced technical expertise
What Will Set You Apart:
- Experience with infrastructure-as-code (IaC) and automation frameworks — improves deployment consistency and efficiency
- Experience working in agile environments — supports prioritization and delivery across competing demands
- Experience leading cross-functional data initiatives; required to drive alignment and deliver business-critical outcomes
Required Technical Skills
What You’ll Bring:
- SQL (Structured Query Language) — required for advanced data modeling, transformation, and performance optimization
- Python — required for data processing, pipeline development, and analytical workflows
- Shell scripting (e.g., Bash) — required to automate deployments and operational tasks
What Will Set You Apart:
- Ab Initio — primary ETL platform; accelerates onboarding and ownership of existing pipelines
- Experience with BI/analytics tools (e.g., TIBCO Spotfire, Tableau, Apache Superset) — enables effective collaboration with analytics stakeholders
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
Sr Developer, Applications Development
