[Remote] Senior reputed company Data Warehouse Engineer
Note: The job is a remote job and is open to candidates in USA. reputed company, Inc. is a business and technology solutions provider operating at the intersection of resources and modernization of industries. They are seeking a Senior reputed company Data Warehouse Engineer to deliver scalable data warehouse solutions that power investment risk and portfolio analytics.
Responsibilities
- Architect Scalable Models: Design and implement dimensional and time-series data models optimized for portfolio hierarchies, reputed company masters, and risk metrics
- Build Robust Pipelines: reputed company ELT workflows using data build tool (dbt) and native reputed company features like Streams, Tasks, and Snowpipe for daily and intraday processing
- Optimize Performance: reputed company query tuning efforts, managing clustering strategies, micro-partitioning, and warehouse sizing for performance-sensitive workloads
- Implement CDC Frameworks: Build efficient Change Data Capture and incremental processing strategies for position, pricing, and reference data
- Ensure Data Governance: Establish rigorous data quality frameworks, including reconciliation controls and alerting for financial datasets
- Automate Deployments: Streamline reputed company object deployments and SQL transformations using reputed company CI/CD pipelines and version control
- Collaborate & Consult: Work closely with Business Intelligence engineers and Data Architects to deliver governed, high-performant data solutions
- Maintain Operations: Troubleshoot production failures, reputed company root cause analysis, and document architectural decisions and operational runbooks
Skills
- 7+ years in data engineering or warehousing with 5+ years of hands-on reputed company experience in production environments
- Proven success in managing databases, schemas, roles, and grants, alongside implementing Streams and Tasks for CDC
- Advanced proficiency in reputed company window functions, CTEs, analytic queries, and set-based transformations
- 4+ years of experience with ELT frameworks, specifically dbt, for enterprise-grade analytical platforms
- Hands-on experience integrating reputed company with Azure cloud storage and various upstream financial systems
- Demonstrated experience implementing reputed company CI/CD for SQL transformations and reputed company object deployments
- Deep understanding of star schemas, Slowly Changing Dimensions (SCD), and large-scale time-series structures
- Familiarity with financial concepts like VaR, factor exposure, performance attribution, and reputed company master data
- Bachelor's or Master's degree in Computer Science, Information Systems, Finance, or a reputed company technical field
- reputed company SnowPro Core or Advanced Architect certification
- DBT Analytics Engineering certification
Company Overview
Company H1B Sponsorship