Job Description
Location: Salt Lake City, 5 days onsite in office Contract: 6-month initial contract term with extension / conversion potential Work Authorization: Must be authorized to work in the U.S. without sponsorship requirements
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.
Ellofant is seeking a Senior Business Analyst to support a Fortune 50 client's Internal Audit leadership team. This is not an auditing role this is a business operations and analytics role where you'll spend most of your time in Excel doing the analytical heavy lifting that drives executive decision-making.
You will own the data analysis, modeling, and reporting that keeps leadership informed. This means building complex Excel models, writing advanced formulas, pulling and manipulating data from multiple sources (Smartsheet, SharePoint, internal databases), creating KPI dashboards, preparing materials for monthly business reviews and CFO presentations, and turning raw data into executive-ready insights. You'll work directly with senior leadership, and your Excel skills will be put to work every single day.
This is a contract-to-hire opportunity ideal for someone who came up through a top analyst program (banking, consulting, corporate finance), lives in Excel, and can build sophisticated models and analyses quickly and accurately.
What You'll Do
Build complex Excel models for financial analysis, variance reporting, and business performance tracking
Write advanced formulas (INDEX/MATCH, XLOOKUP, array formulas, nested IF statements, etc.) to automate reporting and analysis
Pull, clean, and manipulate large datasets from multiple sources including Smartsheet, SharePoint, and internal systems
Create dynamic dashboards using pivot tables, charts, conditional formatting, and data validation
Develop KPI frameworks and scorecards that translate raw data into actionable business insights
Prepare executive materials for monthly business reviews, CFO reporting, and leadership meetings all Excel-based
Design and maintain reporting templates and models that can be refreshed and reused efficiently
Perform ad hoc analyses to answer leadership questions quickly and accurately
Support cross-functional committees and strategic initiatives with data tracking, analysis, and reporting
Identify opportunities to automate manual processes and improve data quality through better Excel workflows
Partner with Internal Audit leadership with strong communication skills and executive presence
What We're Looking For
2 4 years of experience in business operations, corporate finance, strategy, or a top-tier analyst program where Excel was your primary tool
Expert-level Excel skills you can build complex models from scratch, write sophisticated formulas, work with large datasets, and troubleshoot errors quickly
Deep proficiency with pivot tables, VLOOKUP/XLOOKUP/INDEX/MATCH, array formulas, nested functions, and conditional logic
Experience designing dashboards, reports, and analytical frameworks that are both functional and visually clean
Comfortable working with data from Smartsheet, SharePoint, and other business systems
Strong analytical mindset with exceptional attention to detail your work is accurate, thorough, and reliable
Ability to work independently, manage multiple priorities, and deliver high-quality work under tight deadlines
Excellent communication skills and ability to translate complex analyses into clear recommendations for senior stakeholders
Comfortable managing up and working in a fast-paced, high-expectations environment
Nice to have: VBA/macros, Power Query, SQL, or experience with other data tools
Nice to have: Experience in audit, finance, risk, or compliance functions
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 an ellofant 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 come.