Senior Business Intelligence Consultant

Wipfli Advisory LLC

3d • $88,000 - $118,000 • Remote

About The Position

At Wipfli, people count. At Wipfli, our people are core to everything we do—the catalyst behind our ability to create exceptional impact and extraordinary results. We believe in flexibility. We focus on relationships. We encourage each individual to follow their own path. People truly matter and they feel it. For those looking to make a difference and find a professional home, Wipfli offers a career-defining opportunity.

Job Summary
Under the direction of a Manager, or Senior Manager/Director, the Senior Consultant will develop and provide solutions for clients pursuing operational excellence and/or technical solutions. They will be self- managed for long periods and interface regularly with clients and others outside of Wipfli. Help lead and shape the delivery resources, in accordance with firm policies and procedures. If not leading people or business development efforts, will be focused on expanding technical solutions across Wipfli's footprint.

Requirements

• Bachelor’s Degree or an equivalent combination of education and experience.
• 5+ years’ experience in a professional services firm or 5+ years of private industry experience focused on appropriate technical area with 1+ years in professional services.
• Works towards obtaining additional appropriate advanced certifications.
• Ability to communicate with and collaborate with clients to define requirements for analytic applications.
• Demonstrated problem-solving experience and capabilities.

Nice To Haves

• Bachelor’s Degree in related field
• Training, support or consulting advisory experience.
• Experience with compliance or professional standards associated with area of expertise.
• Experience designing AI enabled data and BI workflows such as automation of data ingestion, transformation, data quality checks, and reporting.
• Experience in integrating generative AI and retrieval augmented generation (RAG) into analytics and data platforms such as natural language querying, automated insights, semantic model building.
• One or more vendor data-management or data-engineering certifications (relevant examples include: Snowflake Snowpro Certification, Microsoft Fabric Data Engineer DP-700 Certification, or Azure Databricks Platform Architect, etc.).
• Experience with estimating work efforts for development and deployment of the same applications.
• Strong SQL skills with the ability to develop complex queries, joins, window functions, and performance optimization.
• Microsoft Fabric, Snowflake, Databricks experience or experience with another cloud data platform. An understanding of Lakehouses, Warehouses, and Data Pipelines.
• Experience with version control tools such as Git for managing code and collaboration.
• Thorough grasp of the basic principles of data modeling. Understand how to structure data for analytics (star schemas, dimensional modeling basics); awareness of OLTP (normalized) vs. OLAP (denormalized) design.
• Demonstrated proficiency in connecting to various data sources, including OLE DB, ODBC, SFTP, and APIs. Possesses foundational skills in authentication, API invocation, and transforming data into structured tables.
• Requirements documentation and work-effort estimation for planning.

Responsibilities

• Proposes solutions or alternatives that are linked to client business needs and proactively notifies the team leader of project timeline pressures and suggests solutions.
• Architects and develops solutions based on client requirements and in-depth knowledge of standard applications.
• Collects and analyzes relevant data, conducts client interviews, prepare workpapers and reports, and serve as lead subject matter expert.
• Communicates with clients on functional deliverables and work plan status and issues for both client and internal projects to Project Manager.
• Organizes, establishes, and monitors progress on project work plans to ensure projects are completed on time and within budget.
• Monitors out-of-scope requests to ensure proper change management is communicated.
• Trains, mentors and/or serves as performance coach to Consultant I’s and Consultant II’s. Delegates and leverages work to ensure staff development.
• Actively participates with opportunity leaders or regional teams in business development activities as subject matter experts.
• Leads and participates in research and development and foundational efforts to position the team to learn, develop and deliver innovative solutions to the market.

Benefits

• Wipfli values fair, transparent, and competitive compensation, considering each candidate's unique skills and experiences.
• Individuals may be eligible for an annual discretionary bonus, subject to participation rules and based on a variety of factors including, but not limited to, individual and Firm performance.
• Wipfli cares about our associates and offers a variety of benefits to support their well-being. Highlights include 8 health plan options (both HMO & PPO plans), dental and vision coverage, opportunity to enroll in HSA with potential Firm contribution and an Employee Assistance Program. Other benefits include firm-sponsored basic life and short and long-term disability coverage, a 401(k) savings plan & profit share as well as Firm matching contribution, well-being incentive, education & certification assistance, flexible time off, family care leave, parental leave, family formation benefits, cell phone reimbursement, and travel rewards. Voluntary benefit offerings include critical illness & accident insurance, hospital indemnity insurance, legal, long-term care, pet insurance, ID theft protection, and supplemental life/AD&D.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 501-1,000 employees