Business Analyst

Tata Consultancy Services; Midvale (UT); On-site; USD 100,000 - 118,000; Full time

Benefits offered by this job

Discretionary Incentive

Medical Coverage

Dental & Vision

Disability Insurance

Pet Insurance

Commuter Benefits

Training Reimbursement

Vacation & Holidays

Legal Assistance

401K Plan

Performance Bonus

College Fund

Student Loan Refinancing

Job summary

Tata Consultancy Services in Utah seeks a Business Data Analyst / ETLTester to validate conversion code and perform data profiling using SQL and Python. You will collaborate with data engineers and analysts to ensure accurate data translations and comprehensive validation results.

The role emphasizes ETL discipline, automation, and strong communication. Prior lending domain knowledge is preferred, with a salary range disclosed in the posting.

Qualifications

• Advanced SQL experience with basic query building for profiling data.
• Automation, regression, and end-to-end testing for ETL.
• Experience with Python and PySpark.
• Basic understanding of database platforms and utilities.
• Familiarity with ETL disciplines and data translation.
• Strong analytical and communication skills.
• Self-motivation and ability to work independently.
• Good organization and time management skills.
• Commercial lending knowledge is preferred.

Responsibilities

• Collaborate with business analysts and data engineers to validate conversion code.
• Document gaps in requirements and remediation options.
• Build SQL queries for data profiling and validation using Python.
• Perform other duties as assigned.

Skills

SQL

ETL Testing

Python

PySpark

Data Profiling

Data Validation

Communication

Self-Motivation

Time Management

Lending Knowledge

Education

Bachelor of Computer Science

Job description

Job Description

Skill: Business Data Analyst / ETLTester

Must Have Technical/Functional Skills

• Advanced SQL experience; ability to build basic queries to profile and validate data
• Strong Knowledge and experience in Automation , Regression , End to End test for ETL
• Experience on Python and Pyspark
• Basic understanding of database platforms and utilities to enable translation of business requirements to technical requirements
• Basic understanding of ETL (extraction, transformation, and loading) disciplines
• Strong Analytical skills
• Strong communication skills
• Self-Motivation and drive to independently find answers prior to asking for help
• Strong organization and time management skills
• Commercial Lending knowledge preferred.

Roles & Responsibilities

• Collaborate with business analysts and data engineers to validate conversion code is accurate and complete.
• Document gaps in requirements and potential remediation
• Build SQL queries to conduct data profiling and validation scripts using Python
• Perform other duties as assigned.

Salary Range - $100,000-$118,000 a year

TCS Employee Benefits Summary

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.

Insurance Options: Auto & Home Insurance, Identity Theft Protection.

• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Qualifications

BACHELOR OF COMPUTER SCIENCE