Data Architect

Title: Data Architect
Location: Houston TX - Hybrid 4 days a week in office
Contract: 6 Months and Possibility of Extension

Must Have:
Data Architecture, AWS, Snowflake, DBT, Python, SQL, ETL/ELT, Data Engineering
Data Modeling
Energy Trading and Risk Management (ETRM)
ETRM Data Modeling & Data Architecture

JOB DESCRIPTION

Job Description
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 GCP 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.
Preferred Skills & Qualifications
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, Client 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.
Bachelor's degree, preferably in Computer Science, Information Technology, Computer Engineering, or related IT discipline, or equivalent experience.
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

Other Skills and Abilities:
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.