Business Data Analyst - P&C Insurance - Strong SQL, STTM
Back to Jobs
Arthur Grand TechnologiesGet Smart Job AI Coach in the appFree on iOS and Android 





Business Data Analyst - P&C Insurance - Strong SQL, STTM
65–70 / Month
Location
Jersey City, NJ, United States
Experience
Mid
Posted
Jul 18, 2026
Apply by
August 17, 2026
Applicants
0
Early applicantEasy applyContractHybrid
Job Description
## 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.
Key Responsibilities
- Perform end-to-end data analysis, profiling, validation, and transformation for large-scale integration projects.
- Develop source-to-target data mappings (STTM) and documentation based on business requirements.
- Collaborate with stakeholders to translate functional requirements into technical specifications.
- Work with data engineers to implement and validate data consolidation and transformation logic.
- Optimize complex SQL queries for performance and accuracy with large datasets.
- Participate in data quality assessments and recommend cleansing or enrichment strategies.
- Leverage P&C Insurance domain knowledge to ensure data alignment with business processes.
- Facilitate communication between business SMEs, data modelers, and technical teams.
Skills Required
SQLSource-to-target mapping (STTM)Data profilingData validationData transformationETL processesData consolidationData standardizationCommunicationInterpersonal skillsDocumentationCollaboration
Benefits
- Market-relevant benefits
- Professional growth opportunities
App exclusive · Free
Smart Job AI Coach
Your personal interview coach on every job — readiness tips, profile improvements, and role-specific prep. Available only in the Pulse Job app.
Interview readiness
See how prepared you are and what to improve for each role.
Personalized tips
Actionable suggestions based on your profile and the job.
After you apply
Keep coaching momentum from job detail through application success.
Similar roles for you
Matched using this role's title and skills. Open the job search anytime to see every listing.

Sr. Revenue Analyst Corporate Strategy and Business Development
Align Technology
Full-timeEasy applyWork from Office
EMEA-PolandSenior
Senior Financial Analyst, AWS Supply Chain Operations Finance
Amazon
82,700–117,100 / Year
Full-timeEasy applyWork from Office
SeattleSenior

Senior Tableau Developer
BizTech Fusion
ContractEasy applyHybrid
AustinSenior

Enterprise Developer
San Jose State University
6,492–8,072 / Month
Full-timeEasy applyWork from Office
Monterey BayMid

Oracle ODS Developer
Datamatics Technologies
Full-timeEasy applyWork from Home
GurgaonMid

Senior Developer (Salesforce, Oracle DB)
Emerson
Full-timeEasy applyHybrid
MandaluyongSenior