Data Engineer II, Accounting

Job summary
The Accounting BI team supports the global Accounting organization with process automation/improvements, developing automated reporting solutions/tools, and improving the ability of the accounting organization to process, analyze, access and consume accurate and timely financial data. The team supports the global accounting organization and partners closely with accountants and financial analysts supporting the various businesses and industries Amazon operates in.

The ideal candidate thrives in a fast-paced environment, relishes working with ambiguity, big data, and enjoys the challenges of highly complex business context. This role requires an individual with excellent analytical abilities, deep knowledge of business intelligence solutions, and the ability to quickly learn, adapt and work with a variety of technologies.

Responsibilities of this position include:

• Working with stakeholders and other engineering teams to identify and scope the right data architecture and technology to be used to facilitate analysis of most common Amazon customer behavioral questions.
• Partnering with partner engineering teams to enhance data infrastructure, data availability, and broad access to customer insights made available through BI tools across the organization.
• Design, build and implement the right ETL processes using AWS and similar technologies.
• Implement anomaly detection systems to have a proactive approach to any potential data quality issues, using industry standard frameworks.
• Enable large scale analytics using EMR and other big data technologies
• Establishing and implementing technology best practices that should be followed across the organization.
• Work on proof of concepts for adoption of new technology and tools

Basic Qualifications

• 3+ years of experience as a Data Engineer or in a similar role
• Experience with data modeling, data warehousing, and building ETL pipelines
• Experience in SQL

• Bachelor’s degree in Engineering, Statistics, Computer Science, Mathematics or related field
• Experience RDBMS databases like MySQL/SQL Server/Oracle and MPP Databases like Redshift, Teradata or Netezza
• Experience with programming languages such as Java, PySpark/Scala, Python, etc.
• Experience in gathering requirements and formulating business metrics for reporting

Preferred Qualifications

• 5+ years of experience as a Data Engineer or in a similar role
• Masters in computer science, mathematics, statistics, economics, or other quantitative fields
• Excellent data presentation skills and demonstrated ability to successfully partner with business and technical teams
• Experience with Big data tools like Kinesis or Kafka ,Spark
• Knowledge of software engineering best practices across the development lifecycle, including agile methodologies, coding standards, code reviews, source management, build processes, testing, and operations