Pricing Associate

Metropolitan Warehouse & Delivery Corp. is looking for a detail-oriented and analytical Pricing Associate to join the Pricing & Business Analytics department. This role involves supporting pricing analysis, managing customer rates, preparing proposals, generating reports, and aiding commercial decision-making. The ideal candidate will have strong Microsoft Excel skills and experience with Power BI reports and the Power BI Service. The position focuses on maintaining pricing accuracy, supporting business analysis, and enhancing operational efficiency by working with existing pricing models, reports, and workflows. The role operates on an evening shift from 5 PM to 2 AM and is based in Bahria Town Phase 4, Rawalpindi.

Key Responsibilities

- Pricing Analysis: Analyze customer pricing, shipment volumes, revenue, and profitability to support pricing decisions and identify business opportunities.
- Proposal Preparation: Prepare customer pricing proposals, quotations, rate comparisons, RFP responses, and pricing addenda.
- Rate Card Management: Maintain and update customer rate cards, fuel surcharges, accessorial charges, rebates, and contractual pricing terms.
- Excel Analysis: Utilize Excel to analyze large datasets, maintain pricing calculators, validate calculations, and develop reporting templates.
- Power BI Reporting: Navigate existing Power BI reports and dashboards, apply filters, review trends, interpret key performance metrics, and extract insights for pricing analysis.
- Power BI Service: Access and navigate published reports through Power BI Service, work with shared reports and dashboards, and use available reporting resources to support daily tasks.
- Data Validation: Review pricing inputs, identify discrepancies, validate calculations, and ensure the accuracy and consistency of pricing information.
- Business Reporting: Prepare recurring reports, performance summaries, and analytical insights for management review.
- Cross-Functional Collaboration: Coordinate with Sales, Operations, Finance, and other departments to address pricing requests and resolve data discrepancies.
- Process Improvement: Identify opportunities to streamline pricing processes, improve reporting accuracy, and reduce repetitive manual work.
- Documentation: Maintain organized pricing records and ensure proposals, rate updates, and approvals are appropriately documented.

Required Qualifications

- Bachelor’s degree in Finance, Accounting, Business Administration, Economics, Business Analytics, or a related field.
- 1 to 3 years of relevant experience in pricing, financial analysis, reporting, business analytics, or commercial operations.
- Strong Microsoft Excel skills, including PivotTables, XLOOKUP/VLOOKUP, SUMIFS, COUNTIFS, IF statements, and data analysis.
- Familiarity with navigating Power BI reports and dashboards.
- Working knowledge of Power BI Service, including accessing published reports, applying filters, and interpreting reported metrics.
- Strong analytical, numerical, and problem-solving abilities.
- Excellent attention to detail and accuracy.
- Good communication, organizational, and time-management skills.

Preferred Qualifications

- Experience in logistics, transportation, freight, supply chain, or final-mile delivery.
- Exposure to Microsoft Power Automate or other workflow automation tools.
- Experience working with pricing models, rate cards, revenue analysis, cost structures, or profitability reporting.
- Familiarity with preparing commercial proposals, customer quotations, and RFP responses.
- Interest in process improvement and business analytics.

Key Competencies

- Advanced Microsoft Excel proficiency.
- Power BI report navigation and data interpretation.
- Pricing analysis and commercial awareness.
- Data accuracy and attention to detail.
- Analytical thinking and problem-solving.
- Effective communication and stakeholder coordination.
- Strong organization and task prioritization.
- Initiative in process improvement.

Performance Expectations

- Complete pricing requests and proposals accurately and within deadlines.
- Maintain reliable and up-to-date pricing records and customer rate cards.
- Effectively utilize Power BI reports to support pricing analysis and business reporting.
- Identify pricing discrepancies and data-quality issues promptly.
- Deliver timely reporting and analytical assignments.
- Contribute to process improvements and reduce manual work where possible.

Compensation

The position offers a monthly salary ranging from Rs. 120,000 to Rs. 150,000.

Work Location

This is an in-person role based in Bahria Town Phase 4, Rawalpindi, with working hours from 5 PM to 2 AM.