Business Intelligence Architect

Title: Business Intelligence Architect Location: Remote - United States

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.

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.

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.

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 (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.

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 where appropriate, improve upon) the client's existing SQL Server schemas and data relationships.
• 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, output, and accuracy against the legacy versions.
• Document source-to-target mappings for both data integration and report output (covering mappings from SQL Server to Snowflake and from SSRS to Sigma) in a form that reporting team members and client stakeholders can easily understand.
• Sequence and coordinate the migration to minimize disruption to the client's ongoing reporting and data operations, including planning cutover phases and parallel-run validation.

Collaboration, Communication & Support 

• Communicate proactively with team members and client stakeholders about potential system issues, migration risk, and status. Support off-hours upgrade and/or migration work when necessary.
• Actively participate in data and application development peer reviews, interdepartmental requirements-gathering sessions, troubleshooting, and project support.
• Identify data inconsistencies, anomalies, and scripting issues to support increasing overall system performance through code/script reviews, and develop and implement recommendations accordingly.
• Ensure end-user issues are identified, tracked, reported on, and resolved in a timely manner.
• Complete all yearly compliance training and testing, and comply with bank, Federal,and State regulations. Adhere to departmental and bank-wide service standards.

What You Will Bring

Required Qualifications

• 5-8 years of relevant experience for this role.
• 3-5 years of relevant experience in a traditional financial institution (bank or credit union).
• Excellent attention to detail, data accuracy, and quality of output.
• Proficient in the areas of statistics, finance, and retail and commercial banking business concepts.
• Passion to self-educate and stay current on the latest analytics and data platform trends in marketing, banking, and other fields, including modern cloud data warehousing and BI tools.
• Excellent written and oral communication skills to articulate effectively in forums and meetings with technical and non-technical teams, and to explain migration decisions and trade-offs clearly to client stakeholders.
• Ability to provide clear and concise project documentation to various stakeholders, including source-to-target mapping and migration plans.
• Strong time management skills, with proficiency in prioritizing, scheduling, and managing multiple project schedules and differing levels of criticality across legacy support and migration work.
• Proficient in the Microsoft Development and Office Suite.
• Proficient in the areas of application development (programming), database and system/application design. Knowledge of legacy and web-based systems and intrinsic interfaces (WebAPI, TCP, UDP, Database, etc.).
• Legacy platform: SQL Server; SSIS, SSRS, SSAS.
• Target platform: Snowflake; Sigma.
• Visio, Lucid.
• Data modeling: Sparx, Oxygen, Altova, Erwin, SQL Developer (Oracle), SQL Data Modeler (Oracle).
• Reporting and Integration frameworks: Sigma, Tableau, Power BI, SSRS, SSIS.
• Visual Studio VB and/or C# — software development (Web, WinForm, Services, API, WebAPI).

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 their priorities independently, communicate proactively, remain responsive, and participate on camera during virtual meetings.

A strong remote culture requires intentional effort from everyone. We expect team members to engage in our global community, proactively build relationships, participate actively in team and company conversations, seek opportunities to collaborate, and take shared ownership of creating a connected and inclusive remote community including showing up on camera.

Compensation and Benefits

• Base salary range: $135,000 to $150,000 annually
• Annual cash bonus and equity eligibility, if applicable.
• Remote Work Environment
• Health, dental, and vision insurance, including HSA/FSA/DCA
• 401(k) plan
• Flexible time-off and company holidays
• Additional paid volunteer day
• Supplemental Insurance Programs, including voluntary Life, Accident, Critical Illness, Pet Insurance
• Employee Assistance Programs [EAP]
• Wellness programs
• Growth and development programs

Actual compensation will be determined based on relevant experience, skills, role scope, and location.

Hiring at Nymbus

As an AI-first company, we embrace the power of AI tools throughout our hiring process. Nymbus remains committed to finding the right match for our teams and candidates alike. While we are excited about the AI tools available to us today, including AI-enabled video interview tools, we remain equally committed to maintaining human involvement and oversight throughout the hiring process.

Nymbus is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.

Nymbus is committed to providing reasonable accommodations for qualified individuals with disabilities throughout the application and interview process, including accommodations related to our use of AI tools. If you require an accommodation, please notify your recruiter.

Applicants must be legally authorized to work in the country in which the position is based. This role is currently based in the United States. Not all locations are available for consideration, and locations will be evaluated on a case-by-case basis.

In compliance with applicable pay transparency laws, this posting includes the anticipated base salary range, a general description of available benefits, and the application deadline where required. Actual compensation will be determined based on the candidate’s relevant experience, skills, and location.