Amazon is seeking a Business Intelligence Engineer (BIE) to support Vendor Investigation and Transaction Accuracy (VITA). VITA’s mission is to detect and prevent theft, fraud, abuse and waste globally. We use advance techniques to prevent erroneous payments and to protect Amazon shareholders. We are seeking a BIE to support our automation and data needs. The ideal candidate thrives in a fast-paced environment, relishes working with large transactional volumes and big datasets, and is passionate about data and analytics. Ideal BIE L5 build and maintain advanced data pipelines and dashboards in a scalable and performant manner. They partner with data engineering, product teams, and technology stakeholders to onboard new data sources, ensure data lineage, deliver comprehensive data products and provide automation solutions. The candidate must deliver robust solutions and should be proficient with scripting languages like SQL, Python and work independently on the data challenges. The BIE should have Accounts payables domain knowledge and must be eager to dive deep into invoice, vendor, and payment data to develop fraud, risk, and erroneous payment analytics. The BIE will identify manual investigation opportunities and develop advanced analytical solutions using AI which will be used by VITA investigators and senior leadership. BIE L5 should use statistical analysis to address VITA’s biggest problems in proactively identifying defects. The candidate will have opportunities to (and will be asked to) get exposure to the modern cloud-based data technologies. The individual must be proactive in taking ownership of data ingestion from variety of source systems, build data pipelines and analytics, have excellent problem-solving abilities and have deep knowledge of advanced analytical solutions. The individual must have the ability to mentor other BIEs, work with technology, product development, finance, and business teams. The ideal candidate must have excellent communication, organizational, and prioritization skills with the ability to handle multiple tasks simultaneously. Key job responsibilities • Translate business risks and needs into the development of analytics for fraud and risk detection • Coordinate with technical teams as appropriate to develop and implement analytics and reporting needs • Partner with stakeholders to gather requirements and integrate necessary data sources to support business analysis and reporting • Design and implement advanced analytical solutions. Take ownership of critical dashboards • Design optimized data loading pipelines and leverage AI to create fraud detection models • Recognize and adopt best practices for building a scalable business intelligence platform • Apply analytics and data mining techniques to solve complex problems, drive business decisions and identify major gaps and opportunities • Assess trends, analyzes data and proposes hypotheses to identify potential fraud patterns and financial abuse • Collaborates with the business to research, develop and test new fraud detection and prevention rules • Coordinate with global team members to conduct deep dives walk-throughs and quality reviews of evidence to resolve complex problems. • Mentor and provide technical guidance to other BIEs on resolving data quality issues. Act as Subject Matter Expert when it comes to data questions. ### Basic qualifications - 5+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience - Experience with data visualization using Tableau, Quicksight, or similar tools - Experience with data modeling, warehousing and building ETL pipelines - Experience writing complex SQL queries - Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business - Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling - Knowledge of SQL and data warehousing concepts - Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field ### Preferred qualifications - Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift - Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets - Experience with forecasting and statistical analysis Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.