Business Analyst (Smartsheet & Excel Expert)

Location: Salt Lake City or New York (preferred) Contract: 6-month initial term with 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. — Job Description We're looking for a highly skilled Project & Portfolio Management Specialist to join our team and support the Global Internal Audit Business Unit of a Fortune 50 Financial Institution. In this role, you will work closely with the Chief of Staff of a Internal Audit to drive operational excellence and strategic alignment across a diverse, global team. You'll be instrumental in coordinating action items, tracking commitments, and improving our project management practices to enhance efficiency and transparency. This is a hands-on position for someone who thrives on creating structure and clarity within a critical function. You'll be a key player in ensuring that our initiatives, from individual audits to our full portfolio, are executed effectively and that progress is clearly communicated to leadership. What You'll Be Doing: Advanced Smartsheet Administration & Automation: Manage complex Smartsheet environment including templates, live sheets, references between sheets, email automation, workflow automations, sheet-based automations, reports and dashboards. This role requires expert-level proficiency across the full platform—comprehensive technical knowledge beyond foundational usage. Architect and maintain sophisticated multi-sheet systems driving operational efficiency. Strategic Excel Analysis & Insights: Perform rapid-turnaround analysis for business reviews and leadership visibility. Build complex integrated formulas and custom analytical frameworks. Study data independently, apply intuition, and proactively propose insights. Deliver deep-dive analysis and strategic recommendations under tight deadlines with advanced formula expertise. Executive Presentations & Visual Storytelling: Create compelling executive presentations and decks efficiently and effectively. Translate complex data into visual narratives that drive leadership decisions. SharePoint & Confluence Project Administration: Provide project-level administration with responsibilities including access management to appropriate sections, executing live changes quickly, and building automation workflows between tools using no-code capabilities. Project & Portfolio Governance: Central point of contact for tracking action items and commitments across global internal audit teams. Manage project governance and quarterly functional inventories. Knowledge Management: Establish and maintain centralized Confluence repository. Ensure documentation standards, accessibility, and organizational knowledge continuity. Technical Backlog Management: Centralize intake requests, govern prioritization, and serve as business analyst liaison translating business needs into technical requirements. Meeting Coordination & Operational Support: Manage meeting minutes, agendas, and Business Review data compilation. Support Chief of Staff with meeting prep and operational tasks. Relationship Management: Build strong stakeholder relationships from technical teams to senior leadership. Support training initiatives and team engagement. What We're Looking For: Smartsheet Expert: Comprehensive proficiency with templates, live sheets, references between sheets, email automation, workflow automations, sheet-based automations, reports and dashboards across the full platform. Excel Specialist: Advanced expertise with complex integrated formulas, independent analytical thinking, data intuition, and rapid turnaround capabilities for business reviews and leadership visibility. Executive Communication: Strong presentation and storytelling skills with visual design capability and efficient deck development. SharePoint & Confluence: Project administration proficiency including access management, rapid implementation of changes, and no-code automation workflows. Seasoned Professional: Proven track record in complex global organizations juggling multiple priorities. Internal Audit Knowledge: Experience supporting audit teams with understanding of function-specific processes. Strong Communicator: Effective across all levels, relationship builder, proactive self-starter. If you are a detail-oriented professional who can connect the dots between individual tasks and strategic goals, and you're passionate about making a real impact on organizational efficiency within an internal audit function, we encourage you to apply. —— 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.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 https://www.ellofant.com/. Job Types: Full-time, Contract, Temporary Pay: $50.00 - $75.00 per hour Expected hours: 40 per week Application Question(s): This job requires you to work onsite, 5 days a week. Can you commit to be onsite 5 days a week? Do you require sponsorship to work legally in the USA? Do you have expertise in Smartsheet beyond basics and building to maintaining workflows or automations? i.e., Email automations do not count, they are simple / basic. Do you consider yourself an excel whiz with a business analysis background? You won't be just putting pivots blindly on data, you will be merging many datasets, generating your analytics using advanced integrated functions (not simple basic ones) and then you will generate pivots where you will propose insights to leadership by yourself. Work Location: In person