Logo
New York Technology Partners

Data Modeler / Data Architect

New York Technology Partners, Newark, New Jersey, us, 07175

Save Job

Direct message the job poster from New York Technology Partners

US IT Recruiter specializing in IT Recruitment and Staffing Services Data Modeler / Data Architect (Redshift & Dimensional Modelling) We are seeking a seasoned Data Modeler / Data Architect responsible for translating complex business and reporting needs, particularly related to customer analytics, into robust conceptual, logical, and physical data models. A primary focus of the role is the design and implementation of highly optimized data models in AWS Redshift, utilizing expertise in dimensional modeling (Star and Snowflake schemas). The successful candidate will define data standards and transformation requirements for data engineering teams and possess strong knowledge of the AWS data architecture ecosystem (Redshift, Glue, Step Functions, and DataZone).

Key Focus Areas & Required Technical Skills

Data Modelling Expertise: Expertise in dimensional modelling (Star and Snowflake schemas) is mandatory.

Design & Documentation: Proficiently design and document conceptual, logical, and physical models for analytical use cases, specifically focusing on AWS Redshift.

Translation & Requirements: Experience working with business SMEs to understand analytical and reporting requirements and defining data standards and data pipeline transformation requirements.

AWS Redshift Specialization: Experience with AWS Redshift and demonstrated ability to implement models (tables, views/materialized view) and perform performance optimization.

Data Architecture Knowledge: Familiarity with the AWS data ecosystem, including AWS Glue, Redshift, and Step Functions.

Governance: Knowledge of AWS Datazone for managing data lineage and governance.

Domain (Ideal): Ideally, experience working with customer analytics.

Preferred Certifications

AWS Certified Solutions Architect – Professional (or Associate)

AWS Certified Data Engineer – Associate

Seniority level Mid-Senior level

Employment type Contract

Job function Information Technology

Industries Staffing and Recruiting, IT Services and IT Consulting, and Utilities

Referrals increase your chances of interviewing at New York Technology Partners by 2x

Get notified about new Data Modeler jobs in Newark, NJ.

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr