وظائف SQL - الرياض السعودية

<p>Autopia is a managed B2B marketplace providing a platform that addresses supply, delivery, and credit inventory challenges in the automotive spare parts supply chain. This platform provides all reliable spare parts from key brands in one place, along with financial solutions that support customer growth and merchant inventory expansion.</p><p><br></p><p><strong>We Hire Builders</strong></p><p>We are looking for people who see themselves in decisions, not just tasks—and we are currently looking in Riyadh for a <strong>Category Analyst</strong> to take charge of commercial category analysis, review outputs from Autopia's automated pricing systems, and make final decisions based on market understanding.</p><p>You will work daily on pricing and distribution systems as well as Metabase dashboards to know at any moment where category prices stand relative to the market, which products (SKUs) are winning or losing demand due to price, and which flash offer should launch next.</p><p>This is a role where numbers translate directly into pricing decisions that impact Autopia's market competitiveness.</p><p><br></p><p><strong>Responsibilities</strong></p><ul><li>Continuously compare Autopia's category prices against market and competitor prices (OEM and aftermarket), maintaining updated reference prices for the active SKU base.</li><li>Analyze differences between cash and credit pricing as well as competitor credit terms, recommending price positions that win demand while protecting margins.</li><li>Create, price, and schedule flash offers for the category, ensuring they meet launch criteria (minimum margin, positioning relative to market index, credit price gap, supplier availability and lead time, and approval limits) prior to launch, and track performance post-launch.</li><li>Monitor out-of-stock products, missed price quotes, and canceled or unconverted orders to identify where price is the driver, and estimate recoverable demand volume.</li><li>Process price lists and supplier offers for the category, detecting errors and outliers, and feeding pricing systems with clean data.</li><li>Build periodic reports on pricing and promotional performance within the category.</li><li>Support expansion studies into new brands and assortment decisions with pricing and demand evidence.&nbsp;</li></ul><p><br></p><p><strong>Qualifications</strong></p><ul><li>Bachelor's degree in Supply Chain, Business Administration, Economics, Engineering, or a related field.</li><li>2 to 5 years of experience in pricing, category management, commercial analysis, or merchandising analytics.</li><li>Advanced proficiency in Excel and working knowledge of SQL (we work on Metabase/PostgreSQL, which is an essential tool).</li><li>Ability to translate analysis into a price or offer and defend it with numbers.</li><li>Fluency in Arabic and English to communicate with suppliers and the internal team.</li></ul><p><br></p><p><strong>Nice to Have</strong></p><ul><li>Knowledge of the OEM and aftermarket spare parts ecosystem, including part numbering and cross-referencing.</li><li>Experience in e-commerce, platforms, distribution, or the automotive spare parts sector.</li><li>Knowledge of Python.</li></ul><p><br></p><p><br></p>

