Azure Data Warehouse Specalist

at  Luxoft

PROJECT DESCRIPTION

Azure Data Warehouse Specialist will work closely with the Development Team to design, build interfaces and integrate data from a variety from internal and external data sources into the new Enterprise Data Warehouse on Azure.
This includes architectural design and guidance, translating product requirements into hardware requirements like performance and quality, building a working knowledge of the Azure infrastructure to analyze design option impacts and leading data-based decision making to reduce design options to viable recommendations.

SKILLS

Must have
5+ years of experience in data warehousing, with at least 3 years on Azure.
Proven experience with Azure SQL Data Warehouse (Synapse Analytics), Azure Data Lake, Azure Databricks, and Azure Data Factory.
Experience with Azure Service Fabric in Banking environment
Other skills:
Strong SQL and database management skills.
Proficiency in ETL tools and processes.
Knowledge of data modeling, data architecture, and data governance.
Excellent problem-solving and analytical skills.
Strong communication and collaboration skills.
Education:
Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field. Master’s degree preferred
Nice to have
Microsoft Certified: Azure Data Engineer Associate or Azure Solutions Architect.
Experience with data visualization tools like Power BI.
Knowledge of machine learning and advanced analytics.

You will be engaged by the bank as an Azure Data Warehouse Specialist to drive the following activities:
Design and Development
Architect, design, and develop scalable enterprise data warehouse solutions on Azure.
Implement data integration and ETL processes using Azure Data Factory.
Optimize data storage solutions using Azure SQL Data Warehouse (Synapse Analytics), Azure Data Lake, and other relevant services.
Implementation and Management
Deploy and manage data warehouse environments using Azure Service Fabric.
Ensure high availability, disaster recovery, and performance tuning of data warehouse solutions.
Monitor and manage data pipelines and workflows to ensure efficient data processing.
Data Integration and ETL
Design and develop ETL processes to integrate data from various on-premises and cloud-based sources.
Transform and clean data to meet the business requirements for reporting and analytics.
Security and Compliance:
Implement data security measures, including encryption, access controls, and compliance with regulatory standards.
Conduct regular security audits and assessments to ensure data protection.
Collaboration and Support
Work closely with data architects, development team and business stakeholders to understand data requirements and deliver actionable insights.
Provide technical support and training to other team members and end-users as needed.
Documentation and Best Practices:
Maintain comprehensive documentation of data warehouse architectures, processes, and workflows.
Stay current with industry best practices and emerging technologies in data warehousing and cloud computing.