Data Analyst Intern

PSECU Pennsylvania State Employees Credit Union; United States; On-site; USD 21,000 - 30,000; Part time

Job summary

PSECU Pennsylvania State Employees Credit Union is seeking a Data Analyst Intern to join the BI team. You will pull data from multiple sources, build dashboards, and generate insights to support decision making.

You’ll work under supervision to ensure data security, accuracy, and availability while assisting with ad-hoc reporting needs. The role emphasizes learning and growth, with exposure to SQL, R, Python, and BI tools like Power BI, Tableau, and Looker.

Qualifications

• High School (Required) Any equivalent combination of experience and education.
• Must be a current student actively pursuing a degree or certification for the duration of the internship/student worker assignment.
• Must meet PSECU’s minimum employment eligibility requirements, including being at least 18 years of age at the time of hire.
• In 1934, 22 ordinary people pooled $90 of their own money and formed PSECU, a not-for-profit credit union, to provide a better life for themselves and their families.

Responsibilities

• Create standard or ad hoc queries or reports to extract data from disparate databases or data sources.
• Analyze data to produce dashboards, metrics, or insights and identify trends or anomalies.
• Support advanced analytics initiatives including data mining, statistical analysis, and predictive modeling.
• Provide training and assistance to users for generation of ad-hoc reports.

Skills

SQL

R

Python

Education

High School or equivalent

Tools

Power BI

Tableau

Looker

Job description

Members Achieve More isn't just a tagline for us, it's part of everything we do! We're looking for passionate individuals to join our team to help us maintain that focus every day. Want to work somewhere that's remained strong for 90 years, that encourages you to learn, grow, and pursue your dreams? If yes, then read on...

The Data Analyst Intern will report directly to the Business Intelligence Manager and is responsible for creating standard or ad hoc queries or reports to extract data from disparate databases or data sources. The Data Analyst Intern analyzes data to produce dashboards, metrics, or insights and identify trends or anomalies. Additionally, this role may support advanced analytics initiatives including data mining, statistical analysis, and predictive modeling efforts. In this position, you will Data Analysis – Pull and Analyze data and build models that are used by the business or organization to support decision making. Provides technical assistance to users in order to insure the efficient procurement of data. Experience with SQL, R, and Python. Reporting - Familiar with modern business intelligence tools like Power BI, Tableau, Looker. Use detailed specifications from which reports and dashboards will be written. Reports will be designed, coded, tested, debugged, documented and maintained using business intelligence standards. Provides quality report services to user processes within the organization. Quality report services include cooperative design, effective implementation, adequate documentation and continual support of BI reports. Ability to analyze BI reports and respond with suggestions for imrovements and enhancements. Other - Under supervision provides security, accuracy, integrity, availability, performance, and validity to all credit union data and all reports. Under immediate supervision, assist in research and fact-finding. Participate with other specialists to improve and/or convert legacy reports to the Credit Unions BI solution. Provide training and assistance to users for generation of ad-hoc reports Other duties as assigned.

Qualifications:

• High School (Required) Any equivalent combination of experience and education.
• Not Required Must be a current student actively pursuing a degree or certification for the duration of the internship/student worker assignment.
• Required Must meet PSECU’s minimum employment eligibility requirements, including being at least 18 years of age at the time of hire.
• Required In 1934, 22 ordinary people pooled $90 of their own money and formed PSECU, a not-for-profit credit union, to provide a better life for themselves and their families. Since then, PSECU has grown to over $8 billion in assets, more than 590,000 members, and approximately 850 employees. We’ve been recognized by several organizations for our high-quality, low-cost financial products and services, positive member experience, and commitment to helping our Members Achieve More.