Advanced Excel Modeler

Job Title: Advanced Excel Modeler
Location: LATAM
Duration: Long Term/ Full Time
Timezone: CST

Profile Summary:

We are looking for an Advanced Excel Modeler who designs and develops complex financial and operational models using advanced Excel functionalities, including Power Pivot, complex formulas, and data validation, to provide insightful analysis and support strategic decision-making across the organization. This role requires data manipulation and visualization expertise and the ability to translate complex business requirements into robust, user-friendly Excel models. Candidates must be able to work with a team, including other data scientists, developers, and clients. English skills and comfort in front of clients are critical. It is essential to be fast and able to execute Excel formulas and pivot tables and comprehend fundamental data correlation.

PRINCIPAL DUTIES AND RESPONSIBILITIES (May perform any or all of the following):
Minimum 3-5 Years of Experience is required

1. Model Development: Construct intricate financial models utilizing advanced Excel features like Power Pivot, creating dynamic calculations, forecasting scenarios, and sensitivity analysis to evaluate business risks and opportunities.
2. Data Integration and Manipulation: Extract, clean, and transform data from multiple sources to ensure accuracy and consistency within the Excel models. The company uses SQL for the data warehouse; the Excel modeler must be proficient in using external data sources, Power Query, VB, macros, and automation.
3. Visual Data Presentation: Design clear and impactful data visualizations using charts, graphs, and dashboards to communicate insights to stakeholders effectively.
4. Collaboration and Training: Collaborate with cross-functional teams to understand business needs and translate them into Excel models while also providing training on advanced Excel functionalities to colleagues.
5. Model Maintenance and Optimization: Review and update models regularly to reflect changing business requirements, ensuring data integrity and efficiency.

Required Skills:

1. Proficient in Advanced Excel Functions: Deep understanding of complex formulas beyond simple VLOOKUP, INDEX MATCH, SUMIFS, CUBEMAGIC, PivotTables, Power Pivot, data validation, conditional formatting, and macros.
2. Data Analysis Skills: Ability to analyze large datasets, identify trends, and interpret results to inform decision-making.
3. Business Acumen: Strong grasp of business principles and financial concepts to effectively model business scenarios.
4. Communication Skills: Excellent ability to communicate complex analytical findings clearly and concisely to both technical and non-technical audiences.
5. Problem-Solving Skills: Capacity to identify issues within data and models, troubleshoot, and develop solutions.

Desired Qualifications:

1. Bachelor's degree in Finance, Accounting, Business Administration, or related field.
2. Proven experience in developing and managing sophisticated Excel models for financial analysis, forecasting, or operational planning.
3. Experience with data extraction and manipulation tools (e.g., Power Query) is a plus.
4. Strong proficiency in data visualization techniques.
5. Experience in training and mentoring others on advanced Excel skills.

ABOUT ISHIR

ISHIR is a digital innovation and enterprise AI services provider. We work with startups and enterprises to shape the future through accelerated innovation, deep technical expertise, access to global digital talent, and a passion for complex problem-solving. With our help, our clients overcome their most difficult digital challenges leveraging AI.

We are not just consultants; we are partners in our clients’ success, assisting them with regaining competitive edge by identifying opportunities for differentiation, industry disruption, scalable innovation, and go-to-market strategies that deliver successful outcomes.

At ISHIR, we help bold businesses accelerate innovation through Talent, Speed-to-Market, and AI. We help make an impact by solving real problems using innovation, improved customer experiences, and the right technologies.

As an ISHIR employee, you will get the advanced training you need to be successful and the opportunity to apply it. You must be passionate about technology, crave responsibility, and be eager to apply your knowledge to real business solutions for our startup and enterprise customers. These are the qualities of a person destined for success at ISHIR.

ISHIR attracts a special type of individual—someone who is proactive, thrives on challenges, feeds off success, and looks at moving targets not as obstacles but as opportunities. ISHIR is an exciting place to work. It is imbued with an entrepreneurial spirit and promotes self-reliance, open communication, and collaboration.