Assistant Manager - Business Intelligence & Insights

Assistant Manager - Business Intelligence and Insights Group

Mandatory Skills : Python, Power Bi, Business Insights

Job Summary :

Role : Reporting / Dashboard Automation Specialist in the Non-Distribution Patch of BIIG

• Primary Focus : Leveraging technical tools like Python, Power BI, SQL, VBA, and automation techniques to drive reporting and analytics efficiency.
• Automate Reporting Systems : Develop and maintain end-to-end automated reporting pipelines using Python (pandas, numpy, etc.), Power BI, and SQL. Design and implement automated scripts for report generation, ensuring data integrity, timeliness, and accuracy.
• Data Transformation & Integration : Design complex ETL (Extract, Transform, Load) processes to integrate data from multiple sources, optimizing performance and reducing manual intervention. Build data models, perform data cleansing, and develop complex queries to provide accurate and meaningful insights.
• Advanced Analytics : Apply statistical analysis, machine learning models, or advanced Python libraries (e.g., SciPy, scikit-learn) to identify patterns, anomalies, and insights from large datasets. Implement predictive models and trend analysis to assist in business forecasting and decision-making.
• Dashboard Development & Visualization : Create interactive, real-time dashboards in Power BI, integrating with backend databases and automating data flows for dynamic reporting. Use DAX, Power Query, and other Power BI features to create complex metrics and KPIs.
• VBA & Macro Automation : Develop and optimize VBA scripts and macros to automate repetitive tasks in Excel and other reporting tools. Integrate these solutions with other systems, enabling seamless data transfers and report generation.
• Database Management : Write and optimize complex SQL queries, stored procedures, and triggers to extract data, perform calculations, and automate reporting tasks. Ensure data quality and consistency through rigorous database management practices.
• Performance Optimization : Optimize Python and SQL code for performance, ensuring scalability and handling large datasets efficiently. Conduct troubleshooting and performance tuning of automation scripts to minimize processing time and improve reliability.

Functional Responsibilities :

Others :

5 days Work from office.

Location : Gurugram

Mode of interview : F2F

(ref : hirist.tech)