Business Intelligence Architect

About Nymbus

Nymbus is a high-growth fintech company, ‘Built to Move,’ empowering banks and financial institutions to transform faster, compete smarter, and deliver greater value in today’s digital marketplace. At Nymbus, we’re revolutionizing banking technology. Our award-winning modern core platform and cloud-based solutions help financial institutions modernize, scale, and succeed. As part of our team, you won’t just be part of a tech revolution;

you’ll be at the forefront of it, driving innovation and delivering exceptional client experiences.

Nymbus is building the next generation of fintech platforms, and that takes people who are ready to challenge convention, move with purpose, and reimagine what’s possible. We operate with an AI-first mindset across our business, continuously improving how we work, and the value we deliver to our clients.

We want our partners to be thrilled about the possibilities we are creating together and the lasting impact our collaboration will bring to the industry and consumers. The journey to growth begins with doing something different. And that journey starts with the great people who make Nymbus.

We challenge the status quo, question assumptions, and work together to turn bold ideas into meaningful progress.

Nymbus is seeking a Business Intelligence Architect to lead the data warehouse and reporting transformation for a key financial institution client currently operating on a Microsoft SQL Server data warehouse platform (SQL Server, SSIS, and SSRS). This role will serve as the technical lead guiding the client's migration from its existing Microsoft stack to a modern data platform built on Snowflake (database) and Sigma (analytics and reporting).

The Business Intelligence Architect will maintain and support the client's existing SQL Server-based data warehouse and reporting environment while simultaneously designing, building, and migrating data models, ETL pipelines, and reports to Snowflake and Sigma.

This is a hands-on, client-facing role requiring strong data modeling, database development, and BI/reporting expertise, along with the ability to translate an existing Microsoft-based architecture into an equivalent (and improved) design on the new platform.

You will work both independently and collaboratively with cross-functional partners (including data engineering, product, and client stakeholders) to deliver a well documented, low-disruption transition from the legacy stack to Snowflake and Sigma, while keeping existing reporting and data operations running smoothly throughout the migration.

• Understand database design methodologies and assist in the design, implementation, and maintenance of data models using data modeling tools (Sparx, Oxygen, Altova, Erwin, etc.).
• Develop and document ETL data flows using SSIS, Power Shell, PowerPoint, Visio, and T-SQL to support the client's existing SQL Server environment.
• Use the Microsoft technology stack (Word, Excel, PowerPoint, Visio) to support application and operations systems throughout the transition period.
• Create new and manage existing reports, dashboards, and agents in the Business Intelligence system (SSRS) to ensure timely and accurate data reporting for use by bank managers for decision-making purposes.

• Serve as the lead technical architect for converting the client's data warehouse and reporting environment from SQL Server/SSIS/SSRS to Snowflake and Sigma.
• Design target-state data models in Snowflake that faithfully translate (and where appropriate, improve upon) the client's existing SQL Server schemas and data relationships.
• Re-engineer existing SSIS-based ETL data flows into…