DATA ANALYST (CCP for ICT Professionals - Data and AI)

Responsibilities:

. Consolidate TRD's proposal status, inventory readiness, project updates and operational follow-up data in Microsoft Excel Power Query, then prepare planning and budget-support summary views in Microsoft Power BI Desktop for management review of its Counter-UAS / anti-drone business activities.

. Improve TRD's manual reporting process for its Counter-UAS / anti-drone business by cleaning recurring data in Microsoft Excel Power Query, preparing dashboard views in Microsoft Power BI Desktop, and supporting simple repetitive reporting tasks through Python via Google Colab.

. Gather TRD's reporting requirements from Business, Inventory, Project, Logistics, Finance, Engineering support and Management teams, then structure required fields in Microsoft Excel Power Query, organise recurring Counter-UAS business data tables in PostgreSQL, and prepare reporting views in Microsoft Power BI Desktop.

. Track TRD's lead movement, proposal progress, partner engagement, inventory visibility, project handover updates and operational status indicators through Microsoft Power BI Desktop, with supporting Counter-UAS business data cleaned and refreshed through Microsoft Excel Power Query.

. Analyse TRD's lead sources, enquiry types, client segments, partner responsiveness, proposal turnaround, inventory readiness and recurring bottlenecks by preparing cleaned datasets in Microsoft Excel Power Query, performing analysis support in Python via Google Colab, and presenting Counter-UAS business insights in Microsoft Power BI Desktop.

. Collect and consolidate TRD's sales reports, partner updates, trade show records, proposal files, inventory references, project updates and operational reports. Transform the data through Microsoft Excel Power Query, organise recurring reporting tables in PostgreSQL, and support repetitive data preparation tasks through Python via Google Colab.

. Handle TRD's business, client, partner, inventory, project and operational data responsibly by keeping approved source records in Microsoft Excel Power Query, maintaining only required reporting tables in PostgreSQL, and preparing internal Counter-UAS business reporting views in Microsoft Power BI Desktop for authorised review.

. Create clear dashboard views in Microsoft Power BI Desktop for TRD's salespipeline movement, trade show lead conversion, partner engagement, proposal progress, inventory visibility, project updates and operational status indicators for its Counter-UAS / anti-drone solutions.

. Create, maintain and update structured reporting tables in PostgreSQL for TRD's recurring business, sales, partner, inventory, project and operational data. Retrieve, filter, join, summarise, validate and compare datasets used for Counter-UAS business reporting and analysis.

. Review reporting pain points from TRD's internal users, improve report templates in Microsoft Excel Power Query, and refine dashboard views in Microsoft Power BI Desktop so Business, Inventory, Project and Management teams can understand and update Counter-UAS business information more easily.

. Organise TRD's lead source data, client segments, trade show records, partner updates and proposal movement in Microsoft Excel Power Query, then prepare opportunity visibility reports in Microsoft Power BI Desktop to support business follow-up for its Counter-UAS / anti-drone solutions.

. Maintain TRD's reporting schedules, dashboard update routines, report templates, data dictionaries, field definitions and quality checks. Use PostgreSQL for recurring reporting tables, Microsoft Excel Power Query for data preparation, and Microsoft Power BI Desktop for scheduled management reporting outputs.

. Coordinate with TRD's Business, Inventory, Project, Logistics, Finance, Engineering support and Management teams to clarify reporting requirements and verify information sources. Prepare cleaned report inputs in Microsoft Excel Power Query, validate recurring records in PostgreSQL, and share management-ready views through Microsoft Power BI Desktop.

Skills / Requirements:

. Strong attention to detail and ability to review information accurately.

. Able to organise, check, and summarise data from different sources.

. Good analytical thinking and problem-solving skills.

. Able to prepare clear reports and present information in an understandable manner.

. Comfortable coordinating with different departments to gather and verify information.

. Able to work independently while ensuring timely follow-up on reporting matters.