Data Engineer - AWS/ETL - on-site

Job Description

Full-time, in office position

Must have AWS, ETL & Python experience

Must be very hands-on

Data Engineer

The Data Engineer will be part of the overall team that is actively engaged in the ongoing database engineering process, partnering with development groups, and providing deep subject matter expertise to feature design, and as an advocate for bringing forward and resolving customer issues.

Responsibilities:

Analyze schemes and applications to determine the most appropriate migration strategies and architectures.

Leverage the latest technologies and products to convert legacy database schemas and applications code between database engines.

Identify and remediate technical obstacles.

Operate development and production environments in the cloud, run and analyze test results, perform diagnostics and troubleshooting, open, prioritize, and help triage defects, track and report test status and results.

Design solutions and tooling to execute automated database deployments & upgrades.

Standardize design patterns and usage of persistence solutions that can be adopted across multiple use cases.

Evaluate and drive changes to database and software architectures to address recurring issues or limitations.

Research and identify new opportunities for innovation.

Basic Qualifications:

Deep knowledge and experience designing and maintaining AWS databases and Data Lake technology.

Experience engineering and managing multiple database flavors for complex production systems

Familiarity with Amazon Web Services (Aurora, Athena, Dynamo DB, Glue, Sagemaker, S3, etc.).

Broad awareness of customer workloads and use cases, including performance, availability and scalability.

Experience analyzing issues holistically, from the application tier through the database, down to the storage.

Working knowledge of relational database internals (locking, consistency, serialization, recovery paths).

Working knowledge of Python scripting language.

Coding skills in the procedural language for at least one database engine.

Excellent communication skills

Systems engineering experience for troubleshooting and tuning

Experience ingesting data from different sources and/or ETL development experience.

Developing software code in one or more programming languages (Python, Java, etc)