About Devu Solutions

 We are looking for a Senior Cloud Data Architect to be responsible for leading a team of engineers and consultants to deliver technical solutions from architecture through deployment.

Your Role And Responsibilities

• Perform overall architecture design, performance tuning/cost management, and implementation of Big Data analytical solutions with GCP native cloud data tools (e.g. BigQuery, Cloud Table, Cloud Spanner, etc.)
• Provide thought leadership and assistance to clients with defining their data architecture and analytic strategies on GCP.
• Implement end-to-end data analytics solutions (from data ingestion through visualization) for large-scale, complex client environments. 
• Lead a team of data engineers in designing, developing, testing, and deploying high-performance data analytics solutions. 
• Communicate complex technical topics to non-technical business and senior executives and assist with scoping, architecting, and selling cloud data solutions. 

Your Expertise

• 7+ Data Warehouse architect and delivery experience
• 2+ years cloud data architect experience with GCP native data tools (e.g. BigQuery)
• 5+ years delivering successful Data Analytics projects
• Ability to translate business challenges into Data Analytics solutions
• 5+ years ETL/ELT/Python programming skills including experience with pipeline orchestration tools, logging, monitoring & alerting, deep troubleshooting, and automated testing & deployments (CI/CD)
• Certification in relevant GCP areas, such as GCP Professional Data Engineer or Google Professional Cloud Architect
• Demonstrated ability to effectively and accurately estimate data analytics project work effort.

Responsibilities:

• Collaborate with data architects and other stakeholders to design scalable and optimized data warehouse solutions on the Azure platform.
• Develop and maintain data warehouse architectural documentation, including schema designs, data flow diagrams, and integration patterns.
• Move SSIS / ETL Processes and execute SSIS within Azure Data Factory.
• Design the NextGen Data Warehouse using Azure.
• Expertise in using Master Data Management strategies, and designing Data Warehouse structure and schema with Azure Data Services.
• Execute SSIS packages in Azure from SSDT to assess the cloud compatibility of SSIS packages and run them on Azure-SSIS IR within ADF.
• Fix any issues found in IR testing and can migrate all SSIS packages to run in Azure.
• Re-write all SSIS packages into ADF and expand analytics using Azure Synapse and Power BI
• Investigate the use of Azure Fabric for end-to-end data processes from Data Science to Analytics
• Write efficient T-SQL queries for data transformation, extraction, loading, and reporting purposes.
• Implement data partitioning, indexing, and distribution strategies to enhance query performance.
• Integrate data from various sources, both on-premises and in the cloud, into the Azure Data Warehouse using appropriate ETL/ELT techniques.
• Work with data integration tools such as Azure Data Factory or SSIS to automate data pipelines.
• Monitor and analyze query performance and data warehouse health, identifying and resolving bottlenecks and performance issues.
• Optimize query execution plans, indexing strategies, and data distribution to achieve optimal performance.
• Implement security measures to protect sensitive data within the Azure Data Warehouse, following best practices for data encryption, access controls, and data masking.
• Ensure compliance with relevant data privacy and security regulations, such as GDPR or HIPAA.
• Provide training and guidance to junior team members on data warehouse best practices and technologies.

Qualifications:

• Bachelor's or higher degree in Computer Science, Information Technology, or a related field.
• Proven experience in designing, implementing, and optimizing data warehousing solutions using Azure services (Azure Synapse Analytics, Azure Data Factory, Azure SQL Data Warehouse).
• Plan the ETL process for the data warehouse design.
• Choose appropriate Azure data services (Synapse, ADF)
• Create data warehouse operations runbook