Seeking an experienced contractor to support an enterprise data modeling transformation initiative. This role will assess existing data modeling processes and technology, execute structured manual testing of critical workflows, and develop a phased roadmap for test automation and quality gates. The contractor will collaborate with data modelers, data engineers, platform teams, and data governance stakeholders to improve data quality, consistency, governance, and release readiness across data models and related metadata.
Required Skills & Qualifications
7 years of experience in data engineering, data architecture, data modeling, QA, or related roles with a strong testing focus.
Hands-on experience establishing testing frameworks, developing test cases, and implementing test automation.
Strong understanding of logical data modeling, including entities, relationships, keys, normalization, dimensional and relational models, and naming standards.
Advanced Client Excel skills, including complex worksheets and data analysis.
Strong SQL skills and experience validating data, schemas, and modeling artifacts.
AI/ML fluency and the ability to identify opportunities for testing automation and process improvement.
Experience testing data and metadata workflows beyond application UI testing.
Ability to document test results, manage defects, analyze findings, and communicate actionable recommendations.
Prior work experience at client or in client's Industry
Applicants must be able to work directly for Artech on W2
Preferred Skills & Qualifications
Experience with enterprise data modeling tools such as ER/Studio, ERwin, SAP PowerDesigner, or Sparx Enterprise Architect.
Familiarity with metadata, catalog, and governance platforms such as Collibra, Alation, Informatica, or Client Purview.
Experience with CI/CD and automation tools such as GitHub, GitLab, Azure DevOps, or Jenkins.
Experience implementing automated quality checks, schema validation, model diffing, and regression testing.
Familiarity with Snowflake, Databricks, SQL Server, Oracle, PostgreSQL, and DDL deployment practices.
Mortgage industry knowledge and experience working with mortgage-related data.
Day-to-Day Responsibilities
Assess the end-to-end data modeling lifecycle, including intake, design, review, approval, governance, versioning, publication, change management, and release.
Evaluate data modeling tools, metadata catalogs, version control, CI/CD integrations, and work management systems.
Develop and execute test plans and test cases for data model creation, updates, standards validation, keys, relationships, and referential integrity.
Define a testing strategy focused on data quality, governance, release readiness, auditability, and delivery efficiency.
Collaborate with architecture, engineering, governance, and delivery teams.
Analyze test results and communicate defects, risks, status updates, and recommendations.
Company Benefits & Culture
Competitive compensation package
Opportunities for professional development and growth
Inclusive and collaborative work environment
For immediate consideration please click APPLY to begin the screening process with Alex.