<p>Full Stack Developer — Backend Focus</p><p><br></p><p>Elham is looking for a full-time developer with strong backend skills and the ability to contribute to frontend development.</p><p><br></p><p>Work arrangement: Remote</p><p>Schedule: 8 hours per day, 6 days per week</p><p>Monthly salary: USD 700–800, depending on level</p><p><br></p><p>Responsibilities</p><p>• Build and maintain reliable APIs, design database models, and develop real-time updates.</p><p>• Contribute to frontend development using React, Next.js, and Tailwind CSS.</p><p>• Analyze problems, debug errors, write meaningful tests, and collaborate via Git and GitHub.</p><p>• Take ownership of delivery, communicate clearly, manage priorities, and commit to quality standards and deadlines.</p><p><br></p><p>Required Skills</p><p>• JavaScript and TypeScript.</p><p>• React, Next.js, and Tailwind CSS.</p><p>• NestJS and/or Express.js.</p><p>• Socket.IO for real-time communication and updates.</p><p>• PostgreSQL and Prisma ORM.</p><p>• Understanding of Clean Architecture and applying it appropriately to the project size.</p><p>• Git, GitHub, and collaborative coding.</p><p>• Docker and practical knowledge of CI/CD concepts.</p><p>• Strong analytical and debugging skills.</p><p>• Efficient use of AI tools such as Codex and Claude, with clear guidance, reviewing and testing outputs, and taking ownership of the final code.</p><p><br></p><p>API Documentation is Essential</p><p>Strong experience with OpenAPI using Swagger or Scalar is required, covering authentication where present, parameters, request and response schemas, status codes and errors, and usage examples, keeping documentation aligned with implementation.</p><p><br></p><p>Mandatory Technical Challenge to Apply</p><p>Complete the challenge and attach the code in ZIP format. A CV alone is not sufficient, and a GitHub link is optional and does not replace uploading the code.</p><p><br></p><p>Develop a mini fixed-slot appointment booking API using TypeScript with NestJS or Express, PostgreSQL, and Prisma. It includes listing available slots from seed data, creating and cancelling bookings, preventing double booking even when two concurrent requests arrive, and making the slot available again after cancellation. Include input validation, clear error handling, simple Socket.IO updates, OpenAPI documentation aligned with implementation, and tests for booking success, preventing concurrent conflicts, and slot availability after cancellation.</p><p><br></p><p>This is an independent recruitment exercise. It does not require a frontend, login, payment, cloud deployment, or CI/CD setup. Target duration is 2–3 hours; report actual time and any incomplete parts.</p><p><br></p><p>The ZIP contains code, Prisma files, migrations, seed, tests, README with instructions for running, testing, and accessing documentation, and .env.example without sensitive data. Exclude node_modules and secrets. Include a brief explanation of conflict prevention mechanisms, key decisions, potential improvements, and an AI-use disclosure: tools used and how output was reviewed and tested, or a statement that none were used.</p><p><br></p><p>AI use is permitted. You must understand the code and be able to explain it and perform a short modification during the interview.</p><p><br></p><p>Evaluation: 40% correct behavior and conflict prevention, 20% code quality and data design, 20% OpenAPI documentation accuracy, 15% tests and ease of running, 5% real-time updates. No points for unrequested extra features.</p><p><br></p><p>How to Apply</p><p>Review the full challenge specifications and submit your CV and mandatory code ZIP file through the recruitment portal:</p><p>https://careers.elham.net.sa/jobs/full-stack-backend</p><p><br></p><p>The application must be submitted via this link so the team can review your info and code together.</p><p><br></p><p>────────── ENGLISH ──────────</p><p><br></p><p>Full Stack Developer — Backend Focus</p><p><br></p><p>Elham is hiring a full-time developer with strong backend skills and the ability to contribute to frontend development.</p><p><br></p><p>Work arrangement: Remote</p><p>Schedule: 8 hours per day, 6 days per week</p><p>Monthly salary: USD 700–800, depending on level</p><p><br></p><p>WHAT YOU WILL DO</p><p>• Build and maintain reliable APIs, database models, and real-time features.</p><p>• Contribute to frontend features using React, Next.js, and Tailwind CSS.</p><p>• Diagnose issues, write meaningful tests, and collaborate through Git and GitHub.</p><p>• Take ownership of delivery, communicate clearly, manage priorities, and meet quality standards and deadlines.</p><p><br></p><p>REQUIRED SKILLS</p><p>• JavaScript and TypeScript.</p><p>• React, Next.js, and Tailwind CSS.</p><p>• NestJS and/or Express.js.</p><p>• Socket.IO for real-time communication and updates.</p><p>• PostgreSQL and Prisma ORM.</p><p>• Clean Architecture, applied appropriately to the size of the project.</p><p>• Git, GitHub, and collaborative development.</p><p>• Docker and practical knowledge of CI/CD concepts.</p><p>• Strong analytical and debugging skills.</p><p>• Ability to use AI tools such as Codex and Claude effectively: provide clear instructions, review and test their output, and take responsibility for the final code.</p><p><br></p><p>API DOCUMENTATION IS ESSENTIAL</p><p>You must have strong experience with OpenAPI using Swagger or Scalar. Documentation must cover authentication where applicable, parameters, request and response schemas, status codes, errors, and usage examples, and remain aligned with the implementation.</p><p><br></p><p>MANDATORY TECHNICAL CHALLENGE</p><p>To apply, complete the challenge and upload your code as a ZIP file. A CV alone is not sufficient, and an optional GitHub link does not replace the ZIP attachment.</p><p><br></p><p>Build a small fixed-slot appointment booking API using TypeScript, NestJS or Express, PostgreSQL, and Prisma. It must list available seeded slots, create and cancel bookings, prevent double booking even when requests arrive concurrently, and make a cancelled slot available again. Include input validation, clear errors, simple Socket.IO updates, accurate OpenAPI documentation, and tests for successful booking, concurrent booking conflicts, and availability after cancellation.</p><p><br></p><p>This is a standalone hiring exercise. No frontend, login, payments, cloud deployment, or CI/CD setup is required. The target duration is 2–3 hours; report your actual time and any incomplete parts.</p><p><br></p><p>Submit a ZIP containing the source code, Prisma schema and migrations, seed, tests, README with setup/testing/documentation instructions, and a non-sensitive .env.example. Exclude node_modules and secrets. Include a brief explanation of conflict prevention, key decisions, potential improvements, and your AI-use disclosure.</p><p><br></p><p>AI tools are allowed. You must understand your submission and be able to explain it and make a short modification during the interview.</p><p><br></p><p>Evaluation: 40% correct behavior and conflict prevention; 20% code quality and data design; 20% OpenAPI accuracy; 15% tests and ease of running; 5% real-time updates. Extra features do not earn additional points.</p><p><br></p><p>HOW TO APPLY</p><p>Read the full challenge specification and submit your CV and mandatory code ZIP through our careers portal:</p><p>https://careers.elham.net.sa/jobs/full-stack-backend</p><p><br></p><p>Applications must be submitted through this link so your code and application can be reviewed together.</p>

