Data Modeller

$75,000 - $120,000/Yr

TATA Consulting Services - Juno Beach, FL

Juno Beach, FL

Professional, Scientific, and Technical Services

About the position

The position involves designing, implementing, and optimizing cloud-based data models that leverage AWS services such as Amazon Redshift, AWS Glue, Amazon RDS, and Amazon S3. The role focuses on supporting data analytics and business intelligence through effective data modeling and architecture. Collaboration with data engineers and cloud architects is essential to ensure proper integration of data sources, storage, and processing within the AWS ecosystem. The candidate will also be responsible for designing and optimizing data warehouses, ensuring they are scalable and cost-efficient while handling complex queries and large datasets.

Responsibilities

• Design, implement, and optimize cloud-based data models using AWS services.
• Collaborate with data engineers and cloud architects for data integration.
• Design and optimize data warehouses using Amazon Redshift.
• Work with the ETL team to design efficient data transformation processes and pipelines.
• Apply data modeling techniques such as normalization and schema design.
• Ensure seamless data integration from multiple sources into AWS platforms.
• Monitor and optimize query performance on AWS platforms.
• Ensure data security and compliance following AWS best practices.

Requirements

• Experience with AWS services like Amazon Redshift, AWS Glue, Amazon RDS, and Amazon S3.
• Strong understanding of data warehousing concepts and ETL processes.
• Proficiency in data modeling techniques including normalization and schema design.
• Experience in performance tuning and optimization of queries in AWS.
• Knowledge of data security and compliance best practices.