Opportunity For Executive / Sr Executive - MIS

Job Description

Role & responsibilities Design, build, and maintain Power BI dashboards and reports to visualize key metrics and business performance. Manage, automate, and streamline MIS reporting processes to ensure accuracy and timely delivery. Work extensively on Advanced Excel functions (e.g., pivot tables, lookups, formulas, macros) for day-to-day reporting. Extract, clean, and manipulate large datasets using SQL to prepare reports and dashboards. Liaise with cross-functional teams to understand reporting requirements and translate them into effective data solutions. Monitor and troubleshoot existing reports and data flows, ensuring data integrity and consistency. Generate ad-hoc reports and analysis as requested by management. Assist in validations, and standardization across reporting systems. Ensure all documentation and SOPs for dashboards and reports are maintained Build Python automation scripts to pull data from multiple APIs across different business systems on a scheduled basis. Use Power Query to build and optimize data transformation logic in Excel and Power BI, ensuring clean and analysis-ready datasets for dashboards. Troubleshoot and enhance existing automation workflows to reduce manual intervention and improve reliability. Preferred candidate profile Minimum 1+ years of hands-on experience in Power BI development and dashboard creation. Proficient in Advanced Excel (formulas, pivot tables, data validation, etc.). Strong knowledge of SQL for querying and data extraction. • Good understanding of data visualization principles and dashboard best practices. Attention to detail with a commitment to delivering high-quality outputs. Ability to work independently and handle multiple tasks under tight deadlines. Strong communication skills and the ability to explain data insights clearly to non-technical stakeholders. Strong hands-on experience with Python, especially in building data pipelines for transformation and managing large structured datasets. Experience in automating manual reporting workflows by integrating with APIs and preparing it for use in Excel and Power BI. Interested candidates can reach me @ 9686698157 or you can share your CV to anil.shyam@ample.co.in