Piper Companies is looking for a ETL Developer with AWS for a Managed Service Provider.


This position is 100% remote.


US Citizen or Permanent Green Card holders


We are looking for a savvy Data/ETL developer to join our growing team of analytics experts. The Developer will work with a team to build a New Data Platform on AWS Redshift. The Developer will be responsible for supporting the ingestion of data sources into a data lake and identifying and resolving issues with source data quality problems before committing to the Redshift Data warehouse. The developer should have experience in applying data science techniques such as machine learning, fuzzy logic and artificial intelligence to solve complex data quality issues. The developer must be comfortable with transforming data using visual tools as well as scripting solutions.

They will also be responsible for creating the data sets required for reporting and dashboarding for Loan Processing. They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. The ideal candidate is an experienced data wrangler who enjoys optimizing data systems.

Responsibilities for Data Engineer

  • Implement transformation to clean the source data, including the use of ETL tooling, scripting and data science techniques.
  • Decompose data features into user stories
  • Design technical solution for features
  • Refine user stories into tasks
  • Provide research and analysis on data sources in support of data discovery and requirements elicitation
  • Monitor monthly data source replication and ETL jobs to ensure successful completion
  • Work with the System Team on any deployment or compilation issues encountered during automated deployments
  • Conduct periodic ETL data refreshes in Analytics preprod environment in support of QA and UAT
  • Provide UAT support, triage, troubleshooting, and explanations
  • Provide GitLab peer review and code merges
  • Manage code merges and deployments to preprod in support of QA activities


Qualifications for Data/ ETL Developer

  • Expert level knowledge in building data warehouses
  • Experience with AWS and developing lambda functions to support data curation, notification & monitoring programs.(3-4 yrs)

Knowledge of Python (3-4 yrs experience)

Expert Level experience on RedShift (3-4 yrs)

  • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
  • experience with Database technology, including index strategies, performance tuning and optimization and stored procedures. .
  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
  • 2+ years’ experience in data modeling and database design including both relational and data mart/data warehouse database design, breadth and depth in established and emerging data technologies.
  • Able to create standard common business vocabulary, express strategic data requirements, outline high level integrated designs to meet system and application- s strategy and business architecture.
  • Able to work and communicate with Solution Architects, System Developers, Data Modelers, DBAs
  • 2+ years expertise in the following sectors is required: housing and mortgage finance, Federal credit programs, and government benefit programs
  • Strong analytic skills related to working with structured and unstructured datasets.
  • Build processes supporting data transformation, data structures, metadata, dependency and workload management.
  • A successful history of manipulating, processing and extracting value from large, disconnected datasets.
  • Strong project management and organizational skills.
  • Experience supporting and working with cross-functional teams in a dynamic environment.
  • Knowledge of both the LGY business (mortgage and loans), OIT operations, and understanding of system development life cycle preferred

Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Fathom Management Fathom Management |
Yesterday

Certified AWS Senior DeveloperWe have been working aggressively with the customers to assess and migrate IT systems into cloud-based environments (Microsoft Azure, Amazon Web Services and others) as well as procure and implement new technology to replace legacy systems. The AWS D

Intone Networks Intone Networks |
2 d ago

Here’s what you’ll do in this role: The Unix Administrator position is responsible for the day-to-day support and administration of virtualized Unix environments in both on-prem and Cloud/AWS configurations Focus is on AIX/RHEL administration, third party software app

Vings Technologies Vings Technologies |
2 d ago

AWS DeveloperLocation: Denver, CO (Remote)Develop, bound and model software APIs for the data moving in and out of the applicationJava, Microservices coding experience working in AWS Environment by using Lambda, Step Functions, and cloud servicesTranslate business and functional.

Job Description:Pluralsight is hiring Training Architects specializing in AWS Databases. The role is remote based in the US.Our Training Architects are cloud industry professionals who love sharing their knowledge of and passion for cloud computing with others. They are part tech

