

RSM is hiring an SMI Data Analyst 1 in Bengaluru to support the firm’s Sales and Marketing Intelligence team. The role centres on turning raw numbers from Power BI and Excel into executive-ready PowerPoint presentations that senior leaders can use for decisions. You will work alongside analysts based in the US and Canada, handle ad hoc data requests, and make light edits to existing reports so business questions get answered quickly. It is a strong starting point for candidates who enjoy data storytelling, care about accuracy, and want exposure to enterprise-level reporting at a global professional services network.
This role suits candidates who like working with numbers but also enjoy explaining what those numbers mean. At RSM, the SMI Data Analyst 1 sits between raw dashboards and the leadership slides that guide sales and marketing decisions.
Why This Role Matters
Leadership teams rarely have time to open dashboards and dig through filters. They depend on analysts who can pull the right figures, check them, and present them in a format that is clear on the first read. This position supports Enterprise-level analysis on Sales and Marketing performance, so the quality of your work directly shapes the conversations leaders have in review meetings.
The role is built around two skills working together: foundational data analysis and polished presentation development.
Because you will partner closely with senior analysts, you also get a front-row view of how experienced professionals frame insights, handle follow-up questions, and structure a story around data.
A Typical Day In This Role
Your day will likely begin with checking incoming requests from the SMI team and the US/Canada-based analysts. Some requests will be quick data pulls from an existing Power BI dashboard. Others will be larger, such as building or refining a PowerPoint deck for a leadership meeting.
Expect a mix of the following through the week:
Work Area | What You Will Do |
|---|---|
Presentation Development | Build and refine executive-ready PowerPoint decks with consistent formatting |
Data Extraction | Pull and compile data from Power BI and Excel for analysis |
Trend Analysis | Identify trends, variances, and key performance drivers |
Data Validation | Check that numbers in slides match the reporting outputs |
Report Support | Make light modifications to existing reports to answer business questions |
Ad Hoc Requests | Respond to time-sensitive asks from the SMI team |
Data Storytelling Responsibilities
The presentation side of this job goes beyond making slides look neat. You will translate dashboards, data outputs, and analyst insights into visual narratives that leadership can absorb quickly. When US or Canada-based analysts send “next level deep” requests, you will iterate with them to sharpen the story and answer the follow-up question before it is asked.
A slide that needs no explanation usually comes from an analyst who understood the data first.
Consistency matters here. Fonts, chart styles, number formats, and terminology should align across every deliverable, since leadership notices when two slides show the same metric differently.
Analysis And Validation Work
On the analysis side, you will extract and compile data, then look for movement worth explaining. That could be a dip in campaign performance, a variance against target, or a region outperforming others. Supporting deeper-dive analysis means spotting these patterns and documenting what appears to drive them.
Equally important is validation. You are expected to confirm that reporting outputs and presentation materials tell the same story. Small mismatches between a dashboard and a slide can undermine trust, so attention to detail is treated as a core requirement rather than a bonus.
Power BI And Reporting Exposure
You will not be building enterprise data models from scratch in this role. Instead, you will leverage existing Power BI dashboards to retrieve and format data, and make light changes to existing reports when a business question needs a faster answer. You will also help keep data consistent across reporting outputs.
Part of the job is communicating report update ideas to developers. That means describing what a report should show, which fields matter, and why, in language a BI developer can act on.
Power BI Excel SQL PowerPoint
Skills Comparison At A Glance
Area | Required | Preferred |
|---|---|---|
Education | Bachelor’s degree or equivalent experience | Economics, Business Analytics, or Marketing major |
Office Tools | Strong to advanced Microsoft Office skills | Not specified |
Data Skills | Working with large datasets, Excel, BI, SQL concepts | Prior SQL experience |
BI Tools | Understanding of reporting concepts | Hands-on experience with a BI tool |
Analytics | Analytical mindset | Experience analyzing data and predicting outcomes |
Communication | Verbal and written clarity | Not specified |
Work Style | Autonomous and team-oriented, good prioritization | Not specified |
Hiring Expectations
The experience band is 0-3 Years , so both fresh graduates and early-career professionals can apply. Recruiters are likely to look closely at how clearly you communicate, how careful you are with numbers, and whether you can handle several tasks in a fast-paced environment.
Candidates with a degree in Economics, Business Analytics, or Marketing have an edge, but the posting also accepts equivalent experience. If your background is in another stream such as IT or engineering, projects that show data analysis and reporting can make up the difference.
Working With A Global Team
The SMI team collaborates across regions, and you will work directly with analysts in the US and Canada. This means clear written updates, good time management across time zones, and comfort in receiving feedback and turning it around quickly.
Time-sensitive deliverables for leadership meetings are part of the routine. Being organized, flagging risks early, and confirming requirements before starting will help you stay ahead.
Full-Time Associate Level Global Collaboration
Things Worth Learning Before Applying
A little preparation can make your application noticeably stronger. Focus on these areas:
Excel beyond the basics, including pivot tables, lookups, and chart formatting. SQL fundamentals such as joins, filters, and aggregations. Power BI basics, including how to read a dashboard, apply slicers, and export figures. PowerPoint design habits like clean layouts, consistent styling, and one message per slide.
Understanding database structures and data querying at a conceptual level is listed as a requirement, so be ready to explain how tables relate and how you would pull a specific metric.
What Recruiters May Evaluate
Expect questions that test both thinking and communication. You may be asked to explain a time you found an error in a report, describe how you would present a sales trend to a senior leader, or walk through a simple SQL or Excel problem.
Be ready to show how you prioritize multiple tasks, how you handle unclear requests, and how you double-check your work before sharing it.
What Can Strengthen Your Resume
Highlight any project where you analyzed data and presented findings, even if it was academic. A dashboard you built, an Excel analysis you documented, or a presentation you delivered all show relevant ability. Mention the tools used and the outcome, such as a trend you identified or a decision your analysis supported.
Avoid vague phrases like “good with data.” Specific examples of datasets handled, metrics tracked, and reports produced are far more convincing.
Career Direction From Here
This position builds a foundation in sales and marketing analytics, business intelligence, and executive communication. With experience, analysts often move toward senior analyst roles, deeper BI work, or specialized analytics functions, depending on interest and performance.
Certifications such as Microsoft Power BI Data Analyst or an SQL certification can support that growth.
Keywords For Resume
Data Analyst • Sales Analytics • Marketing Analytics • Power BI • Microsoft Excel • PowerPoint • SQL • Business Intelligence • Data Visualization • Data Validation • Variance Analysis • Reporting • Ad Hoc Analysis • Stakeholder Communication • Attention to Detail
Closing Notes
This opportunity offers early-career candidates a practical way to build skills in analytics, reporting, and presentation within a global professional services environment. Applicants who combine careful data handling with clear communication will be well placed to grow in this role.
The above article is written by me, a person interested in technology, automobiles, modern gadgets, movies, music, and clean aesthetics.



