Data Modeler

Data Modeler

Must-Haves:

- 6-9 years’ experience in performing data modeling/data design, hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols)
- Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required.
- Solutions Delivery experience - expertise in system development lifecycle, integration, and sustainability
- Advanced data modeling or database experience; experience with Data Lake/Lakehouse, Synapse, IDM, ER/Studio and/or Erwin modeling tools
- Knowledge on Data lake/Cloud Platforms(Azure - Synapse), ADF, Databricks
- Good understanding of business processes,





Industry data models and EDW/MDM environments

Plusses:

- Knowledge on any cloud platforms specifically Synapse and Azure is added advantage.

Day-to-day:

- Primary focus would be to partner with Enterprise Architecture to create Data Models, establish data standards and govern across all development; advocate and assist in governing Enterprise Architecture standards and strategy via data solutions.
- Governs data design/modeling – documentation of metadata (business definitions of entities and attributes) and constructions database objects, for baseline and investment funded projects, as assigned.
- Provides and/or supports data analysis, requirements gathering, solution development, and design reviews for enhancements to, or new, applications/reporting
- Independently complete designs and database object constructs on any supported platform, including Microsoft Azure, Synapse, Teradata, Sybase, Salesforce, Oracle, and/or DB2 (Accountable)






- Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, and machine learning).
- Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models
- Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
- Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
- Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS,





operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
- Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.

▶️ Data Modeler
🖊️ Insight Global
📍 Alappuzha