Data Analyst Intern

PSECU; Harrisburg (Dauphin County); On-site; USD 25,000 - 34,000; Full time

Job summary

PSECU in Harrisburg, PA seeks a Data Analyst Intern to support BI reporting and data analysis initiatives. You will report to the Business Intelligence Manager and help extract data, build dashboards, and generate insights.

You will work with SQL, R, Python and BI tools like Power BI, Tableau or Looker to produce reliable reports and support decision making. This internship emphasizes learning, growth, and hands-on projects within a collaborative credit union.

Qualifications

• Currently enrolled in a degree or certification program for the duration of the internship.
• Must be at least 18 years old and eligible to work in the US.
• Strong knowledge of SQL, R, and Python; BI tooling experience is a plus.

Responsibilities

• Data Analysis – pull, analyze data and build models to support decision making.
• Reporting – create dashboards and BI reports using BI tools (Power BI/Tableau/Looker).
• Other – assist in data security, accuracy, integrity, availability and quality of reports.
• Other duties as assigned by the BI Manager.

Skills

SQL

R

Python

Power BI

Tableau

Looker

Education

High School Diploma or Equivalent

Currently enrolled in a degree/certification program for the duration of the internship

Tools

SQL databases

Excel

Data visualization tools

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 RequiredMust be a current student actively pursuing a degree or certification for the duration of the internship/student worker assignment.| RequiredMust meet PSECU's minimum employment eligibility requirements, including being at least 18 years of age at the time of hire.| Required