BCforward
Data Architect
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Architect on a contract basis, focusing on data modeling and pipeline transformation in AWS Redshift. Requires expertise in dimensional modeling and experience with AWS Glue. Preferred certifications include AWS Certified Solutions Architect and AWS Certified Data Engineer.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
680
-
🗓️ - Date
November 18, 2025
🕒 - Duration
Unknown
-
🏝️ - Location
Unknown
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
New Jersey, United States
-
🧠 - Skills detailed
#Data Architecture #Snowflake #Data Pipeline #"ETL (Extract #Transform #Load)" #Data Engineering #Data Lineage #AWS Glue #AWS (Amazon Web Services) #Scala #Redshift #Physical Data Model
Role description
• Work with business SMEs to understand analytical and reporting requirements
• Translate business and reporting needs into conceptual, logical, and physical data models
• Define data standards, relationships, and data pipeline transformation requirements for data engineering implementation
• Design and implement and Redshift data models, including tables, views/materialized view to ensure optimal performance and scalability
Essential Technical Skills
• Experience in transforming business requirements into optimal data models. Ideally experience working with customer analytics.
• Expertise in dimensional modeling (Star and Snowflake schemas)
• Design and document conceptual, logical, and physical models for analytical use cases in AWS Redshift
• Experience with AWS Redshift and performance optimization
• Knowledge of AWS Glue, Redshift, Step Functions for data architecture
• Familiar with AWS Data Zone for data lineage and governance
Preferred Certifications
• AWS Certified Solutions Architect – Professional (or Associate)
• AWS Certified Data Engineer – Associate
• Work with business SMEs to understand analytical and reporting requirements
• Translate business and reporting needs into conceptual, logical, and physical data models
• Define data standards, relationships, and data pipeline transformation requirements for data engineering implementation
• Design and implement and Redshift data models, including tables, views/materialized view to ensure optimal performance and scalability
Essential Technical Skills
• Experience in transforming business requirements into optimal data models. Ideally experience working with customer analytics.
• Expertise in dimensional modeling (Star and Snowflake schemas)
• Design and document conceptual, logical, and physical models for analytical use cases in AWS Redshift
• Experience with AWS Redshift and performance optimization
• Knowledge of AWS Glue, Redshift, Step Functions for data architecture
• Familiar with AWS Data Zone for data lineage and governance
Preferred Certifications
• AWS Certified Solutions Architect – Professional (or Associate)
• AWS Certified Data Engineer – Associate
