Senior Business Intelligence, Data Analytics & Automation Specialist

In this role, you will work with enterprise data platforms, cloud environments (Google Cloud Platform), and legacy systems to build scalable data models, impactful dashboards, and executive-level reports. You will combine technical expertise with strong business acumen to ensure high-quality, accurate, and actionable insights.

Data Engineering & Transformation

• Extract and manage structured and unstructured data from enterprise platforms, SharePoint, and relational databases
• Design and develop ETL (Extract, Transform, Load) pipelines using tools such as Power Query and Alteryx
• Develop optimized SQL queries (including BigQuery) for efficient data processing
• Build scalable and reusable data models for reporting and analytics

Reporting & Visualization

• Develop interactive dashboards using Power BI  and  Qlik Sense
• Create executive-level reports and presentations with strong attention to data accuracy and formatting standards
• Develop advanced Excel-based models using complex formulas, pivot tables, and templates

Automation

• Design and implement automated workflows using Microsoft Power Automate
• Enable automated report distribution, alerts, and notifications via Teams and email

Deployment & Support

• Publish dashboards and configure data refresh schedules
• Implement role-based access control and data security standards
• Monitor and troubleshoot data pipelines and reporting issues

User Engagement & Continuous Improvement

• Gather requirements from stakeholders and translate them into dashboards and reports
• Track dashboard usage and adoption metrics
• Continuously enhance reporting solutions based on business needs

Required

Any Graduate

• 8+ years of experience in Data Analytics, Business Intelligence, or similar roles
• Strong experience in Power BI  and  Qlik Sense
• Proficiency in SQL and data modeling concepts
• Experience with ETL tools (Power Query, Alteryx, or similar)
• Advanced skills in Microsoft Excel and PowerPoint
• Experience with Power Automate or similar workflow automation tools
• Strong analytical and problem-solving skills
• Excellent communication skills with ability to present to leadership

Preferred (Good to Have)

• Experience with Google Cloud Platform (GCP), BigQuery and Python
• Knowledge of automotive industry KPIs (market share, segmentation, etc.)
• Basic understanding of AI/ML concepts