Business Data Analyst - P&C Insurance - Strong SQL, STTM

Arthur Grand Technologies
Jersey City, NJ, United States
about 1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$135,200.0 - $145,600.0
Working hours
Regular working hours

Tech stack

Data Analysis Big Data Data Cleansing Data Integration Extract Transform Load (ETL) Data Mapping Data Transformation Data Profiling Performance Tuning Query Optimization Standard Sql SQL Databases
+6 more
Data Streaming Enterprise Data Management Freeform SQL Analytic Functions Information Technology Data Delivery

Job description

  • Perform end-to-end data analysis, including data profiling, validation, and transformation for large-scale data integration and reporting projects.
  • Develop source-to-target data mappings (STTM) and documentation based on business requirements.
  • Collaborate with business users and stakeholders to gather, analyze, and translate functional requirements into technical specifications.
  • Work with data engineers and developers to implement and validate data consolidation, standardization, and transformation logic.
  • Optimize complex SQL queries for performance and accuracy in handling large datasets.
  • Participate in data quality assessments and recommend data cleansing or enrichment strategies.
  • Leverage domain knowledge of Property & Casualty Insurance-including policy administration and claims lifecycle-to ensure data alignment with business processes.
  • Facilitate communication between business SMEs, data modelers, and technical teams for successful data delivery and adoption.

Requirements

We are seeking a Business Data Analyst with a strong background in large-scale data applications, data analysis, and transformation to support enterprise-level initiatives in the Property & Casualty (P&C) Insurance domain. The ideal candidate will bring hands-on expertise in SQL, data mapping, and business analysis, along with deep domain knowledge of policy and claims data. This role requires close collaboration with business stakeholders, SMEs, and technical teams to drive data accuracy, consistency, and value., * 5+ years of hands-on experience in data analysis, data mapping, and data transformation within enterprise data environments.

  • Strong proficiency in SQL, including analytical functions, query optimization, and performance tuning.
  • Proven experience developing source-to-target mapping (STTM) documents and understanding ETL/data flow processes.
  • Exposure to data consolidation, standardization, and transformation across heterogeneous data sources.
  • In-depth knowledge of the Property & Casualty Insurance domain,
  • Exceptional communication and interpersonal skills-able to work effectively with technical teams, business stakeholders, and subject matter experts.
  • Strong documentation skills with the ability to create clear and concise technical and business art

Benefits & conditions

Contract

Compensation: USD 65 - USD 70 - hourly

About the company

Arthur Grand is an IT services firm specializing in Digital Transformation initiatives for Federal, Commercial, State & local customers. Since 2012, Arthur Grand has been successfully supporting and delivering IT services to our customers in the areas of enterprise modernization and transformation with a core focus on emerging technologies including Cloud Solutions (AWS, Azure), Agile Development, Custom Programming, Full Stack Development, DevOps, DevSecOps, CI/CD, Web Development, Mobile APP Development, Data Visualization, Data Warehousing, Financial/ERP System Implementation and Infrastructure Management. Arthur Grand’s culture of delivery excellence, combined with a commitment to bring the best talent to provide services, has earned our company an unparalleled reputation for delivering transformative results.

We are a minority-owned staff augmentation and technology consulting company

To keep our valued employees, we need to keep them engaged in challenging, interesting work, offer market-relevant benefits, and provide continued opportunities for professional growth. Please send your resume for immediate consideration

If you are interested in the above opportunity, we warmly invite you to join our team.

Arthur Grand Technologies is an Equal Opportunity Employer (including disability/vets)

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on jobs.smartrecruiters.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

4:06 min

Using ClickHouse as a foundation for fast analytics

Hellmar Becker Hellmar Becker · WWC Europe 2026

3:28 min

Defining big data and machine learning fundamentals

Ayon Roy · LIVE

2:36 min

Integrating business experts and conceptualizing analytical use cases

Stefan Donsa Stefan Donsa +1 · LIVE

1:56 min

Creating immutable blockchain tables using standard SQL syntax

Wei Hu Wei Hu · WWC 2023

2:10 min

Why organizations combine big data and machine learning

Ayon Roy · LIVE

1:28 min

Building shared Java modules and analyst targeting platforms

Chris Heilmann +2 · LIVE

Videos

See all

Related articles

See all