Sr. Data Architect

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

Data Architect
OLTP
OLAP
ETL
API

Job Details

Hi,

Job Title:- Sr. Data Architect

Location:- Dallas, TX - HYBRID

Duration:-12 months+

Intake NOTES: NO CLOUD PEOPLE

Key Skills & Requirements:

  • Recent Oracle experience (preferably Oracle Exadata) is a must; candidate should have used Oracle within the last 2 years.
  • Strong data modeling and design experience (OLTP & OLAP).
  • Ability to communicate clearly about their own contributions, not just team efforts.
  • Hands-on experience with SQL Server is also valued.
  • Should be able to work directly with functional users to gather requirements and explain architectural decisions.

Not a Fit:

  • Candidates focused heavily on cloud technologies (AWS, Google Cloud Platform, etc.).
  • Profiles that are more data engineer or enterprise architect oriented.
  • Candidates who only talk theory and can't explain how they applied it in projects.
  • DBAs who are strictly physical (indexing, storage, etc.) with no architectural mindset.

Interview Focus:

  • Candidates must explain recent, real-world solutions they ve implemented.
  • Must be able to articulate why they made certain architecture decisions and what the impact was.

Other Details:

  • In-person interviews required (DFW-based preferred; relocation okay at candidate s expense).
  • ETL tools used: Informatica, Ab Initio, Tibco ESB, Goldengate.
  • Team is 95% on-premise, with no current cloud migration plans.
  • Role supports multiple simultaneous projects both small and enterprise requiring modeling, design review, and user interaction.
  • Data Governance and MDM are early-stage; experience here is a plus, not required.

ABOUT THE ROLE:

Primary responsibilities of the Senior Data Architect include designing and managing Data Architectural solutions for multiple environments including but not limited to Data Warehouse, ODS, Data Replication/ETL Data Management initiatives. The candidate will be in an expert role and will work closely with Business, DBA, ETL and Data Management teams providing solutions for complex Data related initiatives. This individual will also be responsible for developing and managing Data Governance and Master Data Management solutions. This candidate must have good technical and communication skills coupled with the ability to mentor effectively.

Responsibilities

  • Establishing policies, procedures and guidelines regarding all aspects of Data Governance
  • Ensure data decisions are consistent and best practices are adhered to
  • Ensure Data Standardization definitions, Data Dictionary and Data Lineage are kept up to date and accessible
  • Work with ETL, Replication and DBA teams to determine best practices as it relates to data transformations, data movement and derivations
  • Work with support teams to ensure consistent and pro-active support methodologies are in place for all aspects of data movements and data transformations
  • Work with and mentor Data Architects and Data Analysts to ensure best practices are adhered to for database design and data management
  • Assist in overall Architectural solutions including, but not limited to Data Warehouse, ODS, Data Replication/ETL Data Management initiatives
  • Work with the business teams and Enterprise Architecture team to ensure best architectural solutions from a Data perspective
  • Create a strategic roadmap for MDM implementation
  • Responsible for implementing a Master Data Management tool
  • Establishing policies, procedures and guidelines regarding all aspects of Master Data Management
  • Ensure Architectural rules and design of the MDM process are documented and best practices are adhered to

Qualifications

  • 5+ years of Data Architecture experience, including OLTP, Data Warehouse, Big Data
  • 5+ years of Solution Architecture experience
  • 5+ years of MDM experience
  • 5+ years of Data Governance experience, working knowledge of best practices
  • Extensive working knowledge of all aspects of Data Movement and Processing, including Middleware, ETL, API, OLAP and best practices for data tracking
  • Good Communication skills
  • Self-Motivated
  • Capable of presenting to all levels of audiences
  • Works well in a team environment

Zafar Khan

Technical Recruiter

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.