
Senior Business Execution Consultant – Branch Distribution Data Analyst
Wells Fargo
full-time
Posted on:
Location Type: Office
Location: Charlotte • Iowa • Minnesota • United States
Visit company websiteExplore more
Salary
💰 $87,000 - $154,000 per year
Job Level
About the role
- Pull, clean, and manipulate large and granular datasets (customer level, block group level, demographic, and operational).
- Build high quality Power BI dashboards with optimized DAX measures, drill paths, tooltips, and KPIs that support executive business reviews.
- Develop automated scripts, ETL jobs, and reusable analytical pipelines using Python, SQL, and SAS.
- Streamline and automate manual processes, including the creation of business case decks, reporting packages, and recurring analytics.
- Support data infrastructure enhancements through query optimization, data modeling, and workflow orchestration.
- Apply statistical methods to analyze trends, test hypotheses, build forecasts, and derive actionable insights.
- Translate complex analytical output into clear, concise insights that inform branch strategy and senior leader decision making.
Requirements
- 4+ years of Business Execution, Implementation, or Strategic Planning experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education
- 4+ years of Advanced data analytics and statistical modeling
- Develop efficient, reusable scripts for data wrangling, validation, and analysis.
- Design scalable automation pipelines.
- Write and optimize complex SQL queries, stored procedures, and ETL logic.
- Create SAS programs for data processing, transformations, and analytics.
- Migrate existing SAS logic into Python/SQL based pipelines where applicable.
- Build high performance dashboards with optimized DAX measures.
- Identify opportunities to eliminate manual effort. Develop automations using Python, PowerShell, SAS, RPA tools, or workflow orchestrators.
- Strong knowledge of hypothesis testing, probability, regression, ANOVA, clustering, and timeseries forecasting.
- Experience with SAS/STAT procedures (PROC REG, PROC GLM, PROC LOGISTIC, PROC ARIMA, PROC MIXED, PROC SURVEY*).
- Ability to turn statistical results into business recommendations.
Benefits
- Health benefits
- 401(k) Plan
- Paid time off
- Disability benefits
- Life insurance, critical illness insurance, and accident insurance
- Parental leave
- Critical caregiving leave
- Discounts and savings
- Commuter benefits
- Tuition reimbursement
- Scholarships for dependent children
- Adoption reimbursement
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
PythonSQLSASDAXETLdata wranglingstatistical modelingdata analysisdata visualizationautomation
Soft Skills
analytical thinkingcommunicationproblem solvingstrategic planningcollaborationattention to detailtime managementadaptabilitydecision makinginsight generation