Consultant Data Development

transunion; Hyderabad; Hybrid; INR 900,000 - 1,500,000; Full time

Job summary

TransUnion in Hyderabad is seeking a Consultant in Data Analysis and Consulting. The role emphasizes advanced SQL and Spark SQL, ETL setup, data reporting, and mentoring junior analysts. Hybrid work requires in-person presence at least two days per week.

The candidate should have 6+ years in SQL/Spark SQL, Unix commands, data modeling, and experience with AWS/GCP cloud environments. A strong ability to translate business needs into data solutions is essential.

Qualifications

• 6+ years of experience in SQL, Spark SQL, Unix commands and data analysis.
• Strong understanding of ETL processes and data modeling.
• Experience with large-scale data environments (GCP, AWS).

Responsibilities

• Design and optimize complex SQL/Spark SQL queries for large datasets.
• Lead ETL setup and data pipeline validation efforts.
• Work with cross-functional teams to translate business needs into data solutions.
• Mentor junior analysts and review their work.
• Analyze Java logs to identify performance bottlenecks and issues.

Skills

SQL

Spark SQL

Unix commands

ETL processes

Data modeling

Education

Bachelor's or Master's degree in CS/ Engineering

Tools

Git

Docker

Kubernetes

Job description

TransUnion's Job Applicant Privacy Notice

Team Overview

This role involves advanced data analysis using SQL and Spark SQL, supporting ETL setup, and driving insights for business teams. intermediate-level knowledge of Linux commands and cloud environments, and solid experience in data reporting. The ability to understand and analyze Java logs is essential for this role. It is not a Data Engineering or development role.

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

• Design and optimize complex SQL/Spark SQL queries for large datasets.
• Lead ETL setup and data pipeline validation efforts.
• Work closely with cross-functional teams to translate business needs into data solutions.
• Mentor junior analysts and review their work.
• Ensure data accuracy and consistency across systems.
• Utilize Linux commands for system operations, troubleshooting, and deployment tasks.
• Work within cloud environments (AWS, GCP) to manage infrastructure, data workflows, and deployments.
• Create and maintain data reports and dashboards.
• Analyze Java logs to identify and try to resolve performance bottlenecks and application issues.

Required Knowledge And Experiences

• 6+ years of experience in SQL, Spark SQL, Unix commands and data analysis.
• Strong understanding of ETL processes and data modeling.
• Experience with large-scale data environments (e.g., GCP, AWS).
• Ability to work independently and manage multiple priorities.

Preferred Qualifications

• Bachelor's or Master's degree in Computer Science, Engineering, or related field.
• Experience with version control systems (e.g., Git).
• Familiarity with containerization tools like Docker and orchestration platforms like Kubernetes.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.

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

Consultant, Data Analysis and Consulting