Job
Description
Design, Develop, and Maintain Redshift Data Warehouses: Architect, build, and optimize Redshift clusters for high performance and scalability. Design and implement data models, schemas, and ETL/ELT pipelines. Develop and maintain complex SQL queries and stored procedures. Ensure data quality and integrity within the Redshift environment. Data Loading and Transformation: Develop and implement efficient data loading strategies from various sources (e.g., databases, files, APIs). Design and implement data transformation and cleansing processes. Optimize data loading performance and minimize data latency. Performance Tuning and Optimization: Monitor and analyze Redshift cluster performance. Identify and troubleshoot performance bottlenecks. Implement performance tuning strategies, such as indexing, partitioning, and query optimization. AWS Integration: Leverage other AWS services, such as S3, Glue, EMR, and Lambda, to enhance data warehousing solutions. Integrate Redshift with other cloud-based applications and services. Security and Compliance: Implement and maintain data security measures, including access control, encryption, and data masking. Ensure compliance with relevant data privacy regulations (e.g., GDPR, CCPA). and Communication: Collaborate with data analysts, data scientists, and business stakeholders to understand their data needs. Communicate technical information effectively to both technical and non-technical audiences. Required Skills Strong proficiency in SQL Experience with AWS Redshift Knowledge of data warehousing concepts and best practices Experience with ETL/ELT processes Experience with data modeling and schema design Understanding of cloud computing concepts and AWS ecosystem Experience with scripting languages (e.g., Python, Shell) Strong analytical and problem-solving skills Desired Skills Experience with AWS services like S3, Glue, EMR, Lambda Experience with data visualization tools (e.g., Tableau, Power BI) Experience with data quality and validation tools Experience with Agile development methodologies AWS certifications (e.g., AWS Certified Data Analytics - Specialty)
