Data Analyst
Description
Position: Data Analyst
Mode: 100% Remote
Shift Timing: 05:30 PM to 02:00 AM IST
Working Days: Monday–Saturday
Type: Full time
Exp: 2+ Years
About the Role
Senior Data Analyst to manage and analyse data across all departments of the firm, from client enquiries and calls to matters, billing and hiring. You’ll organise data held in SharePoint and spreadsheets, build reliable dashboards in Power BI, and turn numbers into clear insights for the partners and management team.
This is a hands-on role with high visibility, ideal for someone who enjoys building reports and systems as much as explaining what the data means.
Key Responsibilities
Data management and integration
Organise and maintain firm-wide data stored in SharePoint, Excel and other systems
Gather and consolidate data from multiple platforms, including Google Analytics, social media platforms and CRM
Integrate data sources into Power BI to create seamless, automated reporting
Set up and maintain a clear SharePoint structure, naming standards and access permissions
Maintain a reliable, single source of truth for key firm metrics
Ensure data accuracy through regular checks, audits and clean-up
Reporting and dashboards
Build and maintain Power BI dashboards for management and each department
Prepare and deliver daily, weekly, monthly and quarterly MIS reports on schedule
Send End of Day (EOD) reports to the Resource Manager summarising the day’s work and progress
Respond to ad-hoc data requests from partners and department heads
Client enquiries, calls and leads
Track and report on client enquiries, call volumes, response times and missed calls
Analyse enquiry sources and conversion from enquiry to consultation to engagement
Report on enquiry trends by practice area
Website and social media analytics
Develop Power BI dashboards giving real-time insight into website traffic, social media performance and campaign effectiveness
Monitor key metrics such as engagement rates, traffic sources, conversions and ROI
Analyse website and social media data in depth to identify trends, patterns and areas for improvement
Regularly audit website and social media analytics setups to ensure accurate tracking and reporting
Firm performance analytics
Report on matters opened and closed by practice area and lawyer
Track billable hours, utilisation, realisation, billing and collections
Provide insights on client-wise revenue and repeat business
Hiring and HR data
Maintain recruitment data: open positions, candidate pipeline, time-to-hire, joining and attrition for associates, interns and staff
Software usage reporting
Track and report on how software and tools (such as CRM, VDI and VPN) are being used across departments
Provide usage reports to the Resource Manager with recommendations for improvement
Stakeholder collaboration
Hold biweekly meetings with Heads of Departments (HODs) to review reporting needs, data quality and tool effectiveness
Work with HODs to resolve data-related challenges and improve how teams use reports and dashboards
Automation and process improvement
Automate data collection and reporting using Power Query and Power Automate
Reduce manual reporting work and improve data entry processes across teams
Train staff on correct data entry and use of dashboards
Stay updated on AI-driven tools and practical applications that can improve the firm’s reporting and operations
Confidentiality
Handle client and matter data with strict access controls
Follow the firm’s confidentiality and data protection policies at all times
Requirements
Must have
Bachelor’s degree in Computer Science or a related field
[3] years of experience in data analysis, MIS, reporting or business intelligence
Strong hands-on experience with Power BI (data modelling, DAX, scheduled refresh)
Advanced Excel skills: pivot tables, XLOOKUP, Power Query, data validation
Working knowledge of SharePoint (document libraries, lists, permissions)
Strong attention to detail and the ability to explain data clearly to non-technical audiences
Experience working with multiple teams and handling sensitive information responsibly
Skills
Sign in to read and join the discussion.