Data Engineer I, Secure Third Party Tools (S3T)
AWS
Big Data
Cloud
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Engineering Security
Data Integration
Data Integration Tools
Data Lake
Data Pipeline
Data Platform
Data Processing
Database
Databases
ETL
Informatica
Information Technology (IT)
Programming Languages
S3
Software Development
SQL
Job Description
Build and maintain secure, scalable data infrastructure for secured access to large datasets within Amazon Security Foundations.
Responsibilities
- Design, implement, and support a platform for secured access to large datasets
- Architect, develop, and maintain end-to-end scalable data infrastructure and data pipelines
- Own the team’s data strategy and define the technical roadmap for data storage and pipeline design and implementation
- Partner with technology teams to extract, transform, and load data from diverse sources using SQL, scripting, and AWS big data technologies
- Design and implement complex ETL pipelines and BI solutions
- Collaborate with business owners, developers, and Business Intelligence Engineers to evaluate new data sources and deliver data
- Enable self-service within the team by providing the skills needed to handle complex tasks independently, including efficient troubleshooting of data-related issues to increase autonomy and productivity, with a focus on self-reliance
Requirements
- 1+ years of data engineering experience
- Experience with data modeling, data warehousing, and building ETL pipelines
- Experience with one or more query languages such as SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, or Scala
- Experience with one or more scripting languages such as Python or KornShell
Preferred Qualifications
- Experience with big data technologies such as Hadoop, Hive, Spark, and EMR
- Experience with any ETL tool such as Informatica, ODI, SSIS, BODI, or Datastage
Technologies
- SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, Scala
- Python, KornShell
- Hadoop, Hive, Spark, EMR
- Informatica, ODI, SSIS, BODI, Datastage
- AWS big data technologies
- ETL
Compensation & Location
- Location: Austin, TX (onsite)
- Salary: USD 101,300 - 160,000 per year
Benefits
- Sign-on payments
- Restricted stock units (RSUs)
- Health insurance (medical, dental, vision, prescription), Basic Life & AD&D, 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
- Parental leave
Similar Jobs
C
G