Data Architect- ETRM, AWS

Overview

Hybrid
$100 - $101
Contract - Independent
Contract - W2
Contract - 24 Month(s)

Skills

API
Amazon DynamoDB
Amazon Kinesis
Amazon RDS
Amazon S3
Amazon Web Services
Analytics
Cloud Computing
Computer Engineering
Computer Science
Data Analysis
Data Architecture
Data Extraction
Data Governance
Data Management
Data Modeling
Data Quality
Data Stewardship
Data Warehouse
Database
ER/Studio
ERwin
ETRM
Financial Reporting
Geographic Information System
Geospatial Analysis
IT Management
Informatica
Information Technology
Meta-data Management
Oracle
PostgreSQL
Python
Remote Desktop Services
Reporting
Risk Management
SQL
SQL Azure
Scripting
Shell Scripting
Snow Flake Schema
Specification Gathering
Writing

Job Details

We are seeking an experienced Data Architect. 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.

Hybrid: 4 days in the office, Mon, Tues, Wed, Thursday - Friday work from home

Data Architect- ETRM, AWS

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, 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.
  • 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

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.