Senior Analytics Consultant

About this role:

Wells Fargo is seeking to fill a Senior Analytics Consultant position that is critical to maintain ongoing support, administration, and development of enterprise business intelligence and reporting solutions. The role requires deep expertise in MicroStrategy, advanced SQL, data warehousing, and analytics tool and connectivity support to ensure the continued delivery of executive dashboards, KPI reporting, data quality processes, and production support. Additionally, experience with emerging analytics technologies, automation, and cloud-based solutions will help advance reporting capabilities and improve operational efficiency.

In this role, you will:

• Consult, review and research moderately complex business, operational, and technical challenges that require an in-depth evaluation of variable data factors
• Perform moderately complex data analysis to support and drive strategic initiatives and business needs
• Develop a deep understanding of technical systems and business processes to extract data driven insights while identifying opportunities for engineering enhancements
• Lead or participate on large cross group projects
• Mentor less experienced staff
• Collaborate and consult with peers, colleagues, external contractors, and mid-level managers to resolve issues and achieve goals
• Leverage a solid understanding of compliance and risk management requirements for supported area

Required Qualifications:

• 4+ years of Analytics experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education
• 1+ years of experience in BI and Analytics development, administration, and support.
• Experience in MicroStrategy/Strategy Architecture, Intelligence Server, Workstation, Library, Dossiers, Reports, and Dashboards.
• Experience designing and developing enterprise BI solutions using MicroStrategy/Strategy or other BI tools.

Desired Qualifications:

• Experience designing and developing and end-user support of BI solutions using Strategy, Tableau, PowerBI, ThoughtSpot, Starburst, Dremio.
• REST API integrations and MicroStrategy/Strategy SDK experience.
• Python scripting for automation and analytics.
• Knowledge of data governance and data catalog solutions.
• Exposure to AI/ML analytics on GCP.
• Experience using Jira, Confluence, Azure DevOps, or similar Agile tools
• Proficient in creating attributes, facts, metrics, transformations, filters, prompts, custom groups, and consolidations.
• Strong understanding of metadata management and schema architecture.
• Experience with performance tuning and query optimization.
• Advanced SQL development and optimization skills.
• Experience writing complex queries, stored procedures, views, and performance-tuned reporting queries.
• Strong understanding of Data Warehousing concepts, Star Schema, and Snowflake Schema.
• Experience with BigQuery, Oracle, SQL Server, Snowflake, PostgreSQL, or Teradata.
• Knowledge of ETL/ELT processes and data integration frameworks.
• Experience validating data quality and implementing data reconciliation processes.
• Build and maintain executive dashboards, operational reports, and KPI scorecards.
• Experience working in Agile/Scrum environments.
• Ensure timely delivery of high-quality analytics solutions.
• User, group, and security administration within MicroStrategy.
• Manage object migration across DEV, QA, UAT, and PROD environments.
• Implement security filters and role-based access controls.
• Troubleshoot production issues and provide root cause analysis.

Job Expectations:

• This position offers a hybrid work schedule
• This position is not eligible for Visa sponsorship

Salary Ranges:

• $87,000 - $140,000 - Charlotte, NC
• $87,000 - $140,000 - West Des Moines, IA
• $87,000 - $140,000 - Irving, TX
• $96,000 - $154,000 - Minneapolis, MN

Pay Range
 

Reflected is the base pay range offered for this position. Pay may vary depending on factors including but not limited to demonstrated examples of prior performance, skills, experience, or work location. Employees may also be eligible for incentive opportunities.

Benefits

Wells Fargo provides eligible employees with a comprehensive set of benefits, many of which are listed below. Visit Benefits - Wells Fargo Jobs for an overview of the following benefit plans and programs offered to employees.

• 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

Posting End Date:

*Job posting may come down early due to volume of applicants.

We Value Equal Opportunity

Wells Fargo is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other legally protected characteristic.

Employees support our focus on building strong customer relationships balanced with a strong risk mitigating and compliance-driven culture which firmly establishes those disciplines as critical to the success of our customers and company. They are accountable for execution of all applicable risk programs (Credit, Market, Financial Crimes, Operational, Regulatory Compliance), which includes effectively following and adhering to applicable Wells Fargo policies and procedures, appropriately fulfilling risk and compliance obligations, timely and effective escalation and remediation of issues, and making sound risk decisions. There is emphasis on proactive monitoring, governance, risk identification and escalation, as well as making sound risk decisions commensurate with the business unit’s risk appetite and all risk and compliance program requirements.

Applicants with Disabilities

To request a medical accommodation during the application or interview process, visit Disability Inclusion at Wells Fargo.

Drug and Alcohol Policy

Wells Fargo maintains a drug free workplace.  Please see our Drug and Alcohol Policy to learn more.

Wells Fargo Recruitment and Hiring Requirements:

a. Third-Party recordings are prohibited unless authorized by Wells Fargo.

b. Wells Fargo requires you to directly represent your own experiences during the recruiting and hiring process.