Data Analyst Intern

First Bank & Trust • Sioux Falls, SD

2d

About The Position

Assisting the Data Engagement team with work that includes designing, maintaining, and automating reports and delivery; testing results; researching data sources; assisting internal customers in the use of data engagement tools and technology. Qualifications: This candidate should be working on a bachelor’s degree, preferably with an emphasis in one of the following: Economics, Business, Accounting, Mathematics, or Computer Science. T-SQL and Microsoft Office familiarity is preferred. This person must possess analytical, excellent inter-personal communication and customer service skills, the ability to stay organized, prioritize, and exercise confidentiality and discretionary judgement. FBT will not sponsor, renew, or extend immigration visas for this position. Principal Responsibilities: Work effectively with internal customers to improve the quality of data and reporting; understand specific customer, management, and departmental needs; perform analysis of data and design reports. Make improvements and benefits that could be derived from modifications or automation of existing reports and manual processes. Assist with research, analysis, build, and maintenance of automated reports using various software applications, PBI, and SQL language. Thoroughly test data integrity of new or modified reports. Contribute to departmental procedures which outline instructions for completion of all required reports, department deliverables, and blueprints for automated reports. Demonstrate continuous effort to improve operational efficiency, productivity, and accuracy; decrease turnaround times, streamline work processes, and work cooperatively and jointly to provide quality seamless customer service. Act in accordance with FBT Policies and Procedures as set forth in the employee handbook. Adhere to compliance procedures and participate in required compliance training. Compensation Grade Hourly Grade 3 First Bank & Trust is an Equal Opportunity, Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability, or status as a protected veteran. Read our complete Equal Employment Opportunity Policy Statement. Applicants who would like to request reasonable accommodation to the application or interview process should call Human Resources at 800.843.1552 or email [email protected]. We invest in our people: Our communities have contributed to the success of our business and our families. In turn, this allows us to contribute to the success of our communities. We have remained an independent community institution over the years and employ almost 700 people. Our employees are like family (they’re also part owners). Not only is working for us rewarding, but you’ll also be a part of a positive culture and company that gives back to the community. Our Benefits: Comprehensive Healthcare Benefits Peace of mind when it comes to you and your family's well-being with generous health, dental, vision, and life insurance. Plus, optional access to additional life, disability, and other forms of insurance. 401(k) & ESOP Profit Sharing Employees are owners. Receive a match of up to 7% of your contributions to your retirement account. Wellness Program The Healthy Way Program incentivizes gym membership and hosts educational programs and challenges throughout the year. Education Student loan repayment assistance program. Tuition reimbursement. A robust internal training program that goes beyond onboarding. We want you to continue learning. That's why we offer job shadowing, a mentorship program, and more. Volunteer Service Hours Paid time to volunteer. Employees get 16 hours to take part in and donate their time to local charities. In-house Childcare & Preschool Kid's World childcare and preschool in Brookings is available for the children and grandchildren of employees. Our Culture: We value our culture and work hard to keep it top of mind at all times. Employees rally around 9 core principles, creating a collaborative and enjoyable work experience for all. During the onboarding process, all new employees attend a culture camp, which is led by the CEO and the Chairman of the Board. Work for us: Our employees enjoy working together and treat eachother (and customers) like family. Check out our career opportunities, and join a company that cares about its people and community.

Requirements

• This candidate should be working on a bachelor’s degree, preferably with an emphasis in one of the following: Economics, Business, Accounting, Mathematics, or Computer Science
• This person must possess analytical, excellent inter-personal communication and customer service skills, the ability to stay organized, prioritize, and exercise confidentiality and discretionary judgement
• FBT will not sponsor, renew, or extend immigration visas for this position

Nice To Haves

• T-SQL and Microsoft Office familiarity is preferred

Responsibilities

• Work effectively with internal customers to improve the quality of data and reporting
• Understand specific customer, management, and departmental needs
• Perform analysis of data and design reports
• Make improvements and benefits that could be derived from modifications or automation of existing reports and manual processes
• Assist with research, analysis, build, and maintenance of automated reports using various software applications, PBI, and SQL language
• Thoroughly test data integrity of new or modified reports
• Contribute to departmental procedures which outline instructions for completion of all required reports, department deliverables, and blueprints for automated reports
• Demonstrate continuous effort to improve operational efficiency, productivity, and accuracy
• Decrease turnaround times, streamline work processes, and work cooperatively and jointly to provide quality seamless customer service
• Act in accordance with FBT Policies and Procedures as set forth in the employee handbook
• Adhere to compliance procedures and participate in required compliance training

Benefits

• Comprehensive Healthcare Benefits Peace of mind when it comes to you and your family's well-being with generous health, dental, vision, and life insurance. Plus, optional access to additional life, disability, and other forms of insurance.
• 401(k) & ESOP Profit Sharing Employees are owners. Receive a match of up to 7% of your contributions to your retirement account.
• Wellness Program The Healthy Way Program incentivizes gym membership and hosts educational programs and challenges throughout the year.
• Education Student loan repayment assistance program. Tuition reimbursement. A robust internal training program that goes beyond onboarding. We want you to continue learning. That's why we offer job shadowing, a mentorship program, and more.
• Volunteer Service Hours Paid time to volunteer. Employees get 16 hours to take part in and donate their time to local charities.
• In-house Childcare & Preschool Kid's World childcare and preschool in Brookings is available for the children and grandchildren of employees.

What This Job Offers

• Career Level: Intern
• Number of Employees: 501-1,000 employees