Senior Business Intelligence Architect
U.S. Bank
full-time
Posted on:
Location Type: Hybrid
Location: Minnesota, North Carolina, Ohio, Texas • 🇺🇸 United States
Visit company websiteSalary
💰 $126,820 - $149,200 per year
Job Level
Senior
Tech Stack
AzureCloudETLJavaPostgresPythonScalaSparkSQLSSISTableau
About the role
- 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.
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.
- 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, 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
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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLT-SQLDAXdata modelingETLdata ingestiondata processingdata visualizationscriptingprogramming
Soft skills
communicationcollaborationproblem-solvinganalytical skillsstakeholder managementinfluencing skills
Certifications
Bachelor's degree