Data Engineer

Required Skills:

Data Engineer with Snowflake, AWS (S3, Glue, Lambda, Aurora Postgres)

Language Needs

- Python SQL

- needs to have strong querying with relational DB

- complex SQL statement Orch Tool: Control M

The Role

We are seeking an experienced Senior Data Engineer with a passion for delivering high impact operational and analytical data solutions that integrate across a large organization. In this role, you will build and modernize the database, business rules and API layers of our Customer Relationship Management (CRM) platform. This platform enables all Client customer facing associates with simple, integrated, and modern tools to provide superb customer and client service.

You will apply a variety of cloud-native (AWS and Snowflake) technologies to develop innovative solutions to sophisticated problems. This position is a critical element to delivering Client’s promise of crafting the best customer experiences in financial services.

The Expertise and Skills You Bring

Bachelor’s degree in Computer Science (or closely related)

Proven expertise in Data Modeling, Data Profiling, Data Analysis, Data Quality, Data Governance and Data Lineage

Experience migrating databases from On Prem to AWS Cloud

Hands-on experience building highly resilient, scalable, and efficient solutions using AWS services like Lambda, Glue, step functions, etc. is a must

Hands-on experience with Snowflake (building pipelines)

SQL specialist; ETL background and experience with schedulers a must

Proven experience developing, debugging and tuning complex SQL statements, PL/SQL packages and procedures

Hands-on experience with Aurora Postgres

Experience with DevOps or CI/CD Pipelines using Maven, Jenkins, Terraform, Github, Ansible, etc

Strong in managing API to database connections using different relational database drivers (Oracle, PostgreSQL, etc.)

Knowledge of Messaging Technologies (Kafka, Kinesis, SNS, SQS)

Desire and ability to learn and implement new technologies

Knowledge of how to develop highly scalable distributed systems using Open-Source technologies

Experience in Cloud-based (AWS) Architecture