Sr. Data Architect

Senior Data Architect – Data Architecture & Enterprise Solutions

Dallas‑Fort Worth, TX – Hybrid (Mandatory Thursday Onsite) – Local Candidates Only. This position requires a hybrid work arrangement with mandatory onsite presence every Thursday for team collaboration and stakeholder meetings. Candidates must be located in the Dallas‑Fort Worth metroplex; remote‑only candidates will not be considered.

Role Type:
Full‑time Contract Position (Contract End: Dec 10, 2025).

We're seeking a hands‑on Senior Data Architect who can roll up their sleeves and deliver technical solutions—not just provide high‑level strategy. This is not a leadership or management role; it is an expert technical position requiring deep, practical experience in data modeling, architecture design, and implementation.

CRITICAL REQUIREMENT:
You must be able to discuss your hands‑on technical work in detail during interviews. Candidates who provide only high‑level answers or cannot articulate specific technical decisions they have made will not be considered. Your resume should reflect actual implementation work, not just oversight or governance roles.

In this role, you will design and manage data architectural solutions across multiple environments including Data Warehouse, ODS, Data Replication, and ETL initiatives. You will work directly with Business teams, DBAs, ETL developers, and Data Management teams to solve complex data challenges. This position requires someone who can both architect solutions and understand the technical details of implementation deeply enough to guide and mentor others effectively.

• Design and implement data architectural solutions for Data Warehouse, ODS, Data Replication, and ETL initiatives using hands‑on technical expertise.
• Create detailed data models (conceptual, logical, and physical) with strong emphasis on normalization, dimensional modeling, and performance optimization.
• Establish, document, and enforce policies, procedures, and guidelines for all aspects of Data Governance.
• Ensure data decisions are consistent across the organization and architectural best practices are followed in implementation.
• Maintain and update Data Standardization definitions, Data Dictionary, and Data Lineage documentation ensuring accessibility for all stakeholders.
• Collaborate directly with ETL, Replication, and DBA teams to determine and implement best practices for data transformations, movement, and derivations.
• Work hands‑on with support teams to establish consistent proactive support methodologies for data movements and transformations.
• Mentor Data Architects and Data Analysts through detailed technical guidance on database design and data management best practices.
• Provide hands‑on assistance in overall architectural solutions including technical design, data modeling, and implementation strategies.
• Partner with business teams and Enterprise Architecture to ensure optimal architectural solutions from a data perspective.
• Create and execute strategic roadmap for Master Data Management (MDM) implementation with specific technical milestones.
• Take ownership of implementing MDM tools including technical configuration, integration, and deployment.
• Establish comprehensive policies, procedures, and guidelines for all aspects of Master Data Management.
• Document architectural rules and design of the MDM process ensuring technical specifications are detailed and actionable.

• 5+ years of hands‑on Data Architecture experience across OLTP, Data Warehouse, and Big Data environments with demonstrable technical implementations.
• 5+ years of Solution Architecture experience with proven ability to design and implement complex data solutions from conception to deployment.
• 5+ years of Master Data Management (MDM) experience including hands‑on implementation of MDM tools and processes.
• 5+ years of Data Governance experience with working knowledge of best practices and hands‑on implementation expertise.
• Extensive hands‑on knowledge of all aspects of data movement and processing including Middleware, ETL, APIs, and OLAP technologies.
• Strong data modeling expertise with ability to…