Description

Design, develop, and optimize data warehouse and reporting solutions to support analytics operations.

Responsibilities

• Design and implement ETL processes to extract, transform, and load data from various sources into the data warehouse.
• Create and maintain data models, schemas, and structures for efficient storage and retrieval.
• Build and manage scalable data lake solutions for storing raw and processed data.
• Administer and optimize PostgreSQL and MySQL databases to ensure performance and data integrity.
• Automate data processing tasks and quality checks using Python scripting.

Required Skills

• 5-7 years of experience as a Data Warehouse Engineer, ETL Developer, or in a similar role.
• Proficiency in PostgreSQL and MySQL.
• Expertise in designing and optimizing data warehouse solutions.
• Advanced Python programming skills for data manipulation and automation.
• Hands-on experience with ETL tools and processes.
• Experience with data lake architecture and management.
• Familiarity with reporting and analytics tools such as Tableau or Power BI.
• Experience with AWS, Azure, or GCP.

Preferred Skills

• Knowledge of data governance, security, and compliance best practices.
• Familiarity with data streaming technologies like Kafka or Spark Streaming.
• Relevant certifications such as AWS Certified Data Analytics or Google Cloud Professional Data Engineer.

Key Skills

Education

ANY GRADUATE