What are the responsibilities and job description for the Lead Data Architect position at Tror - AI for everyone?
Role: Lead Data Architect / Snowflake Technical Architect
Location: Newport Beach, CA (Onsite – Local candidates only)
Experience: 12 Years
Job Type: Contract/W2
Duration: Long Term
Overview: We need a senior Data Architect with strong hands-on experience in Snowflake and AWS to lead a large data modernization project for an insurance/financial client.
This is not just a design role; you will actively work with the team to build and deliver the solution.
Must-Have Skills
- Strong experience with Snowflake (advanced level)
- Experience with AWS S3 (data lake / Lakehouse architecture)
- Hands-on with DBT and/or Matillion (ETL tools)
- Strong data modeling experience (enterprise level)
- Experience with data governance tools (like Collibra)
- Good knowledge of SQL & Python
- Experience in data modernization / migration projects
- Domain experience in Insurance or Financial Services
Experience Required
- 12 years in data engineering / analytics
- 3 years as a Data Architect / Solution Architect
- Experience working on large enterprise projects
Key Responsibilities
- Design and build a modern data platform using:
- Snowflake AWS S3 dbt Matillion
- Implement Lakehouse architecture (Bronze, Silver, Gold layers)
- Create data models for insurance domain (policy, claims, finance, etc.)
- Set up data pipelines, transformation frameworks, and standards
- Define data governance, quality, and lineage
- Lead multiple teams/workstreams (ingestion, transformation, reporting, etc.)
- Migrate legacy ETL tools (Informatica/SSIS) to modern tools
- Work closely with business and technical teams
Tools & Technologies: Snowflake, AWS S3, DBT, Matillion, Collibra, Profisee MDM, SQL, Python, Tableau, Power BI, CI/CD (Azure DevOps), Git
Good to Have
- Experience with ACORD data model (insurance standard)
- Experience with MDM tools (Profisee or similar)
- Exposure to AI tools (Snowflake Cortex, Copilot, etc.)
- Snowflake certifications (SnowPro Advanced)
Soft Skills
- Strong communication
- Ownership mindset
- Ability to work in fast-paced environments
- Team collaboration
Success Criteria (What They Expect)
- Build the data platform within first 3 months
- Deliver high-quality, accurate data (99% accuracy)
- Ensure consistent architecture across teams
- Improve efficiency using automation/AI tools