Job Summary (List Format):
- Design develop and maintain data pipelines using Azure Data Factory.
- Create and manage efficient data models in PostgreSQL.
- Optimize PostgreSQL database and query performance through indexing tuning and monitoring.
- Perform data modeling and mapping from various data sources.
- Develop and maintain logging mechanisms in Azure Data Factory for pipeline monitoring and troubleshooting.
- Utilize strong knowledge of Azure Key Vault Azure Data Lake and PostgreSQL.
- Handle file operations in Azure Data Factory including reading writing and transforming data from diverse file formats.
- Write and optimize complex SQL queries for various data scenarios.
- Demonstrate excellent problem-solving skills to address complex data challenges.
- Collaborate with business stakeholders data architects and product owners to gather and fulfill data requirements.
- Ensure data quality and integrity via validation and quality checks.
- (Preferred) Experience with Power BI including creating and configuring semantic models and reports.