Job Description
About Company:
We’ve built great IP in the IoT space, in embedded hardware Wireless Data Acquisition, Logistics and Supply chain, Big Data and Analytics, BI and mobile platforms.
Transworld has its own R&D team of engineers who design and develop mobile hardware and write cloud based server side, enterprise class software and deployments. A startup, Transworld has substantial traction in other areas and verticals of application for its technology – Utilities and Power, TV Ratings, TV Anti-Piracy, Warehouse and cloud based CRM and ERP solutions.
All of its solutions center around its core technology expertise and IP – remote wireless data acquisition devices for the Internet of Things, server software for Cloud Big Data, BI, CRM and ERP and are built using open source software and platforms – instantly scaleable on the cloud.
Transworld star performer, the Mobile Eye, is an embedded hardware device that captures and processes data form a variety of sensors, both in-house and COTS, to move results of processed data to the cloud for Big Data analytics in near real time.
FleetView, Transworld’s online big data portal offers full function, real time fleet management on the cloud, with end-to-end visibility across the supply chain. FleetView integrates easily with standard ERPs like SAP or J. D. Edwards, in addition to the Indian household financial accounting package, Tally.
FleetView lets users monitor their fleet turnaround, destination wise ETAs, plan return loads as well as generate invoicing, purchase orders and manage expenses, by vehicle, driver, location or group. with more than 12,000 vehicle units delivered, the portal handles more than 1 million data records per day and has provided road safety systems for big brand companies like ACC Holcim, Castrol, BP, PraxAir, Linde, Unilever, Shell, Agility and lots of other safety and efficiency conscious majors.
Company Name: FleetView – Transworld Technologies Ltd.
Experience: Fresher.
Role: Data Analyst/ BI Developer.
Job Location: Pune.
Eligibility Criteria:
- Qualification: BE/B.TECH(CS/IT),BCS,BCA,MCS,MCA.
- Pass out Year: 2023/2024/2025.
- Percentage Criteria: NA.
- Any Bond: 2 Years.
Approx. Package: Rs. 2,16,000/- Per Annum(Based on Interview).
Roles and Responsibilities:
- Gather and analyze business requirements to design effective data dashboards and reporting solutions.
- Define, implement, and monitor key performance indicators (KPIs) such as shipment performance, driver alerts, and device health.
- Design and maintain datasets in Apache Superset for accurate and scalable analytics.
- Write, test, and optimize complex SQL queries for reporting and dashboard development.
- Validate data accuracy by comparing dashboard outputs with raw MySQL database records.
- Troubleshoot and resolve data issues including joins, GroupBy errors, and missing values.
- Develop and maintain interactive dashboards for operational and client-specific use cases.
- Create visualizations including KPI cards, line charts, bar charts, heatmaps, and drill-down tables.
- Enhance dashboard usability through filters, layout optimization, and intuitive design.
- Apply CSS customizations and branding elements to improve dashboard UI.
- Optimize dashboard performance to ensure efficient loading and responsiveness.
- Implement cross-filtering and interactivity across multiple dashboard components.
- Develop automation workflows using Python, Node-RED, and Telegram Bot API.
- Manage user roles, permissions, and access control in Apache Superset.
- Deliver reports, conduct client demos, and resolve data discrepancies based on stakeholder feedback.
Skills Required:
- Strong proficiency in SQL (joins, aggregations, query optimization)
- Experience with Apache Superset for dashboard development
- Knowledge of MySQL for data extraction and validation
- Hands-on experience with Grafana
- Programming skills in Python
- Familiarity with Node-RED for workflow automation
- Experience with Telegram Bot API for alerting systems
- Understanding of Amazon Web Services for infrastructure management
- Strong data validation and data quality assurance skills
- Expertise in KPI definition and business metrics analysis
- Dashboard design, data visualization, and storytelling skills
- Ability to optimize dashboards for performance and usability
- Knowledge of CSS for dashboard UI customization
- Problem-solving and analytical thinking ability
- Effective communication and stakeholder management skills