Job Title

Azure SQL Data Architect - Remote

Job Description Summary

As an Azure SQL Data Architect, you’ll play a pivotal role in designing, implementing, and managing data and information solutions within the Azure platform. Your expertise will span both technical skills and architectural principles, ensuring efficient and secure data management.

Job Description

We are seeking an Azure SQL Data Architect, that has significant experience operating effectively in a global organization and managing complex environments. This candidate will also have background in various data platforms. Experience building and continually improving governance processes and tools is a plus.

Key Areas of Responsibility:

1. Develop and Maintain Azure Data Architecture:
   • Design and maintain the data architecture, ensuring compliance with data-related policies and standards.
   • Analyze system integration challenges related to data and propose effective solutions.
   • Create Roadmaps for modernization of legacy data platforms.
   • Design, develop, and maintain SQL databases and ensure high levels of data availability.
   • Write optimized SQL queries for integration with applications and reporting.
   • Develop, implement, and optimize stored procedures and functions using T-SQL.
   • Analyze, design, and create database objects (tables, views, indexes, etc.).
   • Collaborate with software developers, system administrators, and data analysts to meet project requirements.
   • Design and implement ETL processes to transform and load data between different environments and systems.
   • Administer and maintain Azure SQL databases, ensuring data integrity, security, and performance tuning.
   • Manage and monitor database performance and troubleshoot issues.
   • Automate tasks related to database management using Azure DevOps and other automation tools.
   • Work with Azure Data Factory, Azure Synapse, and other data-related services to implement end-to-end data pipelines.
   • Implement data security best practices in Azure, including data encryption, access management, and backup solutions.
2. Design and Implement Data Solutions on Azure:
   • Utilize a range of Azure services, including Azure SQL Database, Data Factory, Data Lake Store, Data Lake Analytics, Stream Analytics, Azure Storage, and Cosmos DB.
   • Collaborate with data scientists and IT team members to address data-related technical issues and support infrastructure needs.
3. Data Security and Privacy Protection:
   • Implement robust security measures to safeguard data.
   • Ensure compliance with privacy regulations.
4. Create Data Tools for Analytics:
   • Build tools to assist data scientists and analysts in optimizing the Azure system.
   • Foster innovation and industry leadership through effective data solutions.
5. Strategize for Data Acquisitions and Recovery:
   • Develop and implement strategies for data acquisition, archive recovery, and database implementation.
6. Collaborate with Data Governance Teams:
   • Ensure data solutions align with regulatory requirements.
   • Work closely with governance teams to maintain compliance.
7. Monitor System Performance and Troubleshoot Issues:
   • Keep track of system performance metrics.
   • Address any issues promptly.
8. Stay Updated on Azure Platform and Best Practices:
   • Continuously learn about Azure services and industry best practices.

Qualifications:

• Minimum 5 to 7 years of experience in data management and technology.
• Proficiency in Azure data services, including Azure SQL, Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, and other related technologies.
• Proficiency in migration from on-prem legacy SQL to Azure PaaS SQL.
• Knowledge of migration technologies for SQL as well as workload migration.
• Strong experience with Azure SQL Database, Azure Data Factory, and Azure DevOps.
• Hands-on experience with database performance tuning, query optimization, and indexing.
• Experience with cloud technologies and deploying databases in Microsoft Azure.
• Familiarity with CI/CD pipelines and automated deployments in Azure environments.
• Knowledge of data security principles and practices, especially in cloud environments.

Skills & Personal Qualities:

• Strategic mindset: ability to envision end state and the milestone activities to achieve.
• Excellent written and verbal communication.
• Analytical and data-driven.
• Financial acumen.
• Highly adept at project and change management and storytelling.
• Solution-oriented problem solver.
• Keen attention to detail.
• Ability to perform under pressure.