Remote Data Architect: ER/Studio + AWS Data Warehouse

RAZOR; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

Razor is seeking a Data Architect to design, develop, and maintain enterprise data architecture across cloud-based databases. You will build robust data models and data warehouse/data lake solutions using ER/Studio Enterprise, while collaborating with cross-functional teams to deliver scalable data solutions.

You will also design ETL architectures, support MDM and data quality initiatives, and work with Databricks, Redshift, Tableau, and AWS services. A U.S.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field (or equivalent).
• 3+ years of hands-on experience with ER/Studio Enterprise Data Modeling and Architecture tools.
• 3+ years of experience with enterprise data modeling, data architecture, and Data Warehouse/Data Lake design.
• 3+ years of experience designing and developing ETL solutions, including MDM and data cleansing.
• 3+ years of experience with AWS Cloud, Oracle Databases, and Amazon RDS.

Responsibilities

• Design and maintain enterprise data architecture supporting cloud-based database environments.
• Develop and maintain logical and physical data models using ER/Studio Enterprise.
• Design, develop, and optimize enterprise Data Warehouse and Data Lake solutions.
• Design data structures supporting structured, semi-structured, and unstructured data.
• Design and develop ETL architecture and data integration solutions.
• Support master data management and data quality initiatives, including data cleansing.
• Architect and support enterprise database environments utilizing AWS, Oracle, and Amazon RDS.
• Collaborate with application developers, database administrators, and business stakeholders to develop scalable data solutions.
• Support data analytics initiatives and enterprise reporting platforms.
• Participate in Agile software development activities and collaborate across cross-functional technical teams.
• Research, evaluate, and document recommendations for enterprise data architecture improvements.

Skills

Data modelling

Data architecture

ETL development

SDLC knowledge

Education

Bachelor's degree in CS/IS/Engineering

Tools

ER/Studio Enterprise

Databricks

AWS

Oracle

Amazon RDS

Tableau

Job description

Razor is seeking a Data Architect to design, develop, and maintain enterprise data architecture across cloud-based databases. You will build robust data models and data warehouse/data lake solutions using ER/Studio Enterprise, while collaborating with cross-functional teams to deliver scalable data solutions.

You will also design ETL architectures, support MDM and data quality initiatives, and work with Databricks, Redshift, Tableau, and AWS services. A U.S.