StackAdapt is an advertising platform that delivers self-serve solutions that enable digital marketers and agencies to thrive. As an employer, the company has been recognized by Ad
Snowflake Database Administrator
Location
United States + 1 moreAll locations: United States | Canada
Posted
12 days ago
Salary
C$100K - C$125K / year
Seniority
Mid Level
No structured requirement data.
Job Description
Snowflake Database Administrator
StackAdapt
Role Description This role will be responsible for all operational database administration duties, data engineering, and data operations within the Data Lake and Enterprise Data Warehouse (Snowflake) ecosystem including, but not limited, to the following: - Take the lead on our daily database administration, ensuring our data environment stays healthy and reliable. - Partner closely with our Staff EDW Architect to bring new visions to life, designing high-quality data artifacts that follow industry best practices. - Turn business needs into smart, reusable ETL solutions that grow alongside our company. - Design end-to-end pipelines using your expertise with data models and architecture diagrams to build automated ingestion and transformation pipelines that keep our data moving on schedule. - Analyze and produce artifacts such as Source-to-Target Mapping documents. - Build pipelines that bring together data from everywhere—whether it’s RDBMS, APIs, JSON, or flat files—creating a seamless flow of information. - Define the "Source of Truth" using tools like Python and ETL software to clean, integrate, and transform data into a single, reliable resource the whole company can trust. - Provide day-to-day operational support for all the data pipelines by monitoring and investigating alerts, while troubleshooting and remediating production issues in a timely manner. - Act as a player-coach for junior and intermediate data engineers and ETL developers as the EDO team grows. Qualifications - Deep experience performing ETL design and development via custom coding (SQL, Python, Spark, Java, etc.) as well as using ETL tools (e.g., Coalesce, Informatica, DataStage, Talend) and other tools such as Data Quality tools, Metadata Manager, etc. - Extensive hands-on, professional experience working with Snowflake as a Database Administrator (DBA) and clear understanding of Snowflake’s Access Control framework. - Comfortable with Cloud-hosted solutions, especially AWS with experience deploying Secrets Manager, KMS, S3, EC2, Linux, Cross-Account Access, etc. in a scaled environment. - Innate curiosity to fundamentally understand and solve problems. - Understanding of data warehousing architecture fundamentals (e.g., Kimball vs. Inmon, Medallion Architecture, 3NF data models, reference data models, dimensional models, conformed dimensions, SCDs, etc.). - Experience in orchestrating data operations via tools such as Apache Airflow, Cron, Astronomer, etc. Requirements - The compensation range listed for this role reflects the expected hourly rate for candidates located in Ontario, Canada. - This range represents hourly rate only. Depending on the role, candidates may also be eligible for additional compensation such as annual bonuses, commissions, equity awards, and a comprehensive benefits package. - Factors Influencing Final Compensation: - The final compensation offer will be determined by a variety of factors, which may include, but are not limited to: the candidate's specific experience, technical skills, knowledge, abilities, and relevant education, licensure, and certifications. - Other business factors, such as organizational needs and budget alignment, may also be considered in the final offer. - Ontario Hourly Band: $100,000 — $125,000 CAD Benefits - Highly competitive salary - Retirement/401K/Pension Savings globally - Competitive Paid time off packages including birthdays off! - Access to a comprehensive mental health care program - Health benefits from day one of employment - Work from home reimbursements - Optional global WeWork membership for those who want a change from their home office and hubs in London and Toronto - Robust training and onboarding program - Coverage and support of personal development initiatives (conferences, courses, books, etc.) - Access to StackAdapt programmatic courses and certifications to support continuous learning - An awesome parental leave program - A friendly, welcoming, and supportive culture - Our social and team events!
Related Guides
Related Categories
Related Job Pages
More DevOps Engineer Jobs
Senior DevOps Engineer, Network
CodiLimeA strategic partner for technology-driven companies | Network engineering | Software engineering
• Building and/or migrating virtualized environments • Automating and orchestrating deployment of virtualized solutions in private cloud • Working in agile methodology and collaborating with the rest of the team • Mentoring teammates and sharing knowledge
Platform Engineer / DevOps Azure (GenAI & Kubernetes)
NEORISNEORIS is a Digital Accelerator that helps companies step into the future.
Role Description Estamos en búsqueda de: Platform Engineer / DevOps Azure (GenAI & Kubernetes) - Diseñar, construir y operar plataformas cloud-native sobre Azure, garantizando estabilidad, seguridad y escalabilidad en entornos productivos. - Administrar y evolucionar clústeres Kubernetes en producción, aplicando buenas prácticas de alta disponibilidad, seguridad y observabilidad. - Diseñar e implementar pipelines CI/CD para despliegue continuo de microservicios y soluciones basadas en APIs. - Colaborar con equipos de desarrollo y arquitectura para habilitar entornos de ejecución para soluciones GenAI/LLM bajo estándares corporativos y regulatorios. - Implementar soluciones de observabilidad distribuida y monitorización mediante OpenTelemetry. - Asegurar el cumplimiento de requisitos normativos y de seguridad en entornos cloud regulados. Qualifications - Entre 4 y 6 años de experiencia en platform engineering, DevOps, SRE o cloud engineering (Azure, AWS o GCP), con al menos 2 años en entornos productivos y mínimo 6 meses en entornos GenAI/LLM o especialización demostrable. - Experiencia en entornos con altos requisitos de cumplimiento normativo (banca, seguros, utilities, sector público u otros regulados). - Experiencia real operando Kubernetes en producción (AKS, EKS o GKE). - Experiencia sólida en Azure, especialmente en servicios core de plataforma. - Experiencia diseñando e implementando pipelines CI/CD con GitHub Actions o Azure DevOps. - Conocimiento práctico de Azure Container Registry (ACR), Azure Key Vault y Microsoft Entra ID para gestión de identidades. - Experiencia con OpenTelemetry y diseño de soluciones de observabilidad distribuida. - Experiencia en despliegue de microservicios con Docker y patrones cloud-native. - Conocimientos de networking cloud y seguridad básica (TLS, control de egress, segmentación de red, RBAC). - Dominio de Python, especialmente con FastAPI o frameworks equivalentes para construcción de APIs y middleware. Requirements - Deseables: - Experiencia previa trabajando con equipos de arquitectura o habilitación de plataformas internas. - Conocimientos adicionales en prácticas SRE y automatización avanzada. - Certificaciones cloud (Azure, Kubernetes o similares). Benefits - Contrato indefinido con salario competitivo. - Modalidad flexible y posibilidad de trabajo remoto. - Plan de carrera personalizado y formación continua. - Participación en proyectos estables con alto componente técnico. - Flexibilidad horaria y enfoque en la conciliación. - Beneficios sociales adaptados a tus necesidades.
• Oversee and enhance our cloud infrastructure (Google Cloud, Terraform) and software architecture to ensure optimal security and efficiency, while leading modernization and scaling efforts. • Identify vulnerabilities, and mitigate risks, staying ahead of emerging threats to safeguard sensitive data and maintain compliance. • Implement advanced monitoring (Grafana) to continuously track and analyze system performance, optimizing processes to prevent failures and minimize downtime for maximum system visibility. • Collaborate closely with product development teams to align infrastructure improvements with business objectives and contribute to the strategic direction of IT operations.
• Design, build, and maintain CI/CD pipelines for automated build, test, and deployment workflows • Manage cloud infrastructure on AWS (EC2, Amazon Connect, S3, Lambda, VPC, IAM, etc.) • Deploy and manage containerized applications using Docker and Kubernetes • Implement Infrastructure as Code (IaC) using Terraform or CloudFormation • Monitor system performance and reliability using observability tools (Prometheus, Grafana, CloudWatch, etc.) • Automate repetitive tasks and improve operational efficiency • Ensure system security, compliance, and best practices in cloud environments • Collaborate with development teams to streamline release processes and troubleshoot issues • Manage logging, alerting, and incident response processes
