Azure SQL Data Architect - Remote
Austin, Texas, USA
Job Title
Azure SQL Data Architect - RemoteJob 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 managementJob 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:
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 troubleshooting 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.
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.
Data Security and Privacy Protection:
- Implement robust security measures to safeguard data.
- Ensure compliance with privacy regulations.
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.
Strategize for Data Acquisitions and Recovery:
- Develop and implement strategies for data acquisition, archive recovery, and database implementation.
Collaborate with Data Governance Teams:
- Ensure data solutions align with regulatory requirements.
- Work closely with governance teams to maintain compliance.
Monitor System Performance and Troubleshoot Issues:
- Keep track of system performance metrics.
- Address any issues promptly.
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 story telling
- Solution oriented problem solver
- Keen attention to detail
- Ability to perform under pressure
Cushman & Wakefield also provides eligible employees with an opportunity to enroll in a variety of benefit programs, generally including health, vision, and dental insurance, flexible spending accounts, health savings accounts, retirement savings plans, life, and disability insurance programs, and paid and unpaid time away from work. In addition to a comprehensive benefits package, Cushman and Wakefield provide eligible employees with competitive pay, which may vary depending on eligibility factors such as geographic location, date of hire, total hours worked, job type, business line, and applicability of collective bargaining agreements.
The compensation that will be offered to the successful candidate will depend on factors such as whether the position is covered by a collective bargaining agreement, the geographic area in which the work will be performed, market pay rates in that area, and the candidate’s experience and qualifications.
The company will not pay less than minimum wage for this role.
The compensation for the position is: $127,500.00 - $150,000.00Cushman & Wakefield provides equal employment opportunity. Discrimination of any type will not be tolerated. Cushman & Wakefield is an Equal Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability, protected veteran status or any other characteristic protected by state, federal, or local law.
In compliance with the Americans with Disabilities Act Amendments Act (ADAAA), if you have a disability and would like to request an accommodation in order to apply for a position at Cushman & Wakefield, please call the ADA line at 1-888-365-5406 or email HRServices@cushwake.com. Please refer to the job title and job location when you contact us.
INCO: “Cushman & Wakefield” ApplyJob Profile
Dental Insurance Disability Insurance Flexible Spending Accounts Health Savings Accounts Retirement savings plans
Tasks- Collaborate with teams
- Design data architecture
- Ensure compliance
- Ensure data security
- Implement ETL processes
- Manage database performance
Analytical Architecture Automation Azure Data Factory Azure DevOps Azure SQL Azure Synapse Best Practices Change Management Communication Compensation Cosmos DB Data & Analytics Data Architecture Database Management Data Governance Data Integration Data Lake Data Security ETL Governance Leadership Management Organization Performance Tuning Reporting SQL T-SQL
Experience5-7 years
Education TimezonesAmerica/Anchorage America/Chicago America/Denver America/Los_Angeles America/New_York Pacific/Honolulu UTC-10 UTC-5 UTC-6 UTC-7 UTC-8 UTC-9