senior data architect (1 or 2 day onsite in dallas, TX)

Sr. Data Architect

Hybrid onsite 1-2 days/week in Dallas, TX

12+ months contract (high probability to extend)

Notes from Manager:

Hands on Data Architect role with strong data modeling skills with ERWIN. Must have good recent experience working with Oracle.

• NOT looking for enterprise architect- seeking someone who is hands on
• Someone who is able to do hands on modeling and design for OLTP and OLAP models.
• Strong in SQL and Oracle / PL/SQL
• Some cloud experience is a plus
• Must have hands on modeling NOT someone who is managing people. NOT seeking someone who is doing POCs and bringing in new tools for data or implementing new cloud services.
• Seeking someone who is NOT focused in on cloud only.
• NOT just seeking strategy and high level. Truly a hands-on role.
• Day to Day: Modeling, working with teams to understand requirements for application, how data is stored in the application, and then model tables for them on how it should work given the requirements for the application. Same thing for reporting- gather requirements on what type of reports are going to be needed and ability structure the data for reporting dependent on the type of reporting needed
• Ability to review code and give feedback on enhancements to PL SQL Code- but not hands on writing it
• Only 15-20% strategy, 75-80% hands on
• ERWIN for data modeling required
• Strong communication, good thought process, organized

Project/Day to Day: 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.

Senior Data Architect (SDA)

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