Business Intelligence Architect

Nymbus is seeking a Business Intelligence Architect to lead the data warehouse and reporting transformation for a key financial institution client. The role involves maintaining and supporting the existing SQL Server-based data warehouse while designing, building, and migrating data models, ETL pipelines, and reports to Snowflake and Sigma. The ideal candidate will have strong data modeling, database development, and BI/reporting expertise, along with the ability to translate an existing Microsoft-based architecture into an improved design on the new platform.

• Lead the data warehouse and reporting transformation for a key financial institution client, guiding the migration from Microsoft SQL Server to a modern data platform built on Snowflake and Sigma.
• Maintain and support the client's existing SQL Server-based data warehouse while simultaneously designing, building, and migrating data models, ETL pipelines, and reports to Snowflake and Sigma.
• 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, ensuring a well-documented and low-disruption transition.

• 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.)
• Target platform: Snowflake; Sigma
• 3-5 years of relevant experience in a traditional financial institution (bank or credit union)
• 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
• 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
• Legacy platform: SQL Server; SSIS, SSRS, SSAS
• 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
• Proficient in the areas of statistics, finance, and retail and commercial banking business concepts
• Excellent attention to detail, data accuracy, and quality of output
• Reporting and Integration frameworks: Sigma, Tableau, Power BI, SSRS, SSIS
• 5-8 years of relevant experience for this role
• Ability to provide clear and concise project documentation to various stakeholders, including source-to-target mapping and migration plans
• Visual Studio VB and/or C# — software development (Web, WinForm, Services, API, WebAPI)
• Proficient in the Microsoft Development and Office Suite
• Data modeling: Sparx, Oxygen, Altova, Erwin, SQL Developer (Oracle), SQL Data Modeler (Oracle)
• Visio, Lucid