Senior Business Intelligence Architect

U.S. Bank-posted 5 days ago
Full-time • Senior
Hybrid • Cincinnati, OH
5,001-10,000 employees
Resume
Match Score
Upload and Match ResumeTrack Jobs with Teal

At U.S. Bank, we’re on a journey to do our best. Helping the customers and businesses we serve to make better and smarter financial decisions and enabling the communities we support to grow and succeed. We believe it takes all of us to bring our shared ambition to life, and each person is unique in their potential. A career with U.S. Bank gives you a wide, ever-growing range of opportunities to discover what makes you thrive at every stage of your career. Try new things, learn new skills and discover what you excel at—all from Day One. Job Description U.S. Bank is seeking a seasoned Business Intel 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.
  • 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.
  • 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.
  • 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
  • BI experience in Treasury Management
  • 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
Track Jobs with Teal

Job Search Resources

•
Resume Builder
•
Senior Architect Resume Examples
•
Senior Architect Cover Letter Examples

Tools

Career Hubs

Guides

Company

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service