Area Data Architect (ER/Studio Data Architect),



Office Address

Project Description

Customer is one of the leading insurance complany. The Company through, its subsidiaries, provides life insurance, retirement, and employee benefits. As part of this project team need to work on redesigning couple analytics applications.


    Area Data Architect (Modeler) is responsible for design, development and expansion of data assets that support business intelligence, advanced analytics, and reporting. They will also develop, maintain, and support the enterprise data warehouse system, corresponding data marts, and data interfaces between operational systems. This Area Data Architect- modeler will analyze and review complex object and data models and the metadata repository to structure the processes and data for better management and efficient access. Create and maintain the data documentation and be the liaison between multiple team.

    Key Job Responsibilities:
    • Hands-on working experience with ER studio
    • Expertise in using ER Studio
    • Supports corporate data assets and Designs, reviews and maintains data models.
    • Partners with Area Data Steward on data asset attributes and definitions.
    • Follows established Data Architecture Framework and Guidelines for the design, development, management, storage, access, navigation, movement, transformation and quality of corporate data assets.
    • Strong knowledge on Data Warehousing, Data Modeling Concepts, Data Architecture, Database design etc.
    • Strong experience in designing Conceptual, Logical, Physical data models.
    • Experience with integration of data from multiple data sources
    • Ability to architect end-to-end data products and make the right choice of technology stack based on the use case
    • Optimize new and current database systems
    • Strong knowledge on Modeling tools such as Erwin or ER Studio, MS Visio etc.,
    • Strong experience in Reverse engineering and Forward Engineering and generating DDLs considering all the performance aspects
    • Demonstrable experience in developing, publishing, and maintaining all documentation for data models that demonstrates data lineage
    • Ability to quickly learn and adapt modeling methods from case studies or other proven approaches
    • Strong experience in source data analysis and source to target/ETL mappings
    • Performs the data analysis activities to capture data requirements clearly, completely and correctly, and represent them in a formal and visual way through the data models.
    • Creates semantically rich logical data models that define the Business data requirements and are independent of any technology solution (i.e. DBMS.)
    • Manages the life cycle of the data model from requirements to design to implementation to maintenance.
    • Looks for opportunities to provide data reuse, balancing the issues of centralization and replication.
    • Encourages the Business to manage data as an asset.
    • Ensures the preservation of strategic data assets as applications and technologies come and go.
    • Requires an in-depth understanding of the Business data needs and the ability to align those business needs with the overall Enterprise data vision.
    • Evaluates the use of data to the goals and practices of the Business in a way that provides clear results.
    • Acts as a liaison, deducing the data needs of a particular project or group and explaining the importance and use of the data most relevant to them.
    • Helps ensure the accuracy and accessibility of all "important" data and is responsible for knowing what data is "important" and why.
    • Compiles and maintains the schema definition for physical data models.
    • Reviews all physical data models with data management committee before implementation.
    • Assists the ETL developers to help ensure that the Business data rules are implemented correctly and clarifies issues as they arise.


Must have

    • 5+ years of experience data modeling data solutions including but not limited to : ODS, Data Warehouse, Data Integration Hub, OLTP/OLAP, or equivalent knowledge
    • Core competency in: Relational DBMS (Oracle, SQL Server), Data modeling
    • ER Studio or similar Entity Relationship tool.

Nice to have

    Agile Methodology


English: C1 Advanced



Relocation package

If needed, we can help you with relocation process. Click here for more information.

Work Type

BigData (Hadoop etc.)

Ref Number


More job opportunities in
BigData (Hadoop etc.)

Specialization Position / Title Location Seniority Send to a friend
BigData (Hadoop etc.) Application Developer Azure Databricks Chennai, IN Regular
BigData (Hadoop etc.) Senior Big Data Developer Chennai, IN Senior
BigData (Hadoop etc.) Application Developer Azure Databricks Chennai, IN Regular
BigData (Hadoop etc.) Senior Developer Informatica Chennai, IN Senior