Job Description:
We are looking for a talented Azure Data Warehouse Developer to design, develop, and maintain our Azure-based data warehouse solutions. The ideal candidate will have strong experience in Azure services and tools related to data warehousing, such as Azure Synapse Analytics, Azure SQL Data Warehouse, and Azure Data Factory. You will collaborate closely with data engineers, architects, and business stakeholders to ensure the successful delivery of scalable and efficient data warehouse solutions that meet business needs.
Essential Duties and Responsibilities:
– Design, develop, and implement end-to-end data warehouse solutions on the Azure platform using
Azure Synapse Analytics, Azure SQL Data Warehouse, and Azure Data Factory.
– Develop ETL/ELT processes to integrate data from various source systems into the Azure data
warehouse.
– Perform data modeling and schema design to support analytics and reporting requirements.
– Optimize data warehouse performance and ensure data integrity and reliability.
– Collaborate with data engineers and architects to understand data requirements and translate them
into technical specifications.
– Implement data warehouse best practices, including partitioning, indexing, and compression
techniques to enhance query performance and minimize storage costs.
– Ensure data consistency and accuracy through data validation and quality assurance processes.
– Implement security controls and access permissions to safeguard sensitive data within the data
warehouse environment.
– Develop and maintain documentation related to data warehouse architecture, processes, and data
lineage.
– Monitor and troubleshoot data warehouse issues and provide timely resolutions.
– Ensure compliance with data security and privacy policies and regulations throughout all data
warehouse processes.
– Stay current with Azure data warehousing technologies and industry trends to continuously improve
data warehouse solutions.
– Highly proficient with Data Bricks, Python (Spark), and SQL.
Education and/or Work Experience Requirements: –
- Bachelor’s degree in computer science, Software Engineering, Information Systems, or a related field preferred.
- Highly proficient with Data Bricks, Python (Spark), and SQL. – Azure certifications related to data engineering or data analytics is a plus
- Strong experience in database design, data modeling, and data integration.
- Familiarity with additional programming languages and frameworks such as C#, .Net and Visual Studio is a plus.
- Experience with reporting and BI tools such as Power BI, SQL Server Reporting Services, and Crystal reports.
- Understanding of Web APIs including SOAP and REST.
- Proficient with development methodologies such as Agile.