What we're working onEnterprise companies turn to us to help them launch innovative digital products that interact with hundreds of millions of customers, transactions and data points. The problems we solve every day are real and require creativity, grit and determination. We are

More jobs by this company

Piper Companies Piper Companies |
|
Yesterday

Piper Companies is seeking a Remote Python Developer for a world leading technology firm in the Raleigh-Durham, North Carolina area. The Remote Python Developer must be willing to work east coast hours and will have the opportunity to fully work remote. The Remote Python Develope

Piper Companies is looking for a SQL Database Refactoring Developer, Tech Lead for a Managed Services organization in Remote.Responsibilities for the SQL Database Refactoring Developer, Tech Lead Locating and cataloging all Oracledatabase objects, develop compatibility matrix wit

100% remote positionTechnical Skills1. You have strong development skills in Ruby, with familiarity in JavaScript, React, Angular, and/or Java2. You have a strong DevSecOps understanding and experience3. You have experience with front-end technologies such as JavaScript٫ HT

Piper Companies Piper Companies |
4 d ago

Piper Enterprise Solutions is searching for a Security Platforms Engineer for a financial services company. This role is 100% remote.Responsibilities for Security Platforms Engineer: Work in a team with other engineers in administering security and risk applications, as well as t

Piper Companies is looking for a Director, Software Product Integration who would like to join an industry leader in the financial services sector located in Philadelphia, PA.This is a Remote Opportunity!Responsibilities for the Director, Software Product Integration include:Resp

Piper Companies Piper Companies |
|
7 d ago

Piper Companies is currently seeking a PHP Software Engineer for a full-time opportunity with an innovative company based out of Raleigh, North Carolina (NC). The Software Engineer will develop SaaS solutions for commercial service contractors Responsibilities of the Software Eng

Piper Companies Piper Companies |
|
7 d ago

Piper Companies is currently seeking a Lead Back End Engineer for a full-time opportunity with a unique and innovative company in Raleigh, North Carolina (NC). The Lead Engineer will support work with the engineering team in supporting the flagship product Responsibilities of the

Piper Companies is looking for a Associate Director of Business Intelligence for a leading marketing organization. This role is remote with quarterly travel to NYC.Responsibilities for the Associate Director of Business Intelligence:Create and drive the development of data produc

Piper Companies Piper Companies |
9 d ago

