Senior Business Intelligence Architect

Join to apply for the Senior Business Intelligence Architect role at U.S. Bank

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

• 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

• 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
• BI experience in Treasury Management
• 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, Power Shell, 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

• BI experience in Treasury Management
• This position is not eligible for visa sponsorship
• This role requires working from a U.S. Bank location three (3) or more days per week

If there’s anything we can do to accommodate a disability during any portion of the application or hiring process, please refer to our disability accommodations for applicants.

Our approach to benefits and total rewards considers our team members’ whole selves and what may be needed to thrive in and outside work. That s why our benefits are designed to help you and your family boost your health, protect your financial security and give you peace of mind. Our benefits include the following (some may vary based on role, location or hours):

• 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

U.S. Bank is an equal opportunity employer. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, and other factors protected under applicable law.

Posting may be closed earlier due to high volume of applicants.