Data Modeler and Information Architect

PeopleCaddie; Jersey City (NJ); Hybrid; USD 68,880 - 82,656; Part time

Job summary

A consulting firm is seeking an experienced Data Modeler and Information Architect to enhance enterprise data models and implement best practices. Located in Jersey City, candidates need to have 6–9 years of relevant experience, proficiency with Erwin Data Modeler, and the ability to work with data quality frameworks. This role offers a competitive pay rate of $50-$60 per hour on a contract basis.

Qualifications

• 6–9 years of enterprise data analysis experience.
• 6–9 years of information data architecture experience.
• 6–9 years of data architecture experience.

Responsibilities

• Lead redesign of enterprise data models to meet analytics needs.
• Integrate MDM and data quality best practices.
• Collaborate with various teams to support data requirements.
• Use Erwin Data Modeler for model management.
• Architect optimized data lakes and Databricks solutions.
• Read SPARK code to support data pipelines.
• Produce documentation for data models.
• Champion data architecture best practices.

Skills

Erwin Data Modeler

Advanced data modeling skills

Implementation of MDM and data quality frameworks

Large-scale data lakes experience

Ability to interpret SPARK code

Teamwork and communication skills

Education

Bachelor’s degree in Computer Science or related field

Job description

1 week ago Be among the first 25 applicants

This range is provided by PeopleCaddie. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$50.00/hr - $60.00/hr

Job Title: Data Modeler and Information Architect (Contract)

Location (onsite): (1) Jersey City, NJ, (2) Atlanta, GA, or (3) Columbus, OH

Pay Rate: $50-$60 per hour (W2)

Duration: 3+ Months

Overview

Seeking an experienced Data Modeler and Information Architect to lead the redesign and enhancement of enterprise data models, integrate MDM and data quality best practices, and architect optimized data lake and Databricks solutions for one of our Big Four clients. This is a hands-on role requiring expert proficiency with Erwin Data Modeler, advanced data modeling, and the ability to interpret SPARK code in support of robust analytics and data pipelines.

Key Responsibilities

• Redesign, enhance, and govern conceptual, logical, and physical data models to meet evolving business and analytics needs.
• Integrate master data management (MDM) and data quality best practices, including standardization, matching/merging, survivorship, and stewardship workflows.
• Collaborate with Data Engineering, Analytics, Product, and Governance teams to ensure models support reporting, advanced analytics, and broader enterprise requirements.
• Use Erwin Data Modeler for modeling, version control, naming standards, metadata management, and model-to-database synchronization.
• Architect and optimize data lakes and Databricks environments (table design, partitioning, performance tuning, cost optimization).
• Read and interpret SPARK code (PySpark/Scala) to understand data lineage and transformations, validate models, and support pipeline design and optimization.
• Produce documentation: data dictionaries, entity definitions, lineage and mapping specs, model change logs, and standards.
• Champion data architecture best practices including reusability, security and privacy considerations, and scalability.

Requirements

• Erwin Data Modeler
• Advanced data modeling skills across relational and analytical use cases (e.g., 3NF, dimensional).
• Proven experience implementing MDM and data quality frameworks and tooling.
• Hands-on background with large-scale data lakes and lakehouse patterns.
• Ability to read and interpret SPARK code to support and validate data pipelines.
• Strong teamwork, stakeholder management, communication, and documentation skills.

Required Skills & Qualifications

• 6–9 years of enterprise data analysis experience
• 6–9 years of information data architecture experience
• 6–9 years of data architecture experience
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field (or equivalent experience)

Preferred Skills & Qualifications

• Experience with data governance frameworks and metadata/lineage tools
• Familiarity with CI/CD for data (e.g., Git-based model versioning)
• Exposure to data quality platforms and MDM suites
• Understanding of security/privacy controls and PII handling within data platforms

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Information Technology

Industries

• IT Services and IT Consulting

Referrals increase your chances of interviewing at PeopleCaddie by 2x