E
Full Time Any

Salt Lake City, Utah · USA job

Senior Consultant - Business Intelligence (BI) Strategy & Implementati

Ellofant

Salt Lake City, Utah

Job description

Location: Salt Lake City, Utah
On-site five days a week
No remote or hybrid option
Full-time contract with the potential to convert to a permanent position

Ellofant is a modern consulting firm built for those who want to do work that actually moves the needle. We help companies navigate change, complexity, and scale through a blend of strategic thinking, trusted technology, and hands-on execution. Our clients rely on us not just for advice, but for building systems, launching products, and driving outcomes that matter. At Ellofant, we value clarity over jargon, momentum over perfection, and people over process. We're looking for curious, driven individuals who want to solve real problems with real impact. If you're excited about challenging what's possible and delivering meaningful change while you're at it, Ellofant might be your next move.

About the role
Ellofant is looking for a Senior Consultant to support a major Business Intelligence initiative with a Fortune 50 financial services provider.

You will work closely with leaders and subject matter experts across finance, operations, risk, compliance, strategy, and other business functions. Your job will be to understand what they need, turn those needs into clear requirements, and help move BI solutions from an idea through implementation.

This role is a good fit for someone who is comfortable asking thoughtful questions, working through ambiguity, and turning complex information into practical solutions. You should be able to work at both the strategic and detailed levels. One day you may be leading a stakeholder workshop, and the next you may be documenting calculations, reviewing a data model, or building an executive presentation.

What you will do
Lead and support stakeholder interviews, discovery sessions, and requirements workshops
Build strong working relationships with business leaders and subject matter experts
Understand business processes, challenges, reporting needs, decisions, and desired outcomes
Collect, document, and prioritize BI use cases
Identify relevant data sources and understand their ownership, availability, definitions, quality, and dependencies
Translate business needs into detailed business and functional requirements
Create data models, calculations, business rules, metric definitions, and reporting logic
Document requirements for the data platform and the BI products that will be built on it
Lead and support the implementation of business solutions using Alteryx and other BI tools
Connect stakeholder needs, use cases, data sources, requirements, calculations, and delivered solutions
Support testing, business validation, issue resolution, and user acceptance
Use Excel for analysis, calculations, data validation, and rapid prototyping
Use Visio to create process maps, workflows, data flows, and solution designs
Create clear and polished PowerPoint presentations for stakeholders and senior leadership
Turn complex analysis into a simple and persuasive story
Present recommendations, progress updates, risks, and decisions to leadership
Support communication, stakeholder alignment, and adoption as new solutions are introduced

What we are looking for
At least 7 years of relevant experience in business intelligence, analytics strategy, management consulting, business analysis, data transformation, or BI implementation
Strong management consulting or client-facing experience
Experience working within financial services and an understanding of its business processes, controls, and data needs
Hands-on experience designing or implementing solutions in Alteryx
Experience leading requirements gathering from early discovery through implementation
Strong understanding of business use cases, data sources, data modeling, calculations, metrics, and reporting requirements
Ability to turn unclear or incomplete stakeholder requests into detailed and actionable requirements
Advanced PowerPoint skills with a strong eye for executive storytelling and presentation quality
Strong Visio skills for documenting processes, workflows, and data flows
Advanced Excel skills for analysis, modeling, validation, and prototyping
Excellent communication, facilitation, writing, and presentation skills
Confidence working with senior stakeholders in a large and complex organization
Strong attention to detail and the ability to manage multiple priorities
Ability to work on-site in Salt Lake City five days a week

How we expect AI to be used
We want someone who knows how to use AI to work faster and more effectively. AI can help with research, analysis, first drafts, documentation, and presentation development.
AI will never replace thoughtful work, sound judgment, or attention to detail. Anything created with AI must be reviewed in detail, verified, tailored to the audience, and improved before it is shared. Generic or lightly edited AI output will not meet the quality expected in this role.

What success looks like
You bring structure to unclear problems and help stakeholders turn their ideas into solutions that can actually be built. Your requirements are detailed and easy to follow. Your data models and calculations are thoughtful and accurate. Your presentations are clear, polished, and appropriate for senior leadership.

Most importantly, you earn the trust of the people you work with and help move the initiative forward.

Why This Role Matters
If you're someone who gets satisfaction from building the perfect model, finding insights in the data, and knowing your work directly supports C-suite decision-making, this is your role. You'll be the analytical engine behind a leadership team at one of the world's largest companies, and your Excel skills will be mission-critical every day.

Equal Employment Opportunity & Inclusivity
Ellofant is proud to be an Equal Employment Opportunity Employer. We do not discriminate in employment on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability, age, protected veteran status, genetic information, or any other characteristic protected by law. This policy applies to all aspects of employment, including recruitment, hiring, placement, promotion, compensation, benefits, training, termination, and other conditions of employment.

Commitment to Diversity, Equity & Inclusion
We believe diversity, equity, and inclusion are fundamental to innovation, thoughtful client service, and a thriving workplace culture. We welcome and value different perspectives, experiences, and backgrounds including but not limited to race, gender, ethnicity, sexual orientation, disability status, veteran status, and neurodiversity. Accommodations are available upon request during the application and interview process.

Pay Transparency & Benefits
Compensation will be commensurate with your experience, skill set, and job location. Ellofant offers a competitive benefits package, which may include medical and dental coverage, retirement savings plans, paid time off, and professional development support. Salary range will be disclosed to candidates as part of the interview process where permitted.

Application Privacy & Process
Your personal information, including resume, interview feedback, and any background checks, will be collected and used solely for recruitment purposes and handled in accordance with applicable privacy laws. Employment is contingent upon successful completion of verification of eligibility and reference checks. You must be authorized to work in the U.S.

Fraud Awareness
Please be aware of potential recruitment fraud. Ellofant will never request payment or sensitive financial information at any stage of the hiring process. All legitimate communication will come from dot com email address. If you receive suspicious outreach claiming to be from Ellofant, please contact us directly.

We appreciate your interest in Ellofant and encourage candidates from all backgrounds who are excited about challenging what's possible to apply.

To learn more about Ellofant, please visit ellofant dot com

Explore related USA jobs

Similar jobs you may like

Related roles with a similar title and location.

Same category Same postal code Same area Same location Same country

Business Intelligence (BI) Consultant, Alteryx / PowerBI - SLC

Ellofant

Salt Lake City, Utah, United States · 84199

Same category Same location Same country

Associate ERP Analyst

Thrive Foods

Provo, Utah, United States · 84601

Same category Same location Same country

Associate ERP Analyst

Thrive Foods

American Fork, Utah, United States · 84003

Need help finding a job?

Chat with our AI assistant.