DESCRIPTION
Amazon Publisher Services (APS) helps digital publishers around the world build and grow thriving businesses. We provide services and advanced technologies to web, mobile app and advanced TV publishers of all sizes, including many of comScore’s global top 100, to help them monetize their content with demand from multiple programmatic buyers. Our server-side header bidding solutions are fast and reliable across devices, handling billions of queries per day, delivering ads in milliseconds. The result is more profitable advertising for publishers and more relevant ads for customers.
The APS Marketplace Services team is seeking an experienced BI Engineer who will build tools and reports that analysts, engineers and account managers can use to uncover opportunities that drive demand through our publisher and vendor connections. You own our report building and automation platform, and key, high reliability data sets. You will be the engine that accelerates insight creation across our organization by making it easier to access data and transform it into information. To be successful in this role, you will have to obsess over our workflow and process and then invent and simplify methods for us to work better. You are a report automation expert and a process optimizer who makes the most out of available resources to make things easier for themselves and others.
Key job responsibilities
* Manage a library of python functions to extract and load data to and from a variety of sources
* Build and manage pipelines that create simplified datasets which input into reports and frequently done analyses
* Define and build report automation processes including the monitoring, alerts and fixes to pipeline failures
* Evangelize the tools you’ve built to maximize their use
* Network across Amazon Ads to discover and magnify BI best practices
* Play an active role in strategic & operational planning discussions
About the team
Join this team to experience the benefits of working in a dynamic, entrepreneurial environment, while leveraging the resources of Amazon Inc.(AMZN), one of the world’s leading Internet companies. We provide a highly customer-centric, team-oriented environment in our offices located in Palo Alto, Austin, New York, London, and Tokyo. Learn more at aps.amazon.com.
BASIC QUALIFICATIONS
- 3+ 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 in Statistical Analysis packages such as R, SAS and Matlab
- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
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
Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status.
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.