Responsibilities: Lead and develop backend architecture using Python and Django. Design and build AI solutions and integrate advanced AI models and APIs into existing systems. Develop and design RESTful APIs and scalable software architectures. Improve database performance, tackle technical challenges, and ensure system stability and speed. Guide team developers and perform code reviews to implement best practices. Requirements & experience: 5 to 7 years of hands-on web development experience with Python and Django. Deep background and hands-on applications in AI, integrating tools and models with systems. Proficiency in databases (e.g., PostgreSQL) and caching tools (e.g., Redis). Strong experience in software architecture thinking and building microservices. Proficiency with version control tools (Git) and deployment/run environments (CI/CD & Cloud Services). <p><strong>Additional Details</strong></p><ul><li>Number of vacancies: 1</li><li>Shift system: Morning and Evening</li><li>Welcomes people with disabilities (mild mobility impairment, hearing impairment - designed, hearing impairment - partial hearing loss, use of crutch, use of wheelchair, limb amputation, polio)</li></ul>

Responsibilities and duties: Leading and developing the backend architecture using Python and Django. Designing and building AI solutions and integrating advanced models (AI Models & APIs) into existing systems. Building and designing RESTful APIs and scalable software architectures. Improving database performance, addressing complex technical challenges, and ensuring system stability and speed. Guiding developers in the team and conducting code reviews to apply best practices. Requirements and experience: At least 5 to 7 years of hands-on web development experience using Python and Django. In-depth background and practical applications in AI and integrating its tools and models with systems. Proficiency in working with databases (such as PostgreSQL) and caching tools (such as Redis).Strong experience in software architecture thinking and building microservices. Proficiency in version control tools (Git) and deployment/run environments (CI/CD & Cloud Services). <p><strong>Additional details</strong></p><ul><li>Number of vacancies: 1</li><li>Shift system: morning and evening</li><li>Welcomes people with special needs (mild mobility impairment, hearing impairment - designed, hearing impairment - hard of hearing, use of cane, use of wheelchair, limb amputation, polio)</li></ul>

