Data Architect

Overview

Remote
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 8 Month(s)

Skills

data architecture artifacts/ data dictionaries/ pipeline topologies/ ERD diagrams
Strong data modeling
Data Warehousing/ OLAP/ ETL environment
Modeling tools: DB Schema/ SqlDBM/ ER/Studio/ Erwin
Data quality/ data profiling/ data cleansing/ data mapping/ data integration/ data marts
Dimension Data Modeling/ Relational Data Modeling (3NF)
Snowflake Architecture/ Snowflake DB/
ER/Dimensional Data Modeling Database Design and RDBMS specific features
BI Reporting tool: PowerBI
BI/DW solution (ETL/ OLAP/ Data mart)/ Informatica

Job Details

DirectClient: Railroad Commission of Texas(RRC)
Solicitation Number: 455-26-27688
Title: Data Architect
Location: 1701 Congress Ave, Austin, TX 78711
Duration: Until 8/31/2026 with possible extension
Last date for submission: November 21, 2025 (12.00 PM-CST)

Important Note: Position will be remote. Texas local candidates only.

Job Description
The Worker will perform advanced (senior-level) Data Modeling (Build Facts & Dimensions Tables) work related to implementing complex, emerging technology hardware and software projects for the Railroad Commission of Texas (RRC) 's mainframe transformation program.
The position would perform data modeling that includes data analysis and data architecture work along with designing and developing/enhancing database systems for software projects included in the Mainframe Transformation Program at the Railroad Commission of Texas (RRC). The focus of the work is to elicit requirements and analyze existing data and systems for the purpose of creating or enhancing existing database solutions to transform legacy systems data to modern normalized database solutions. The position requires knowledge and background in MS SQL Server, Oracle, Snowflake, and Mainframe IMS Hierarchical databases, significant experience in development of data modeling documentation, as well as awareness of the full environment technical stack of Microsoft SSIS, Informatica, MuleSoft, COBOL, Java, Snowflake, Salesforce, .NET, Oracle, Snowflake and GoAnywhere.

CANDIDATE SKILLS AND QUALIFICATIONS
Minimum Requirements:
Years Required /Preferred Experience
5+ Required Create data architecture artifacts such as data dictionaries, pipeline topologies, ERD diagrams, and other documents needed to define data pipelines.
5+ Required Document data architecture, processes, and workflows.
5+ Required Collaborate with stakeholders to understand data requirements and translate them into technical solutions
5+ Required Strong analytical and problem-solving skills, experience as [Data Architect/Modeler] and [Data Analyst] with high proficiency in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP, and ETL environment
5+ Required Experience in designing Architecture for Modeling a data warehouse by using tools like DB Schema, SqlDBM, ER/Studio
5+ Required Data Warehousing: Full Cycle Project Leadership, business-driven requirements, capacity planning, gathering, feasibility analysis, enterprise and solution architecture, design, construction, data quality, profiling and cleansing, source-target mapping, gap analysis, data integration/ETL, SOA, data marts, Data modeling for OLTP, Dimension Data Modeling for data warehouse star/snowflake design, Facts & Dimension Tables.
3+ Required Experience in Relational Data Modeling (3NF); Work on background processes of Snowflake DB, Snowflake Architecture, drill down to the lowest levels of system design and construction
3+ Required Experience in Dimensional Data Modeling: Practical understanding of Data Modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Facts & Dimension tables
3+ Required System Analysis experience in F&D Analytics, ER/Dimensional Data Modeling Database Design and RDBMS specific features
3+ Required Experience in BI/DW solution (ETL, OLAP, Data mart), Informatica, BI Reporting tool like PowerBI and experience in leading the team of application, ETL, BI developers, Testing Team
3+ Required Create and optimize data pipelines for business intelligence and analytics purposes
Preferred Extensive experience on usage of ETL & Reporting tools like PowerBI
Preferred Collaborate with DBA to improve ETL processes and workflows
Preferred Participate in code reviews and contribute to best practices for data engineering
Preferred Experience with version control systems (Git) and CI/CD practices
Preferred Experience in the Oil and Gas industry as well as general compliance and enforcement-related projects as a Data Modeler.
Preferred Knowledge of data governance and compliance requirements in Oil & Gas
Preferred Proven ability to work compatibly within multifaceted teams.
resolve conflict and deal with challenging situations.
Preferred Excellent communication abilities and team collaboration; Strong analytical and problem-solving skills
Preferred Bachelor s degree in computer science, Business
Administration or related discipline or equivalent work
experience.
Preferred Snowflake Snowpro or Certified Professional Data Modeler or Data Management & Analytics Microsoft Certified Solutions or similar certification

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.