About This Role
Building and maintaining data intelligence solutions for Amazon's Last Mile Brazil organization is the core of this Business Intelligence Analyst role within the Pricing & Payments team. The analyst will ensure pricing accuracy, payment reliability, and financial health across all delivery partner programs by developing automated mechanisms and analytical frameworks.
Responsibilities
- Design, build, and maintain automated data pipelines and ETL processes that support payment reconciliation, pricing validation, and financial reporting across all partner programs
- Develop and maintain SQL-based queries, views, and stored procedures to extract, transform, and analyze large-scale operational and financial datasets
- Build and maintain dashboards and reporting mechanisms (QuickSight, Tableau, or equivalent) providing real-time visibility into payment status, pricing accuracy, disputes, and financial KPIs
- Create automated reconciliation mechanisms that identify payment discrepancies, pricing errors, and anomalies before they impact partners
- Develop self-service analytical tools that enable the Payments and Pricing team to access insights without requiring ad-hoc requests
- Automate recurring reports and manual processes, driving efficiency gains across the Payments & Pricing function
- Conduct deep-dive analyses on payment cycles, dispute patterns, incentive effectiveness, and pricing model performance to support data-driven decision-making
- Build alerting and exception-handling mechanisms that proactively flag issues (e.g., payment delays, pricing inconsistencies, unusual dispute volumes)
- Partner with Technology and Engineering teams to define data requirements, validate data sources, and ensure data quality and integrity
- Support the development of pricing models and incentive simulations by providing historical data analysis, scenario modeling, and impact projections
- Document all data solutions, pipelines, and mechanisms with clear technical specifications and operational runbooks
- Present analytical findings and automation proposals to stakeholders, translating technical solutions into business value
Requirements
- Bachelor's degree or equivalent work experience in Business, Engineering, Supply Chain, Transportation, Mathematics, Economics, Physics or another technical field
- Knowledge of writing and optimizing SQL queries in a business environment with large-scale, complex datasets
- Experience building data pipelines or automated ETL processes
- Experience with reporting and Data Visualization tools such as Quick Sight / Tableau / Power BI or other BI packages
- Experience with data scripting languages (e.g., SQL, Python, R, or equivalent) or statistical/mathematical software (e.g., R, SAS, Matlab, or equivalent)
