Remote BI Architect: Snowflake & Sigma Data Migration Lead

nymbusinc; United States; Remote; USD 135,000 - 150,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401(k) plan

Flexible time off

Volunteer day

Wellness programs

Growth opportunities

Job summary

nymbusinc is hiring a BI Architect to lead the data warehouse and reporting transformation for a major client. You will guide the migration from a legacy Microsoft SQL Server stack to a modern Snowflake/Sigma platform, while maintaining the current environment.

The role is hands-on and client-facing, requiring strong data modeling, ETL design, and expertise in SSRS, SSIS, T-SQL, PowerShell, VB, and C#. Banking industry experience is essential, with a focus on accuracy and timely delivery.

Qualifications

• 5–8 years of relevant experience, including 3–5 years in a traditional bank or credit union.
• Strong attention to detail, data quality, and accuracy of output.
• Proficiency in statistics, finance, and banking business concepts.
• Excellent written and oral communication skills with both technical and non-technical audiences.
• Strong time management and ability to balance legacy support alongside migration work.
• Proficiency with the Microsoft development and Office Suite, including VB or C#.

Responsibilities

• Design, implement, and maintain data models using modeling tools such as Sparx, Erwin, Oxygen, or Altova.
• Develop and document ETL data flows using SSIS, PowerShell, and T-SQL while supporting the existing SQL Server environment.
• Build and maintain reports, dashboards, and agents in SSRS to support accurate decision‑making.
• Serve as the lead technical architect for migrating the data warehouse and reporting environment to Snowflake and Sigma.
• Re‑engineer SSIS‑based ETL flows into Snowflake‑native pipelines and rebuild SSRS reports as equivalent Sigma workbooks, validating parity with legacy outputs.
• Document source‑to‑target mappings for both data integration and reporting, and coordinate the sequencing of work to minimize disruption.

Skills

Data modeling

ETL design

SSIS

PowerShell

T-SQL

VB/C#

SSRS

Snowflake

Sigma

Tableau/Power BI

Tools

SSIS

PowerShell

T-SQL

VB

C#

Job description

nymbusinc is hiring a BI Architect to lead the data warehouse and reporting transformation for a major client. You will guide the migration from a legacy Microsoft SQL Server stack to a modern Snowflake/Sigma platform, while maintaining the current environment.

The role is hands-on and client-facing, requiring strong data modeling, ETL design, and expertise in SSRS, SSIS, T-SQL, PowerShell, VB, and C#. Banking industry experience is essential, with a focus on accuracy and timely delivery.