Amazon Business Intelligence Engineer II Veritas 

United States, Washington, Seattle 

449395066

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 1TB.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, Hive/EMR, Spark, SNS, SQS, Kinesis) 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
Training & Career Growth
We’re continuously raising our performance bar as we strive to become Earth’s Best Employer. That’s why you’ll find endless knowledge-sharing, training, and other career-advancing resources here to help you develop into a better-rounded professional.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, hasn’t followed a traditional path, or includes alternative experiences, don’t let it stop you from applying.Work/Life Balance

- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience with data modeling, warehousing and building ETL pipelines
- Experience in Statistical Analysis packages such as R, SAS and Matlab
- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling