Data Architect

JOB TITLE: DATA ARCHITECT – P&C INSURANCE (ONSITE) LOCATION: Piscataway, New Jersey CONTRACT (1099) including benefits CITIZENSHIP REQUIREMENT: U.S. Citizens or Green Card Holders only JOB DESCRIPTION: We are seeking an experienced DATA ARCHITECT to support a large-scale data modernization initiative for a Property & Casualty (P&C) insurance client. This is an onsite role based in Piscataway, NJ and requires hands-on experience with Azure Data Factory (ADF), Informatica PowerCenter, and Guidewire CDA. You’ll work closely with stakeholders and technical teams to design and implement modern, scalable, and efficient data solutions using cloud-native and big data tools. RESPONSIBILITIES: Design and implement enterprise metadata-driven data pipelines using ADF and Informatica PowerCenter Build and manage an Operational Data Store (ODS) from Azure Data Lake Integrate Guidewire Claim Data Access (CDA) into existing architecture for advanced reporting and analytics Optimize and troubleshoot complex data workflows and pipelines Leverage Python, T-SQL, and Spark to develop custom processes Design serverless solutions using Azure Functions for scheduled and event-driven workflows Ensure cloud cost-efficiency and performance optimization Provide guidance on Hadoop-based big data solutions where applicable Collaborate with cross-functional teams and communicate solutions clearly to stakeholders REQUIRED SKILLS: 15+ years of experience in data architecture, engineering, or ETL development Strong hands-on expertise with Azure Data Lake, ADF, and SQL Server Advanced experience with Informatica PowerCenter for ETL Proficiency in Python, T-SQL, and Spark Hands-on experience building ODS systems from data lakes Knowledge of P&C insurance domain Proven ability to troubleshoot and optimize data pipelines Excellent communication skills (verbal & written) Experience with cloud cost optimization strategies NICE TO HAVE: Familiarity with Guidewire Experience with Hadoop-based solutions HOW TO APPLY: Submit your resume and contact information through Indeed. We’re looking to fill this role quickly — apply today if you’re ready for a new challenge with a dynamic and impactful project. #TRFGroupInc #TRFTechnologies #PenmarkGlobalGroupInc #WeAreHiring #HiringNow #JoinUs #JoinOurTeam #JoinOurJourney #JoinOurMission Job Types: Full-time, Contract Pay: $75.00 - $80.00 per hour Benefits: 401(k) Paid time off Work Location: In person