Senior Data Architect (SDA)

Genesis10•Dallas, TX

4h•Hybrid

About The Position

Genesis10 is seeking a Data Architect for our client in the utilities industry. This long term contract position is located in Dallas, TX 77202. Hybrid schedule 3 days onsite. W2 Hourly Pay rate range: ( $85-115/hr Depending on experience ) Description: This role is not an Enterprise level, but rather a hands on Data Architect. 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.

Requirements

5+ years of Oracle Database with knowledge of SQL Server (90% on-prem)
Oracle Exadata experience
5+ years of Solution Architecture experience
5+ years of MDM experience
5+ years of Data Modeling
5+ years of Data Governance experience, working knowledge of best practices (25% of the job)
Extensive working knowledge of all aspects of Data Movement and Processing, including Middleware, ETL, API, OLTP, OLAP and best practices for data tracking
Excellent Communication skills
Self-Motivated
Capable of presenting to all levels of audiences
Works well in a team environment

Nice To Haves

Oracle GoldenGate

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.