Business Intelligence Architect, NYMBUS
$135-150k
Digital banking technology solutions
Be an early applicant
Digital banking technology solutions
201-500 employees
Be an early applicant
$135-150k
201-500 employees
Company mission
To provide the access, experience, and value needed to enable great financial services for all.
Role
Who you are
- 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)
What the job involves
- 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, 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
- 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
- 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
Our take
Nymbus is a leading provider of banking technology solutions that enables banks and credit unions of any size to achieve digital innovation and growth. The company’s financial solutions ensure its clients can quickly launch full-service digital banks, and/or convert existing banks/credit unions to the Nymbus ecosystem, while safely deploying a range of risk-free solutions at scale.
By enabling its users to optimize their digital growth strategies, Nymbus has solidified its position as a highly attractive alternative to legacy business models as it opens the door to capturing a new niche of customer segments that would be otherwise unobtainable.
Nymbus is well positioned to keep building on this momentum as more banks and credit unions look for simpler, faster ways to modernize. Its growing list of partnerships, new features, and industry recognition show that it's not just keeping up with change but helping drive it. As the demand for seamless digital experiences continues to rise, Nymbus is likely to play an even bigger role in shaping how everyday banking works, making it easier for institutions to compete and for customers to manage their finances.
Steph
Company Specialist at Welcome to the Jungle
Insights
4% employee growth in 12 months
Company
Funding (last 2 of 6 rounds)
May 2023
$70m
SERIES D
Aug 2021
$3m
LATE VC
Total funding: $178m
Company benefits
- Employer Subsidized Medical and Dental Insurance
- Healthcare and Dependant Care Flexible Spending Accounts
- Nymbus Awards and Recognition
- Retirement Plan Services / 401(k)
- Parental and Disability Leaves
- Time Off and Company Holidays
- Flexibility of being Fully Remote
- Collaborative Environment
Company HQ
Downtown, Jacksonville, FL
Leadership
Jeffery Kendall
(CEO & Chairman)Jeffery is current a Member of the Forbes Finance Council and YPO. Prior to joining Nymbus in 2020, he was an Executive VP of North America at Temenos. He also spent over 8 years at Kony in various roles, including Executive VP & GM.
Jeffrey Fonda
(CFO)Prior to joining Nymbus in 2024, Jeffrey was the CFO at DotCom Therapy and a VP of Finance at Mortgage Cadence.
Ed Gross
(CPO)Ed joined Nymbus in 2020 as an SVP of Product Design, moving into the role of Chief Product Officer in 2025. Previously, he was a Senior VP of UX & Design at Temenos. He also spent over 8 years at Kony in various roles, including Senior VP of Product & UX.
Share this job
View 3 more jobs at NYMBUS