Sr. Data Architect (12/9/25)

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: Dec10,2025). Job Description 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. Duties and Responsibilities 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. Required Experience & Skills 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 create and review detailed conceptual, logical, and physical data models. Deep understanding of dimensional modeling (star/snowflake schemas), normalization techniques, and data warehouse design patterns. Proven ability to discuss technical decisions, trade‑offs, and implementations in detail during technical interviews. Expert knowledge of database design principles, indexing strategies, partitioning, and performance tuning. Experience with data lineage tracking, metadata management, and data cataloging best practices. Strong technical communication skills with ability to articulate complex architectural concepts to technical and non‑technical audiences. Self‑motivated with proven ability to work independently on complex technical challenges. Demonstrated mentoring capability with ability to provide detailed technical guidance to junior architects and analysts. Works effectively in collaborative team environments while maintaining technical accountability. MUST be currently located in the Dallas‑Fort Worth metroplex with ability to be onsite every Thursday. Nice‑to‑Haves Experience with utility, energy, or critical infrastructure data architectures. Familiarity with Oracle, SQL Server, and modern data platforms (Hadoop, MongoDB, cloud data warehouses). Knowledge of data vault modeling methodologies and implementation. Experience with Erwin Data Modeler, PowerDesigner, or similar enterprise data modeling tools. Background in implementing data quality frameworks and data profiling solutions. Certification in data architecture (CDMP, TOGAF) or enterprise architecture frameworks. Experience with cloud‑based data architectures (Azure, AWS, GCP). Knowledge of real‑time data integration patterns and streaming architectures. Familiarity with DataOps practices and CI/CD for data pipelines. Education Bachelor's degree in Computer Science, Information Systems, Data Management, Engineering, or related technical field required. Master's degree preferred. Equivalent hands‑on technical experience will be considered. Pay & Benefits Summary Competitive hourly rate: $90–$100/hour based on experience and qualifications. Hybrid work arrangement with mandatory Thursday onsite collaboration in Dallas‑Fort Worth (flexibility on other days). Opportunity to work on mission‑critical data architecture supporting infrastructure for millions of Texans. Collaborative, fast‑paced team culture that values technical excellence and hands‑on expertise. Professional development opportunities working alongside experienced technical teams on complex enterprise solutions. Exposure to large‑scale enterprise data systems spanning multiple architectural patterns and technologies. Results‑driven, solution‑oriented culture where technical contributions directly impact organizational success. #J-18808-Ljbffr