
Open since May 2015
Data Architect (Permanent /Full time )
AI Summary
Designs and develops enterprise data models and data warehouse structures, collaborating with ETL and reporting teams to support BI solutions in the insurance industry.
About this role
Tech Tammina LLC
Relevant Experience (Yrs):
8+ years
Technical/Functional Skills:
· Minimum 8-10 years of industry experience in Data Architecture and Data Modeling using ER Studio or Erwin.
· Must have full lifecycle project experience as a Data Architect in designing and developing Enterprise Data models.
· Must have multiple full lifecycle project experience as a Data modeler in modeling for Operational Data Stores, Data Warehouses and Data Marts.
· Strong understanding of DW concepts
· Hand on experience in implementing Dimensional and 3NF data models.
· Understanding of DW appliances, Hadoop, SQL and PL/SQL concepts, standards and best practices
· Database development, physical database design and data modeling experience
Roles & Responsibilities:
· Capture new requirements or changed requirements for modeling for new data marts, ODS, data warehouse.
· Logical and Physical modeling and design for 3NF/dimensional model for ODS/Data Warehouse,
· Develop/Modify data models as per requirements
· Strong experience of data modeling in the Insurance industry, preferably life business, is a must.
· DDL for database creation on appliances and manage database creation activities from inception to completion including interdependencies with other teams
· Conversant with designing data structures for Hadoop staging and DW and Data marts hosted in DW appliances
· Take an active role in the cross-functional design and coordinate with ETL and reporting teams
· Work closely and foster strong relationships with ETL architecture team, database administration and data consumers (e.g., reporting and interfaces teams) to design warehouse/BI data structures
· Manage the build phase and quality-assure the code to ensure that it meets requirements and adheres to standards; resolve difficult design and build issues; troubleshoot bugs
· Plan and execute Quality Assurance testing with the QA team and resolve QA defects
· Plan and manage QA and Production releases and ensure they are deployed smoothly
Generic Managerial Skills:
· Ability to prioritize and work on multiple tasks simultaneously
· Strong communication and organizational skills
· Ability to multi-task, prioritize and execute on assigned deliverables
· Ability to quickly learn new systems and business processes
Education:
Bachelor’s Degree
## Qualificationsplease share your profile to mdanish(at)1stitsolutions.com
## Additional InformationJob Status: Full Time / Permanent
Eligibility: EAD GC/ GC/ US Citizen
Share the Profiles to mdanish(at)1stitsolution.com
Contact: 703 349 1004
Keep the subject line with Job Title and Location
Skills
Explore related jobs
More jobs at Tectammina
Similar Data Warehouse jobs
- I
Senior Consultant, Data Engineer (Databricks Experience)Infinitive · McLean, Virginia - W
Data Governance & Security EngineerWoodmark Consulting GmbH · Bundesweit - SData EngineerSpectrum Health Care · Toronto, ON
- T
OFSAA Data ArchitectTectammina · Norwalk, CT - B
EuroHUB Senior Data Engineer 100%BJB Bank Julius Baer & Co. Ltd. · Madrid - H
ETL Data ModelerHsssoft · Fort Mill, SC
Jobs in Richmond
- C
Orthophoniste à 1.0000 ÉTPConseil scolaire francophone de la Colombie-Britannique · Richmond, British Columbia - O
Patient Care Assistant - Med/SurgOakBend Medical Center · Richmond, TX - O
Human Resources & Benefits Coordinator - Full TimeOakBend Medical Center · Richmond, TX - O
Medical Technologist- PRNOakBend Medical Center · Richmond, TX - O
Patient Access Representative - Physical Therapy- OP Richmond Full TimeOakBend Medical Center · Richmond, United States - O
Patient Access Representative - ECCOakBend Medical Center · Richmond, TX
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.