> Markdown version of [/jobs/ext/221343-azure-security-engineer](https://www.wearedevelopers.com/jobs/ext/221343-azure-security-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Azure Security Engineer - **Company:** OpenKyber LLC - **Location:** United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Query Performance, Data Analysis, Microsoft Azure, Databases, Information Engineering, Data Governance, Data Systems, Data Warehousing, Document-Oriented Databases, Factor Analysis, Software Architecture, Reference Data, Standard Sql, SQL Databases, Systems Integration, Data Processing, Snowflake, Change Data Capture, Gitlab-ci, Star Schema, Data Management, Software Version Control, Data Pipelines - **Published:** May 19, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=35c0de1886689777 ## About the Role A senior-level Snowflake Data Warehouse Engineer with 7+ years of data engineering experience and 5+ years of hands-on Snowflake experience in production environments. This role will deliver scalable, high-performant data warehouse powering investment risk and portfolio analytics. The ideal candidate has built and optimized enterprise-grade analytical platforms, implemented robust CDC frameworks, and supported performance-sensitive financial reporting workloads. The resource will assist with developing reliable, governed, and performant data solutions that enable exposure reporting, factor analysis, time-series risk metrics, stress testing, and performance attribution. This role works closely with business intelligence engineers, data architects, and data scientists., * 7+ years of experience in data engineering or data warehousing roles. * 5+ years of hands-on Snowflake experience in production environments, including: * Creating and managing databases, schemas, roles, and grants. * Designing and implementing Streams and Tasks for CDC and scheduled processing. * Building and optimizing materialized views and performance-driven data models. * Expert-level SQL skills, with deep experience in complex window functions, CTEs, analytic queries, set-based transformations, and query performance tuning. * 4+ years of experience with ELT frameworks or transformation tools, preferably dbt. * Experience integrating Snowflake with Azure cloud storage and upstream financial systems. * Demonstrated experience implementing GitLab CI/CD for SQL-based transformations and Snowflake object deployments. * Strong understanding of analytical data modeling, including star schemas, slowly changing dimensions, fact tables, aggregates, and large-scale time-series structures. * Experience supporting high-volume, performance-sensitive financial or portfolio datasets. * Familiarity with portfolio accounting, security master data, market data feeds, or risk concepts such as VaR, factor exposure, stress testing, or performance attribution. ## Description * Implement Snowflake schemas and object lifecycle strategies optimized for risk and portfolio analytics workloads. * Develop scalable, dimensional, and time-series data models supporting portfolio hierarchies, positions, security master integration, exposures, and risk metrics. * Build robust ELT pipelines using dbt and native Snowflake capabilities, including Streams, Tasks, and Snowpipe, to support daily and intraday data processing. * Implement efficient change data capture and incremental processing strategies for position, pricing, risk, and reference data. * Develop and maintain high-performance tables, views, and materialized views aligned with performance-sensitive analytical use cases. * Lead query performance optimization efforts, including clustering strategy design, micro-partition awareness, warehouse sizing, caching behavior, and workload management. * Establish data quality frameworks, including reconciliation controls, completeness checks, monitoring, and alerting for financial datasets. * Automate Snowflake deployments and SQL transformations using GitLab CI/CD pipelines and version control best practices. * Document data models, lineage, architectural decisions, governance controls, and operational runbooks. * Troubleshoot production failures, perform root cause analysis, and remediate issues impacting reporting timelines. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [Hacking AI at the Edge of the Indian Ocean](https://www.wearedevelopers.com/videos/100177-hacking-ai-at-the-edge-of-the-indian-ocean) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london)