Lead Data Modeler

Veracity Software Inc; Indiana (PA); Remote; USD 100,000 - 130,000; Full time

Job summary

A technology solutions provider is seeking a Lead Data Modeler to design, develop, and maintain data models that support business intelligence and analytics initiatives. The ideal candidate has a degree in Computer Science, over 8 years of experience in data modeling, and strong leadership skills. This full-time role is remote, with a preference for candidates in the EST time zone.

Qualifications

• 8+ years of experience in data modeling, data architecture, or data warehousing.
• Strong knowledge of relational, dimensional, and NoSQL data modeling.
• Experience with cloud data platforms (AWS, Azure, Google Cloud) is a plus.

Responsibilities

• Lead the design and implementation of enterprise-wide data models.
• Develop and maintain conceptual, logical, and physical data models.
• Collaborate with business stakeholders to understand data requirements.

Skills

Data modeling

Leadership

SQL

Communication

Collaboration

Education

Bachelor's or Master's degree in Computer Science

Tools

ERwin

PowerDesigner

SQL Developer Data Modeler

Job description

Overview

Full Time position located in Indianapolis (Remote). Preference for candidates in the EST time zone. No H1B Transfer.

The Lead Data Modeler will be responsible for designing, developing, and maintaining enterprise data models that support business intelligence, analytics, and data warehouse initiatives. This role requires deep expertise in conceptual, logical, and physical data modeling, along with the ability to lead a team of data modelers and collaborate with business and IT stakeholders.

Responsibilities

• Lead the design and implementation of enterprise-wide data models for operational systems, data warehouses, and analytical solutions.
• Develop and maintain conceptual, logical, and physical data models.
• Collaborate with business stakeholders to understand data requirements and translate them into efficient data models.
• Ensure data models are aligned with data governance, security, and compliance standards.
• Partner with ETL developers, BI teams, and data architects to implement models effectively in the data warehouse and analytics environments.
• Review and optimize existing data models for performance, scalability, and maintainability.
• Establish and enforce data modeling standards, best practices, and documentation guidelines.
• Mentor and guide junior data modelers and team members.
• Evaluate emerging data modeling tools, techniques, and technologies to improve modeling efficiency.

Required Skills & Qualifications

• Bachelor's or Master's degree in Computer Science, Information Systems, or related field.
• 8+ years of experience in data modeling, data architecture, or data warehousing.
• Strong knowledge of relational, dimensional, and NoSQL data modeling.
• Experience with data modeling tools like ERwin, PowerDesigner, SQL Developer Data Modeler, or equivalent.
• Strong SQL skills and understanding of database concepts.
• Knowledge of ETL processes, data warehousing concepts, and BI reporting.
• Experience with cloud data platforms (AWS, Azure, Google Cloud) is a plus.
• Excellent communication, collaboration, and leadership skills.

Preferred Skills

• Experience with big data platforms like Hadoop, Spark, or Databricks.
• Familiarity with data governance and master data management (MDM) concepts.
• Certification in data modeling or data architecture is a plus.

Employment details

• Employment type: Full-time
• Location: Indianapolis, IN (Remote); EST time zone preferred