<p>Job Title: Applications &amp; Portal Interfaces Engineer*</p><p><br></p><p>*Job Overview*</p><p><br></p><p>We are looking for an Applications and Portal Interfaces Engineer with at least 3 years of experience in supporting enterprise applications, web portals, and software integration services (Middleware), to join our IT team in a government/enterprise work environment. The ideal candidate possesses practical experience in Microsoft technologies, IIS servers, SQL Server databases, and Application Programming Interfaces (REST/SOAP APIs).</p><p><br></p><p>*Key Responsibilities*</p><p><br></p><p>- Supporting and maintaining enterprise portals and ensuring continuous operation for internal and external users.</p><p>- Managing and configuring Microsoft IIS servers.</p><p>- Participating in coordinating and supporting deployment activities for new releases in coordination with development teams.</p><p>- Receiving and handling Level 1 and Level 2 (L1/L2) technical support tickets and escalating complex cases when necessary.</p><p>- Supporting authentication services associated with Active Directory.</p><p>- Monitoring application performance and health using tools such as Zabbix and SolarWinds.</p><p>- Performing initial checks and minor performance tuning on SQL databases.</p><p>- Managing SSL certificates, tracking their validity, and renewing them.</p><p>- Assisting in analyzing and troubleshooting system integration errors via REST/SOAP APIs.</p><p>- Preparing initial Root Cause Analysis (RCA) reports under the supervision of senior engineers.</p><p>- Documenting operating procedures and daily technical procedures.</p><p>- Participating in routine preventive maintenance activities.</p><p>- Coordinating with service providers and external technical support when needed.</p><p><br></p><p>*Required Qualifications*</p><p><br></p><p>- Bachelor's degree in Software Engineering, Computer Science, or a related field.</p><p>- At least 3 years of practical experience in application or web portal support.</p><p>- Good knowledge of Microsoft IIS, Windows Server, and Linux basics.</p><p>- Practical knowledge of SQL Server (Oracle is an added plus).</p><p>- Basic understanding of REST/SOAP APIs, JSON, and XML.</p><p>- Familiarity with incident management tools such as ServiceNow or Jira.</p><p>- Knowledge of ITIL fundamentals in incident and change management.</p><p><br></p><p>*Preferred Technical Skills*</p><p><br></p><p>Application Support | Enterprise Portals | IIS | Windows Server | SQL Server | REST/SOAP APIs | Active Directory | SSL Certificates | Incident &amp; Change Management | PowerShell | Git | Azure DevOps</p>

<p></p><p>We announce the availability of a job vacancy for the position of:</p><p><strong>Data Analyst</strong></p><p>We are looking for someone with the ability to analyze data and turn it into reports and indicators that help management make decisions and improve performance.</p><p><strong>Responsibilities and Duties:</strong></p><ul><li>Preparing periodic and analytical reports.</li><li>Designing and developing interactive <strong>Dashboards</strong>.</li><li>Analyzing data and extracting key metrics and trends.</li><li>Preparing and monitoring Key Performance Indicators (<strong>KPIs</strong>).</li><li>Collecting, organizing, and cleaning data from various sources.</li><li>Translating data into clear and understandable outputs for management.</li><li>Continuously developing reports and Dashboards according to the needs of different departments.</li><li>Collaborating with various departments to understand their data and reporting needs.</li></ul><p><strong>Requirements:</strong></p><ul><li>Experience in data analysis and reporting.</li><li>Proficiency in using <strong>Power BI</strong>.</li><li>Proficiency in <strong>Excel</strong> and data analysis.</li><li>Ability to work with databases, with knowledge of <strong>SQL</strong> preferred.</li><li>High skills in reporting and data visualization.</li><li>Ability to analyze problems and draw conclusions.</li><li>Good communication and organizational skills.</li></ul><p><br></p>

