Job ID: 114508-1
Job Title: Data Analyst
Location: Philadelphia, PA
Duration: 6 months
Pay Rate: $50-$55/hr on W2/C2C
Description:
Strong experience in SQL and working with relational databases preferably RedShift.
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
Experience in insurance or financial services domain.
Experience with data wrangling tools like AWS SageMaker Data Wrangler or AWS Glue DataBrew.
Exposure to ETL tools and data warehousing concepts.
Familiarity with data governance and metadata management practices.
Experience working in Agile/Scrum environments.
Desirable Skills:
Keyword:
Skills: PostgreSQL~PL/SQL
Experience Required: 10 & Above