Data Reporting Analyst
Job Summary
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.
Responsibilities
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
Qualifications
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.)
Required Experience:
IC
About Company
FordĀ® is Built for America. Discover the latest lineup in new Ford vehicles! Explore hybrid & electric vehicle options, see photos, build & price, search inventory, view pricing & incentives & see the latest technology & news happening at Ford.