The Consultant Data Analysis role focuses on advanced data analysis with SQL and Spark SQL, setting up ETL processes, creating data reports, and mentoring junior analysts while ensuring data consistency across systems.
TransUnion's Job Applicant Privacy Notice
What We'll Bring:
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.Key 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 using tools such as Tableau, or similar platforms.
• Analyze Java logs to identify and try to resolve performance bottlenecks and application issues.
What You'll Bring:
Required Skills:
- 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.
Impact You'll Make:
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 Job Title
Consultant, Data Analysis and ConsultingTop Skills
AWS
Docker
GCP
Kubernetes
Linux
Spark Sql
SQL
Tableau
TransUnion Pune, Mahārāshtra, IND Office
6th Floor, Tower B, Panschil Business Park, Vimanaggar, Pune, India, 411014
Similar Jobs at TransUnion
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
The role involves data analysis using SQL/Spark SQL, ETL processes, data reporting, and collaboration with teams to meet project requirements.
Top Skills:
AWSETLExcelGCPJavaPower BISpark SqlSQLTableau
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
As a Salesforce Consultant, you will enhance the Salesforce platform, ensure its integration with backend systems, and support business users while developing new capabilities.
Top Skills:
ApexCopado DevopsCSSEtl ToolsHTMLJavaScriptJSONLightning Web ComponentsMulesoftRestSalesforceSoapSOQLSoslVisualforceXML
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
The Data Analyst role involves writing SQL queries, supporting ETL processes, creating reports, and analyzing data to troubleshoot issues.
Top Skills:
AWSETLExcelGCPPower BISpark SqlSQLTableau
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
