Analytics Specialist

About the Role Prospect Infosystem LLP is looking for a detail-oriented Analytics Specialist with 4+ years of experience to join our team in Hyderabad. You will be responsible for transforming raw data into actionable insights, building dashboards and reports, and supporting data-driven decision-making for internal stakeholders and clients. This role requires a strong blend of analytical thinking, technical skills, and the ability to communicate findings clearly to both technical and non-technical audiences. Key Responsibilities: Collect, clean, and analyze data from multiple sources to identify trends, patterns, and business insightsDesign, build, and maintain interactive dashboards and reports for stakeholders and clientsPartner with business and client teams to understand reporting needs and translate them into analytics solutionsWrite and optimize complex SQL queries to extract and manipulate data from relational databasesDevelop and maintain ETL/data pipelines to ensure accurate and timely data availabilityPerform statistical analysis to support business decisions and validate hypothesesMonitor key business metrics and KPIs, flagging anomalies or significant trends proactivelyCreate clear, well-structured presentations and reports summarizing analytical findingsCollaborate with engineering and data teams to ensure data quality, consistency, and governanceSupport ad-hoc data requests and deep-dive analyses across departments or client accountsContinuously evaluate and recommend improvements to reporting tools, processes, and data infrastructureEnsure data accuracy, consistency, and compliance with data privacy standards Required Skills & Qualifications: 4+ years of experience in data analytics, business intelligence, or a related analytical roleStrong proficiency in SQL for querying and manipulating large datasetsHands-on experience with BI/visualization tools: Power BI, Tableau, or LookerSolid skills in Excel (pivot tables, advanced formulas, macros)Working knowledge of Python or R for data analysis and automationExperience with statistical analysis and interpreting quantitative dataFamiliarity with data warehousing concepts and tools (Snowflake, BigQuery, Redshift, or similar)Understanding of ETL processes and data pipeline fundamentalsAbility to translate business questions into structured analytical approachesStrong attention to detail and data accuracyExcellent communication skills, with the ability to present data insights to non-technical stakeholdersExperience working with large, messy, or unstructured datasets Preferred Qualifications: Experience with cloud data platforms (AWS, Azure, or GCP)Familiarity with version control (Git) for analytics code and scriptsExposure to A/B testing and experimentation frameworksKnowledge of data modeling and dimensional modeling conceptsExperience working in a client-facing or services-based delivery environmentRelevant certifications (Power BI, Tableau, Google Data Analytics, etc.) Education: Bachelor's degree in Statistics, Mathematics, Computer Science, Economics, or a related field (or equivalent practical experience) What We Offer Competitive salary aligned with experience and market standardsExposure to diverse analytics projects across multiple client domainsComprehensive health insurance and wellness benefitsFlexible working hours and hybrid work optionsLearning & development support for certifications, courses, and conferencesCollaborative, growth-oriented work culture About the Role Prospect Infosystem LLP is looking for a detail-oriented Analytics Specialist with 4+ years of experience to join our team in Hyderabad. You will be responsible for transforming raw data into actionable insights, building dashboards and reports, and supporting data-driven decision-making for internal stakeholders and clients. This role requires a strong blend of analytical thinking, technical skills, and the ability to communicate findings clearly to both technical and non-technical audiences. Key Responsibilities: Collect, clean, and analyze data from multiple sources to identify trends, patterns, and business insightsDesign, build, and maintain interactive dashboards and reports for stakeholders and clientsPartner with business and client teams to understand reporting needs and translate them into analytics solutionsWrite and optimize complex SQL queries to extract and manipulate data from relational databasesDevelop and maintain ETL/data pipelines to ensure accurate and timely data availabilityPerform statistical analysis to support business decisions and validate hypothesesMonitor key business metrics and KPIs, flagging anomalies or significant trends proactivelyCreate clear, well-structured presentations and reports summarizing analytical findingsCollaborate with engineering and data teams to ensure data quality, consistency, and governanceSupport ad-hoc data requests and deep-dive analyses across departments or cli