
Senior Data Architect – Data Mapping & Data Warehousing :: Arlington, TX (Hybrid)
Artech · Dallas, TX · Hybrid
Strong hiring record · median 7 days open
- First seen
- 19 November 2026
- Reposted
- Not since September 2026
All reasons
In its favour
- Posted today
- Still listed on the employer's own board
Job Description
Senior Data Architect – Data Mapping & Data Warehousing
Location
Arlington, TX
Work Arrangement
Hybrid – Onsite 2 days per week
Position Type
Contract
Experience Level
Expert (10+ Years)
Primary Skill
Data Mapping
Job Summary
We are seeking an experienced Senior Data Architect / Data Warehousing Consultant to support an enterprise data modernization initiative involving the migration of existing Oracle Exadata data products to a new data platform (Helix) and downstream Analytics Platform.
The ideal candidate will have extensive experience in enterprise data architecture, data warehousing, data mapping, Databricks, SQL, and analytics model design. This role requires strong technical and analytical expertise, along with the ability to gather business requirements, translate business needs into technical data specifications, and coordinate with business stakeholders, source system teams, and data engineering teams.
This is primarily a data architecture, data analysis, and technical coordination role rather than a hands-on development position. A seasoned Data Architect, Data Warehouse Architect, or Technical Project Manager with strong data warehousing and SQL expertise would be well suited for this opportunity.
Key Responsibilities
- Data Architecture & Data Warehousing
- Analyze existing enterprise data products and understand the current data warehouse architecture.
- Assess existing Oracle Exadata data structures, tables, fields, and downstream data dependencies.
- Support the transition of existing data products to the new Helix source platform and Analytics Platform.
- Provide architectural guidance on data models, schemas, target tables, and data integration approaches.
- Ensure target data structures align with business reporting, analytics, and operational requirements.
- Data Mapping & Requirements Analysis
- Conduct detailed analysis of existing Exadata data products to identify business-critical tables, columns, fields, and data dependencies.
- Collaborate with business users to understand data consumption patterns, reporting requirements, and technical needs.
- Engage with the Helix source system team to understand available source data structures and attributes.
- Map business-required source fields from existing Exadata data products to the corresponding Helix source fields.
- Prepare and maintain detailed Source-to-Target Mapping (STTM) documents.
- Validate data mappings to ensure completeness, accuracy, consistency, and alignment with business requirements.
- Identify data gaps, transformation requirements, dependencies, and mapping challenges.
- Databricks & Analytics Platform
- Provide technical guidance on moving source data into the enterprise Analytics Platform using Databricks.
- Guide data engineers in designing and developing target tables based on approved business and technical requirements.
- Support analytics model design and ensure data structures meet downstream reporting and analytical needs.
- Review data transformation logic, SQL queries, and data models to ensure alignment with mapping specifications.
- Provide recommendations for scalable and efficient data warehouse and analytics solutions.
- Stakeholder Management & Technical Coordination
- Facilitate technical discussions between Helix source system teams, data engineers, business users, and other stakeholders.
- Lead requirements-gathering discussions to understand business data needs and technical dependencies.
- Translate business requirements into clear data mapping specifications and technical documentation.
- Resolve data-related questions, mapping discrepancies, and design challenges during implementation.
- Coordinate with business and technical teams to ensure consistent understanding of data requirements and target-state solutions.
- Technical Leadership & Documentation
- Guide and mentor junior team members in preparing and maintaining Source-to-Target Mapping documentation.
- Review mapping documents and ensure adherence to established documentation standards.
- Provide technical direction to developers and data engineers during data migration and target table development.
- Review proposed data designs and provide recommendations to address technical and business requirements.
- Track data dependencies, mapping issues, assumptions, and design decisions throughout the project lifecycle.
Required Qualifications & Experience
- 10+ years of experience in Data Architecture, Data Warehousing, Data Engineering, or enterprise data transformation initiatives.
- Expert-level experience in data mapping, including Source-to-Target Mapping (STTM).
- Strong understanding of enterprise data warehouse architecture, data modeling, schemas, and analytics platforms.
- Hands-on proficiency with Databricks and its application in enterprise data and analytics environments.
- Strong SQL skills, including the ability to analyze complex queries, tables, joins, and data structures.
- Experience working with Oracle Exadata or similar enterprise database platforms.
- Proven experience gathering and analyzing business and technical data requirements.
- Experience translating business requirements into data mapping specifications and target data models.
- Strong stakeholder management and technical facilitation skills.
- Ability to guide data engineers and junior team members through technical design and documentation activities.
- Excellent analytical, problem-solving, communication, and documentation skills.
Additional Required Skills
- Informatica PowerCenter & Oracle SQL: Advanced (6–9 years)
- Data Analytics – Analytics Model Design: Advanced (6–9 years)
- Facilitation of Requirements Gathering: Advanced (6–9 years)
Preferred Technical Skills
- Databricks
- Data Architecture and Enterprise Data Modeling
- Data Warehousing
- Source-to-Target Data Mapping
- Oracle Exadata
- SQL and Oracle SQL
- Informatica PowerCenter
- Analytics Model Design
- Data Migration and Transformation
- Data Integration
- Business and Technical Requirements Analysis
- Stakeholder Management
Ideal Candidate Profile
The ideal candidate will be a seasoned Data Architect, Data Warehouse Architect, or Data Transformation Consultant with extensive experience in enterprise data modernization and data mapping initiatives.
Candidates should be capable of analyzing existing data products, gathering business requirements, mapping source data to target systems, and guiding engineering teams in building analytics-ready data structures.
Strong Databricks proficiency, expert-level data mapping capabilities, advanced SQL knowledge, and the ability to facilitate discussions across business and technical teams are essential for success in this role.
Key Differentiator
Candidates must have strong enterprise data architecture and Source-to-Target Mapping experience, combined with Databricks proficiency, Oracle SQL knowledge, and the ability to bridge business requirements with technical data engineering delivery.
Skills
- Oracle Database
- Databricks
- SQL
- Informatica
More jobs at Artech
All 60- Application Developer - SeniorArtech · Plano, TX · USD 70–75/hrtoday
- VMWare and VCF Implementation ExpertArtech · Remote, NYtoday
- Azure Data EngineerArtech · Newark, NJ · USD 50–55/hrtoday
- L3 Network EngineerArtech · Dallas, TXtoday
- US Application Database Administrator - Nosql Cloud DatabasesArtech · New York, NYtoday
Similar roles
- Data Scientist Technical SpecialistArcfield · Chantilly, Virginia, United StatesUpdated today
- Azure Data EngineerArtech · Newark, NJ · USD 50–55/hrtoday
- Azure Data EngineerArtech · Newark, NJ · USD 50–55/hrtoday
- Business Intelligence AnalystZobility · Raymond, OHtoday
- Senior Data Scientist, Systems PerformanceMotional · Boston, Massachusetts, United States · Las Vegas, Nevada, United States · Pittsburgh, Pennsylvania, United States +1 · USD 149,000–198,500/yrtoday
- Director of Data ScienceMotional · Boston, Massachusetts, United States · Las Vegas, Nevada, United States · Pittsburgh, Pennsylvania, United States +1 · USD 288,000–396,000/yrtoday