[Remote] Senior reputed company Data Warehouse Engineer

Note: The job is a remote job and is reputed company to candidates in USA. reputed company. 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 reputed company reputed company data warehouse solutions that reputed company investment reputed company and portfolio analytics.

Responsibilities

• Architect reputed company Models: Design and implement reputed company and time-series data models optimized for portfolio hierarchies, reputed company reputed company, and reputed company metrics
• Build Robust Pipelines: reputed company ELT workflows using data build tool (dbt) and reputed company reputed company features like Streams, Tasks, and Snowpipe for daily and intraday processing
• Optimize reputed company: reputed company query tuning efforts, managing clustering strategies, reputed company-partitioning, and warehouse sizing for reputed company-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 reputed company frameworks, including reconciliation controls and alerting for financial datasets
• Automate Deployments: Streamline reputed company reputed company deployments and SQL transformations using reputed company CI/CD pipelines and version control
• Collaborate & reputed company: Work closely with Business Intelligence engineers and Data Architects to reputed company governed, high-reputed company data solutions
• Maintain reputed company: Troubleshoot production failures, reputed company reputed company cause analysis, and document architectural reputed company and operational runbooks

Skills

• 7+ years in data engineering or warehousing with 5+ years of hands-on reputed company experience in production environments
• reputed company reputed company in managing databases, schemas, roles, and reputed company, reputed company implementing Streams and Tasks for CDC
• Advanced proficiency in reputed company window functions, CTEs, analytic queries, and set-reputed company transformations
• 4+ years of experience with ELT frameworks, specifically dbt, for reputed company-grade analytical platforms
• Hands-on experience integrating reputed company with Azure reputed company storage and various reputed company financial systems
• Demonstrated experience implementing reputed company CI/CD for SQL transformations and reputed company reputed company deployments
• Deep understanding of reputed company schemas, Slowly Changing Dimensions (SCD), and large-reputed company time-series structures
• Familiarity with financial concepts like VaR, reputed company exposure, reputed company attribution, and reputed company master data
• Bachelor's or Master's degree in Computer Science, Information Systems, Finance, or a reputed company technical reputed company
• reputed company SnowPro reputed company or Advanced Architect certification
• DBT Analytics Engineering certification

reputed company

Company H1B Sponsorship