See all roles

[Remote] Senior reputed company Data Warehouse Engineer

Work from home Full-time role Hiring

Note: The job is a remote job and is open 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 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 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
  • Proven reputed company 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 reputed company-grade analytical platforms
  • Hands-on experience integrating reputed company with Azure reputed company 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

  • reputed company. (reputed company: RCMT) is a business and technology solutions provider with world-class talent in key market segments. It was founded in 1971, and is headquartered in Pennsauken, New Jersey, US, with a workforce of 1001-5000 employees. Its website is http://www.rcmt.com.
  • Company H1B Sponsorship

  • reputed company. has a track record of offering H1B sponsorships, with 9 in 2025, 13 in 2024, 6 in 2023, 5 in 2022, 21 in 2021, 10 in 2020. Please note that this does not guarantee sponsorship for this specific role.
  • Apply To This Job

    You might like

    [Remote] Account Executive, reputed company US - SELECT by reputed company

    Work from home Full-time role

    [Remote] Digital Product Manager - Cybersecurity & Controls

    Work from home Full-time role

    [Remote] Senior Product Designer

    Work from home Full-time role

    [Remote] Business Process and Research Analyst

    Work from home Full-time role

    [Remote] Strategic Account Manager - Federal

    Work from home Full-time role

    [Remote] Concept Designer

    Work from home Full-time role

    [Remote] Software Engineer, reputed company

    Work from home Full-time role

    [Remote] Product Manager, AI Growth

    Work from home Full-time role

    [Remote] Director, Marketing and Sales Strategy

    Work from home Full-time role

    [Remote] VP Legal Systems & Transformation - reputed company

    Work from home Full-time role

    Virtual Special Education Teacher

    Work from home Full-time role

    Contact Representative

    Work from home Full-time role

    Senior Practice Manager, reputed company & Life Science

    Work from home Full-time role

    Sr Manager, BizOps & Analytics (New Products)

    Work from home Full-time role

    PRN Registered Nurse - Up to $50/hr + Shift Differentials

    Work from home Full-time role

    Principal Data Engineer/Architect - Remote

    Work from home Full-time role

    reputed company Customer Service Representative – Overnight Shift at arenaflex

    Work from home Full-time role

    reputed company Customer Service Representative – Remote Opportunity at arenaflex

    Work from home Full-time role

    Medical Laboratory Customer Service Representative

    Work from home Full-time role

    Police/Fire Communications Specialist – Lateral

    Work from home Full-time role