Data Engineer with Mortgage experience

Role: Data Engineer with Mortgage experience Location: Cincinnati, OH (Must be onsite 2 days a week) Visa: H1B, H4EAD USC (Passport Number Mandatory) Years: 9 & 12 Years TECHNICAL SKILLS Must Have Apache NiFi Databases: - Oracle 8i/9i/10g, IBM DB2, SQL Server, Other DW-BI, Snowflake, PostgreSQL ETL SQL SSIS Kafka 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 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.