Sr. Business Intel Engineer, Wimsi

Amazon Amazon · Big Tech · Seattle, WA · Business Intelligence

This role focuses on building and maintaining reporting pipelines and data platforms for marketing and advertising operations. It involves data onboarding, monitoring, analysis, and ensuring data integrity to support business decision-making. While it mentions experience with data science and machine learning, the core responsibilities are in business intelligence and data engineering, not direct AI/ML model development or deployment.

What you'd actually do

  1. Design, develop, and oversee the reporting pipelines to onboard agency managed media metrics into reporting and measurement tool, using appropriate technologies (e.g., SQL, Python, Spark, AWS Lambda, etc.).
  2. Onboard and monitor new features for current and future roadmap of reporting and measurement products .to enable data-driven decision-making
  3. Collaborate with stakeholders (marketing, advertising, finance, engineering, science, legal, and product management) to understand business domains, requirements, and expectations.
  4. Work closely with owners of data source systems to gain insights into their capabilities and limitations
  5. Deliver minimally to moderately complex data analysis to support business needs

Skills

Required

  • SQL
  • ETL
  • Oracle
  • processing large, multi-dimensional datasets from multiple sources
  • performing statistical analysis
  • developing automated reporting
  • programming to extract, transform and clean large (multi-TB) data sets
  • theory and practice of design of experiments and statistical analysis of results
  • AWS technologies
  • scripting for automation (e.g. Python)
  • advanced SQL skills
  • theory and practice of information retrieval, data science, machine learning and data mining

Nice to have

  • working directly with business stakeholders to translate between data and business needs
  • managing, analyzing and communicating results to senior leadership

What the JD emphasized

  • critical importance to the future of Amazon
  • never-been-done-before challenges of remarkable complexity
  • fusing marketing, customer experience, and technical skills
  • holistic, data-driven picture
  • standardized data platform
  • clean, reliable, and accessible data feeds
  • cross-channel media strategy and planning, buying, marketing operations, campaign reporting, and measurement
  • trustworthy data, technology, and tools
  • data-aware
  • informed, data-driven decisions
  • complex, ambiguous challenges
  • new media planning and campaign lifecycle products and features
  • transformative opportunity
  • reporting pipelines
  • onboard agency managed media metrics
  • reporting and measurement tool
  • onboard and monitor new features
  • reporting and measurement products
  • data-driven decision-making
  • business domains, requirements, and expectations
  • data source systems
  • capabilities and limitations
  • minimally to moderately complex data analysis
  • business needs
  • best practices in reporting
  • data integrity
  • thorough testing
  • validating outputs
  • comprehensive documentation
  • influence business owners
  • thoughtful decision-making
  • rapidly-evolving environment
  • executives and business units across Amazon
  • excellent verbal and written communication skills
  • prioritize the most impactful projects and programs
  • drive businesses forward
  • building innovative solutions
  • large-scale data tools
  • identifying high-priority work and projects
  • maximize results for key stakeholders
  • solving complex problems
  • company-wide strategic decisions
  • 10+ years of professional or military experience
  • 5+ years of SQL experience
  • 1+ years of SQL, ETL or Oracle experience
  • 1+ years of processing large, multi-dimensional datasets from multiple sources experience
  • 1+ years of performing statistical analysis experience
  • 1+ years of developing automated reporting experience
  • Experience programming to extract, transform and clean large (multi-TB) data sets
  • Experience with theory and practice of design of experiments and statistical analysis of results
  • Experience with AWS technologies
  • Experience in scripting for automation (e.g. Python) and advanced SQL skills.
  • Experience with theory and practice of information retrieval, data science, machine learning and data mining
  • Experience working directly with business stakeholders to translate between data and business needs
  • Experience managing, analyzing and communicating results to senior leadership