• Citizen

• Full Time

• Direct Hire

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 7th Oct 2022

• As our Data Architect, you will report to our Director, Data Architecture who reports to our Second Vice President, Enterprise Data Architecture.

Your responsibilities will include the following activities:

• Review and understand data requirements for Individual Markets, Enterprise and Group Benefits projects, with a special emphasis on projects focused on reporting, analytics and data warehousing.
• Collaborate with business and IT partners to refine and document system data requirements
• Perform data analysis activities including data profiling, creation of data dictionaries, data transformation rules and integration requirements.
• Develop, document and maintain logical and physical data models for supported applications;
• Coordinate across organizations as required to support data integration efforts;
• Support and apply data standardization policies;
• Other related activities, as assigned.

Your Responsibilities

• Data Modeling: Develop, document and maintain logical and physical data models that accurately reflect the existing environment and update for new projects/enhancements. Work with DBA and other staff as necessary, to instantiate physical databases based on the models.
• Data Analysis & Design: Review data sources and assess data quality; determine the appropriate data inputs, outputs and integration rules and strategy. Create functional design specifications to be used by the developers.
• Model Management: Version and configuration manage data models so that they are consistent with development testing and production deployment environments.
• Information Dissemination: Publish models and metadata in the form of web pages, graphics and reports to projects, management and other interested parties in order to raise the organizational knowledge of what data exists where.
• Cross-Organizational Coordination: Interface with business units, internal IT, customers and management in the performance of duties.
• The above description includes most significant duties performed. However, other occasional work assignments not mentioned are assumed to be included. Management reserves the right to assign and/or reassign duties and responsibilities at any time.

Reporting Relationships

• As our Data Architect, you will report to our Director, Data Architecture who reports to our Second Vice President, Enterprise Data Architecture.

Competencies/Skills

• Logical and Physical Data Modelling
• Expert-level data sourcing and data mapping and data analysis skills.
• Expert-level database skills creating and optimizing queries and data structures.
• Excellent written and verbal communication skills.
• Creative problem-solving skills.
• Ability to work independently or as part of a project team.
• Ability to self-manage tasks to meet delivery targets.

Knowledge

• Insurance domain knowledge; preferably with an insurance carrier.
• HIPAA and other regulations that govern the access of data
• Relational database concepts; Strong experience in SQL Server and related technologies.
• ETL concepts, preferably Informatica or Syncsort
• Proficient in data modelling tools preferably Erwin.
• Strong RDBMS knowledge.
• Familiarity with Hadoop and the Data Lake would be highly desirable. Familiarity with Hive, Alteryx or any other related technologies would be a huge plus.
• Familiarity with Mainframe data structures in VSAM and DB2 would be a big plus.

Experience

• 8+ Years of IT industry experience, with 5+ years of experience as a Data Architect or in data related areas.
• Sound exp of AWS.
• Developed and implemented relational data models.
• Significant experience interfacing with both customers and management.
• Familiarity with Big Data technologies like Hadoop and Data Lake is a plus.