Business Intelligence Architect

📋 Description

• Serve as the technical architect for the transformation of a SQL Server, SSIS, and SSRS environment
• Maintain and support the existing SQL Server-based data warehouse, ETL pipelines, reporting
• Design, implement, and maintain data models using established data modeling methodologies and tools.
• Develop and document ETL workflows using SSIS, PowerShell, T-SQL, and related Microsoft
• Design target-state Snowflake data models that accurately translate existing schemas and
• Re-engineer legacy SSIS workflows into modern Snowflake-based ingestion and transformation

🎯 Requirements

• 5–8 years of relevant professional experience in business intelligence, data architecture, data
• 3–5 years of experience working within a traditional financial institution such as a bank or credit
• Strong expertise with SQL Server, SSIS, SSRS, and SSAS, with the ability to support and modernize
• Hands-on experience with Snowflake and Sigma, ideally involving data warehouse or BI platform
• Strong understanding of data modeling, database design, ETL development, reporting, and application
• Experience with data modeling tools such as Sparx, Oxygen, Altova, Erwin, SQL Developer, or SQL

🎁 Benefits

• $135,000–$150,000 annual base salary.
• Annual cash bonus and equity eligibility, where applicable.
• Fully remote work environment.
• Health, dental, and vision insurance.
• HSA, FSA, and DCA options.
• 401(k) retirement plan.