IT System Coordinator

Job Details

Job Position – IT System Coordinator

Company Name – Acciona

SALES OPERATIONS (Railway Project)

Location: Jeddah, KSA

Key Responsibilities:
1. Database Management & Documentation:
-Develop and maintain comprehensive database documentation, with a focus on SQL scripts, query structures, and data integration processes.
-Ensure clear communication and document control procedures to manage project phases and data workflows effectively.

2. System Implementation & SQL Optimization:
-Coordinate new system rollouts with a focus on SQL testing, ensuring data consistency, performance, and stability.
-Collaborate with stakeholders to refine SQL-based solutions, making necessary adjustments to optimize database processes and support final delivery.

3. System Maintenance & SQL Troubleshooting:
-Oversee system maintenance with regular SQL database updates in response to policy or regulatory changes.
-Provide SQL troubleshooting and support to maintain data integrity, resolving issues promptly.

4. Sales & Demand Data Management:
-Manage SQL-driven processes for handling agency requests, train schedules, and allocation planning.
-Optimize SQL queries for commercial offers, train allocations, and quota adjustments to meet demand efficiently.

5.Passenger Claims & Compensation Processing:
-Process compensation for passenger claims related to system or sales errors, utilizing SQL to analyze incidents and identify patterns in delays, cancellations, or payment issues.

6. Regulatory Reporting & Data Integration:
-Prepare SQL-based reports for regulatory bodies (e.g., Transport General Authority) and clients, ensuring accurate data extraction from PostgreSQL.
-Use SQL to manage and integrate data into automated Excel VBA processes for efficient reporting.

7. Data Analysis & Report Generation:
-Develop and maintain Power BI and Excel reports, leveraging SQL to extract data insights, monitor sales operations, and identify system errors.
-Ensure data accuracy and apply corrective SQL solutions to enhance reporting and meet customer needs.

Skills & Requirements:
-SQL Proficiency: Expertise in SQL, particularly PostgreSQL, for data management, query optimization, and reporting.
-Strong Programming Skills: In-depth knowledge of SQL and database programming is required to develop optimized queries, automate processes, and troubleshoot complex issues.
-Advanced Excel Skills: Proficiency in Excel, including VBA programming for data automation.
-Data-Driven Mindset: Ability to leverage SQL for data analysis, troubleshooting, and report generation.

Interested candidates should submit their resume and a cover letter detailing their relevant experience and qualifications to recruitmentme@acciona.com

Tagged as: IT Jobs, Linkedin Jobs