Data Analyst

Responsibilities Location Hinjawadi, Pune, Maharashtra, MaharashtraIN Job ID REQ-056507 Key Responsibilities: Platform Support & Stabilization: · Data Extraction and Manipulation: Extract, clean, transform, and load data from various sources, including Oracle DWH and Amazon Redshift, using tools like SQL and Alteryx. · Data Analysis and Interpretation: Analyse large datasets to identify trends, patterns, and insights that can drive business decisions. · Report and Dashboard Development: Design, develop, and maintain interactive and insightful reports and dashboards using PowerBI to visualize key performance indicators and business metrics. · Business Requirements Gathering: Collaborate with stakeholders from different business units to understand their data and reporting needs, translating them into actionable analytical solutions. · Collaboration with Enterprise Application Teams: Partner with enterprise application teams to understand data flows, data quality, and ensure data integrity for reporting and analysis. · Ad-hoc Analysis: Conduct ad-hoc data analysis to answer specific business questions and provide timely insights. · Data Quality Assurance: Participate in data quality initiatives to ensure the accuracy and reliability of data used for analysis and reporting. · Documentation: Create and maintain clear and concise documentation for data sources, analytical processes, reports, and dashboards. · Presentation of Findings: Communicate analytical findings and recommendations effectively to business stakeholders through presentations and reports. · Continuous Improvement: Identify opportunities to improve data analysis processes, reporting methodologies, and the utilization of analytical tools. · Documentation: Develop and maintain documentation for data workflows, platform configurations, and operational processes. · Compliance: Adhere to and enforce data security policies and compliance requirements for the data warehouse environments. Basic Qualifications · Bachelor's degree in a quantitative field such as Business Analytics, Data Science, Statistics, Economics, Computer Science, or a related discipline. · Minimum of 5-8 years of experience as a Data Analyst or in a similar role. · Strong proficiency in SQL and experience querying relational databases, particularly Oracle DWH and Amazon Redshift. · Hands-on experience with data visualization tools, with a strong preference for PowerBI. · Proven experience using Alteryx for data preparation, blending, and advanced analytics. · Excellent analytical and problem-solving skills with the ability to interpret complex data and translate it into actionable insights. · Strong communication and presentation skills, with the ability to explain technical concepts to non-technical audiences. · Ability to work independently and collaboratively in a fast-paced environment, managing multiple priorities. · Experience working with diverse business units and understanding their unique data needs is highly desirable. · A proactive and results-oriented mindset with a strong attention to detail. · Excellent analytical, problem-solving, and troubleshooting skills. · Strong communication and collaboration skills, with the ability to work effectively in a team environment. Preferred Characteristics · Familiarity with cloud platforms such as AWS, Azure, or GCP. · Exposure to data lake concepts and technologies (e.g., AWS S3, Apache Spark, Hadoop) is a plus. · Familiarity with enterprise application data (e.g., ERP, CRM, SCM) is a plus. · Experience with other tools like Tableau is a plus. · Knowledge of data governance, security, and compliance practices · Experience working effectively in a global, matrixed organization. · Ability to drive outcomes in a highly complex matrix environment which is often amorphous. · Foster a culture of accountability, collaboration, innovation, and customer focus. · Continuously upskill the team to stay aligned with evolving technology trends and business needs.