Business Intelligence Architect - Nymbus

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.

The Opportunity

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.

What You Will Own

Legacy Platform Support & Data Architecture

• 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, PowerShell, PowerPoint, Visio, and T-SQL to support the client's existing SQL Server environment.
• Use the Microsoft technology stack to support application and operations systems throughout the transition period.
• Create new and manage existing reports, dashboards, and agents in SSRS to ensure timely and accurate data reporting for bank managers.

Snowflake & Sigma Migration Leadership

• 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 improve upon the client's existing SQL Server schemas.
• Re-engineer existing SSIS-based ETL data flows into Snowflake-native ingestion and transformation pipelines.
• Rebuild existing SSRS reports and dashboards as equivalent Sigma workbooks and reports, validating parity in logic and output.
• Document source-to-target mappings for data integration and report output.
• Sequence and coordinate the migration to minimize disruption to ongoing reporting and data operations.

Collaboration, Communication & Support

• Communicate proactively with team members and client stakeholders about potential system issues, migration risks, and status.
• Participate in data and application development peer reviews, interdepartmental requirements-gathering sessions, and troubleshooting.
• Identify data inconsistencies and anomalies to support increasing overall system performance.
• Ensure end-user issues are identified, tracked, reported on, and resolved in a timely manner.

What You Will Bring

• Experience: 5-8 years of relevant experience, including 3-5 years in a traditional financial institution (bank or credit union).
• Core Stack: SQL Server, SSIS, SSRS, SSAS, Snowflake, Sigma, T-SQL.
• Tools: Visio, Lucid, Visual Studio VB and/or C#.
• Data Modeling: Sparx, Oxygen, Altova, Erwin, Oracle SQL Developer.
• Skills: Excellent attention to detail, strong grasp of finance, statistics, and retail/commercial banking concepts, and strong time management skills.

How We Work

Nymbus is a remote-first company. Success in our remote environment requires self-motivation, initiative, and strong personal accountability. Team members are expected to manage priorities independently, communicate proactively, remain responsive, and participate on camera during virtual meetings.