TechDoQuest · 22 hours ago
Data Modeler
Edison, NJ
Contract
Onsite
Mid, Senior LevelTechDoQuest is seeking a hands-on Data Modeler to design and evolve enterprise-grade data models for reporting, analytics, and advanced insights. The role involves translating business requirements into various data design formats and collaborating with multiple teams to ensure the delivery of scalable models.
Cloud ComputingConsultingInformation TechnologyOutsourcingProfessional ServicesSoftware
Hiring Manager
Dharmita Kaithwas
Responsibilities
Model design & documentation: Create ERDs and data models (conceptual, logical, physical) for relational (3NF) and dimensional (star/snowflake) structures; maintain comprehensive documentation (data dictionaries, entity/attribute catalogs, glossaries)
Assist with the development and maturing of data modeling standards, guidelines, processes, and procedure for P&C Insurance
Multi‑source harmonization: Analyze and reverse‑engineer “as‑is” structures from varied source systems; design canonical and conformed models to unify and standardize data for enterprise use
Requirements translation: Partner with Information Architecture and Business Analysis to convert business concepts into precise technical designs, S2T (source‑to‑target) mappings, and DDL with clear integrity rules
Physical design alignment: Work with Data Architects and DBAs to validate physical design choices (partitioning, indexing, constraints) and ensure alignment to performance, reliability, and governance SLAs
Analytics & reporting enablement: Model aggregated and hierarchical structures and define fact/dimension layers, including SCD policies and conformed dimensions, to power BI, self‑service, and operational reporting
Standards & governance: Establish and enforce enterprise data standards (definitions, naming, keys, relationships), embed data quality and lineage considerations, and support stewardship and audit needs
Reference/master data: Define approaches to unify identifiers and entities across systems (golden‑record rules, survivorship, conformance strategies)
Collaboration & leadership: Guide onshore/offshore contributors on modeling deliverables, review cycles, and documentation; facilitate stakeholder reviews and sign‑offs
Continuous improvement: Contribute to modeling standards, templates, and checklists; advocate reusable patterns across subject areas and lines of business
Qualification
Required
Strong data‑modeling expertise using ER diagrams and tools such as Erwin (or ER/Studio, equivalent)
Proven delivery of conceptual, logical, and physical models at enterprise scale, spanning 3NF and dimensional approaches
Ability to gather and translate business requirements into clear technical designs, S2T mappings, and DDL (keys, constraints, indexes)
SQL proficiency and deep understanding of database design, normalization, referential integrity, and performance considerations
Experience designing for aggregated & hierarchical reporting, SCD policies, and conformed dimensions
Effective collaboration with Architecture/BA/DBA/Engineering teams; excellent written and verbal communication skills
High attention to detail, consistency, and data quality across large and complex datasets
Company
TechDoQuest
Techdoquest is a software company that specializes in IT consulting & services, cloud migration, IT Staffing, outsourcing, and telecom.
Founded in 2018
51-200 employees
H1B Sponsorship
TechDoQuest has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (2)
Funding
Current Stage
Growth StageCompany data provided by crunchbase