ETL DataStage Architect level & Mortgage Banking) : Cincinnati, OH

Role: ETL DataStage Architect level & Mortgage Banking)

Location: Cincinnati, OH (ONSITE 5 DAYS WEEK IS PREFERRED)

Duration: Long Term

This individual will need to have 7+ years of depth in Infosphere DataStage/SQL Server
This role is onsite in Cincinnati, OH
Previous experience at 5/3 is preferred
Experience with BKFS (Black Knight Financial Services)/MSP is preferred
Previous experience working in mortgage industry is preferred
Experience with Kafka is preferred (nice to have)
Experience with Snowflake is preferred (nice to have)
Jr. roles may be considered

Job Overview:-

We are seeking a skilled Data Engineer with a strong background in mortgage banking to join our IT team.
The candidate will be instrumental in constructing, testing, and maintaining our mortgage banking data architecture.
This includes optimizing data flow and collection to ultimately support data analysis and decision-making processes.

Responsibilities:-

Design, construct, install, test, and maintain highly scalable data management systems.
Ensure systems meet business requirements and industry practices for mortgage banking.
Build high-performance algorithms, prototypes, predictive models, and proof of concepts.
Translate complex functional and technical requirements into detailed architecture, design, and high-performing software.
Integrate new data management technologies and software engineering tools into existing structures.
Create data tools for analytics and line of business that assist them in building and optimizing our product into an innovative industry leader.
Work with data and analytics experts to strive for greater functionality in our data systems.
Maintain a secure and compliant data processing environment in line with industry regulations.

Qualifications:-

Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.
Proven experience as a Data Engineer, preferably in the mortgage banking industry.
Strong knowledge of data warehousing solutions and relational SQL and NoSQL databases, Snowflake, STRONG experience in ETL, leveraging IBM Datastage.
Experience with AWS cloud services: EC2, RDS, MSK, Lambda.
Experience with object-oriented/object function scripting languages a plus.
Solid analytical skills and the ability to understand complex business requirements.
Familiarity with data pipeline and workflow management tools: dbt, Apache Kafka, Snowflake data pipeline/streams.
Knowledge of financial and mortgage banking principles.
Strong organizational and interpersonal skills, with the ability to manage tasks and timelines effectively.

Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.
Proven experience as a Data Engineer, preferably in the mortgage banking industry.
Strong knowledge of data warehousing solutions and relational SQL and NoSQL databases, Snowflake, MS SQL Server a plus.
STRONG experience in ETL, leveraging MS SSIS.
Experience with AWS cloud services: EC2, RDS, MSK, Lambda.
Experience with object-oriented/object function scripting languages a plus.
Solid analytical skills and the ability to understand complex business requirements.
Familiarity with data pipeline and workflow management tools: dbt, Apache Kafka, Snowflake data pipeline/streams.
Knowledge of financial and mortgage banking principles.

Strong organizational and interpersonal skills, with the ability to manage tasks and timelines effectively.

Best Regards

Riya | Lead – Talent Acquisition

United IT Solutions Inc