Job
Description
Job Summary - We are seeking a detail-oriented and analytical Data Analyst to join our team. The ideal incumbent will be responsible for collecting, processing, and analyzing large datasets to uncover insights that drive strategic decision-making. You will work closely with cross-functional teams to identify trends, create visualizations, and deliver actionable recommendations that support business goals. Key Responsibilities. Drive business excellence by identifying opportunities for process optimization, automation, and standardization through data insights. Design, develop, and maintain robust ETL pipelines and SQL queries to ingest, transform, and load data from diverse sources. Build and maintain Excel-based dashboards, models, and reports; automate repetitive tasks using Excel macros, Power Query, or scripting tools. Ensure data quality, integrity, and consistency through profiling, cleansing, validation, and regular monitoring. Translate business questions into analytical problems and deliver actionable insights using statistical techniques and data visualization tools. Collaborate with cross-functional teams (e.g., marketing, finance, operations) to define data requirements and address business challenges. Develop and implement efficient data collection strategies and systems to optimize accuracy and performance. Monitor and troubleshoot data workflows, resolving issues and ensuring compliance with data privacy and security regulations. Document data processes, definitions, and business rules to support transparency, reuse, and continuous improvement. Support continuous improvement initiatives by providing data-driven recommendations that enhance operational efficiency and decision-making. Contribute to the development and implementation of best practices in data management, reporting, and analytics aligned with business goals. Person Profile . Qualification - Bachelor’s / Master’s degree in Computer Science, Information Systems, Statistics, or a related field. Experience- 2 -5 Yrs. Desired Certification & Must Have- 3–5 years of experience in data analysis, preferably in the pharmaceutical industry. Advanced proficiency in SQL (joins, CTEs, window functions, optimization) and expert-level Excel skills (pivot tables, advanced formulas, VBA/macros). Strong understanding of data warehousing, relational databases, and ETL tools (e.g., SSIS, Talend, Informatica). Proficiency in data visualization tools (e.g., Power BI, Tableau) and statistical analysis techniques. Solid analytical and problem-solving skills with attention to detail and the ability to manage complex data sets and multiple priorities. Excellent communication and documentation skills to convey insights to technical and non-technical stakeholders. Familiarity with data modelling, database management, and large-scale data manipulation and cleansing. Demonstrated ability to work collaboratively in Agile/Scrum environments and adapt to evolving business needs. Strong focus on process optimization, continuous improvement, and operational efficiency. Experience in implementing best practices for data governance, quality assurance, and compliance. Ability to identify and drive initiatives that enhance business performance through data-driven decision-making. Exposure to business domains such as finance, operations, or marketing analytics with a strategic mindset Show more Show less
