Business Intelligence Specialist, AMZL PSX
Amazon· Pricing & Payments / PSX (Partner Strategy & Experience) – AMZL
Osasco, SP, BrazilFull-timePosted 4w ago
About the role
Role within Amazon’s Last Mile Brazil organization (PSX) focused on designing, developing, and maintaining data intelligence solutions, automated pipelines, and analytical frameworks to ensure pricing accuracy, payment reliability, and financial health across delivery partner programs in Brazil.
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
- Build alerting and exception-handling mechanisms that proactively flag issues
- 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
Qualifications
- Bachelor's degree in Computer Science, Information Science, Information Technology, Engineering, Mathematics, Physics, or a related 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 QuickSight / Tableau / Power BI or other BI packages
- Experience with data scripting languages (e.g., SQL, Python, R) or statistical software
- Experience translating customer needs into business requirements
- Strong analytical skills, attention to detail, and effective communication abilities; experience with SQL Server/MySQL
- Experience communicating technical concepts to non-technical audiences
- Experience in Portuguese & English communication and presentation skills
Skills
Required:SQLETL / Data PipelinesData VisualizationPython / scripting
Nice to have:Data modeling / data warehousing
Benefits
- Not specified in the provided text
Last updated Oct 25, 2026. Interested? Apply on the company site.
More open roles at Amazon
- IT Support Associate II, Ops Tech Solutions (OTS)todayPlainfield, Indiana · Operations IT Support Engineering
- Head of Energy and Water, AWS LegaltodayHybrid (Seattle, WA) · Legal
- Software Development Engineer, Creative Asset Library, CreativeXtodaySeattle · Software Development
- Software Development Engineer, Creative Asset Library, CreativeXtodayHybrid (Seattle, WA) · Software Development
- IT Support Associate II, OTStodayIrving, TX · Operations IT Support Engineering