This job has closed.

U.S. Bank · 1 month ago

Senior Business Intelligence Architect

Hopkins, MN

Full-time

Onsite

Senior Level, Lead/Staff

$127K/yr - $149K/yr

10+ years exp

U.S. Bank is a leading financial services provider dedicated to helping customers make smarter financial decisions. They are seeking a seasoned Business Intelligence Architect to contribute to their technology initiatives by designing and maintaining Business Intelligence solutions.

BankingFinancial ServicesInsuranceMortgageWealth Management

No H1B

Responsibilities

Administrative Tasks - Disaster Recovery exercises, Documentation, System Maintenance, Manage Scheduled Jobs

Maintain and support platform, Incident Management and Service Requests

Testing and Quality Assurance

Managing CI/CD pipelines, deploying builds, and monitoring deployments

Setting up and maintaining development, testing, and staging environments

Managing source control systems (e.g., Git) and resolving merge conflicts

Qualification

Business Intelligence architectureAzure Data ServicesETL designAdvanced SQL ServerData modelingPower BIScripting/programmingCloud securityStakeholder managementCollaborationProblem-solving

Required

Bachelor's degree or equivalent work experience

At least 10 years experience within a total information technology (IT) environment

At least 9 years experience with BI applications; decision support systems, query and reporting, online analytical processing, statistical analysis, forecasting, and data mining

At least 3 years experience with business intelligence design and architecture

Design, develop, and maintain end-to-end Business Intelligence solutions, including data ingestion, processing, and visualization, leveraging Azure SQL Managed Instance, SSIS, ADF, Azure Storage, and Azure VM for scalable and efficient ETL workflows

Create interactive dashboards and reports in Power BI, perform advanced data analysis, and write complex SQL queries to transform raw data into actionable insights for business decision-making

Advanced SQL Server knowledge (T-SQL, DAX, performance tuning, security, SSIS/SSRS). Postgres is a plus

Data modeling (relational, dimensional, multi-dimensional, semantic layers)

Experience developing and implementing models for clustering, recommendations, and forecasting

Experience with Azure Data Services (Azure SQL, Synapse, Data Factory, Data Lake, Power BI)

ETL design and implementation experience (data pipelines, load processes, error handling)

Business Intelligence tools (Power BI, Tableau, SSRS, SSAS, semantic modeling)

Experience with Metadata management and governance

Scripting/programming (Python, PowerShell, or similar for automation)

Spark or Databricks experience (Java, Scala preferred)

Understanding of enterprise architecture and integration patterns

Familiarity with cloud security, networking, and resource management in Azure

Strong communication, Collaboration, Problem-solving and analytical skills