<p><strong>Job Title:</strong> Oracle Fusion ERP Administrator / Developer (Hybrid Role)</p><p><strong>Company:</strong> Cellular Networks, Riyadh</p><p><strong>Job Summary</strong></p><p>The <strong>Oracle Fusion ERP Administrator / Developer (Hybrid Role)</strong> is responsible for configuring, customizing, integrating, and administering the <strong>Oracle Fusion Cloud</strong> system. This role ensures system reliability, data integrity, and optimal performance across Financials, Procurement, Supply Chain Management (SCM), and Human Capital Management (HCM) modules, while supporting internal teams, optimizing processes, and ensuring compliance with the requirements of the <strong>Saudi Central Bank (SAMA)</strong> and the <strong>Personal Data Protection Law (PDPL)</strong>.</p><p><strong>Key Responsibilities</strong></p><p><strong>1. System Administration</strong></p><p>• Manage the <strong>Oracle Fusion ERP</strong> system across company modules, including Financials, Procurement, HCM, and Supply Chain.</p><p>• Monitor system health, integrations, <strong>ESS</strong> jobs, performance, roles, and access privileges.</p><p>• Manage user accounts, role permissions, data security, and workflows.</p><p>• Conduct quarterly update assessments, regression testing, and verify the readiness and health of system environments.</p><p><strong>2. Functional and Technical Support</strong></p><p>• Provide Level 2 and Level 3 <strong>(L2/L3)</strong> support for Finance, HR, Procurement, and Operations teams.</p><p>• Troubleshoot and resolve configuration, integration, workflow, and data issues.</p><p>• Prepare and document Standard Operating Procedures <strong>(SOPs)</strong>, Root Cause Analysis <strong>(RCA)</strong>, technical notes, and knowledge base articles.</p><p>• Support User Acceptance Testing <strong>(UAT)</strong>, System Integration Testing <strong>(SIT)</strong>, and deployments of new enhancements.</p><p><strong>3. Development and Customization</strong></p><p>• Develop dashboards using <strong>OTBI</strong>, <strong>BI Publisher</strong> reports, and <strong>Bursting Logic</strong>.</p><p>• Create and maintain <strong>FBDI/ADFdi</strong> templates, <strong>HDL</strong> programs, and <strong>HCM Extracts</strong>.</p><p>• Implement <strong>Page Composer</strong> customizations and UI personalizations.</p><p>• Create, develop, and optimize <strong>BPM</strong> workflows and approval rules.</p><p>• Maintain <strong>Fast Formulas</strong> for Payroll, Absence, and Benefits.</p><p><strong>4. Integrations</strong></p><p>• Build integrations using <strong>OIC (Oracle Integration Cloud)</strong>.</p><p>• Maintain <strong>REST/SOAP API</strong> based integrations with internal systems.</p><p>• Manage secure <strong>B2B</strong> file transfers related to the company's core systems.</p><p>• Monitor integration tracking, failures, and performance.</p><p><strong>5. Data Management</strong></p><p>• Execute data loading processes using <strong>FBDI, HDL, and ADFdi</strong>.</p><p>• Support data cleansing, validation, and reconciliation processes.</p><p>• Ensure data readiness and audit logs for <strong>SAMA</strong> requirements, internal audit, <strong>PDPL</strong>, and compliance teams.</p><p>• Maintain accurate data retention records and access logs.</p><p><strong>6. Governance, Security, and Compliance</strong></p><p>• Ensure compliance with the <strong>SAMA Cybersecurity Framework</strong> requirements and the <strong>Personal Data Protection Law (PDPL)</strong>.</p><p>• Enforce Role-Based Access Control <strong>(RBAC)</strong> and Segregation of Duties <strong>(SoD)</strong> in Oracle.</p><p>• Maintain audit trails and periodic access review documentation.</p><p>• Support internal and external audit activities related to ERP controls.</p><p><strong>7. Continuous Improvement and Projects</strong></p><p>• Support the company's digital transformation roadmap and integrations.</p><p>• Collaborate with Finance, HR, and Operations teams to streamline Oracle workflows.</p><p>• Lead automation efforts using <strong>OIC</strong>, analytics, and <strong>BPM</strong> workflows.</p><p>• Participate in planning, roadmap development, and quarterly reviews with business teams.</p><p><strong>Required Qualifications</strong></p><p><strong>Education and Experience</strong></p><p>• Bachelor's degree in Computer Science, Information Systems, or a related field.</p><p>• <strong>3 to 8 years</strong> of hands-on experience in <strong>Oracle Fusion ERP</strong> administration and development.</p><p>• Experience managing multi-module ERP environments and handling quarterly updates.</p><p><strong>Technical Skills</strong></p><p>• <strong>OTBI, BI Publisher, FBDI, ADFdi</strong></p><p>• <strong>OIC</strong> integrations using <strong>REST, SOAP</strong>, and file-based integrations</p><p>• <strong>BPM</strong> workflows</p><p>• <strong>HDL and HCM Extracts</strong></p><p>• <strong>SQL, PL/SQL, XML, XSLT, JSON</strong></p><p>• Knowledge of <strong>Git, Jenkins, and Jira</strong> tools is a plus.</p><p><strong>Soft Skills</strong></p><p>• Strong analytical capabilities and advanced troubleshooting skills.</p><p>• Excellent communication skills and ability to coordinate and collaborate across cross-functional teams.</p><p>• Strong attention to documentation and governance.</p><p>• Ability to work under pressure in fast-paced fintech environments.</p><p><strong>Preferred Professional Certifications</strong></p><p>• <strong>Oracle Fusion Cloud</strong> certifications in Financials, HCM, Procurement, and OIC.</p><p>• <strong>ITIL Foundation</strong> certification.</p><p>• Familiarity with <strong>SAMA and PDPL</strong> compliance requirements is a plus.</p>

