Data Reporting Analyst

Ford Motor CompanyChennai, Tamil Nadu, Indiafull time
Active

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.

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 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

Preferred (Good to Have)

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

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 using Power 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 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

Similar jobs