Data Modeler

OP; Plano (TX); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

401(k)

Dental Insurance

Health insurance

Vision insurance

Job summary

A technology consulting firm is looking for a Data Modeler to design and document innovative data architectures across multiple platforms including RDBMS and NoSQL. The ideal candidate has over 5 years of experience in data modeling and a solid understanding of data architectures, including data warehouses and data lakes. This role emphasizes building data flows and optimizing query performance while adhering to best practices in data management.

Qualifications

• 5+ years of hands-on relational, dimensional, and/or analytic experience.
• Experience with data warehouses and enterprise big data platforms.
• Good knowledge of metadata management and data modeling tools.

Responsibilities

• Develop conceptual, logical, and physical data models.
• Oversee existing data architecture and optimize query performance.
• Implement business data requirements across all data platforms.

Skills

RDBMS expertise

Data modeling

ETL and data ingestion

Team management

Data visualization

Education

Bachelor’s degree in computer science or related

Tools

Erwin

ER Studio

Job description

Overview

Are you excited by the challenge of turning complex data into strategic business assets? We're on the lookout for a driven and innovative Data Modeler to join our dynamic Data Platform Team. You'll play a crucial role in designing, implementing, and documenting innovative data architectures, ranging from relational and dimensional models to NoSQL solutions, that empower enterprise-wide data management, analytics, machine learning, and beyond. If you're passionate about shaping the future of data-driven decision-making, this is the opportunity for you.

Key Responsibilities

• Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
• Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.
• Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, and machine learning).
• Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models.
• Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
• Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
• Hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC.
• Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.

Required Qualifications & Skills

• Bachelor’s degree in computer/technical or related experience.
• 5+ years of hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
• Experience with data warehouses, data lakes, and enterprise big data platforms in multi-data-center contexts is required.
• Good knowledge of metadata management, data modeling, and related tools (Erwin, ER Studio, or others) is required.
• Experience in team management, communication, and presentation.

Additional Qualifications

• Experience with Automobile and/or Manufacturing organizations.

Benefits

• 401(k).
• Dental Insurance.
• Health insurance.
• Vision insurance.
• We are an equal-opportunity employer and value diversity, equality, inclusion, and respect for people.
• The salary will be determined based on several factors, including, but not limited to, location, relevant education, qualifications, experience, technical skills, and business needs.

About Us

At OP, we help you harness the power of technology for maximum impact. A technology consulting and solutions company, we offer advisory and managed services, innovative platforms, and staffing solutions across a wide range of fields including AI, cyber security, enterprise architecture, and beyond. For nearly two decades, we’ve been challenging the status quo of the consulting industry serving up fresh, ingenious thinking through a radically lean structure. Together, this strategy delivers unprecedented performance at an unparalleled pace for faster results that propel your business forward.