Job Description :
- Collect clean and structure infrastructure data from multiple sources for reporting and analysis
- Write optimise and maintain SQL queries for data extraction transformation and validation
- Develop and enhance dashboards to provide clear actionable insights on CTO Infrastructure metrics
- Build and maintain Excelbased reports including pivot tables and advanced formulas for recurring MI
- Use Python scripts where applicable to automate routine data processing tasks
- Identify trends anomalies and improvement opportunities in operational data
- Collaborate with technology and operations teams to define reporting needs and ensure accuracy
- Support stakeholders with ad hoc data requests and analysis
RR :
Proficiency in SQL with experience in querying large complex datasets eg BigQuery SQL DatabasesStrong Excel skills advanced formulas pivot tables charts data analysisExperience in dashboarding tools eg Looker Studio, Tableau, QlikBasic Python skills for data manipulation automationAbility to transform raw data into meaningful insights and visualisationsStrong attention to detail with focus on accuracy and data consistencyAbility to prioritise and manage multiple tasks in a fast-paced environmentEffective communication skills to present findings clearly to technical and nontechnical stakeholdersSkills
MicroStrategy, MS Excel, Power BI, Python, QlikView, SAP Business Objects, Tableau, ANSI-SQL, Cognos Analytics, QlikSense, MySQL