First Monday
Jobs
Jobs open to youOnly jobs that can hire where you liveA CV for each jobWritten from your record, every line checkedMemoryIt remembers, so you don’t repeat yourselfInterview helpResearch, prep and hints only you seeWatch how it works0:28
FAQDocsUse in AI, Free
Your countryNorth AmericaEuropeAsia-PacificLatin AmericaNot on the list? Tell us where you liveRequest early accessEarly access
First Monday

Remote jobs that can actually hire you.

Beta formacOSWindows

Jobs

Jobs open to you in CanadaRemote jobs in the USRemote jobs in PolandRemote jobs in the UKRemote jobs in CanadaRemote jobs in Mexico

Product

Jobs open to youA CV for each jobMemoryInterview helpHow it works

Company

FAQContact

Legal

Privacy PolicyTerms & Conditions
Jobs
Jobs open to you in CanadaRemote jobs in the USRemote jobs in PolandRemote jobs in the UKRemote jobs in CanadaRemote jobs in Mexico
Product
Jobs open to youA CV for each jobMemoryInterview helpHow it works
Company
FAQContact
Legal
Privacy PolicyTerms & Conditions
Remote jobs by country
United StatesPolandUnited KingdomCanadaMexicoBrazilGermanySpainPortugalIrelandNetherlandsIndiaSwedenBelgiumAustriaDenmarkFinlandSwitzerlandNorwayAustraliaNew Zealand

Remote jobs by country

United StatesPolandUnited KingdomCanadaMexicoBrazilGermanySpainPortugalIrelandNetherlandsIndiaSwedenBelgiumAustriaDenmarkFinlandSwitzerlandNorwayAustraliaNew Zealand
© 2026 First MondayNo tracking cookies. Anonymous page statistics only.
First Monday
Jobs/Data and AI/Business Intelligence Architect

Business Intelligence Architect

NYMBUS

USData and AIPosted October 6, 2026
Open to people in the United StatesApply for this job Write my CV for this job Early access
Pay
$135,000–$150,000 a year
Required
SQL Server, SSIS, SSRS, Snowflake, Sigma, T-SQL, PowerShell, Data modeling
Nice to have
Sparx, Oxygen, Altova, Erwin
Experience
5–8 years
Benefits
Health insurance, Dental and vision, Family care, Retirement plan
Posted
October 6, 2026
Company
NYMBUS

Who it can hire

We read the post for each of the 21 countries we cover.

  • Open to people in the US

    The employer lists this job as remote there: “US”.

  • Not open to people in the other 20 countries we cover, as far as the post says.

The job post

  • 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

Benefits

  • 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
  • Employer Subsidized Medical and Dental Insurance

Preferred experience

  • 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

First Monday isn’t the employer or a recruiter and isn’t affiliated with NYMBUS. Details may have changed since; confirm with the employer before you apply.

Open to people in the United StatesApply for this job Write my CV for this job Early access
Pay
$135,000–$150,000 a year
Required
SQL Server, SSIS, SSRS, Snowflake, Sigma, T-SQL, PowerShell, Data modeling
Nice to have
Sparx, Oxygen, Altova, Erwin
Experience
5–8 years
Benefits
Health insurance, Dental and vision, Family care, Retirement plan
Posted
October 6, 2026
Company
NYMBUS

Similar jobs open to people in the United States

Architect, Snowflake CortexNimble Gravity · Remote · USSr BI Analyst – Tableau, SQL, Healthcare Analytics & Client ReportingPRO-spectus · Remote · USSenior Solutions ArchitectTiger Analytics · United StatesPrincipal Architect – SnowflakeSHI International · Remote · US
First Monday

Get jobs like this every Monday.

One email a week with new remote jobs open to people in Canada. Free, and one click to unsubscribe. Privacy Policy

Or request early access to the app
Apply for this job