Data Engineer

Data Engineer

Job ID

2024-11193

Job Locations

US-AL-Hoover

Overview

The Data Engineer is responsible for assisting with end-to end data consumption, from loading the data into the data warehouse to leveraging statistical models built with that data to gather critical insights to accommodate business needs.

Location listed is preferred office location but other locations and working remotely within the Renasant footprint may be considered based upon convenience and business necessity.

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

• Document data gathering and processing and provides a detailed set of results and analytical metrics
• Build, prototype, and deploy machine learning models in sandbox and production environments
• Assist with developing and maintaining end-to-end ETL data pipelines
• Develop SQL queries for data extraction from the data warehouse
• Participate in requirements gathering discussions and collect the appropriate level of detail required to and drive towards immediate technical results to solve client problems
• Design and develop data integration / transformation solutions
• Develop ad hoc SQL queries to support internal requests for data
• Create Entity Relationship Diagrams to design and document database solutions
• Design, develop, and maintain SQL Server databases, tables, indexes, stored procedures, views, and triggers
• Develop queries, views, and stored procedures to provide data to front end reporting solutions
• Optimize slow running queries, views, and stored procedures
• Troubleshoot and correct SQL Server performance issues
• Perform other related duties as assigned

Qualifications

• High School Diploma or equivalent
• Minimum of 5 years of developing MS SQL Server stored procedures, functions, tables, and view experience
• Snowflake databases, developing front-end application and database administrator experience preferred
• Experience working with a statistical programming language (R, Python or similar)
• Experience working with Qlik Talend software
• Knowledge of common unsupervised / supervised ML techniques
• Hands-on experience using source control tools and incident tracking software
• Working knowledge of all phases of the Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation
• Proficiency with Microsoft Office products
• Demonstrated ability to work and communicate well with coworkers and stakeholders

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.