We are seeking a Business Intelligence Engineer I to join our Security Data Intelligence (SDI) team. In 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 team's 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.
BASIC QUALIFICATIONS
- 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)
PREFERRED QUALIFICATIONS
- Master's 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
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 https://amazon.jobs/en/benefits.
USA, WA, Seattle - 82,300.00 - 144,000.00 USD annually
