Sr. Data Architect

Overview

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. No relocation assistance available. Remote-only candidates will not be considered.

Full-time Contract Position

IT
Dallas, TX

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 s 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 ve made will not be considered. Your resume should reflect actual implementation work, not just oversight or governance roles.

In this role, you ll design and manage data architectural solutions across multiple environments including Data Warehouse, ODS, Data Replication, and ETL initiatives. You ll 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.

Your day-to-day will involve hands-on data modeling, designing architectural solutions, establishing data governance frameworks, and implementing Master Data Management strategies. You ll need to demonstrate strong technical expertise in OLTP, Data Warehouse design, dimensional modeling, and data movement best practices. This is a technically intensive role where you ll be expected to provide detailed technical guidance, review data models, and ensure architectural standards are implemented correctly.

The ideal candidate has spent years in the trenches doing actual data architecture work—designing schemas, building data models, implementing ETL solutions, and making technical decisions about data structures. You should be passionate about data architecture best practices, comfortable mentoring others on technical implementation details, and energized by solving complex data challenges through hands-on technical work.

You ll report to Data Architecture leadership and work closely with cross-functional technical teams including DBAs, ETL developers, Business Intelligence teams, and Enterprise Architects at our Dallas-Fort Worth facilities.

Our client is one of the largest regulated electric transmission and distribution utilities in the United States, serving over 10 million consumers across North Central Texas. With more than a century of operational excellence, they deliver electricity to homes and businesses through a robust infrastructure spanning 140,000+ miles of transmission and distribution lines. As a critical component of Texas  energy infrastructure, they are committed to reliability, innovation, and safety while investing heavily in grid modernization and smart technology solutions.

Their mission centers on powering quality of life through safe, reliable energy delivery and cutting-edge infrastructure development.

• 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…