<strong>About Nama Partners<br></strong> Nama Partners is a strategic consulting firm that works primarily with entities in the Kingdom of Saudi Arabia and companies with significant interests there. The firm was founded to address issues that do not fit the large firm model: a board of directors discussing a succession issue, a family group considering an external capital injection, or a holding company that has lost a clear picture of its portfolio economics.<br> The firm's work covers corporate strategy, growth, market entry, operating models, efficiency improvement, organization, talent, digital strategy, performance improvement, governance, and risk. The partners who define the scope of work participate in its execution, and cooperation with the client often continues after the recommendation phase, with attendance at board meetings and testing management plans during implementation.<br> <br><strong>Tasks and Responsibilities</strong><ul> <li>Collect client data from various sources, from internal performance reports to industry databases, and clean and organize it so that it becomes valid for analysis.</li> <li>Prepare tables and charts that go into presentation materials and board files, while reviewing the numbers before they are released.</li> <li>Analyze business, product, and market performance, and provide a clear reading of what the numbers say to the team.</li> <li>Monitor performance indicators in ongoing projects and update dashboards periodically.</li> <li>Build simple computational models to estimate the financial impact of options presented to the client.</li> <li>Document the data sources and assumptions used in each analysis so that they can be referred to at a later time.</li> <br><br></ul><strong>Required Qualifications</strong><ul> <li>Basic knowledge of data analysis, from studies, training, part-time work, or a university project.</li> <li>Proficiency in using Excel for tables, functions, and charts.</li> <li>Ability to read numbers and explain what they mean in a few clear sentences.</li> <li>Precision in working with numbers, with a habit of reviewing the file before submitting it.</li> <li>Clear organization in arranging files and sources, and documenting what has been done.</li> <li>Willingness to learn analysis tools and dashboards with guidance from the team.</li> <li>Proficiency in Arabic, written and spoken, and the ability to work in English for reading and correspondence.</li> <br><br></ul><strong>Qualifications that are an added advantage</strong><ul> <li>Practical experience with Power BI or a similar tool for building dashboards.</li> <li>Knowledge of the basics of SQL or Python for handling data.</li> <li>Familiarity with sectors the company operates in, such as family groups, financial services, or government entities.</li> <li>Background in accounting, finance, or business administration.</li> <br><br></ul><strong>What We Offer</strong><ul> <li>A permanent, full-time position.</li> <li>Fully remote work, with tasks performed from Riyadh, Saudi Arabia.</li> <li>Direct participation in projects prepared for decision-makers within well-known entities in the Kingdom.</li> <li>Continuous work with those who define the project scope and execute it, without administrative levels separating analysis from decision-making.</li> <li>Early exposure to the fields of strategy, growth, operating models, and performance improvement.</li> <br><br></ul><strong>Who Will Succeed in This Role<br></strong> Those who succeed here are comfortable working with unorganized numbers at the beginning and rearranging them without waiting for detailed instructions. Someone who writes clearly and prefers a short note that says the thing once over a long piece of material that does not reach a conclusion. A project often goes through periods where demand and priority change, so those working on it need calmness, organization, and the ability to return to the source for verification. Anyone who possesses these habits will find in this role a wide space to learn about real work.

<p>Job Title: Business Analyst — Cleaning Services and Facility Management</p><p>Location: Riyadh, Saudi Arabia (Field-based, with client site visits)</p><p><br></p><p>Department: Operations / Commercial Affairs</p><p><br></p><p>Direct Supervisor: Operations Manager</p><p><br></p><p>Employment Type: Full-time</p><p><br></p><p>Experience Level: 4–7 years</p><p><br></p><p>About the Job</p><p>We are a growing company in the field of cleaning services and facility management, providing commercial, residential, and specialized cleaning contracts across Riyadh. As our contract portfolio and workforce expand, we are looking for a Business Analyst who fully understands that the success of this business relies on two main fronts: field operational efficiency and commercial performance in the market.</p><p><br></p><p>This role is not just about preparing office reports; you will serve as the connection point between Operations, Marketing, and Finance — turning scheduling data, labor costs, operational material consumption, and marketing campaign performance into decisions aimed at improving contract profit margins, reducing customer churn, and achieving profitable growth. Fluency in both Arabic and English is essential, as you will interact directly with field supervisors, field teams, and clients.</p><p><br></p><p>Key Responsibilities</p><p>1. Operations Analysis</p><p>Labor Productivity Analysis: Analyzing labor productivity across different sites (worker-to-area ratio, working hours per contract, and reasons for overtime) and providing recommendations to optimize allocation and scheduling.</p><p><br></p><p>Contract Profitability Models: Building and maintaining contract profitability models covering labor costs, consumables, chemicals, equipment, transportation, and accommodation.</p><p><br></p><p>Service Quality Tracking: Tracking compliance with Service Level Agreements (SLAs) and Key Performance Indicators (KPIs) for each contract, investigating operational deficiencies, identifying root causes, and following up on corrective actions.</p><p><br></p><p>Field Planning &amp; Dispatching: Analyzing route planning, shift patterns, and mobilization for new contracts to minimize downtime and transit costs.</p><p><br></p><p>Consumption Optimization: Tracking the consumption of chemicals and supplies against approved standards, identifying areas of waste, and adjusting procurement processes.</p><p><br></p><p>Workforce Planning: Supporting workforce planning by tracking attrition trends, absenteeism, recruitment lead times, and forecasting required capacity for upcoming contracts.</p><p><br></p><p>2. Marketing &amp; Commercial Analysis</p><p>Marketing Performance Measurement: Measuring the performance of marketing campaigns across digital and traditional channels: lead volume, cost per lead, lead-to-contract conversion rate, and Customer Acquisition Cost (CAC) by sector (B2B corporate contracts vs. B2C individuals).</p><p><br></p><p>Customer Retention: Analyzing customer retention rates, contract renewals, and cancellation reasons, and building early warning indicators for accounts at risk of cancellation.</p><p><br></p><p>Customer Segmentation: Segmenting the customer base (corporate, retail, hospitality, healthcare, residential, government) and identifying higher-margin sectors to focus on.</p><p><br></p><p>Pricing &amp; Tender Analysis: Supporting pricing analysis and proposal/tender submissions — modeling cost-to-serve, win/loss ratios, and competitive price positioning.</p><p><br></p><p>Upselling Opportunities: Evaluating cross-selling and upselling opportunities (deep cleaning, pest control, disinfection, maintenance services) and determining expected financial returns.</p><p><br></p><p>3. Reporting, Systems &amp; Process</p><p>Dashboards &amp; Reporting: Preparing and managing the executive management dashboard and the weekly/monthly reporting package for senior management.</p><p><br></p><p>Systems Requirements Definition: Gathering requirements from Operations, Sales, and Finance and translating them into clear functional specifications for system development.</p><p><br></p><p>Systems Development: Supporting the implementation and optimization of Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Workforce Management, and Field Service Scheduling systems; as well as improving data input quality.</p><p><br></p><p>Process Documentation &amp; Re-engineering: Documenting and re-engineering business workflows, and preparing Standard Operating Procedures (SOPs) manuals and process flowcharts in both Arabic and English.</p><p><br></p><p>Client Reporting: Preparing client-facing performance reports and supporting Quarterly Business Reviews (QBRs) with key accounts.</p><p><br></p><p>Required Qualifications</p><p>Educational Qualification: Bachelor's degree in Business Administration or Information Systems.</p><p><br></p><p>Work Experience: Minimum 4 years of experience in business analysis, including hands-on experience in analyzing operations and marketing/commercial activities.</p><p><br></p><p>Industry Experience: Proven experience in cleaning services companies, Facility Management (FM), or manpower/operational outsourcing companies — a deep understanding of contract-based service delivery, field labor models, and cost-to-serve economics.</p><p><br></p><p>Languages: Native Arabic with full proficiency in English (spoken and written) — ability to conduct interviews and speak with field supervisors in Arabic and present to senior management in English.</p><p><br></p><p>Technical Skills: Advanced skills in Excel / Google Sheets (complex formulas, Pivot Tables, scenario modeling, and dashboard creation).</p><p><br></p><p>Data Analysis Tools: Working knowledge of a data analysis tool (Power BI, Tableau, or Looker Studio).</p><p><br></p><p>Financial &amp; Commercial Concepts: Strong knowledge of commercial concepts and business math: gross profit, contribution margin per contract, Customer Acquisition Cost (CAC), Customer Lifetime Value (LTV), Churn rate, and Utilization rate.</p><p><br></p><p>Preferred Qualifications</p><p>Experience in the Saudi or GCC market, with knowledge of local labor regulations, Saudization requirements, GOSI costs, and labor salaries.</p><p><br></p><p>Experience supporting government or major corporate tenders (RFP submissions, tender pricing, technical/commercial files).</p><p><br></p><p>Proficiency in SQL for data extraction, and experience with ERP systems (such as ERPNext or Odoo) and CRM systems.</p><p><br></p><p>Familiarity with workforce management systems and field service scheduling software.</p><p><br></p><p>Professional certifications such as CBAP or analytics certifications from Google / Meta.</p><p><br></p><p>Personal Skills &amp; Competencies</p><p>Analytical Rigor &amp; Precision: Ability to work with incomplete or unstructured field data to reach accurate and defensible conclusions.</p><p><br></p><p>Credibility &amp; Field Presence: Ability to go on-site, talk to supervisors and workers in Arabic, and understand the actual reality behind the numbers.</p><p><br></p><p>Keen Commercial Insight: Distinguishing between ideas that drive strategic decisions and those that are merely charts.</p><p><br></p><p>Effective Communication: Writing clear reports, presenting confidently to executives, and tailoring the message to suit both operational and commercial audiences.</p><p><br></p><p>Accountability &amp; Initiative: Taking ownership and following up on recommendations until results are achieved, rather than simply delivering reports.</p>