Business Intelligence Engineer en Madrid

Amazon is seeking a BI Engineer to join the Pan EU finance team. The person in this position will play a key role in partnering our EU retail organization on key profitability initiatives.


Location is open to Madrid or Luxembourg offices.


This person will own the production and delivery of a suite of standard reports regularly used by the organization to make key business decisions. This will involve:
1. Build the data structure, transformation processes, load jobs in Redshift and data processing and presentation in Excel
2. Extract relevant vendor attributes, build a data store in Redshift and create a models on various profitability initiatives, including determining the optimal sourcing strategy at a Product level, inventory health and Inventory Valuation Allowance, After-market services deep dives.
3. Debugging report issues and unblocking workflows
4. Communicating with the BI team and customers to provide status updates, etc.
5. Modifying reports via changes to underlying SQL
6. Fielding report related questions from stakeholders
7. Creating the report requires extracting & transforming data from tables and loading it into tables with an optimized data structure

Tools used include:
1. SQL (Oracle and Redshift)
2. ETL tools (internal)
3. Excel
4. Tableau
5. Report scheduling tools (internal)


The ideal candidate will be detail-oriented and driven to provide insightful and timely information to customers. The candidate should have strong communication skills and ability to prioritize effectively to ensure timelines are met. There is always room to make things better so this candidate should also have the ability to invent and simplify. Lastly, the candidate should have an ability to work effectively with cross-functional teams and an ability to work in a fast-paced and ever-changing environment.

The position represents an exciting opportunity to be a part of a dynamic and high paced environment, supporting a global organization and offers significant opportunities for rapid growth.

· Bachelors in Computer Science, Engineering, Statistics, Mathematics or related field
· Knowledge of scripting for automation (e.g., Python, Perl, Ruby)
· Experience with reporting tools like Tableau or other BI packages
· Advanced Excel skills
· Demonstrated ability in writing and tuning SQL scripts
· Solid communication skills and team player
· Demonstrated ability to manage and prioritize workload

. Master’s Degree in Business, Engineering, Statistics, Computer Science, or Mathematics
· Experience using very large datasets
· 3+ years prior experience in a BI role with a technology company or financial institution.