Business Intelligence Engineer, Amazon Security Experiences, Analytics and Science Team

The Amazon Security Experiences (ASE) organization is the data intelligence backbone of Amazon Security. We build and operate the data platform that powers security insights builder experience analytics and tooling decisions across Amazons security ecosystem. Every insight surfaced to security leadership from builder productivity trends to security issue quality metrics flows through systems our team designs builds and maintains.

We operate at scale processing large volumes of security and operational data daily through hundreds of pipelines consisting of transformations reporting queries ingestions and infrastructure management scripts. Our engineers work directly with source systems across AWS and SDO (Security Developer and Operations) data domains to procure data convert it into structured formats build large-scale processing pipelines design analytical data models and maintain infrastructure with the highest security and compliance standards.

We are seeking a Business Intelligence Engineer I to join our Security Data Intelligence (SDI) this role you will build and maintain BI solutions (datasets queries reports dashboards and analyses) that inform how security leadership makes decisions across Amazon. Working on well-defined problems with guidance from senior engineers you will maintain data lineage understanding apply analytics and visualization tools and deliver reliable insights on schedule. You will partner with teams across ASE BizOps MapSec and other security organizations to translate business questions into data-driven answers that serve the broader Amazon Security organization.

Key job responsibilities
Learn and apply team BI best practices when building data artifacts including ETL data models queries and reports. Measure and improve dataset quality across owned solutions. Automate manual processes where possible.

Maintain understanding of relevant data lineage: sources of data how metrics are aggregated and how BI is consumed and acted upon by security leadership. Learn the business context behind the teams data infrastructure and metrics definitions. Investigate data anomalies and validate outputs against source data and business logic.

Build small to mid-size BI solutions or components of larger solutions to answer straightforward business questions with data. Be proficient in SQL maintain straightforward ETL and create data structures using schema definition languages. Use analytics and visualization tools (e.g. QuickSight Excel Tableau) to deliver actionable insights.

Write secure stable testable and maintainable code with minimal defects. Get analyses and code reviewed before deployment. Document solutions for ease of use interpretation and maintainability. Handle data in accordance with Amazon security and compliance policies.

Solve straightforward problems where what to accomplish is clear but how requires skill and knowledge. For example building a dashboard that surfaces security issue quality trends or creating a report that tracks builder productivity across SDO tooling data. Troubleshoot and research root causes taking ownership or ensuring clear hand-off.

Take well-defined requirements and deliver on schedule. Seek input and guidance from team members on technology and business context. Participate in team design scoping and prioritization discussions. Communicate findings effectively to a technical audience.

Work effectively with customers (e.g. business teams Data Scientists) and internal partners to ensure deliverables meet expectations. Partner with peer BIEs and others on the team. Help train new peers. Participate in the interview process.

Apply descriptive statistics to analyze security and operational data. Be familiar with inferential statistics and know when such methods are appropriate. Identify trends in metrics and segment along suitable dimensions to reveal deeper dynamics.

Assume responsibility for code queries reports and analyses you inherit or produce. Ensure proper access control data integrity and auditability. Track security risks mitigate issues and escalate in a timely manner.

About the team
Diverse Experiences
Amazon Security values diverse experiences. Even if you do not meet all of the qualifications and skills listed in the job description we encourage candidates to apply. If your career is just starting hasnt followed a traditional path or includes alternative experiences dont let it stop you from applying.

Why Amazon Security
At Amazon security is central to maintaining customer trust and delivering delightful customer experiences. Our organization is responsible for creating and maintaining a high bar for security across all of Amazons products and services. We offer talented security professionals the chance to accelerate their careers with opportunities to build
experience in a wide variety of areas including cloud devices retail entertainment healthcare operations and physical stores.

Inclusive Team Culture
In Amazon Security its in our nature to learn and be curious. Ongoing DEI events and learning experiences inspire us to continue learning and to embrace our uniqueness. Addressing the toughest security challenges requires that we seek out and celebrate a diversity of ideas perspectives and voices.

Training & Career Growth
Were continuously raising our performance bar as we strive to become Earths Best Employer. Thats why youll find endless knowledge-sharing training and other career-advancing resources here to help you develop into a better-rounded professional.

Work/Life Balance
We value work-life harmony. Achieving success at work should never come at the expense of sacrifices at home which is why flexible work hours and arrangements are part of our culture. When we feel supported in the workplace and at home theres nothing we cant achieve.

- Experience with data visualization using Tableau Quicksight or similar tools
- Experience in data querying or modeling with SQL Excel
- 2 years of analyzing and interpreting data with Redshift Oracle NoSQL etc. experience
- Experience with one or more industry analytics visualization tools (e.g. Excel Tableau QuickSight MicroStrategy PowerBI) and statistical methods (e.g. t-test Chi-squared)

- Masters degree or Advanced technical degree
- Knowledge of data modeling and data pipeline design
- Experience with statistical analysis co-relation analysis
- Experience in data querying or modeling with SQL Excel

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status disability 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 for more information. If the country/region youre applying in isnt listed please contact your Recruiting Partner.

The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience qualifications and location. Amazon also offers comprehensive benefits including health insurance (medical dental vision prescription Basic Life & AD&D insurance and option for Supplemental life plans EAP Mental Health Support Medical Advice Line Flexible Spending Accounts Adoption and Surrogacy Reimbursement coverage) 401(k) matching paid time off and parental leave. Learn more about our benefits at WA Seattle - 82300.00 - 144000.00 USD annually