Data Analyst cum BA (Insurance) : Iselin, NJ : Long Term contract

Jersey City, NJ, US • Posted 17 hours ago • Updated 17 hours ago
Contract Corp To Corp
Contract Independent
Contract W2
12 Months
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

👾 Reticulating splines...

Job Details

Skills

  • Insurance

Summary

Hi,
 
I''d like you to take a look at a great new position we now have available! Your opinion would be valued with regards to this opening. I really appreciate sending an updated resume & the best number with the best time to reach you
 
Role: Data Analyst cum BA (Insurance)
Location: Iselin, NJ
Duration : Long Term contract
  • We are seeking a Senior Data Analyst who is as comfortable with P&C business logic as they are with technical data structures.
  • You will be the critical link in our data modernization track, ensuring that data moving from legacy sources into our bronze and silver layers is profiled, cleaned, and accurately mapped to support high-priority Power BI reporting.
Key Responsibilities:
  • Create and maintain detailed mapping documents that bridge legacy EDW schemas to the new Databricks Medallion architecture (Bronze & Silver layers)
  • Data Profiling & Discovery: Use SQL and Python to profile source data, identifying anomalies, quality gaps, and transformation logic required for the Reporting-Ready Silver layer. 
  • Modernization Liaison: Facilitate the migration of legacy Cognos reports to Power BI, ensuring that P&C business rules (Claims, Underwriting, Policies) are preserved and optimized in the new environment.
  • Subject Matter Expertise: Act as the P&C domain expert to ensure that subject-area specific data (e.g., GWP, Loss Ratios, Premium reserves) is correctly modeled for downstream reporting. 
  • Data Validation: Partner with Data Engineers to perform End-to-End validation, ensuring that data in the Power BI reporting layer matches the financial and operational truth of the source systems.
  • Stakeholder Translation: Translate complex business requirements into technical specifications for the Databricks engineering team.
Required Skills & Qualifications
  • P&C Insurance Domain Mastery:
  • Deep understanding of Policy, Claims, and Underwriting data.
  • You must understand the why behind the data, not just the where. Databricks & Spark SQL:
  • Hands-on experience navigating Databricks environments, running notebooks, and querying Delta Tables.
Technical Toolkit:
  • Expert SQL: Ability to write complex joins and window functions across disparate systems.
  • Python: Proficient in using Pandas/PySpark for data profiling and cleaning.
  • Power BI & Cognos:
  • Experience with both—specifically in migrating logic from the latter to the former.Legacy Knowledge:
  • Familiarity with SSIS and traditional EDW structures to help reverse engineer existing ETL logic.
  • Documentation:
  • Proven track record of creating high-quality STTMs and data dictionaries that developers can follow without ambiguity.
--
 


 

--

Thanks & Regards
HAN IT
   STAFFING

Chigiri Rohith Reddy

Sr.Technical Recruiter

100 Wood Ave S, Suite 102, Iselin NJ, 08830
 
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 90838445
  • Position Id: 9035658
  • Posted 17 hours ago
Contact the job poster
RK

Ruma Kalra

Recruiter @ HAN IT Staffing Inc.
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Jersey City, New Jersey

4d ago

Easy Apply

Contract

Depends on Experience

New York, New York

4d ago

Easy Apply

Contract

$65 - $70

Jersey City, New Jersey

Today

Easy Apply

Contract

New York, New York

Today

Contract

USD66 - USD76

Search all similar jobs