Business Analyst

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

Job summary

Tata Consultancy Services Limited is seeking a Business Data Analyst / ETL Tester in Midvale, UT. The role focuses on validating conversion code, profiling data, and ensuring ETL reliability using SQL, Python and PySpark.

The candidate will collaborate with business analysts and data engineers, document gaps, and drive remediation. Strong communication, self-motivation and time management are essential.

Qualifications

• Advanced SQL experience and ability to profile and validate data.
• Experience in Automation, Regression and End-to-End testing for ETL.
• Experience with Python and PySpark.
• Basic understanding of databases and ETL concepts.

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.

Skills

SQL

ETL testing

Python

PySpark

Data profiling

Data validation

Communication skills

Self-motivation

Time management

Lending knowledge

Education

Bachelor's degree in Computer Science

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:

• 1. Discretionary Annual Incentive.
• 2. Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• 3. Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• 4. Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• 5. Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Location

Midvale, UT

Function

TECHNOLOGY

Role

Business Analyst

ID

432822

Skills

Business analyst

Salary Range

$100,000 - $118,000

Desired Candidate Profile

Qualifications

BACHELOR OF COMPUTER SCIENCE