Data Architect

Date Posted: 06/03/2025

Hiring Organization: Rose International

Position Number: 483600

Industry: Utility

Job Title: Data Architect

Job Location: Houston, TX, USA, 77002

Work Model: Hybrid

Work Model Details: Onsite requirements: Mon-Thurs

Employment Type: Temporary

FT/PT: Full-Time

Estimated Duration (In months): 7

Min Hourly Rate($): 90.00

Max Hourly Rate($): 110.00

Must Have Skills/Attributes: AWS, Azure, Data Analytics, Data Architecture, Data Modeling, Data Warehouse, ERWIN, ETL, Informatica, Lambda, Oracle, PostgreSQL, Python, Snowflake, SQL, Verbal Communication

Experience Desired: Extensive data architecture with data analytics, ETRM Data Models & Tools (10+ yrs); AWS Cloud, SQL, Snowflake, DBT, Python, ETL/ELT, Oracle, DynamoDB (10+ yrs)

Required Minimum Education: Bachelor's Degree

Job Description
Education Requirement:
Bachelor's degree, preferably in Computer Science, Information Technology, Computer Engineering, or related IT discipline, or equivalent experience.

Requirements:
10+ years of experience in data architecture with an emphasis on data analytics and reporting, experience any other industry standard ETRM tools and ETRM Data models. Nice to have GIS and Geospatial experience.
6+ years of experience with at least one of the following cloud platforms: Amazon Web Services (AWS).
10+ years of experience in SQL, data transformations, and experience on Database Platform Snowflake, PostgreSQL, Azure SQL Data Warehouse, Oracle, DynamoDB.
10+ years of experience in the design and build of data extraction, transformation, and loading processes by writing custom data pipelines.
6+ years of experience with one or more of the following scripting languages: Python, SQL, Shell Scripting.
6+ years of experience designing and building solutions utilizing various Cloud services such as S3, Kinesis, RDS, Snowflake, Lambda, Glue, API Gateway, Cloud Watch, DBT, etc.
4+ years of experience in data modeling to support descriptive analytics in PBI.
4+ years of experience in data cataloging, empowering business, and digital partners to utilize data cataloging and metadata for self-service.
4+ years of experience in data governance, including data quality, data stewardship.
Experience with data governance tools and frameworks such as Atlan, Informatica, or similar.
Strong understanding of data management principles and best practices.
4+ years of experience in data modeling, including conceptual, logical, and physical data models.
Experience with data modeling tools such as ER/Studio, ERwin, or similar.
Experience in ETRM, and RNG

Additional Requirements:
Must speak English.
Ability to work with business as well as IT stakeholders.
Strong written and oral communication skills with the ability to work with users, peers, and management.
Strong interpersonal skills.
Ability to work independently and as part of a team to successfully execute projects.
Highly motivated, self-starter with problem-solving skills.
Ability to multitask and meet aggressive deadlines efficiently and effectively.
Extraordinary attention to detail and accuracy.

Job Summary:
We are seeking an experienced Data Architect to join our team. This role involves providing technical leadership to evaluate business needs, translate requirements into technical specifications, and develop ETRM Analytics Data Models to derive Risk Management Insights, Financial Reporting Insights, and Operational Insights.

Key Responsibilities:
Lead the team to evaluate business needs and priorities, liaise with key business partners, and address team needs related to data systems and management.
Translate business requirements into technical specifications; establish and define details, definitions, and requirements of applications, components, and enhancements.
Participate in project planning; identify milestones, deliverables, and resource requirements; track activities and task execution.
Generate design, development, test plans, detailed functional specifications documents, user interface design, and process flow charts for execution of programming.
Develop data pipelines/APIs using Python, SQL, potentially Spark, and AWS, Azure, or Google Cloud Platform methods.
Use an analytical, data-driven approach to drive a deep understanding of fast-changing ETRM business.
Build large-scale batch and real-time data pipelines with data processing frameworks.
Move data from on-prem to cloud and manage cloud data conversions.
Develop and implement data governance frameworks, policies, and procedures to ensure data quality, integrity, and security.
Establish and maintain data governance roles and responsibilities across multiple disciplines.
Conduct data quality assessments and implement data quality improvement initiatives.
Ensure compliance with data privacy regulations and standards and manage data privacy impact.
Collaborate with business and IT stakeholders to define data governance metrics and KPIs.
Provide training and support to data stewards and other stakeholders on data governance best practices.
Facilitate data governance meetings and working groups to address data-related issues and drive CI.
Develop and maintain a data catalog to ensure data assets are well-documented and easily accessible.
Implement large-scale data ecosystems including data management, governance, and the integration of structured and unstructured data to generate insights leveraging cloud-based platforms.
Leverage automation, cognitive, and science-based techniques to manage data, predict scenarios, and prescribe actions.
Drive operational efficiency by maintaining data ecosystems, sourcing analytics expertise, and providing As-a-Service offerings for continuous insights and improvements.

• **Only those lawfully authorized to work in the designated country associated with the position will be considered.**

• **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.**

Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.

California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.

Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).