Senior Data Warehouse Engineer

Job Title: Senior Snowflake Data Warehouse Engineer Location: Remote (U.S.) Duration: 6 Months Contract (Potential Extension) About the Role: We are seeking a Senior Snowflake Data Warehouse Engineer to design, build, and optimize enterprise-scale analytical data platforms supporting investment risk, portfolio analytics, and financial reporting. The ideal candidate will have extensive experience developing high-performance Snowflake solutions, implementing scalable ELT pipelines, and supporting performance-sensitive analytical workloads in production environments .This role will work closely with data architects, business intelligence engineers, and data scientists to deliver reliable, governed, and scalable data solutions that support portfolio exposure reporting, factor analysis, risk metrics, stress testing, and performance attribution. Key Responsibilities: • Design and implement Snowflake databases, schemas, and object lifecycle strategies optimized for analytical workloads. • Develop scalable dimensional and time-series data models supporting portfolio hierarchies, positions, exposures, security master integration, and risk analytics. • Build and maintain ELT pipelines using dbt and native Snowflake capabilities, including Streams, Tasks, and Snowpipe. • Implement efficient Change Data Capture (CDC) and incremental processing frameworks for financial and reference data. • Develop and optimize tables, views, and materialized views for high-performance analytical reporting. • Lead Snowflake performance tuning initiatives, including clustering strategies, micro-partition optimization, warehouse sizing, caching, and workload management. • Establish data quality and reconciliation frameworks, including completeness checks, monitoring, alerting, and exception handling. • Automate Snowflake deployments and SQL transformations through GitLab CI/CD pipelines and version control best practices. • Create and maintain technical documentation including data lineage, architecture diagrams, governance controls, and operational runbooks. • Troubleshoot production issues, perform root cause analysis, and implement corrective actions to ensure reporting reliability. Required Qualifications. • 7+ years of experience in Data Engineering, Data Warehousing, or related disciplines. • 5+ years of hands-on Snowflake experience in production environments. • Strong experience creating and managing Snowflake databases, schemas, roles, grants, and security models. • Proven expertise with Snowflake Streams, Tasks, Snowpipe, and CDC implementations. • Expert-level SQL skills with extensive experience in: • Complex joins • Window functions • Common Table Expressions (CTEs) • Analytical queries. • Query optimization and performance tuning. • 4+ years of experience with dbt or similar ELT transformation frameworks. • Experience designing and implementing dimensional data models, including: • Star schemas • Fact and dimension tables • Slowly Changing Dimensions (SCD) • Aggregate and time-series models • Experience integrating Snowflake with Azure cloud storage and enterprise data sources. • Experience implementing GitLab CI/CD pipelines for Snowflake deployments and SQL transformation workflows. • Strong understanding of data governance, data quality, and operational monitoring. Preferred Qualifications: • Experience supporting investment management, asset management, banking, or capital markets data platforms. • Familiarity with: • Portfolio accounting • Security masterdata • Market data feeds • Risk analytics • Exposure reporting • Performance attribution • Factor modeling • Stress testing • Value at Risk (VaR) • Experience supporting large-scale, high-volume analytical reporting environments. • Exposure to enterprise data governance and regulatory reporting requirements.