Senior Business Intelligence Architect

U.S. Bank National Association • Cincinnati, OH

1d • Onsite

About The Position

U.S. Bank is seeking a seasoned Business Intel Architect with business intelligence applications experience to contribute toward the success of our technology initiatives.

Requirements

• 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.
• BI experience in Treasury Management
• 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
• Ability to translate business requirements into technical solutions
• Stakeholder management and influencing skills

Nice To Haves

• BI experience in Treasury Management

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.
• 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.

Benefits

• Healthcare (medical, dental, vision)
• Basic term and optional term life insurance
• Short-term and long-term disability
• Pregnancy disability and parental leave
• 401(k) and employer-funded retirement plan
• Paid vacation (from two to five weeks depending on salary grade and tenure)
• Up to 11 paid holiday opportunities
• Adoption assistance
• Sick and Safe Leave accruals of one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by law

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level