Very Urgent | Sr. Data/Modeler Architect Contract Jobs | Dallas TX

Job Title :: Sr. Data Architect

Location :: 1616 Woodall Rodgers Fwy Dallas, TX, – hybrid onsite 1-2 days/week – (usually Friday)

Duration :: 12 Months 

Experience :: 12+ Years

Client :: Oncor

Note:: Need DL/Visa and LinkedIn and must be local – final round will be onsite

TOP SKILLS:

Data Modeling (hands-on), ERWIN tool
OLAP OLTP Data
Must have great communication. Must be able to articulate the little details of their project.

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.  

Hours: M-F 8am – 5pm

Remote:  hybrid onsite 1-2 days/week – (usually Friday)

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
 

Extra notes from the manager

Data Architect Role:

Do modeling, design, OLTP
Understand PL Sql but don’t expect them to write it. Review code and understand what it does and give suggestions on how to enhance code but don’t expect them to write it.
Strategy should not be 90% of their current job, look for 15%-20% strategy, the rest hands on.
Use Erwin for Data Modeling
Flex on Solution Architecture experience
Good communication –  is sharp, communicates well, is pretty organized. Looking for someone with those skills.
Need to have SQL and Oracle experience. Some SQL server would be preferred – have a few SQL Server forms. Need to be able to jump from Oracle to SQL Server and back.
If they are just bringing in new tools and doing cloud stuff, not what we need right now, one day will get there.
Key item: if reporting to Execs, that’s an Enterprise Architect. These candidates won’t want to do day to day, they want to do high level strategy.
Day to day: working with functional users with their requirements for data. Will walk through their needs for data. Reporting, asking what kinds of reporting, effect on the business, how often do you need the reports? How we structure the data for reporting is different based on these things.