Data Engineer

Location: Cincinnati, OH. Role is on site up to 5 days a week . Client wants local candidates. Dayton or closer. No one farther out. Wants candidates within a 40 minute drive time.

Duration: 2 year project

Interviews – Video

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

• This individual will need to have 7+ years of depth in Datastage/SQL Server

• This role is onsite in Cincinnati, OH

• Experience with Kafka is preferred (nice to have)

• Experience with Snowflake is preferred (nice to have)

• Bachelor's or Master's degree in Computer Science, Engineering, or a related field.

• Proven experience as a Data Engineer, 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

• 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

• Preferred not required:, leveraging MS SSIS- Experience with AWS cloud services: EC2, RDS, MSK, Lambda