08 Jan
ETL Data Engineer - W2
Delaware, Wilmington , 19801 Wilmington USA

Vacancy expired!

Aetea has been asked by their valued client, a leading

Financial company, to assist with their need for an

ETL Data Engineer. The client and the team you’ll be working in are great and offer positive challenges in a dynamic environment.

To give you an idea of what you will be doing and the team you will be doing it with, here’s the high level overview:You will be the sixth data engineer working under our Analytical Data Director and Chief Analytics Officer. This is an important role to own parts of our data infrastructure as we launch new financial technology products.We are looking for a solutions-oriented team player with a very reliable core SQL data skillset. The ideal engineer is able to communicate excellently with many internal stakeholders across the organization as well as able to contribute to process improvement and change as we continue to expand. We are a fully deployed AWS cloud environment, having cloud experience is a strong nice to have.

Responsibilities
  • Design and develop Extraction, Transformation and Loading (ETL) processes using standard ETL tools to streamline and automate the collection of data from source systems using SQL, Snowflake and AWS technologies
  • Assemble large, complex data sets that meet functional / non-functional business requirements
  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
  • Work with stakeholders including the Marketing, CRM, Finance, Operations, Product, and Development teams to assist with data-related technical issues and support their data infrastructure needs.
  • Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
  • Develop repeatable and scalable data quality audits

Requirements
  • Bachelor’s Degree in Computer Science, MIS or related field
  • 5+ years Advanced SQL knowledge and experience working with relational databases, query authoring (T-SQL/Postgres SQL) as well as working familiarity with a variety of databases. Able to write advanced SQL queries with multi-table joins, group functions, subqueries, set operations, functions, Stored Procedures and basic Java Scripting.
  • 2+ years of Experience with Snowflake Cloud Datawarehouse Platform
  • 2+ Years Experience with Python.
  • Experience with AWS Services a plus (S3, Glue, Lambda)
  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
  • Strong understanding of data modeling and data warehousing principles
  • Excellent documentation and general organization of ongoing tasks, including the ability to evaluate and question business rules.
  • Ability to solve problems and work directly with business SME’s
  • Financial Experience is a plus
  • JavaScripting and PySpark is a plus
This is a contract role, ideally contract to hire but that is dependent on future full-time headcount. Possibly 6 months - 1 year time frame, but no guarantees. The role is open due to converting an existing contractor into a full-time role on the team. This is a great opportunity to get in with a stable and growing organization that values technology and the people that drive it. There is a lot more we can share with you about the role, so please contact me (or apply) at

or through the “apply” function listed. This is an urgent opportunity and the client committed to moving quick when they identify the right person.

Vacancy expired!


Report job