Data Reporting Analyst

Ford Racing; Chennai District; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Ford Racing is seeking a data analytics professional to work on enterprise data platforms and cloud environments in Chennai. You will build scalable data models, create executive dashboards, and deliver accurate reports for leadership.

The role requires hands-on experience with Power BI, Python, SQL, and GCP/BigQuery, plus strong communication skills to present insights to executives. Shipping reliable, automated reporting is a key focus.

Qualifications

• 1+ years of experience in Data Analytics, BI, or similar roles.
• Strong experience in Power BI and Python.
• 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.
• Experience with Google Cloud Platform (GCP), BigQuery.
• Strong analytical and problem-solving skills.
• Excellent communication skills with ability to present to leadership.

Responsibilities

• Extract and manage structured and unstructured data from enterprise platforms, SharePoint, and relational databases.
• Design and develop ETL pipelines using Python and Power Query.
• Develop optimized SQL queries including BigQuery for efficient data processing.
• Build scalable and reusable data models for reporting and analytics.
• Develop interactive dashboards using Power BI and MS Excel.
• Create executive-level reports and presentations with strong data accuracy.
• Develop advanced Excel-based models using complex formulas, pivot tables, and templates.
• Design automated workflows using Power Automate and automate report distribution.
• Enable automated report distribution via Teams and email.
• Publish dashboards, configure data refresh, and enforce data security standards.
• Monitor and troubleshoot data pipelines and reporting issues.
• Gather requirements from stakeholders and translate into dashboards and reports.
• Track dashboard usage and adoption metrics.
• Continuously enhance reporting solutions based on business needs.

Skills

Power BI

Python

Power Query

SQL

BigQuery

GCP

Excel

Power Automate

SharePoint

Data modeling

Education

Bachelor of Computer Science Engineering

BE CSC - AI, ML, LLM specialization

Tools

Power BI

MS Excel

Google Cloud Platform

Alteryx

BigQuery

Power Query

Teams

SharePoint

Job description

In this role, you will work with enterprise data platforms, cloud environments (Google Cloud Platform), and legacy systems to build scalable data models, impactful presentations, 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 Python and Power Query
• 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 usingPower BI and MS Excel
• 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 usingMicrosoft 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

Bachelor of Computer Science Engineering

BE CSC - with Specialization in AI, ML, LLM

• 1+ years of experience in Data Analytics, Business Intelligence, or similar roles
• Strong experience inPower BI and Python
• Proficiency inSQL and data modeling concepts
• Experience withETL tools (Power Query, Alteryx, or similar)
• Advanced skills inMicrosoft Excel and PowerPoint
• Experience withPower Automateor similar workflow automation tools
• Experience withGoogle Cloud Platform (GCP),BigQuery
• Strong analytical and problem-solving skills
• Excellent communication skills with ability to present to leadership

Preferred (Good to Have)

• Knowledge ofautomotive industry KPIs(market share, segmentation, etc.)