> Markdown version of [/jobs/ext/1829102-business-data-analyst-p-c-insurance-strong-sql-sttm](https://www.wearedevelopers.com/jobs/ext/1829102-business-data-analyst-p-c-insurance-strong-sql-sttm). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

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

- **Company:** Arthur Grand Technologies
- **Location:** Jersey City, NJ, United States
- **Experience:** Expert
- **Salary:** $135,200.0 - $145,600.0
- **Contract:** Permanent contract
- **Skills:** 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, Data Streaming, Enterprise Data Management, Freeform SQL, Analytic Functions, Information Technology, Data Delivery
- **Published:** July 9, 2026
- **Apply:** https://jobs.smartrecruiters.com/ArthurGrandTechnologiesInc/744000138154070-business-data-analyst-p-c-insurance-strong-sql-sttm

## About the Role

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

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


## Related Videos

- [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one)
- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [Anomaly Detection - Using unsupervised Machine Learning for detecting anomalies in customer base](https://www.wearedevelopers.com/videos/6-anomaly-detection-using-unsupervised-machine-learning-for-detecting-anomalies-in-customer-base)
- [Why and when should we consider Stream Processing frameworks in our solutions](https://www.wearedevelopers.com/videos/1085-why-and-when-should-we-consider-stream-processing-frameworks-in-our-solutions)
- [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story)
- [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture)

## Related Articles

- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)
- [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria)