Data Analyst

TATA Consulting Services•Philadelphia, PA

24d•Remote

About The Position

Data Analyst Must Have Technical/Functional Skills Strong experience in SQL and working with relational databases (e.g., SQL Server, PostgreSQL). Proven ability to analyze complex stored procedures and extract business logic. Experience creating source-to-target mappings and data flow documentation. Solid understanding of financial and actuarial data, including claims, premiums, reserves, and forecasts. Familiarity with data quality frameworks and issue resolution techniques. Excellent analytical, problem-solving, and communication skills. Ability to work independently and manage tasks in a remote, distributed team environment. Roles & Responsibilities Analyze and understand existing stored procedures to reverse engineer business logic and data flows. Create and maintain Source-to-Target Mapping (STTM) documents for data integration and transformation processes. Investigate and resolve data quality issues, including root cause analysis and recommendations. Perform data profiling and validation to ensure accuracy and completeness of financial and actuarial datasets. Collaborate with data modelers, developers, and business analysts to support data requirements and reporting needs. Document business rules, data definitions, and transformation logic clearly and accurately. Participate in daily stand-ups or sync meetings during onshore-offshore overlap hours. 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. Salary Range : $105,000-$125,000 a year

Requirements

Strong experience in SQL and working with relational databases (e.g., SQL Server, PostgreSQL).
Proven ability to analyze complex stored procedures and extract business logic.
Experience creating source-to-target mappings and data flow documentation.
Solid understanding of financial and actuarial data, including claims, premiums, reserves, and forecasts.
Familiarity with data quality frameworks and issue resolution techniques.
Excellent analytical, problem-solving, and communication skills.
Ability to work independently and manage tasks in a remote, distributed team environment.

Responsibilities

Analyze and understand existing stored procedures to reverse engineer business logic and data flows.
Create and maintain Source-to-Target Mapping (STTM) documents for data integration and transformation processes.
Investigate and resolve data quality issues, including root cause analysis and recommendations.
Perform data profiling and validation to ensure accuracy and completeness of financial and actuarial datasets.
Collaborate with data modelers, developers, and business analysts to support data requirements and reporting needs.
Document business rules, data definitions, and transformation logic clearly and accurately.
Participate in daily stand-ups or sync meetings during onshore-offshore overlap hours.

Benefits

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume