Data Modeler

1 day ago

Trenton, New Jersey, United States Compunnel Inc. Full time

Title: Data Modeler

Location: Trenton, NJ (Onsite)

Duration: months (with possible extension)

Overview:

The Data Modeler is responsible for designing, implementing, and maintaining logical and physical data models that support business intelligence, analytics, and operational applications. This role ensures data structures are optimized for scalability, performance, and data integrity across enterprise systems. The Data Modeler collaborates closely with data architects, database administrators, business analysts, and software developers to translate business requirements into efficient database designs.

Key Responsibilities:

  • Design and maintain conceptual, logical, and physical data models for enterprise data warehouses, data marts, and transactional systems.
  • Collaborate with business analysts and data architects to understand data requirements and translate them into efficient data models.
  • Develop and enforce data modeling standards, naming conventions, and metadata management best practices.
  • Create ER diagrams and maintain documentation of data entities, relationships, and attributes using tools such as ER/Studio, Erwin Data Modeler, Lucidchart, or PowerDesigner.
  • Work with SQL Server, Oracle, PostgreSQL, Azure SQL, or Snowflake databases to implement and maintain optimized schemas and structures.
  • Design and tune database schemas, indexes, and partitioning strategies to support performance and scalability requirements.
  • Collaborate with ETL developers and data engineers to ensure data integration pipelines align with the data model and data quality standards.
  • Support data governance initiatives by ensuring consistency, quality, and accuracy of enterprise data.
  • Participate in data profiling, data lineage analysis, and impact assessments to maintain system integrity and compliance.
  • Work with reporting and BI teams (SSRS, Power BI, Tableau) to ensure analytical models align with data warehouse structures.
  • Provide technical support for database design, query optimization, and data migration initiatives.
  • Ensure all data models comply with security, compliance, and privacy standards (e.g., HIPAA, GDPR, SOX).

Required Skills & Qualifications:

  • Bachelor's degree in Computer Science, Information Systems, Data Science, or related field.
  • 3–7 years of experience in data modeling, database design, or data architecture.
  • Strong proficiency with data modeling tools such as Erwin Data Modeler, ER/Studio, or PowerDesigner.
  • Advanced SQL knowledge and hands-on experience with RDBMS platforms (e.g., SQL Server, Oracle, PostgreSQL, MySQL, Azure SQL, Snowflake).
  • Experience with ETL tools such as SSIS, Informatica, Azure Data Factory, or Talend.
  • Familiarity with data warehousing concepts, dimensional modeling (Star Schema, Snowflake Schema), and OLAP/OLTP systems.
  • Understanding of data governance, metadata management, and master data management (MDM) principles.
  • Strong analytical, communication, and documentation skills.
  • Experience with cloud-based data platforms such as Azure Synapse, AWS Redshift, or Google BigQuery is a plus.

Preferred Qualifications:

  • Experience with NoSQL data modeling (MongoDB, Cassandra).
  • Exposure to data lake architectures (Azure Data Lake, AWS S3).
  • Knowledge of data cataloging tools (e.g., Collibra, Alation).
  • Certification in data modeling, database administration, or cloud data engineering (e.g., Microsoft Certified: Azure Data Engineer Associate).

  • Senior Data Modeler

    5 days ago

    Trenton, New Jersey, United States Recruitinflux Private Solution Full time

    Complete DescriptionSenior Data Modeler (SDM) Specialist will be responsible for the design, develop & implementation of Data Warehouse database structures and Analytical Database structures. SDM will work with Business groups and Application Teams during pre & post assessment periods. The SDM reports to Supervisor/Team Lead. DSM should be able to write...

  • Data Engineer

    2 weeks ago

    Trenton, New Jersey, United States CAI Full time $74,000 - $84,000 per year

    Req NumberR6522Employment TypeFull timeWorksite FlexibilityHybridWho We AreCAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we...

  • Data Architect

    2 weeks ago

    Trenton, New Jersey, United States Largeton Group Full time $60,000 - $120,000 per year

    Job Summary (Data Architect - Mid-Level Data Analyst)Location: Trenton, NJServe as a liaison between Judiciary business units and data warehouse technical teams to translate business needs into technical requirements and BI warehouse solutions.Collaborate with stakeholders to gather, document, and analyze business, data, and functional requirements.Document...

  • Business Insights Analyst Associate

    5 days ago

    Trenton, New Jersey, United States NJM Insurance Group Full time

    New Jersey Manufacturers Insurance Company (NJM) was founded in 1913 by a group of manufacturers seeking to provide cost-effective, safety conscious and financially secure workers' compensation insurance for their workers. From inception the Company has operated as a mutual, with a focus on the needs of its policyholders.Today, NJM Insurance Group, is a...

  • Executive Director – AI and Machine Learning

    3 days ago

    Trenton, New Jersey, United States CVS Health Full time

    At CVS Health, we're building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care.As the nation's leading health solutions company, we reach millions of Americans through our local presence, digital channels and more than 300,000 purpose-driven colleagues – caring for...

  • Business Intelligence Developer

    2 weeks ago

    Trenton, New Jersey, United States GSK Solutions Full time $80,000 - $120,000 per year

    BI Developer (Hybrid)Location: Trenton, NJDuration: 6 MonthsPay Rate: $75/hr on C2C / 1099 (All Inclusive) or $70/hr on W2Interview Process: In-Person OnlyJob DescriptionWe are seeking an experienced BI Developer to work closely with Research Analysts in conducting data analysis to support informed decision-making. The role involves data extraction via SQL,...

  • Software Developer Engineer

    7 days ago

    Trenton, New Jersey, United States CVS Health Full time $86,000 - $173,040 per year

    At CVS Health, we're building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care.As the nation's leading health solutions company, we reach millions of Americans through our local presence, digital channels and more than 300,000 purpose-driven colleagues – caring for...

  • Senior Salesforce Developer

    2 weeks ago

    Trenton, New Jersey, United States TechProjects Full time $120,000 - $180,000 per year

    GreetingsWelcome to TechProjects We specialize in IT System integration to help with some of the biggest names in the public sectors around New York state. Our company provides exceptional IT solutions for our clients, while also offering top-notch career opportunities for our employees.At our firm, we work with a diverse range of clients, from cutting-edge...

  • Microsoft Dynamics 365 Developer

    2 weeks ago

    Trenton, New Jersey, United States Nanosoft Consulting Talent Page Full time $85,000 - $140,000 per year

    Experience implementing Microsoft Dynamics 365 CRM-based business solutions. This position is responsible for the provisioning, development and maintenance of Microsoft Dynamics 365 CRM platform and the ideal candidate will have sound knowledge in Dynamics CRM Best Practices, entities/tables, workflows, configurations, business process flows, portals, custom...

  • Business Intelligence Analyst/Developer

    2 weeks ago

    Trenton, New Jersey, United States RICEFW Technologies Inc Full time $80,000 - $120,000 per year

    Mode of work: HybridMode of Interview: In-PersonLocation: Trenton, New JerseyThe ideal candidate will be responsible for working closely with Research Analysts to assist with conducting data analysis to make informed decisions. The ideal candidate will also conduct data extraction via SQL, App Studio, and WebFocus as well as prepare and document data...