Data Modeler Jobs

Key Responsibilities3D Modeling & Connection Detailing: Design and detail complex structural steel systems (industrial buildings, pipe racks, platforms, and miscellaneous steel) using Tekla Structures, ensuring compliance with AISC codes and engineering connections.Shop & Erection Drawing Production: Extract accurate, high-quality shop fabrication drawings, assembly sheets, single-part details, and field erection plans.BOM & CNC Data Generation: Generate comprehensive Material Take-Offs (MTO), Bill of Materials (BOM), bolt lists, and NC/DXF files for automated CNC machinery.Clash Detection & Quality Control: Conduct thorough internal clash checks (steel-to-steel, geometry, and clearance verification) to resolve constructability conflicts before release.RFI & Revision Management: Track project revisions, implement engineer/architect markups, and draft professional Requests for Information (RFIs) for client coordination.

We are seeking an experienced Data Modeler with strong expertise in the Private Equity and Investment Management domain. The ideal candidate will have hands-on experience in canonical data modeling, Azure Databricks (Medallion Architecture), and financial data governance. This role requires close collaboration with data engineering, business stakeholders, and product owners to design scalable, accurate, and consistent data solutions for enterprise-wide usage.Key ResponsibilitiesDesign and implement canonical data models to support private equity and investment business processes.Develop logical and physical data models aligned with enterprise architecture and cloud strategy.Work within Azure Databricks Medallion Architecture (Bronze/Silver/Gold layers) to design efficient and scalable data flows.Collaborate with data engineering teams to implement models and optimize performance.Gather requirements from business stakeholders and product owners; translate them into robust data models.Ensure data standardization, lineage, and governance across applications and integrations.Create and maintain detailed documentation of data models, metadata, and business definitions.Provide thought leadership on canonical modeling, financial data integration, and cloud-based data architecture.Required Qualifications & Skills8-12 years of experience as a Data Modeler or in a similar data architecture role.Strong domain expertise in Private Equity, Investment Management, or Asset Management (fund structures, portfolio data, investor reporting, valuations).Proven expertise in canonical models and developing logical/physical data models.Hands-on experience with Azure Databricks & Medallion architecture.Proficiency in SQL, relational databases, dimensional modeling, and ETL/ELT processes.Strong background in data governance, metadata management, and data cataloging.Knowledge of financial data standards and regulatory reporting frameworks.Excellent communication and stakeholder management skills.Must-Have ExperiencePrivate Equity / Investment domain expertise.Cloud-based architecture (Azure preferred).Financial regulatory reporting knowledge.Educational QualificationBachelor of Engineering / Bachelor of Technology (B.E./B.Tech.) or equivalent in Computer Science, Engineering, or related field.

Job Title: Date ModelerWork Mode: Remote Experience: 5+Job Description:Skills: Database Architect, Database designing, data modeling, ETL and Data Warehousing Database programming using PL/SQL (Oracle10g/11g/19c) Design and development of ETL jobs. Unix Shell scripting Requirement Analysis and Estimation Functional and Technical design for new assignmentsInterested candidates drop your resume to sanmathi.am2techs08@gmail.com

Atleast 2 Projects done as Data Modeler.Discover, analyze, and scope data requirements ; create high level process models to represent processes for the area under analysis.Create detailed mapping documents covering source to target mapping, transformation logic and harmonization. Design Data Architecture, Strategy, Employ Entity-Relationship modeling with the intent of producing a design best suited for retrospective analysis of data.Healthcare Domain Knowledge is a must; Exposure to HL7, FHIR, OMOP will be a plusSkills : SQL, IBM UDMH Model - Atomic or Dimensional Model, IDA, ERWin, ER-Studio, Data normalization and denormalization techniques.

Analyzing and translating business needs into long-term solution data models.Evaluating existing data systems.Working with the development team to create conceptual data models and data flows.Developing best practices for data coding to ensure consistency within the system.Reviewing modifications of existing systems for cross-compatibility.Implementing data strategies and developing physical data models.Updating and optimizing local and metadata models.Evaluating implemented data systems for variances, discrepancies, and efficiency.Troubleshooting and optimizing data systems.Data Modeler Requirements:1-5 years of hands-on experience with physical and relational data modeling.Expert knowledge of metadata management and related tools.Knowledge of mathematical foundations and statistical analysis.Strong interpersonal skills.Experience with team management.Excellent communication and presentation skills.Advanced troubleshooting skills.