Data Warehouse Consultant

Requirements:

• Experience administering enterprise-grade database systems, with at least 2 years focused on cloud-native database services in Azure.
• Demonstrated experience designing and implementing solutions using Azure SQL Database, Azure SQL Managed Instance, and Azure Cosmos DB.
• Strong understanding of cloud-native design patterns, including statelessness, elasticity, and infrastructure-as-code (IaC).
• Hands-on experience with Infrastructure as Code tools such as ARM templates, Bicep, or Terraform to provision and manage database infrastructure.
• Familiarity with Azure Data Factory, Azure Synapse, and Azure Monitor for integrating, orchestrating, and monitoring database workflows.
• Deep understanding of data classification, masking, encryption, and role-based access control (RBAC) in Azure environments.
• Experience supporting highly scrutinized, public-facing datasets (e.g., elections-related data or open data portals), including audit trail design.
• Proven ability to implement and manage disaster recovery, high availability, and geo-replication strategies within Azure.
• Experience developing logical and physical data models that meet performance and transparency requirements while preserving data provenance.
• Proficiency with T-SQL for scripting, automation, and diagnostics, with a focus on automation of repeatable processes.
• Demonstrated ability to evaluate data storage tradeoffs (e.g., performance vs cost vs governance constraints) in a pay-as-you-go cloud environment.
• Experience participating in design reviews, security assessments, and data governance audits, especially where data is subject to oversight.
• Familiarity with DevSecOps practices, including versioned schemas and the integration of database change management into CI/CD pipelines.
• Strong written and verbal communication skills, including experience preparing technical documentation for public consumption or legal review.
• Experience in Agile/Scrum environments and modern DevOps workflows