Data Warehouse Modeler

Kasasa (formerly BancVue) powers products and services such as Kasasa rewards checking, personal finance management, online account opening, and savings accounts, and online marketing for community banks and credit unions.

The Data Warehouse Modeler is responsible for creating logical and physical data models for Kasasa’s data warehouse and other sub-systems. The Data Warehouse Modeler’s primary responsibility is to organize and structure the data from Kasasa’s other enterprise systems into the Kasasa Data Warehouse. The Data Warehouse Modeler will also work to reduce data redundancy within the existing data warehouse while also improving the data transfer between satellite systems. As a Data Warehouse Modeler you will participate as a member of a cross-functional Agile team consisting of developers, a scrum master and a product owner. You will work closely with your Product Owner to groom user stories - estimating, providing detail and adding acceptance criteria. You will be responsible for code through all stages of deployment. You will help improve software engineering standards and best practices. You must enjoy working with teams, taking initiative and innovating.

* Infuse the Patch Values into your work ethic, every day and every interaction * Work directly with the Product Owner and Data Architect to translate business requirements into deliverable outcomes * Participate in the Agile planning process * Create the facts and dimensions required to meet business objectives and all additional physical objects needed to generate the database schema * Work within our DevOps culture to ensure best practices are followed * Review Data Models to ensure that database structures match the models * Test physical models before deployment * Balanced view of operational success while focusing on delivering business value

* Bachelor’s degree in Computer Science or related field * 4-7 years of experience in enterprise software development, including data warehouse integration * Strong knowledge of data and system integrations * Experience with AWS specifically S3, RDS or RedShift, Terraform and Data Pipeline * Excellent understanding of performance tuning and data integrity testing * 2+ years of experience building, debugging and maintaining enterprise SaaS data solutions * Strong knowledge of SQL (writing and optimizing queries, stored procs) * Superb troubleshooting skills * Excellent communication, teamwork, and collaboration skills * Experience with test-driven development and continuous delivery in an agile software development environment