Database Lead – Data Architect
About Distillery
Distillery is a software development partner that helps organizations design, build, and scale modern technology solutions. Leading companies work with us to accelerate digital initiatives, solve complex technical challenges, and bring innovative products to market faster. Working as an extension of our clients' teams, we deliver lasting business value. Distillery is committed to diversity and inclusion. We embrace a dynamic and inclusive culture where you have the opportunity to continuously learn and grow.
About the Position
We are seeking a Lead SQL Server Database Architect to own the technical direction of our client's SQL Server platform, a stable, production-grade estate that now needs someone to drive its evolution toward modern data warehousing and AI-readiness.
Responsibilities
- Own the platform's technical direction, data modeling standards, and schema governance; make and document architecture decisions with their trade-offs
- Set and enforce standards for performance, reliability, and security
- Lead the shift from on-prem operations to modern data warehousing, dimensional modeling, ELT pipelines, layered raw/curated/semantic architecture, version control and CI/CD for database code, and data lineage and cataloging
- Own the modernization roadmap end to end
- Prepare the platform for AI and ML workloads through clean, governed, accessible data; define governance for access control, sensitive data, and auditability
- Continuously assess the estate for capacity, performance, technical debt, and security risk, and raise findings early with a recommended course of action
- Provide unprompted updates on platform health and initiative progress
- Mentor DBAs on technical depth and on the habit of surfacing problems early; document knowledge so expertise is shared, not concentrated
Requirements
- Deep production SQL Server experience (tuning, indexing, HA/DR)
- Strong data architecture and dimensional modeling background, with demonstrated experience modernizing a legacy estate (not just operating one)
- ETL/ELT pipeline design experience
- Working knowledge of cloud data platforms (Azure Synapse, Fabric, Snowflake, Databricks) and the judgment to assess fit rather than assume it
- Familiarity with what "AI-ready" actually demands of a data platform
- CI/CD experience for database changes
- Track record of driving initiatives from proposal through delivery with measurable outcomes
- Demonstrated ability to escalate risk before impact
- Excellent communication that adapts depth to the audience; experience influencing without direct authority and holding a technical position under pressure
Nice to Have
- Cloud or hybrid migration experience
- dbt, Airflow, Spark
- Data cataloging and lineage tooling
- Observability platforms (Splunk, Datadog, Grafana)
- Regulated or payments environment experience
- Agile/Kanban and SLA-driven delivery
Why You'll Like Working Here
Join a global team committed to Distillery's core values: Unyielding Commitment, Relentless Pursuit, Courageous Ambition, and Authentic Connection.
- 100% Remote Work: Enjoy the freedom to work from anywhere while collaborating with a diverse, multinational team.
- Competitive Compensation: Generous and competitive package in USD, along with a comprehensive benefits plan.
- Flexible Hours: Create a schedule that aligns with your life and priorities.
- Home Office Setup: Receive all the hardware and software needed to succeed from home.
- Innovative Workplace: Collaborate with the global Top 1% of talent in a multicultural and dynamic environment.
- Focus on Growth: Pursue professional and personal development while contributing your unique talents to a team where you can truly shine!
