Data Warehouse Architect 3

Launch Your Career with Cook SystemsReady to elevate your career? Cook Systems, a certified veteran owned IT consulting firm, has been transforming businesses and careers since 1990. Whether you're aiming to work with a Fortune 500 company or a small business, we've got you covered.Our core values: integrity, investment, and innovation drive everything we do, ensuring you grow and succeed in a dynamic, supportive environment. We understand the importance of work life balance and personal growth. Our cutting edge IT consulting partners and FastTrack talent program are designed to help you excel.Join our forward thinking team where excellence and creativity are valued every day. Check out what our associates have to say on Glassdoor. Ready to take your career to new heights? Cook Systems is where your journey to success begins.2 Submittals - Web Cam Interview Only - Market-rate compensation package This position will support the organization?s modernization efforts by designing and implementing cloud-native database solutions in Microsoft Azure to meet the demands of highly available, transparent, and auditable public-facing data systems. The candidate will collaborate with engineering, analytics, and governance teams to architect resilient, scalable, and secure data platforms in compliance with regulatory and public accountability requirements. The role requires expertise in Azure data services, modern database lifecycle practices, and a deep appreciation for the challenges associated with high-profile, publicly scrutinized data sets.Experience architecting and administering enterprise-grade database systems, with at least 2 years focused on cloud-native database services in AzureRequired5YearsDemonstrated experience designing and implementing solutions using Azure SQL Database, Azure SQL Managed Instance, and Azure Cosmos DB.Required5YearsStrong understanding of cloud-native design patterns, including statelessness, elasticity, and infrastructure-as-code (IaC).Required5YearsHands-on experience with Infrastructure as Code tools such as ARM templates, Bicep, or Terraform to provision and manage database infrastructure.Required5YearsFamiliarity with Azure Data Factory, Azure Synapse, and Azure Monitor for integrating, orchestrating, and monitoring database workflowsRequired5YearsDeep understanding of data classification, masking, encryption, and role-based access control (RBAC) in Azure environments.Required5YearsExperience supporting highly scrutinized, public-facing datasets (e.g., elections-related data or open data portals), including audit trail design.Required5YearsProven ability to implement and manage disaster recovery, high availability, and geo-replication strategies within Azure.Required5YearsExperience developing logical and physical data models that meet performance and transparency requirements while preserving data provenance.Required5YearsProficiency with T-SQL for scripting, automation, and diagnostics, with a focus on automation of repeatable processes.Required5YearsDemonstrated ability to evaluate data storage tradeoffs (e.g., performance vs cost vs governance constraints) in a pay-as-you-go cloud environment.Required5YearsExperience participating in design reviews, security assessments, and data governance audits, especially where data is subject to oversightRequired5YearsFamiliarity with DevSecOps practices, including versioned schemas and the integration of database change management into CI/CD pipelines.Required5YearsStrong written and verbal communication skills, including experience preparing technical documentation for public consumption or legal review.Required5YearsExperience in Agile/Scrum environments and modern DevOps workflows.Required5YearsMicrosoft Certified: Azure Database Administrator Associate, Azure Solutions Architect Expert, or DP-203 (Azure Data Engineer Associate)Highly desired5YearsBachelor?s degree in Computer Science, Information Systems, or related field is a plus.Required5YearsWhy Work with UsBenefitsAt Cook Systems, we don't just offer jobs we build futures. Our team is the heart of everything we do, and we're committed to supporting you with benefits that go beyond the basics. We want you to feel secure, valued, and empowered from the very beginning of your journey with us. When you join Cook Systems, here's what you can look forward to:Your Health, Your Way: Choose from two comprehensive medical plans through Blue Cross Blue Shield, complete with dental and vision coverage. With access to one of the nation's largest networks, you'll get the care you need for yourself and your family wherever life takes you.Peace of Mind, Every Step of the Way: Protect what matters most with life, critical illness, and accident insurance through Unum. Because your loved ones deserve security no matter what the future holds.Flexibility for Life's Needs: Save money and plan ahead with a Flexible Spending Account and Daycare FSA through Navia, helping you manage healthcare and dependent care expenses on your terms.Bridging the Gaps: Unexpected costs? No problem. Our Health Gap Insurance through Sunlife helps ensure you're covered when it counts.Your Future Starts Now: Dream big with our 401(k) retirement plan through The Standard. After just six months, you will be eligible to participate, because your future deserves a strong foundation.At Cook Systems, you're not just another employee you're family. Here, your ideas matter, your contributions shine, and your career will thrive. Together, we innovate, grow, and celebrate success every step of the way. Are you ready to be part of something bigger? Let's build the future together at Cook Systems.