jobapplier

Business Intelligence Architect

NYMBUS

Skills

Required

  • Sigma
  • Snowflake
  • SQL Server
  • migration
  • SSIS
  • SSRS
  • WebAPI
  • Database
  • data platform
  • application development
  • programming
  • Visual Studio
  • VB / C#

Preferred

  • SQL
  • Server
  • data warehouse

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.

Responsibilities

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

Requirements

  • 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

Pay

USD 135,000 - 150,000