Business Intelligence Architect

Accountabilities:: Serve as the technical architect for the transformation of a SQL Server, SSIS, and SSRS environment into Snowflake and Sigma. Maintain and support the existing SQL Server-based data warehouse, ETL pipelines, reporting environment, and operational data processes throughout the migration. 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 technologies. Design target-state Snowflake data models that accurately translate existing schemas and relationships while identifying opportunities for improvement. Re-engineer legacy SSIS workflows into modern Snowflake-based ingestion and transformation pipelines. Rebuild SSRS reports and dashboards as Sigma workbooks and reports, validating data, logic, outputs, and accuracy against legacy solutions. Create and maintain reporting solutions that provide timely and accurate information for business and management decision-making. Develop clear source-to-target mappings covering SQL Server-to-Snowflake data integration and SSRS-to-Sigma reporting transformations. Plan and coordinate migration phases, cutovers, and parallel-run validation to minimize disruption to ongoing reporting and data operations. Identify data inconsistencies, anomalies, performance issues, and scripting problems, recommending and implementing improvements. Participate in requirements gathering, technical peer reviews, troubleshooting, application development, and cross-functional project activities. Communicate migration progress, technical decisions, risks, and potential system issues clearly to technical and non-technical stakeholders. Track and resolve end-user issues while providing timely project and operational support. Support scheduled off-hours upgrades or migration activities when required and maintain compliance with applicable banking and regulatory standards. Requirements: 5–8 years of relevant professional experience in business intelligence, data architecture, data engineering, database development, or a related field. 3–5 years of experience working within a traditional financial institution such as a bank or credit union. Strong expertise with SQL Server, SSIS, SSRS, and SSAS, with the ability to support and modernize legacy data environments. Hands-on experience with Snowflake and Sigma, ideally involving data warehouse or BI platform migration. Strong understanding of data modeling, database design, ETL development, reporting, and application or systems architecture. Experience with data modeling tools such as Sparx, Oxygen, Altova, Erwin, SQL Developer, or SQL Data Modeler. Experience with BI and reporting platforms such as Sigma, Tableau, Power BI, and SSRS. Knowledge of software development using Visual Studio, VB, and/or C#, including web applications, Windows applications, services, APIs, and Web APIs. Familiarity with integration technologies and interfaces such as Web API, TCP, UDP, databases, and web-based or legacy systems. Proficiency with Microsoft development and productivity tools, including Word, Excel, PowerPoint, and Visio, as well as tools such as Lucid. Strong understanding of statistics, finance, and retail and commercial banking concepts. Exceptional attention to detail, data accuracy, quality, and analytical problem-solving. Ability to communicate technical concepts, migration decisions, risks, and trade-offs effectively with both technical and non-technical stakeholders. Strong documentation skills, including the ability to create clear source-to-target mappings, migration plans, and technical materials. Excellent time management and prioritization skills, with the ability to balance legacy support, migration activities, and multiple project schedules. Self-motivated and accountable, with the initiative to stay current with modern analytics, cloud data warehousing, BI technologies, and industry trends. Comfortable working independently in a remote-first environment while proactively collaborating with distributed teams and participating actively in virtual meetings. 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. Flexible time off and company holidays. Additional paid volunteer day. Supplemental insurance options, including voluntary life, accident, critical illness, and pet insurance. Employee Assistance Program. Wellness programs and resources. Growth and professional development programs. Opportunity to lead a significant cloud data transformation involving modern data warehousing and business intelligence technologies. Client-facing exposure within a complex and regulated financial services environment.