Data Architect

Tech One IT; United States; On-site; USD 120,000 - 150,000; Full time

Job summary

A technology consulting firm is looking for a Data Architect to lead the design and maintenance of data infrastructure that enables effective storage and analysis. The ideal candidate will have over 15 years of experience in data engineering, particularly in the insurance domain, with strong technical skills in ETL, Python, and AWS. Responsibilities include modeling database structures, defining architecture strategies, and ensuring data integrity. Certification in Databricks and LOMA is preferred for candidates.

Qualifications

• Minimum 5+ years in Insurance Domain.
• 15+ years in Data Engineering.
• Proficiency in data governance and data quality frameworks.

Responsibilities

• Model database structures and select technologies.
• Define data architecture strategies and frameworks.
• Design and optimize databases and data warehouses.

Skills

Insurance Domain

ETL

Python

PySpark

AWS

Data Modeling

Databricks

SQL

Agile methodologies

Education

MCA or Bachelor's degree in engineering

Databricks certification

LOMA certification in Insurance

Tools

Databricks

AWS

JIRA

Job description

Client Location

Remote work timings on EST

Salary

FTE ONLY

Must Skills

5+ years Insurance Domain, ETL, Python, PySpark, AWS

Experience

15+ years

Job Summary

Looking for data architect (onsite), who will lead in designs and maintain 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: 15+ Years in Data Engineering in insurance domain (Minimum 5+ years in Insurance Domain ONLY)

Responsibilities

• Key responsibilities include modelling database structures, selecting technologies, setting governance policies, and working closely with engineers (clients), analysts, and compliance teams. They play a critical role in supporting business intelligence and regulatory initiatives.
• 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, BigQuery, 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 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 in working 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.