{"schemaVersion":"jobsearcher.job.v1","id":"6bf68f2b25b6d8ead5a47412","url":"https://jobsearcher.com/jobs/6bf68f2b25b6d8ead5a47412","canonicalUrl":"https://jobsearcher.com/jobs/6bf68f2b25b6d8ead5a47412","title":"Snowflake Data Engineer","description":"CloudHive's customer is hiring an experienced Analytics Engineer / Data Engineer on a contract basis to own the ingestion, modeling, and transformation of core banking data into a cloud data warehouse.The engineering team works in a hybrid setup (on-premise Linux and a major cloud provider) using Python, Git-based version control, and standard API testing tools to integrate third-party vendor interfaces. Your main focus will be modeling raw core banking data landed in the warehouse, transforming it into production-grade dimensional models, and layering in key ancillary sources (loans, deposits, digital banking, and compliance data) to build a unified enterprise analytics layer.Key Scope of Work & DeliverablesCore Data Modeling: Architect and build dimensional models (Kimball star/snowflake schema) around standard core banking structures — accounts, transactions, customer profiles, and general ledger.Ancillary Data Integration: Design transformation pipelines that join and append external third-party data feeds onto the core banking foundation.Transformation Pipeline & Testing: Develop, test, and document modular transformation models with automated data-quality checks and version control.API Payload Transformation: Partner with Python developers to process, flatten, and model raw JSON/relational API payloads from the core platform and other vendor interfaces.Warehouse Performance & Security: Tune compute resources, role-based access controls (RBAC), clustering, and query execution for banking analytics workloads.Required Qualifications & SkillsCore Banking Domain: Direct experience with a major core banking platform's data structures or comparable financial systems.Warehouse & SQL: Deep expertise in modern cloud data warehousing, complex SQL, and handling semi-structured data (parsing JSON/VARIANT payloads).Transformation Tooling: Proven track record building production transformation models, data-quality tests, and documentation (dbt or equivalent).Dimensional Modeling: Strong background in Kimball methodology, slowly changing dimensions (SCDs), and financial data modeling.Technical Stack: Hands-on experience alongside Python-based API ingestion workflows, Git version control, API testing tools, and hybrid on-prem/cloud environments.","company":"Cloudhive","rawCompany":"cloudhive","city":"San Antonio","state":"TX","isRemote":false,"isActive":false,"createdAt":"2026-08-29T12:46:44.985Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-2051.00","title":"Data Scientists","slug":"data-scientists"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"518210","title":"Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services","slug":"computing-infrastructure-providers-data-processing-web-hosting-and-related-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Snowflake Data Engineer","description":"CloudHive's customer is hiring an experienced Analytics Engineer / Data Engineer on a contract basis to own the ingestion, modeling, and transformation of core banking data into a cloud data warehouse.The engineering team works in a hybrid setup (on-premise Linux and a major cloud provider) using Python, Git-based version control, and standard API testing tools to integrate third-party vendor interfaces. Your main focus will be modeling raw core banking data landed in the warehouse, transforming it into production-grade dimensional models, and layering in key ancillary sources (loans, deposits, digital banking, and compliance data) to build a unified enterprise analytics layer.Key Scope of Work & DeliverablesCore Data Modeling: Architect and build dimensional models (Kimball star/snowflake schema) around standard core banking structures — accounts, transactions, customer profiles, and general ledger.Ancillary Data Integration: Design transformation pipelines that join and append external third-party data feeds onto the core banking foundation.Transformation Pipeline & Testing: Develop, test, and document modular transformation models with automated data-quality checks and version control.API Payload Transformation: Partner with Python developers to process, flatten, and model raw JSON/relational API payloads from the core platform and other vendor interfaces.Warehouse Performance & Security: Tune compute resources, role-based access controls (RBAC), clustering, and query execution for banking analytics workloads.Required Qualifications & SkillsCore Banking Domain: Direct experience with a major core banking platform's data structures or comparable financial systems.Warehouse & SQL: Deep expertise in modern cloud data warehousing, complex SQL, and handling semi-structured data (parsing JSON/VARIANT payloads).Transformation Tooling: Proven track record building production transformation models, data-quality tests, and documentation (dbt or equivalent).Dimensional Modeling: Strong background in Kimball methodology, slowly changing dimensions (SCDs), and financial data modeling.Technical Stack: Hands-on experience alongside Python-based API ingestion workflows, Git version control, API testing tools, and hybrid on-prem/cloud environments.","datePosted":"2026-08-29T12:46:44.985Z","dateModified":"2026-08-29T12:46:44.985Z","hiringOrganization":{"@type":"Organization","name":"Cloudhive","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"San Antonio","addressRegion":"TX","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"6bf68f2b25b6d8ead5a47412"},"url":"https://jobsearcher.com/jobs/6bf68f2b25b6d8ead5a47412"}}