The Data Engineer II role at Amazon Web Services focuses on designing, building, and evolving data capabilities for the Investments Platform. This position involves collaborating with various teams to deliver high-performance data solutions that enhance decision-making and service delivery. The team operates in a dynamic environment, emphasizing innovation and agility. Candidates will leverage AWS technologies and generative AI practices to optimize data workflows and insights.

• 5+ years of developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes.
• 5+ years of developing and operating large-scale data structures for business intelligence analytics using SQL.
• 5+ years of developing and operating large-scale data structures for business intelligence analytics using Oracle.
• Experience with data modeling, warehousing, and building ETL pipelines.
• Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions.
• Experience with non-relational databases or data stores.

• Design and implement robust, scalable data pipelines and ETL processes using AWS-native services.
• Build and maintain data models, schemas, and storage solutions across relational and NoSQL databases.
• Develop, automate, and optimize metrics, reports, dashboards, and analytics workflows.
• Own infrastructure for data processing and analytics, including performance tuning and cost optimization.
• Leverage internal AWS GenAI services to prototype intelligent features and enhance data quality.
• Conduct rapid prototyping, proof-of-concepts, and automation tooling to improve data processes.
• Collaborate across teams to ingest, transform, and integrate data from diverse sources.
• Champion best practices in data integrity, testing, validation, monitoring, and documentation.
• Proactively identify opportunities to improve system reliability, scalability, and efficiency.

• Employees at Amazon are often offered comprehensive health benefits—including multiple medical plan options (no pre-existing condition exclusions, 100% covered in-network preventive care), dental and vision plans, a 24/7 medical advice line from day one, expert second-opinion services, and broad mental-health support with several free counseling sessions (including pediatric). Financial wellness typically includes a 401(k) with company match (up to 2%), Restricted Stock Units (equity), FSAs, an emergency savings program, product and partner discounts, and even college-savings and home-purchase programs. Overall, the package is designed to support employees and their families’ health, finances, and day-to-day life.