Business Intelligence Architect

Nymbus, Inc.

5d • $135,000 - $150,000 • Remote

About The Position

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.

Requirements

• 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).

Responsibilities

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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed