Majesco Migration-Data Architect-

Capgemini•New York, NY

1d•$110,841 - $145,000•Onsite

About The Position

We are looking for an experienced Data Architect with strong expertise in enterprise data architecture, data modeling, and integration within the insurance domain. Experience working with Majesco platforms (Policy, Billing, Claims, Digital1st) is highly preferred. This role involves defining data strategy, designing scalable data solutions, and ensuring data quality, governance, and interoperability across systems.

Requirements

8 years of experience in data architecture, data modeling, or enterprise architecture.
Strong knowledge of insurance domain data structures (PC preferred).
Experience with Majesco Policy/Billing/Claims/D1 data models, APIs, and integration approaches.
Strong understanding of data governance, MDM, metadata management, and data cataloging tools.
Proficiency in SQL and relational databases (SQL Server, Oracle, PostgreSQL).
Experience with data modeling tools (Erwin, Sparx EA, Power Designer).
Experience with ETL/ELT platforms (Informatica, SSIS, Talend, Azure Data Factory).
Experience with cloud data technologies (Azure Synapse, Snowflake, Redshift, BigQuery).
Excellent communication and stakeholder management.
Ability to translate technical data concepts into business language.
Strong problem-solving, analytical thinking, and modeling skills.
Ability to work in Agile Scrum environments.

Nice To Haves

Experience supporting Majesco transformations, system modernizations, or cloud migrations.
Hands-on experience with Azure Data Services (Data Factory, Databricks, ADLS, Synapse).
Familiarity with ACORD data standards and industry reference models.
Experience building pipelines for operational reporting and advanced analytics.

Responsibilities

Define and maintain the enterprise data architecture, including conceptual, logical, and physical data models.
Develop and optimize data models for operational systems, analytics platforms, data lakes, and data warehouses.
Ensure consistent data definitions, metadata standards, and data lineage.
Analyze and interpret Majesco data models, schemas, and integration frameworks.
Design and manage data flows between Majesco Policy, Billing, Claims, and external/internal systems.
Support Majesco migrations, upgrades, extractions, and reporting data pipelines.
Design and oversee ETL/ELT pipelines for structured and unstructured data.
Collaborate with integration architects to ensure high-quality, secure, and reliable data exchanges.
Implement data solutions using cloud-native tools (Azure, AWS, or GCP).
Establish and enforce data governance, master data management (MDM), and data stewardship practices.
Define data quality rules, validation processes, and remediation strategies.
Ensure compliance with regulatory requirements and data security standards.
Partner with business stakeholders, analysts, and developers to translate requirements into scalable data solutions.
Review architecture designs, provide technical guidance, and ensure adherence to enterprise standards.
Lead data architecture discussions across cross-functional teams.

Benefits

Flexible work
Healthcare including dental, vision, mental health, and well-being programs
Financial well-being programs such as 401(k) and Employee Share Ownership Plan
Paid time off and paid holidays
Paid parental leave
Family building benefits like adoption assistance, surrogacy, and cryopreservation
Social well-being benefits like subsidized back-up child/elder care and tutoring
Mentoring, coaching and learning programs
Employee Resource Groups
Vacation: 12-25 days, depending on grade
Company paid holidays
Personal Days
Sick Leave
Medical, dental, and vision coverage
Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
Life and disability insurance
Employee assistance programs