Data Architect (Permanent /Full time )

TecTammina; Richmond (VA); On-site; USD 100,000 - 120,000; Full time

Job summary

A leading tech consultancy is seeking a Data Architect based in Richmond, Virginia. The ideal candidate will have over 8 years of experience in Data Architecture and Data Modeling, especially within the insurance sector. Responsibilities include designing enterprise data models and managing related activities, and collaboration with cross-functional teams. Candidates should possess a Bachelor’s Degree. This is a full-time, permanent position with strong emphasis on organizational and communication skills.

Qualifications

• Minimum 8-10 years of industry experience in Data Architecture and Data Modeling.
• Strong experience in the Insurance industry, preferably life business.
• Hands-on experience in implementing dimensional and 3NF data models.

Responsibilities

• Design and develop enterprise data models.
• Capture new or changed requirements for data modeling.
• Manage build phase and quality-assure code.

Skills

Data Architecture

Data Modeling

SQL

PL/SQL

Hadoop

Dimensional modeling

Organizational skills

Communication

Education

Bachelor’s Degree

Job description

Responsibilities

• 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
• 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

Qualifications

please share your profile to mdanish(at)1stitsolutions.com

Additional Information

Job Status: Full Time / Permanent

Share the Profiles to mdanish(at)1stitsolution.com

Contact: 703 349 1004

Keep the subject line with Job Title and Location