Piper Companies is looking for a DevOps Engineer for a Clinical Trial Financial Company in King Of Prussia, PA- 100% Remote, FULL TIMEHow You Will Contribute Work collaboratively with software engineers to automate the deployment of applications (develop and maintain CI/C

Piper Companies is seeking a REMOTE Full Stack Javascript Developer for an award winning software organization based in the Charlotte, North Carolina area. The REMOTE Full Stack Javascript Developer will join a growing team building out highly scalable and secure cloud native app

Piper Companies is looking for a Solutions Architect who would like to join an industry leader in the financial services sector located in Philadelphia, PA.This is a Remote Opportunity!Responsibilities for the Solutions Architect include:Partner with the business and technology o

Piper Enterprise Solutions is searching for a Associate Director of Data & Technology for a pharmaceutical publishing company. This is a 100% remote position.Responsibilities for Associate Director of Data & Technology: Responsible for developing and supporting data produ

Piper Companies Piper Companies |
12 d ago

Piper Companies is looking for a Remote IT/Technical Recruiter who would like to join an industry leader in the online retail sector.This is a Remote Opportunity!Responsibilities for the Remote IT/Technical Recruiter include:You will work as a true business partner spearheading t

Piper Companies Piper Companies |
15 d ago

Piper Companies is currently seeking an Web Developer for a REMOTE fulltime contract opportunity in the EST time zone. The Web Developer will expand software integral to company services and collaborate with a team to build and improve mission-critical web applications. Responsib

Piper Companies Piper Companies |
15 d ago

Piper Companies is currently seeking an React Developer for a REMOTE fulltime contract opportunity in the EST time zone. The React Developer will expand software integral to company services and aid in the development of web applications. Responsibilities of the Front End Develop

Piper Companies Piper Companies |
16 d ago

Piper Companies is currently seeking a Senior Software Engineer for a 100% remote opportunity! As a Senior Software Engineer, you will utilize your extensive background in web development (C#, and ASP.NET) to contribute to a company culture where change is welcomed and there is c

Piper Companies is looking for a Microsoft Dynamics 365 Developer who would like to join an industry leader in the medical technology sector located in Philadelphia, PAThis is a Remote Opportunity!Responsibilities for the Microsoft Dynamics Developer include:Perform as a subject.

Piper Companies is looking for a Dell Boomi Integration Developer for a leading Financial Services firm in Philadelphia, PAThis is a FULLY REMOTE opportunity! Responsibilities for the Dell Boomi Integration Developer include:You will work with internal and external customers, arc

Piper Companies is looking for a Manager, Application Performance Monitoring who would like to join an industry leader in the financial services sector located in Philadelphia, PAThis is a Remote Opportunity!Responsibilities for the Manager, Application Performance Monitoring inc

Piper Companies is looking for Big Data Engineer for a leading health sciences company. This role is 100% remote.Responsibilities for the Big Data Engineer:Design and build large data processing systems leveraging the market’s most prominent data ingestion technologiesBuild

Piper Companies Piper Companies |
20 d ago

Piper Companies is seeking a Remote Full Stack Developer for a well-known technology organization in the Raleigh-Durham, NC area. The Full Stack Developer will be responsible for developing and maintaining internal applications. The ideal candidate for the Full Stack Developer ro

Piper Companies is looking for a .Net Developer for a financial services client for a 100% remote opportunity.Responsibilities for the .Net Developer:Help on-board new clients by augmenting the existing architecture utilizing the latest technology stackDesign N-Tier Client/Server

Piper Companies Piper Companies |
20 d ago

Piper Companies is looking for a Business Intelligence Engineer who would like to join an industry leader in the financial services sector located in San Diego, CAThis is a Remote Opportunity!Responsibilities for the Business Intelligence Engineer include:You will be responsible.

Piper Companies is looking for a Software Engineer to be part of a financial lending organization. This role is 100% remote.Responsibilities of the Software Engineer:Deliver technology solutions within AWS for system integrations applicationsContribute to the company’s over

Piper Companies Piper Companies |
20 d ago

Piper Enterprise Solutions is searching for a Security Platforms Engineer for a financial services company. This role is 100% remote.Responsibilities for Security Platforms Engineer: Work in a team with other engineers in administering security and risk applications, as well as t

Piper Companies Piper Companies |
21 d ago

Piper Companies is looking for a Software Developer for a Financial services organization in 100% Remote -Full Time - NO SponsorshipESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES:Architect, design, code, unit test, fully implement and deliver application features with highest quali

Piper Companies is currently seeking a Senior Ruby on Rails (RoR) Software Engineer for a fully remote position. The Senior Ruby on Rails (RoR) Software Engineer will have the opportunity to develop features and maintain software applications for the leading education technology.

Piper Companies Piper Companies |
21 d ago

Piper Companies is currently seeking a PHP Developer for a remote opportunity at a national health insurance company. The PHP Developer will aid in the migration of user interfaces onto Vue.js framework, develop and build new applications, and collaborate to teach and learn with.

Piper Companies Piper Companies |
21 d ago

Piper Companies is currently seeking a Product Manager for a fully remote role. The Product Manager will have the opportunity to work on building out ecommerce products to serve enterprise-level clientele at a subscription-based software company.Responsibilities of the Product Ma

Piper Companies is currently seeking a Senior Product Manager for a fully remote role. The Senior Product Manager will have the opportunity to work on advertising SaaS products at a subscription-based software company.Responsibilities of the Senior Product Manager:Design and exec