Data Analyst

Overview

Job Title: Data Analyst
Location: Philadelphia, PA (Onsite)
Duration: Fulltime
Salary Range: $100-$120K/annum

Must Have Technical/Functional Skills

• Strong experience in SQL and working with relational databases (e.g., SQL Server, Postgre
  
  SQL).
• 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.

• 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.