About Us
Moder is building an ecosystem of essential corporate services, technology, and consulting to help the mortgage and finance industry navigate and thrive in the toughest, most dynamic business environment in modern history. We create, buy, and grow companies to build a strong, comprehensive portfolio to help businesses thrive by overcoming the toughest barriers to growth: Getting the right people, processes, and technology.
Moder is the business outsourcing arm of Archwell, specializing in end-to-end or component-based outsourcing, including payroll management solutions, origination, servicing help, and more. Our team is built on industry expertise and provides the traction clients need to launch their companies.
Position Description
Title: Data Engineer SQL , PLSQL, ETL,SNOWFLAKE (IBM Data Stage)
Location: Remote
Type: Full Time
Job Role: We are looking for an experienced SQL , PLSQL and Data Stage ETL developer to join our team as a Data Engineer who will work as part of a team to help design and develop data-driven solutions that deliver insights to the business. The ideal candidate is a data pipeline builder and data wrangler who enjoys building data-driven systems that drive analytical solutions and building them from the ground up. You will be responsible for building and optimizing our data as well as building automated processes for production jobs. You will support our software developers, database architects, data analysts and data scientists on data initiatives
Essential Job Functions
- Designs, develops, builds and implements extracts transforms and loads (i.e. the facilitation of data movement across platforms) utilizing IBM DataStage ETL Tool.
- Designs and develops highly complex ETL processing the support of data warehouses and/ or operational data stores.
- Outstanding SQL/PLSQL Skills and experience performing deep data analysis on multiple database platforms. (Oracle is preferable)
- Understanding Data Transformation and translations requirements and which tools to leverage to get the job done.
- Experience in Data Lake Implementation in snowflake (preferable).
- Develops UNIX scripts and Oracle packages.
- Determines the appropriate design for ETL applications based on information gathered including data sources, data targets, data definitions, data relationships, and business rules.
- Works closely with project management, analysts, data modelers and the existing ETL developers to understand project requirements and contribute to the project solution.
- Provides technical expertise on ETL design, Data modeling, Data Warehousing, and Data integration Partner with Business Intelligence and Business operational teams to understand data sources and implement new requirements.
- Analyzes and summarize data to facilitate Business Intelligent decisions.
- A Solid Experience and understanding of designing and operationalization of large-scale data and analytics solution on snowflake cloud data warehouse.
- Advanced proficiency with SQL and related-RDBMS query tools
- Ability yo clearly communicate solutions to both technical and non-technical teams
- Scripting /Coding experience in Python /UNIX.
Qualifications & Experience
Qualification & Experience Requirements:
- Bachelor's degree in computer science, computer engineering, or a related field.
- 5 + years of experience working with Oracle and ETL (Data Stage)
- 2+ years of experience with the snowflake (Preferable) .
- Familiar with issue tracking systems like JIRA (Project Management Tool) or Trello.
- Experience working in an agile environment.
Desired Skills
- Experience in Snowflake.
- Experience in Datastage and Snaplogic
- Working knowledge of AWS or Azure
- Experience in migrating from on-prem to cloud systems
- Experience in Data Lake Implementation in snowflake (preferable).
