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

Posted Yesterday
Jersey City, NJ, USA
Hybrid
65-70 Hourly
Senior level
Information Technology • Consulting
The Role
Perform end-to-end data analysis, profiling, validation, and transformation for large-scale P&C insurance data. Create source-to-target mappings (STTM), translate business requirements into technical specs, optimize SQL queries, and support data consolidation, standardization, and quality efforts with stakeholders and engineering teams.
Summary Generated by Built In
Company Description

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)

Job Description

 

Title of Position: Business Data Analyst (Property & Casualty Insurance)

Location: Jersey City, NJ – Hybrid (3-4 days onsite)

Duration: Long Term

Employment: Contract

Rate: $Negotiable

Interview type: Video Interview

 

Job Description:

Position: Business Data Analyst (Property & Casualty Insurance)

Jersey City, NJ – Hybrid (3-4 days onsite)

Long Term Contract

 

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.

 

Key Responsibilities:

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

 

Required Skills & Experience:

  • 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

 

About Arthur Grand

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)

Additional Information

All your information will be kept confidential according to EEO guidelines.

Skills Required

  • 5+ years experience in data analysis, data mapping, and data transformation within enterprise 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.
  • Experience with data consolidation, standardization, and transformation across heterogeneous data sources.
  • In-depth knowledge of Property & Casualty insurance domain (policy and claims data).
  • Strong communication and interpersonal skills to work with business stakeholders and SMEs.
  • Strong documentation skills for technical and business artifacts.
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Ashburn, VA
135 Employees
Year Founded: 2012

What We Do

Arthur Grand Technologies an SBA certified 8(a) firm offers a broad range of Technology and Business Consulting services to federal and commercial customers. From strategy to execution, our disciplined yet flexible approach starts and ends with our clients. By listening hard and working harder, client goals become our goals. Their success is our satisfaction. Our associates have significant business, engineering, and technology expertise.

Similar Jobs

Acquia Logo Acquia

Senior Director, Global Strategic Alliances

AdTech • Cloud • Marketing Tech • Productivity • Software • Analytics • Automation
Easy Apply
Remote or Hybrid
United States
1100 Employees

Babylist Logo Babylist

VP, Customer Care & Support

eCommerce • Healthtech • Kids + Family • Retail • Social Media
Easy Apply
Remote or Hybrid
United States
300 Employees
244K-293K Annually

Zocdoc Logo Zocdoc

Engineering Manager

Healthtech • Information Technology • Software • Telehealth
Easy Apply
Remote or Hybrid
USA
900 Employees
210K-270K Annually

Luxury Presence Logo Luxury Presence

Head Of Product

Marketing Tech • Real Estate • Software • PropTech • SEO
Easy Apply
Remote or Hybrid
2 Locations
500 Employees
275K-315K Annually

Similar Companies Hiring

Amplify Platform Thumbnail
Fintech • Financial Services • Consulting • Cloud • Business Intelligence • Big Data Analytics
Scottsdale, AZ
62 Employees
Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account