Developer II (Business Intelligence / RPA, Remote) at HomeTrust Bank in Asheville, North Carolina

Job Description:

Job Summary

Working with other developers and analysts, this Developer II role develops SQL reports, RPA automations, Executive Level Dashboards, internal productivity tools, and creates and maintains databases, tables, and data. This includes researching, designing, testing, documenting, and modifying projects and reports.

 

Key Responsibilities / Essential Functions

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Creates, troubleshoots, maintains, and modifies the following with minimal oversight:
  
  
  
  • SQL Server Reporting Services (SSRS) reports using Visual Studio.
  
  
  • Executive level dashboards using a data visualization tool such as Power BI.
  
  
  • SQL Server Integration Services (SSIS) packages to extract, transform and load data in Oracle and SQL Server databases.
  
  
  • Automation projects using RPA tools like UiPath.
  
  
  • Projects utilizing standard APIs.
  
  
  
  


• Deploys, schedules, and manages SSIS packages on the SQL Server database.


• Deploys reports to SSRS/Power BI, and manages report processing options, access control, subscriptions, snapshots, data caching, and other report properties.


• Consistently writes and translates reports, queries, and data extractions according to specifications with a high level of efficiency.


• Completes performance turning of SQL queries to keep data loads efficient and timely.


• Ensures timely and accurate completion of all deliverables with a high level of independence. 


• Consistently communicates project status.


• Adhere to all corporate policies and procedures, Federal and State regulations and laws.


• Complete all mandatory annual compliance training.


• Follow regulatory requirements including those pertaining to the Bank Secrecy Act (BSA), Anti-Money Laundering (AML), Customer Identification Program (CIP), and OFAC to assist in the identification, detection and determent of money laundering and other unlawful activities, as well as regulations pertaining to lending and consumer compliance to include fair lending laws.


• Perform other duties and special projects as assigned.

 

Job Requirements

Education:

• Bachelor’s degree in Computer Science, Software Engineering, or similar field required.

Required:

• 3+ years of relevant work experience.


• Advanced level knowledge of SQL and advanced report writing experience.


• Must have demonstrated experience and advanced knowledge of Oracle and SQL Server databases, SSIS, SSRS, .NET (C# and/or Visual Basic).


• Must have a passion for continuous innovation, learning new skills, and consistently delivering excellence.


• Proficient in Microsoft Office products.

Preferred:

• Banking experience.


• Experience with Power BI and/or UiPath.  

 

About HomeTrust Bank

HomeTrust Bank, founded in 1926, is a North Carolina chartered, community-focused financial institution committed to providing value-added community banking through online/mobile channels and multiple locations in Virginia, North Carolina, South Carolina, and Tennessee. Learn more at www.htb.com. Apply today to take your first steps towards joining this talented population of employees within a growing organization. 

 

Work Environment, Physical Requirements  

The physical demands described here are representative of those that must be met by an associate to successfully perform the essential functions of this job.  HomeTrust Bank promotes an equal employment opportunity workplace which includes reasonable accommodation of qualified applicants and employees.

• This job operates in a professional office environment and routinely uses standard office equipment such as computers, phones, photocopiers, and fax machines.


• Specific vision abilities required by this position include close vision, distance vision, and the ability to adjust focus.


• Physical activity requiring reaching, sitting, lifting up to 25 lbs., finger dexterity, grasping, feeling, repetitive motions, talking and hearing are required.


• The employee will frequently communicate and must be able to exchange accurate information with others.


• The employee may need to move around their office to attend meetings and to access files, machinery or other job-related tools.

DISCLAIMER:  HomeTrust Bank is an evolving company.  As such this job description is not necessarily an exhaustive list of all responsibilities, duties, skills, efforts, requirements or working conditions associated with the job.  While this is intended to be an accurate reflection of the current job, management reserves the right to revise the job or to require that other or different tasks be performed as assigned.

HomeTrust Bank values and promotes diversity and inclusion in every aspect of our business and at every level within the company. We recruit, hire, and promote employees based on their individual ability and experience and in accordance with Affirmative Action and Equal Employment Opportunity laws and regulations. Our policy is that we do not discriminate on the basis of race, color, gender, national origin, religion, age, sexual orientation, gender identity, gender expression, genetic information, physical or mental disability, pregnancy, marital status, status as a protected veteran, or any other status protected by federal, state, or local law.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

See job description

Apply Now