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

We're Hiring: Data Analyst (Advanced Microsoft Excel) Location: Remote Employment Type: Full-Time Experience: 3–9 Years shift timings - 2pm onwards Advanced Microsoft Exce l 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 Develope r 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 expert ise, 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✔ 3–5+ 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 yst ems Hiring ProcessShortlisted candidates will complete a pr actical Advanced Microsoft Excel as sessment 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 s #NowHiring