IT Data Analytics Intern

Union Home Mortgage; Kentucky; On-site; USD 25,000 - 36,000; Full time

Benefits offered by this job

Paid internship

Mentorship

Professional development

Group projects

Corporate outings

Job summary

Union Home Mortgage’s L.E.A.D Internship Program offers students a real-world environment to learn about the industry, be educated by senior leadership, and develop practical skills. Interns shadow, mentor, work on group projects, and participate in corporate outings while contributing 40 hours per week during a 3‑month summer program from our Strongsville, OH headquarters.

A Data Analyst Intern collaborates with a team to create, enhance and maintain custom reports, extract and visualize data,

Qualifications

• Strong analytical skills and data-driven mindset.
• Familiarity with relational databases and SQL preferred.
• Proficiency with spreadsheet software (Excel, Sheets).
• Exposure to BI/visualization tools (Power BI, Tableau, BO).
• Detail-oriented with ability to multitask and communicate clearly.

Responsibilities

• Develop custom reports and models to address business needs.
• Extract, manipulate, and visualize data across platforms.
• Meet with business partners to ideate on data-driven opportunities.
• Present findings to stakeholders to inform decisions.
• Assist with special projects as directed by supervisor.

Skills

Strong analytical skills

SQL

Spreadsheet applications

BI tools

Attention to detail

Written & verbal communication

Teamwork

AI tools familiarity

Education

Pursuing a 2-year or 4-year college degree in Computer Information Systems, Business Analytics, Data Analytics, or Economics

Tools

Power BI

Tableau

Business Objects

Job description

Union Home Mortgage’s L.E.A.D Internship Program’s goal is to provide a fun, interesting, and real-world environment for our interns to Learn about the industry, be Educated by Sr. Leadership and their peers, Achieve their personal goals and Develop their skills and knowledge base. We pride ourselves in providing innovative programs to our interns for them to learn and grow as they progress through their careers. Some of the programs we offer include: shadowing, mentoring, professional development, group projects and we even take our interns on corporate outings! Our internship program gives students a chance to meet new people, gain more experience, and learn from the best in the business! Our interns are treated like full-time Partners who work 40 hours a week during the 3-month summer program, are compensated, and based out of headquarters in Strongsville, Ohio.A Data Analyst Intern is responsible for working as part of a team to create, enhance and maintain custom reports that are relied upon to effectively and efficiently run the business. Interns also work on special projects to be presented to UHM’s leadership team at the conclusion of the internship.DUTIES & RESPONSIBILITIESDevelop custom reports and models that address business needsExtract, manipulate and visualize data across different platforms.Conduct exploratory meetings with business partners to generate ideas on how data and reporting can be used to drive operational efficiencies, as well as new business opportunitiesPresent findings and recommendations to different audiences and at different times with an emphasis on effectively informing stakeholders with necessary information to make critical business decisions.Other tasks as assigned by your supervisorSKILLS REQUIREDStrong analytical skillsFamiliarity with at least one relational database (SQL preferred)Familiarity with at least one spreadsheet applicationUnderstanding and use of Business Intelligence and visualization Tools (i.e. Power BI, Tableau, Business Objects, etc.)Detail oriented with the ability to multitaskSelf-motivated individual with excellent written and verbal communication skillsA willingness to work both independently and in a team-oriented environmentAn understanding of AI tools and their use (i.e. Co-Pilot, Claude, etc.)EDUCATION & EXPERIENCEPursuing a 2-year or 4-year college degree in Computer Information Systems, Business Analytics, Data Analytics, or EconomicsJunior or Senior StandingApplications are accepted on a rolling basis and positions are open until filled (this may be prior to the job posting expiration date).At UHM, we understand diversity comes in many different forms. It’s our commitment to improve inclusion in the workplace through programs and policies that establish a positive and inclusive environment where every Partner, regardless of their background, can grow and excel. We value diversity, educate on equity, and create inclusive partner opportunities to ensure that you know #UBelongAtUHM!This employer participates in E-Verify. If hired, the employer will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S.Union Home Mortgage Corp. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.