Data Architect

Role Overview: As an individual with experience in Azure Synapse Analytics, Azure Data Lake Storage, AI Tools, Avro, and Parquet, and healthcare data management, you will play a crucial role in designing, developing, and maintaining data pipelines for ingestion, transformation, and loading of data into Azure Synapse Analytics. Your expertise will be instrumental in ensuring compliance with data governance policies, implementing security measures, and optimizing the performance of data pipelines within Azure Synapse Analytics. Key Responsibilities: - Design, develop, and maintain data pipelines for ingestion, transformation, and loading of data into Azure Synapse Analytics. - Work with Azure Synapse Analytics to build and optimize data models, SQL queries, stored procedures, and other artifacts necessary for data processing and analysis. - Understand various file formats, optimize data storage, and implement efficient data reading and writing mechanisms for incremental updates within Azure Synapse Analytics. - Ensure compliance with data governance policies and implement security measures to protect sensitive data stored in Azure. - Continuously optimize data pipelines and storage configurations to improve performance, scalability, and reliability. - Implement monitoring solutions to track data pipeline performance, data quality, and system health. Troubleshoot issues related to data ingestion, transformation, or storage, and provide timely resolutions. Qualifications Required: - Hands-on experience with Azure Synapse Analytics, Azure Data Lake Storage, AI Tools, Avro, and Parquet. - Experience working with data in a healthcare or clinical laboratory environment with a strong understanding of PHI, GDPR & HIPAA/HITRUST. - Relevant certifications such as Azure Data Engineer Associate or Azure Synapse Analytics Developer Associate are highly desirable. - Proficiency in relational databases like Oracle, Microsoft SQL Server, PostgreSQL, MySQL/MariaDB. - Strong SQL skills, including experience with complex SQL queries, stored procedures, and performance optimization techniques. - Proven experience in building ELT pipelines and data integration solutions using tools like Azure Data Factory, Oracle Golden Gate, or similar platforms. - Familiarity with dimensional modeling, star schemas, and data warehousing principles. - Strong analytical skills with the ability to understand complex data requirements, troubleshoot technical issues, and propose effective solutions. - Excellent communication skills and the ability to collaborate effectively with cross-functional teams.,