We're Hiring: Data Analyst (Advanced Microsoft Excel)

We're Hiring: Data Analyst (Advanced Microsoft Excel)

Location: Remote

Employment Type: Full-Time

Experience: 39 Years

shift timings- 2pm onwards

Advanced Microsoft Excel refers to using Excel beyond basic spreadsheets and formulas. It involves working with complex formulas, automation, data analysis, reporting, and modeling to solve business problems efficiently

.For the Pricing Sheet Developer role, candidates should be proficient in the following advanced Excel features

:
Analyze large datasets to identify trends, patterns, and business insigh

ts Develop and maintain advanced Excel models for reporting, forecasting, and financial analys

is Build dashboards and reports to support business decision-maki

ng Automate repetitive tasks using Excel Macros and V

BA Validate data accuracy and reconcile financial and operational repor

ts Perform data cleansing, transformation, and quality chec

ks Collaborate with cross-functional teams to gather reporting requirements and deliver actionable insigh

ts Document business logic, reporting methodologies, and process improvemen

tsRequired Skil

ls
Advanced Microsoft Excel expertise, includi

ng:Advanced Formulas & Functi

• onsINDEX/MA
• TCHXLOO
• KUPIF,
• IFSSUM
• IFSArray Formu
• lasNested Functi
• onsLogical Functi

onsData Managem

• entNamed Ran
• gesData Validat
• ionConditional Formatt
• ingAdvanced Filter
• ingSorting and Data Clean

ingData Analy

• sisPivot Tab
• lesPivot Cha
• rtsWhat-If Analy
• sisTrend Analy
• sisData Model

ingAutomat

• ionExcel Mac
• rosVBA (Visual Basic for Applicatio
• ns)Report Automat

ionFinancial & Pricing Model

• ingFinancial Analy
• sisPricing Mod
• elsForecast
• ingBusiness Calculati

onsError Checking & Validat

• ionFormula Audit
• ingData Reconciliat
• ionError Handl
• ingValidation Che

cksReporting & Documentat

• ionInteractive Dashboa
• rdsExecutive Repo
• rtsDocumentation of Business Lo
• gicProcess Documentat

ion
What We're Looking

For 35+ years of experience as a Data Analyst, MIS Analyst, Reporting Analyst, or similar

role Strong analytical and problem-solving sk

ills Exceptional attention to detail and data accu

racy Experience working with large datasets and financial rep

orts Excellent communication and documentation sk

ills Ability to work independently in a remote environ

ment

Nice t

o Have Knowledge

of SQL Experience with Power Query or Power

Pivot Exposure to Power BI, Tableau, or other BI

tools Experience with financial reporting or pricing an

alysis Experience working with ERP or CRM s

ystems

Hiring

ProcessShortlisted candidates will complete a practical Advanced Microsoft Excel assessment c

• overing:Complex formulas and f
• unctionsPivo
• t TablesData
• AnalysisMacros &
• amp; VBAFinancial
• ModelingData Validation and Reconc

iliationIf you're passionate about turning data into business value and have advanced Excel expertise, we'd love to hear f

rom you!
Apply now or share this opportunity with someone in your network! priyanka.tiwari@trant

orinc.com


#Hiring #DataAnalyst #AdvancedExcel #MicrosoftExcel #DataAnalysis #BusinessAnalysis #Reporting #FinancialModeling #VBA #Macros #PivotTables #SQL #PowerBI #RemoteJob