Amazon Security (AmSec) is looking for a Data Engineer II to join a team of highly skilled individuals working on our initiatives in resource and application discovery within Amazon security. Our product, Veritas, is a foundational service within Amazon security that provides data for security initiatives like security reviews, threat modeling and detection, access control and incident response.
You will be part of a AmSec organization that spans over ten countries worldwide, catering to a wide variety of customer use cases, including security intelligence, application security, incident response, security operations, risk and compliance, acquisitions and subsidiaries, and external partner security.
You will work closely with a diverse range of roles, such as Software Development Engineers, Data Scientist, Data Engineers, Technical Program Managers, Product managers and our Security Engineer customers, to build high quality datasets for security investigations, application modeling, and more.
You'll primarily work with AWS services such as EMR, Glue, Athena, Redshift, S3, SNS, SQS, Apache Airflow, along with some internal tools.
You'll also be part of our transformation journey to build data objects by leveraging AI. Our data lake contains over 500 datasets from various sources, with some handling daily volumes exceeding PBs.
As Data Engineer, you will be gathering and understanding data requirements, partnering with software engineers, and collaborating across roles and teams to create the necessary data infrastructure and high quality pipelines to drive our team's initiatives. We have high-visibility data ingestion goals in a fast-paced, operational environment. The ideal candidate should enjoy the challenge of operating complex and mission-critical systems under ambiguity.
Key job responsibilities
• Develop and influence the teams' data strategy and data storage roadmap through working closely with partners
• Lead designs for data governance strategy, define data schema and develop tools to enable more efficient data sharing with customers which adhere to highly confidential data handling guidelines.
• Continually improve the data quality and operations, via automation and building full CI/CD data pipelines
• Recognize and adopt best practices in data integrity, data model, testing, analysis, validation, and documentation.
• Build end-to-end data pipelines to ingest and transform data from different types of data sources and systems
• Utilize AI/LLM to automate manual and redundant data engineering task
• Evaluate and implement various big-data technologies and solutions (e.g. Redshift, Iceberg, Hive/EMR, Spark, SNS, SQS) to optimize processing of extremely large datasets
• Understand and analyze business processes, logical data models and relational database implementations
• Write high performing and optimized SQL queries
BASIC QUALIFICATIONS
- 4+ years of data engineering experience
- Experience with data modeling, warehousing and building ETL pipelines
- 4+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- Knowledge of professional software engineering & best practices for full software development life cycle, including coding standards, software architectures, code reviews, source control management, continuous deployments, testing, and operational excellence
PREFERRED QUALIFICATIONS
- Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions
- Experience with non-relational databases / data stores (object storage, document or key-value stores, graph databases, column-family databases)
- Experience as a data engineer or related specialty (e.g., software engineer, business intelligence engineer, data scientist) with a track record of manipulating, processing, and extracting value from large datasets
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 - 132,100.00 - 178,800.00 USD annually
