"Alerted.org

Duration: 6+ months Contract

Job Description:

Key Focus Areas:

+ 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 transformation business requirements into optimal data model. 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

Education:

+ Bachelor’s Degree or above.

About US Tech Solutions:

US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com (http://www.ustechsolutionsinc.com/) .

US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.