IT Data Analytics Intern

Union Home Mortgage Corp.; Strongsville (OH); On-site; USD 21,000 - 28,000; Full time

Benefits offered by this job

Compensation

Mentoring

Professional development

Group projects

Corporate outings

Job summary

Union Home Mortgage Corp. in Strongsville, OH, is seeking a Data Analyst Intern to join a 3-month summer program. Interns work 40 hours a week, are treated like Partners, and are compensated while contributing to the team at headquarters in Strongsville.

The role focuses on creating, enhancing and maintaining custom reports to run the business effectively. You will collaborate with Sr. Leadership and peers, develop data-driven insights, and present findings to leadership at the internship's end.

Qualifications

• Strong analytical skills
• Familiarity with at least one relational database (SQL preferred)
• Familiarity with at least one spreadsheet application
• Understanding and use of BI and visualization tools (Power BI, Tableau, Business Objects, etc.)
• Detail oriented with the ability to multitask
• Self-motivated with excellent written and verbal communication skills
• Willingness to work both independently and in a team
• Understanding of AI tools and their use (Co-Pilot, Claude)

Responsibilities

• Develop custom reports and models that address business needs
• Extract, 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 opportunities
• Present 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 supervisor

Skills

Analytical skills

SQL

Spreadsheets

BI tools

AI tools

Detail oriented

Communication

Teamwork

AI tools

Education

Pursuing CIS/Bi Analytics/Economics degree

Junior or Senior standing

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 & Responsibilities

• Develop custom reports and models that address business needs
• Extract, 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 opportunities
• Present 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 supervisor

Qualifications

SKILLS REQUIRED

• Strong analytical skills
• Familiarity with at least one relational database (SQL preferred)
• Familiarity with at least one spreadsheet application
• Understanding and use of Business Intelligence and visualization Tools (i.e. Power BI, Tableau, Business Objects, etc.)
• Detail oriented with the ability to multitask
• Self-motivated individual with excellent written and verbal communication skills
• A willingness to work both independently and in a team-oriented environment
• An understanding of AI tools and their use (i.e. Co-Pilot, Claude, etc.)

Education & Experience

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

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.