Description

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

Design and implement ETL processes to extract, transform, and load data from various sources into the data warehouse. Build and maintain 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. Create and maintain data models, schemas, and structures for efficient storage and retrieval.

Responsibilities

• Design and implement ETL processes to move data from sources to the warehouse.
• Build and manage scalable data lake solutions for raw and processed data storage.
• Administer and optimize PostgreSQL and MySQL databases for performance and integrity.
• Automate data processing tasks and quality checks using Python.
• Create and maintain data models and schemas for efficient retrieval.

Required Skills

• 5-7 years of experience as a Data Warehouse Engineer or ETL Developer.
• Proficiency in PostgreSQL and MySQL database administration.
• Advanced Python programming skills for data manipulation and automation.
• Hands-on experience with ETL tools and processes.
• Experience with data lake architecture and management.
• Experience with cloud platforms: AWS, Azure, or GCP.
• Familiarity with reporting and analytics tools like Tableau or Power BI.

Preferred Skills

• Knowledge of data governance, security, and compliance best practices.
• Familiarity with data streaming technologies like Kafka or Spark Streaming.

Key Skills

Education

ANY GRADUATE