Summary: Seeking a Data Architect with expertise in AWS Redshift for designing data models and optimizing performance.

Bachelor's degree in related field with 8+ years of experience as a data engineer

Expertise in dimensional modeling (Star and Snowflake schemas)

Experience with AWS Redshift and performance optimization

Knowledge of AWS Glue, Redshift, Step Functions for data architecture

Familiarity with AWS DataZone for data lineage and governance

Utilities experience

AWS Certified Solutions Architect - Professional (or Associate)

AWS Certified Data Engineer - Associate

Responsibilities:

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 Redshift data models, including tables, views/materialized view to ensure optimal performance and scalability

Pay Details: $57.00 to $67.00 per hour

Benefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, EAP program, commuter benefits and a 401K plan. Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs. In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable.

Equal Opportunity Employer/Veterans/Disabled

To read our Candidate Privacy Information Statement, which explains how we will use your information, please

The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:
The California Fair Chance ActLos Angeles City Fair Chance OrdinanceLos Angeles County Fair Chance Ordinance for EmployersSan Francisco Fair Chance Ordinance

Massachusetts Candidates Only: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.