Mortgage Data Engineer

Overview

The Mortgage Data Engineer is responsible for assisting with end-to-end data consumption, from sourcing and loading the data into the data warehouse, transforming the data for business use, building reports for the operational departments, and documenting process flows for audit review.

RENASANT BANK IS AN EQUAL OPPORTUNITY EMPLOYER

Responsibilities

• Perform analyses of structured and unstructured data to solve basic business problems utilizing advanced statistical techniques and mathematical analyses
• Assist with ensuring proper consolidation of multiple loan systems with proper documentation of transformations as required by data lineage governance controls
• Develop and manage an object-oriented framework used to store, transform, and organize the entire architecture of the Mortgage database including all tables, views, stored procedures, ETLs
• Participate in requirements gathering discussions with operational leaders in the Origination, Processing, Underwriting, Closing, Secondary, Post-Closing, Servicing, Quality Control, Finance, and Compliance departments to design, build, and implement automation of processes and collect the appropriate level of detail required to and drive towards immediate technical results to solve client problems
• Assist with the creation of Mortgage reports in MicroStrategy using the Renasant Data Warehouse and Mortgage Database
• Create Entity Relationship Diagrams to design and document database solutions
• Develop SQL queries, views, and stored procedures to provide data to front end reporting solutions and internal requests for ad hoc data
• Monitor and maintain data quality reports and ongoing definitions to ensure accurate reporting
• Optimize slow running queries, views, and stored procedures
• Perform other related duties as assigned

Qualifications

• Bachelor's degree in related discipline (e.g., Data Science, Data Analytics, Computer Science, etc.)
• 5+ years of relevant experience developing MS SQL Server stored procedures, functions, tables, and view experience
• Working knowledge of all phases of the Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation
• Proven ability to connect data to business outcomes by designing and interpreting KPIs tied to financial performance, identifying leading and lagging indicators for key functions, and enabling reliable performance reporting through effective data-sourcing and integration
• Advanced-level SQL expertise required, including complex query development (e.g., recursion, pivots/unpivots, window functions, performance optimization, data transformations, and ETL scripts)
• Experience developing production-ready dashboards using Business Intelligence visualization tools (Tableau, Power BI, MicroStrategy, Microsoft SSRS, Cognos, etc.)
• Hands-on experience using source control tools and incident tracking software
• Proficiency with Microsoft Office products
• Demonstrated ability to work and communicate well with coworkers and stakeholders
• Snowflake databases, developing front-end application and database administrator experience preferred

Physical Demands

The physical demands described are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is frequently required to stand or sit; kneel, stoop, or squat; use hands or fingers to handle or feel objects, tools or controls; reach with hands and arms, and talk or hear. The employee is occasionally required to walk. The employee must occasionally lift and /or move up to 25 pounds. Specific vision abilities required by this job include close vision, peripheral vision, depth perception and the ability to focus.

Work Environment

The Bank’s professional working environment requires employees to communicate effectively, both verbally and in writing. Employees must demonstrate strong interpersonal skills when working closely with internal business partners and external clients. Employees may be exposed to confidential and propriety information within the working environment, therefore, must uphold confidentiality at all times. Due to the possibility of being exposed to high risk situations (i.e. robbery), detailed instructions and procedures are required to be followed at all times to safeguard the Bank’s employees, customers, and assets.

The above is intended to describe the general content of and requirements for the performance of this job. It is not to be construed as an exhaustive statement of duties, responsibilities, or requirements. The principal duties and responsibilities enumerated are all essential job functions except for those that begin with the word “May”.

This job description is intended to describe the normal level of work required by the person performing the work. The principle duties outlined are the essential responsibilities and duties. Other duties may be assigned as needs arise. Job requirements and/or processes may be modified to reasonably accommodate persons with a disability as required by law.

This description is not intended as a contract and is subject to change. Any written contractual agreements supersede this job description.