Data Engineer I, Business Data Technologies

Socket.dev; Seattle (WA); On-site; USD 101,000 - 160,000; Full time

Benefits offered by this job

Sign-on bonus

Restricted stock units (RSUs)

Health insurance

401(k) matching

Paid time off

Parental leave

Job summary

Amazon in Seattle is hiring a Data Engineer to translate raw data into actionable insights. You will design data pipelines and data models, enabling automated reporting and data-driven decisions across teams such as analytics, product, and operations.

The role emphasizes building scalable ETL pipelines with SQL, Python and Spark, and collaborating with business customers to deliver comprehensive reporting solutions. Excel in a fast-paced data environment with Amazon-scale data.

Qualifications

• 1+ years of data engineering experience.
• Experience with data modeling, warehousing and building ETL pipelines.
• Experience with one or more query languages (SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, Scala).
• Experience with scripting languages (Python, KornShell).
• Familiarity with Hadoop, Hive, Spark, EMR and ETL tools is a plus.

Responsibilities

• Be hands-on with ETL to build data pipelines to support automated reporting.
• Interface with other technology teams to extract, transform, and load data from a wide variety of data sources.
• Implement data structures using best practices in data modeling, ETL/ELT processes, and SQL, Redshift.
• Model data and metadata for ad-hoc and pre-built reporting.
• Interface with business customers, gathering requirements and delivering complete reporting solutions.
• Build robust and scalable data integration (ETL) pipelines using SQL, Python and Spark.
• Build and deliver high quality data sets to support business analyst, data scientists, and customer reporting needs.
• Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers
• Participate in strategic & tactical planning discussions

Skills

Data engineering

Data modeling

Data warehousing

ETL pipelines

SQL

Python

Spark

Tools

Apache Hadoop

Apache Hive

Apache Spark

EMR

Job description

Business Data Technologies (BDT) makes it easier for teams across Amazon to produce, store, catalog, secure, move, and analyze data at massive scale. Our managed solutions combine standard AWS tooling, open-source products, and custom services to free teams from worrying about the complexities of operating at Amazon scale. This lets BDT customers move beyond the engineering and operational burden associated with managing and scaling platforms, and instead focus on scaling the value they can glean from their data, both for their customers and their teams.

We own the one of the biggest (largest) data lakes for Amazon where 1000’s of Amazon teams can search, share, and store EB (Exabytes) of data in a secure and seamless way; using our solutions, teams around the world can schedule/process millions of workloads on a daily basis. We provide enterprise solutions that focus on compliance, security, integrity, and cost efficiency of operating and managing EBs of Amazon data.

Key job responsibilities

• Be hands-on with ETL to build data pipelines to support automated reporting
• Interface with other technology teams to extract, transform, and load data from a wide variety of data sources
• Implement data structures using best practices in data modeling, ETL/ELT processes, and SQL, Redshift.
• Model data and metadata for ad-hoc and pre-built reporting
• Interface with business customers, gathering requirements and delivering complete reporting solutions
• Build robust and scalable data integration (ETL) pipelines using SQL, Python and Spark.
• Build and deliver high quality data sets to support business analyst, data scientists, and customer reporting needs.
• Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers
• Participate in strategic & tactical planning discussions

A day in the life

As a Data Engineer, you will be working with cross-functional partners from Science, Product, SDEs, Operations and leadership to translate raw data into actionable insights for stakeholders, empowering them to make data-driven decisions. Some of the key activities include:

• Crafting the Data Flow: Design and build data pipelines, the backbone of our data ecosystem.
• Ensure the integrity of the data journey by implementing robust data quality checks and monitoring processes.
• Architect for Insights: Translate complex business requirements into efficient data models that optimize data analysis and reporting. Automate data processing tasks to streamline workflows and improve efficiency.
• Become a data detective! ensuring data availability and performance

Basic Qualifications

• 1+ years of data engineering experience
• Experience with data modeling, warehousing and building ETL pipelines
• Experience with one or more query language (e.g., SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, Scala)
• Experience with one or more scripting language (e.g., Python, KornShell)

Preferred Qualifications

• Experience with big data technologies such as: Hadoop, Hive, Spark, EMR
• Experience with any ETL tool like, Informatica, ODI, SSIS, BODI, Datastage, etc.

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

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.

Location: USA, WA, Seattle - 101,300.00 - 160,000.00 USD annually