Data Architect

Overview

Hybrid
$60 - $65
Contract - W2
Contract - 12 Month(s)

Skills

Data Architect
Data Architecture
Data Modeling
JSON
GraphQL
Data Integration
Data Mapping
PowerDesigner
Erwin
SQL

Job Details

Data Modeling and Architecture:

Design and develop conceptual, logical, and physical data models for relational and non-relational databases.

Create and maintain JSON schemas for real-time event processing and API design.

Define and design GraphQL schemas to support modern API-driven architectures.

Ensure data models align with business requirements and technical constraints.

Business Engagement:

Collaborate with business stakeholders to understand requirements and translate them into data models.

Drive critical discussions with business teams to ensure data models meet current and future needs.

Provide a holistic view of data architecture and its impact on business processes.

Data Integration and Mapping:

Perform complex data mapping analysis across multiple data sources and publishing methods (e.g., real-time vs. batch).

Define data integration strategies and ensure seamless data flow between systems.

Tool Proficiency:

Use data modeling tools such as PowerDesigner, Erwin, or like create and manage data models.

Document and maintain metadata for all data models and schemas.

Cloud and Modern Architecture:

Leverage knowledge of AWS, Azure, or Google Cloud Platform cloud platforms to design scalable and efficient data architectures. Preferred Azure Cloud Synapse/Databricks experience .

Apply Medallion Architecture principles for data lake and data warehouse design.

SQL and Programming:

Write and optimize SQL queries for data analysis and validation.

Use PL/SQL for legacy system analysis and migration efforts (preferred).

Real-Time and Batch Processing:

Design data pipelines for both real-time and batch data processing.

Ensure data models support diverse publishing methods and meet performance requirements.

Industry Expertise:

Apply knowledge of the Payment Processing industry to design domain-specific data models.

Ensure compliance with industry standards and best practices.

Required Skills and Qualifications

Degree/Experience

Bachelor s or master s degree in computer science, Information Systems, or a related field or equivalent years of experience.

Data Modeling Expertise:

Strong experience in conceptual, logical, and physical data modeling.

Preferred - knowledge in designing schemas for relational databases and non-relational data structures (e.g., JSON, GraphQL).

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.