Business Intelligence Engineer

Job description

DESCRIPTION

Amazon Product Imaging builds the world's best online shopping experience through photography, video, graphic design, and usability design enabling millions of customers to make more informed purchasing decisions. Imaging at Amazon is a large and fast-growing network of teams located throughout North America, Europe, India and Asia, focusing on fashion and product photography, photo retouching, graphic design, and image support services. We are continually innovating and setting new industry standards for showcasing 10s of millions of products across multiple global marketplaces. We are obsessed with innovating on behalf of our customers, and continually push beyond the boundaries of traditional e-commerce photography and videography.

As a Business Intelligence Engineer, you will be working with other business analysts, development and finance teams to drive the next generation of analytical and business intelligence capabilities. You'll coordinate with our partner teams to define and build the data architecture, data mart and reporting layers to facilitate standardized reporting and deep business insight. Your expertise will enable us to standardize on taxonomy and simplify data availability for all users.
The successful candidate will be comfortable with big data structures, intimately familiar with SQL, database schema and business processes. The candidate will have a strong bias towards data-driven decision-making and will be comfortable with ambiguity while working in a fast-paced dynamic environment.

Responsibilities
· Encourage the organization to adopt next-generation data architecture strategies, proposing both data flows and storage solutions.
· Partner with analysts, data engineers and software development engineers across Product Imaging org to identify critical datasets which will provide structured and timely access to actionable business information.
· Participate in developing and influencing extensible data design and technical strategy to provide the business with standard dimensions and measures.
· Investigate and implement new big data technologies to solve business problems where appropriate.
· Improve back-end data sources for increased accuracy and simplicity.
· Recognize and adopt best practices in reporting and analysis: including data integrity, test design, analysis, validation, and documentation.
· Simplify and automate reporting, audits, and other data-driven activities.
· Support business with time-critical tactical data analyses.

Desired profile

BASIC QUALIFICATIONS

· · 3+ years of experience in relevant business domains, including data warehousing (understanding of relational databases, data structures and architecture) and business intelligence tools, techniques and technology, or experience in analytics, business analysis or comparable consumer analytics solutions; development of complex reports
· · B.S. degree in mathematics, statistics, computer science or a similar quantitative field
· Advanced Oracle SQL knowledge (using iterative functions, methods of tuning SQL code, etc.) and database in a business environment with large scale complex data sets.
· Proven analytical and quantitative skills (including ability to effectively use business tools such as Excel/Access, macros, OBIEE, SQL, SSAS-type tools, etc.) and an ability to use data and metrics to back up assumptions, develop business cases, and complete root cause analyses.
· Ability to meet tight deadlines and manage multiple competing priorities; ability to work independently and navigate through ambiguous requirements
· Strong verbal and written communication and data presentation skills, including an ability to effectively communicate with creative, business and technical teams
· Knowledge of professional software engineering practices & best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations
· Inquisitive mindset, with proven problem solving ability, and a passion for big data.
· Experience in gathering requirements and formulating business metrics for reporting.