Data Engineer II, Enterprise Risk

Are you passionate about data? Does the prospect of dealing with massive volumes of data excite you? Do you want to create the next-generation tools for intuitive data access? Are you interested in creating the most innovative Legal department in the world, solving unique operational challenges no other company has tackled? Operating at Amazon's scale demands intelligent systems, and a business operations mindset, to wrangle the tens of thousands of incoming legal requests and claims with increasing efficiency as Amazon grows. In this role, you will sit with the Legal Enterprise Risk team, and work with paralegals, business analysts, Legal technologists, economists, lawyers and global business leaders to operationalize the production of legal work and reduce risk for Amazon. You'll enjoy deep diving into things to see how they work, improving on what works, discarding what doesn't, and learning from both. You should be passionate about technology and solving high-impact, ambiguous, business problems in the legal space. You will also leverage and apply advanced AI tools and techniques to automate and scale data tasks, driving efficiency and innovation across the team's workflows. As a Data Engineer, you should be an expert with data lake fundamentals around storage, compute, etc., familiar with multiple data processing stacks like Spark, Presto/Trino, and core data concepts (e.g. Data Modeling and Reporting). You should have deep understanding of the architecture for enterprise level data lake/mesh solutions using NAWS stack or other cloud stacks. You should be an expert in the design, creation, management, and business use of large data-sets. The candidate is expected to be able to build efficient, flexible, extensible, and scalable ETL and reporting solutions. You should be enthusiastic about learning new technologies and be able to implement solutions using them to provide new functionality to the users or to scale the existing platform. Our ideal candidate thrives in a fast-paced environment, relishes working with large transactional volumes and big data, enjoys the challenge of highly complex business contexts (that are typically being defined in real-time), and, above all, is passionate about data and analytics.

Key job responsibilities

• Design, implement, and support a platform providing secured access to large datasets.
• Architect, develop and maintain end to end scalable data infrastructure and data pipelines
• Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions.
• Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using SQL, scripting and AWS big data technologies.
• Designing and implementing complex ETL pipelines and other BI solutions.
• Work closely with business owners, developers, Business Intelligence Engineers to explore new data sources and deliver the data.
• Learn and apply advanced AI tools and techniques to automate, scale, and improve data engineering workflows. Stay current with evolving AI capabilities and identify opportunities to integrate them into the team's processes.
• Empower the team for self-servicing by providing the necessary skills to handle complex tasks independently.
• Ensure that the team can efficiently manage and troubleshoot data-related issues, leading to increased autonomy and productivity, along with fostering a culture of self-reliance.

3+ years of data engineering experience

• 1+ years of developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes experience
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using OLAP technologies experience
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using data modeling experience
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using SQL experience
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using Oracle experience
• Experience with data modeling, warehousing and building ETL pipelines

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)

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