U.S. Bank is seeking a seasoned Business Intelligence Architect with business intelligence applications experience to contribute toward the success of their technology initiatives.
Requirements
- 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 with Azure Data Services (Azure SQL, Synapse, Data Factory, Data Lake, Power BI)
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.
Other
- Bachelor's degree or equivalent work experience
- At least 10 years experience within a total information technology (IT) environment.
- BI experience in Treasury Management
- Experience developing and implementing models for clustering, recommendations, and forecasting
- ETL design and implementation experience (data pipelines, load processes, error handling)
