Data Architect

Mphasis; New York (NY); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading tech company in New York seeks a Data Architect to lead in designing and maintaining robust data infrastructure. This onsite role involves optimizing data architectures, implementing ETL pipelines, and collaborating with cross-functional teams. The ideal candidate should have over 5 years of experience in Data Engineering within the insurance domain, with strong skills in Databricks, AWS, and Python. They will ensure data integrity and compliance while documenting architectural standards. A bachelor's degree in engineering or MCA is required.

Qualifications

• 5+ years of experience in Data Engineering in the insurance domain.
• Experience designing data architectures and ETL pipelines.
• Proficiency in data governance and quality frameworks.

Responsibilities

• Define data architecture strategies and frameworks.
• Optimize databases and data lakes.
• Collaborate with engineers and analysts on pipeline architecture.

Skills

Databricks

AWS

Python

SQL

PySpark

ETL pipelines

Data modeling

JIRA

Education

MCA or bachelor's degree in engineering

Job description

Job Summary

Looking for data architect (onsite) , who will lead and involve in designs and maintains the data infrastructure that enables storage, access, and analysis across the business and client needs . They define how data is collected, structured, integrated, and governed to ensure scalability, security, and performance.

Years of experience needed : 1 5 + Years in Data Engineering in insurance domain.

Responsibilities

• Defining data architecture strategies, frameworks, and models
• Designing and optimizing databases, warehouses, and data lakes
• Ensuring data structures meet business and compliance needs
• Collaborating with data engineers and analysts on pipeline architecture
• Overseeing metadata management, catalogues, and lineage tracking
• Ensuring data integrity, scalability, and performance
• Selecting appropriate storage and cloud platforms (e.g. Snowflake, AWS, Azure, Big Query , Redshift)
• Supporting data governance and access control policies
• Reviewing existing systems for improvement or migration
• Documenting technical standards and architectural decisions
• System design with strategic alignment and governance

Technical Skills

• Experience designing, implementing, and managing data analytics using Databricks in insurance domain.
• Proven experience in developing and implementing ETL pipelines from various data sources using Databricks on cloud AWS
• Design and implement scalable ETL pipelines using Databricks to process and transform data from multiple sources
• Collaborate with data scientists, analysts, and other stakeholders to understand data requirements and deliver high‑quality data solutions
• Optimize data workflows and ensure data quality and integrity throughout the ETL process
• Monitor and troubleshoot data pipeline performance, implementing improvements as necessary
• Work with cloud technologies, specifically AWS, to manage data storage and processing resources effectively
• Document data engineering processes, architecture, and best practices to ensure knowledge sharing within the team
• Stay updated with the latest trends and technologies in data engineering and cloud computing
• Strong proficiency in Python, PySpark and SQL with hands‑on experience developing data pipelines
• Data Modeling/ Data Lineage and awareness of Canonical data model implementation
• Experience in Medallion Architecture implementation
• Experience working in Insurance domain
• Experience with JIRA

Mandatory Skills

• Strong expertise in Databricks, including the ability to develop and optimize ETL pipelines
• Proven experience with AWS cloud services, particularly in data storage and processing
• Solid understanding of data modeling, data warehousing, and data integration techniques
• Proficiency in programming languages such as Python or Scala for data manipulation and transformation
• Strong proficiency in Python, PySpark and SQL with hands‑on experience developing data pipelines
• Familiarity with data governance and data quality frameworks
• Experience in working with Agile methodologies

Qualification

• Education qualification MCA or bachelor’s degree in engineering from a reputed college
• Databricks certification is preferred
• LOMA certification in Insurance is preferred

About Mphasis

Mphasis applies next‑generation technology to help enterprises transform businesses globally. Customer centricity is foundational to Mphasis and is reflected in the Mphasis’ Front2Back™ Transformation approach. Front2Back™ uses the exponential power of cloud and cognitive to provide hyper‑personalized (C=X2C2TM=1) digital experience to clients and their end customers. Mphasis’ Service Transformation approach helps ‘shrink the core’ through the application of digital technologies across legacy environments within an enterprise, enabling businesses to stay ahead in a changing world. Mphasis’ core reference architectures and tools, speed and