Data engineer, AWS GDSP A&I
Role details
Job location
Tech stack
Job description
As a Data Engineer on this team, you will drive efficiency in data handling processes, setup product analytics, drive advanced analysis and build new metrics which are key inputs to improve the health, scale and growth of the Private Pricing Program. You will work collaboratively with the business leaders operations, and engineering teams on many non-standard and unique business problems and support business initiatives by collecting required and related data from external/internal sources.
The ideal candidate should have strong communication skills and ability to prioritize effectively to ensure timelines are met. You will own projects from engaging with customers to production and delivery of a suite of tools used by the organization to make key business decisions. You should be a self-starter, comfortable with ambiguity, able to think big and be creative (while still paying careful attention to detail). You think in terms of architecture, not just code. You proactively work to improve the consistency and integration between your team's BI solutions and any related systems or artifacts.
Key job responsibilities Design, develop, and maintain scalable data solutions for metrics, reports, analyses, and dashboards that support analytical and business needs
Collaborate with technology teams to extract, transform, and load data from diverse sources using AWS services and internal tools Build and deliver high-quality datasets that support data science initiatives and customer reporting requirements
Automate and optimize reporting processes to enable self-service analytics for stakeholders Translate business problem statements into technical analysis requirements
Apply analytical and statistical rigor to answer business questions and drive data-driven decisions Develop measurement frameworks that quantify customer experience and drive business outcomes
Create queries and visualizations for ad-hoc requests, projects, and ongoing reporting needs Write efficient, optimized queries with deep knowledge of data structures and query optimization techniques
Adopt best practices in reporting and analysis including data integrity, design, validation, and documentation
Troubleshoot operational data quality issues and audit existing data pipelines and queries
Recommend improvements to back-end data sources for increased accuracy and simplicity
Requirements
- 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, * 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)
Benefits & conditions
Pulled from the full job description
- AD&D insurance
- Parental leave
- Health insurance
- 401(k) matching
- Paid time off
- Vision insurance
- Dental insurance, 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, MA, Boston - 132,100.00 - 178,800.00 USD annually USA, NY, New York - 145,300.00 - 196,600.00 USD annually USA, TX, Austin - 132,100.00 - 178,800.00 USD annually USA, WA, Seattle - 132,100.00 - 178,800.00 USD annually