Senior Data Modeler & Architect – Erwin, 3NF Lead

TechDigital Group; San Antonio (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

An established industry player is seeking an experienced Data Modeler to join their team. In this pivotal role, you will leverage your expertise in data modeling and database design to create logical and physical data models that meet business requirements. Your responsibilities will include implementing 3NF schema designs, analyzing existing data models for improvements, and collaborating with stakeholders to ensure data governance standards are upheld. This position offers an exciting opportunity to contribute to data management practices and make a significant impact on the organization's data strategy. If you are passionate about data and eager to drive efficiency, this role is perfect for you.

Qualifications

• 6+ years of experience in data modeling and database design.
• Proven skills in implementing 3NF schema design and data governance.

Responsibilities

• Design and create logical and physical data models using Erwin.
• Analyze existing data models and suggest improvements for efficiency.

Skills

Data Modeling

DBA/Erwin Data Modeler

3NF schema design

Data Governance Standards

Database Design

Data Quality Rules

Tools

Erwin

Job description

Mandatory Skills & Experience

• Lead and manage teams in an Onsite–Offshore model.
• Ensure adherence to QA processes and best practices.
• Leverage AI for automation in testing workflows is Must
• Perform database testing with strong expertise in ETL concepts and ETL testing.
• Work extensively on end-to-end flows within retail domain marketing systems
• Strong QA process knowledge.
• Hands-on experience with database testing and ETL testing.
• Recent project experience with retail clients (back-end systems).
• Deep understanding of retail domain marketing systems and end-to-end flows.
  ¬ Review requirements and prepare the Test Plan

¬ Develop and execute ETL test plans, test cases, and test scripts to validate the
accuracy and integrity of data throughout the ETL process
¬ Verify data mappings, transformations, and data loading processes to ensure they
meet business requirements
¬ Should have various types of ETL testing experiences include Metadata Testing, Data
Completeness Testing, Data Accuracy Testing, Data Transformation Testing, Data
Quality Testing, Initial/Incremental load testing
¬ Validates data by running queries in the database and verifying that the results match
the expectations
¬ Perform data reconciliations between source and target systems
¬ Demonstrate strong knowledge of dimensional modelling and data warehouse
concepts, including star schemas, snowflakes, dimensions, and facts
¬ Collaborate with data architects and development team / engineers to design and
implement efficient data structures to ensure the quality of testing by providing data
validation expertise