Senior Business Intelligence Consultant

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.
Essential 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.

Required Qualifications:

• 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.

Preferred Qualifications:

• 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.

Damian Kauffman, from our recruiting team, will be guiding you through this process. Visit his LinkedIn page to connect!
#LI-Remote
#LI-DK1
Wipfli is an equal opportunity/affirmative action employer. All candidates will receive consideration for employment without regards to race, creed, color, religion, national origin, sex, age, marital status, sexual orientation, gender identify, veteran status, disability, or any other characteristics protected by federal, state, or local laws.
Wipfli is committed to providing reasonable accommodations for people with disabilities. If you require a reasonable accommodation to complete an application, interview, or participate in our recruiting process, please send us an email at [email protected]
Wipfli values fair, transparent, and competitive compensation, considering each candidate's unique skills and experiences. The estimated base pay range for this role is $88,000 to $118,000, with offers typically not made at the maximum, allowing for future salary increases. The actual salary at the time of offer depends on business related factors like location, skills, experience, training/education, licensure, certifications, business needs, current associate pay, and relevant employment laws.
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. Eligibility for all benefits programs is dependent on annual hours expectation, position status/level and location. Wipfli offers flexibility for many positions to be performed remotely; please discuss your work preferences with your recruiter during the interview process.
"Wipfli" is the brand name under which Wipfli LLP and Wipfli Advisory LLC and its respective subsidiary entities provide professional services. Wipfli LLP and Wipfli Advisory LLC (and its respective subsidiary entities) practice in an alternative practice structure in accordance with the AICPA Code of Professional Conduct and applicable law, regulations, and professional standards. Wipfli LLP is a licensed independent CPA firm that provides attest services to its clients, and Wipfli Advisory LLC provides tax and business consulting services to its clients. Wipfli Advisory LLC and its subsidiary entities are not licensed CPA firms.