Lead Data Modeler at Derex Technologies Inc

New York, New York, United States -

Full Time

Start Date

Immediate

Expiry Date

19 Oct, 26

Salary

0.0

Posted On

21 Jul, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Enterprise Data Modeling, Conceptual Data Modeling, Logical Data Modeling, Physical Data Modeling, Data Warehousing, Dimensional Modeling, ERwin, ER Studio, SQL, Data Architecture, Business Data Analysis, Metadata Management, Stakeholder Management, AWS Databricks, Delta Lake, Unity Catalog

Industry

IT Services and IT Consulting

Description

Company Description Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software services. Globally headquartered in Harrison New Jersey since 1996 Derex delivers the highest quality technology professionals and an array of customized IT talent solutions designed to improve productivity and drive results to global clients throughout North America. With over two decades of unparalleled experience, Derex provides supports to its clientele, across such industries as Systems Integration, Banking and Finance, Telecommunications, Pharmaceutical and Life Sciences, Energy, Healthcare, Technology, Transportation, and local and federal Government agencies. Job Description Title: Lead Data Modeler Location ; New York, NY(Only Locals) Job Description Lead Data Modeler. Primary Skill: Lead enterprise data modeling activities across multiple business domains including Customer/Assured, Broker, Policy, Claims, Finance, Financials, GWP, Reinsurance, Submission, and HR. Conduct business workshops with business stakeholders, SMEs, and application owners to understand business processes, data requirements, and reporting needs. Assess existing SSIS EDW data models and identify opportunities for reuse, rationalization, and modernization. Perform fit-gap analysis between current-state and target-state enterprise data models. Define and develop conceptual, logical, and high-level physical data models aligned to enterprise architecture standards. Identify enterprise business entities, attributes, business keys, relationships, hierarchies, reference data, and conformed dimensions. Collaborate with Enterprise Architects to define canonical data models and ensure consistency across business domains. Review and validate source-to-target mappings, business rules, and transformation logic to ensure alignment with enterprise data models. Lead cross-domain data model integration and resolve data modeling conflicts across domains. Develop and maintain enterprise data dictionaries, business glossaries, metadata, and modeling standards. Review and approve data models developed by offshore data modelers and provide technical guidance and mentoring. Facilitate design review sessions, architecture walkthroughs, and business validation workshops to obtain stakeholder approval. Support Gold layer mapping and define semantic layer data structures, business entities, KPIs, hierarchies, and business definitions. Ensure compliance with enterprise data governance standards, naming conventions, metadata standards, and modeling best practices. Work closely with Data Engineers, Business Analysts, Data Governance teams, and client stakeholders throughout the project lifecycle. Mandatory Skills: Enterprise Data Modeling, Conceptual/Logical/Physical Data Modeling, Data Warehousing, Dimensional Modeling (Star Schema/Snowflake), ERwin/ER Studio (or equivalent), SQL, Data Architecture principles, Business Data Analysis, Data Dictionary & Metadata Management, Strong stakeholder management and workshop facilitation skills. Preferred Skills: AWS Databricks, Delta Lake, Unity Catalog, Data Vault, Informatica, SSIS, Insurance (Property & Casualty) domain experience, Data Governance Frameworks, Azure DevOps/Jira. Regards, Manoj Goud Derex Technologies INC Contact : 973-834-5005 Ext 206 Additional Information All your information will be kept confidential according to EEO guidelines.

Responsibilities

Lead enterprise data modeling activities across multiple business domains and conduct workshops with stakeholders to define data requirements. Develop conceptual, logical, and physical data models while ensuring alignment with enterprise architecture and governance standards.