APPLICATION INSTRUCTIONS:
CURRENT PENN STATE EMPLOYEE (faculty, staff, technical service, or student), please login to Workday to complete the internal application process (https://pennstateoffice365.sharepoint.com/:b:/s/KnowledgeBaseArticlesSharing/EfiwgKReZ4VAjprFZPKWUm0BqsU3KzTmERfpryq0esPKQ) . Please do not apply here, apply internally through Workday.
CURRENT PENN STATE STUDENT (not employed previously at the university) and seeking employment with Penn State, please login to Workday to complete the student application process. (https://pennstateoffice365.sharepoint.com/:b:/s/KnowledgeBaseArticlesSharing/Eeys15Xva4hFokHVtbP1eGIB5i1WFLc-J3k9KHgrFYZ7mg) Please do not apply here, apply internally through Workday.
If you are NOT a current employee or student, please click “Apply” and complete the application process for external applicants (https://hr.psu.edu/sites/hr/files/ApplicationProcessforExternalApplicationsNon-PennStateEmployees.pdf) .
JOB DESCRIPTION AND POSITION REQUIREMENTS:Position Introduction Auxiliary and Business Services (A&BS) Information and Technology office is actively searching for a highly motivated Application Developer - Business Intelligence.Application Developers are responsible for designing and/or modifying computer systems and applications according to specifications and business requirements; design, code, test, debug, document, deploy, and maintain applications; evaluate existing applications and recommend technical solutions to improve scalability; may develop new applications when existing solutions are not available.The Developer will collaborate closely with business stakeholders and analysts to understand and prioritize data and information requirements. The primary focus of this position will be designing and developing business intelligence (BI) applications and architecture. Through this position, A&BS IT offers an exciting opportunity to contribute to our Business Intelligence culture. If you have creativity and initiative, this role may be the perfect fit for you. As a critical member of the team, you’ll address technical challenges, optimize BI tools, multitask, meet deadlines, and engage in effective customer communication. Your impact will be instrumental in driving success! LocationThe location of this job is primarily in person at the University Park Campus, in State College, PA. with some flexibility for an occasional hybrid mix of in-person and remote work. Candidates must live in the local area or be willing to travel to campus as needed at their own expense. Questions related to flexible work arrangements should be directed to the hiring manager during the interview process. Candidates must be able to work in the U.S. without sponsorship. Position ResponsibilitiesThe successful candidate will be responsible for the following:
Analyze and Present Data: Analyze data and present it through reports to aid in decision-making, identifying and monitoring key performance indicators (KPIs).
Customize Data Models: Understand business requirements and customize data models to best fit user
Build and Maintain PowerBI Dashboards: Use advanced data modeling to create and support PowerBI-based dashboards and related infrastructure.
Design, code, test, debug, implement, modify, and maintain new or existing applications; evaluate code to ensure that it is valid, is properly structured, meets industry standards, and is compatible with browsers, devices, and operating systems
Collaborate for Insights: Engage with subject matter experts and domain experts to gain operational insights and ensure data accuracy.
Investigate data and/or program problems; determine source of problem and take corrective action
Communicate with Stakeholders: Define deliverables, timelines, and responsibilities through effective communication with clients, partners, and internal analysts.
Integrate Reports: Create, publish, and schedule Power BI reports, integrating them into other applications using embedded services or API automation.
Educate and Support Users: Train users and stakeholders on self-service data solutions and provide ongoing support.
Qualifications This position will be filled as an Intermediate Professional or Advance Professional Applications Developer, depending on the final applicant’s experience and education. The Intermediate Professional requires a minimum of an associate degree and 2+ years of relevant experience or an equivalent combination of education and experience. Additional education and/or experience are required for higher-level positions. The successful candidate will have relevant experience, skills and familiarity in:
Data Analysis Expression (DAX) experience – strong understanding and experience of Power BI application layer models
Experienced writing DAX: defining, building, releasing, and evangelizing Power BI-based dashboards
Demonstrated experience in designing, developing and managing complex reports and dashboards
Proficient in Information Systems
Excellent analytical and problem-solving skills for translating data into meaningful visualizations
Working knowledge of Power Queries; MS Power BI suite (Power Query/M/DAX), R language, MS PowerApps
Knowledge of SQL queries, SQL Server Reporting Services (SSRS)
It is preferred that the successful candidate also have:
Bachelor’s Degree in Computer Science, Computer Engineering, or a closely related field
Experience working in Microsoft Fabric (MS Fabric)
Experience with .Net/C#/ASP.NET
Experience with Python
The Pennsylvania State University is committed to and accountable for advancing diversity, equity, inclusion, and sustainability in all of its forms. We embrace individual uniqueness, foster a culture of inclusion that supports both broad and specific diversity initiatives, leverage the educational and institutional benefits of diversity in society and nature, and engage all individuals to help them thrive. We value inclusion as a core strength and an essential element of our public service mission.The salary range for this position, including all possible grades is:$61,800.00 - $115,100.00Salary Structure (https://hr.psu.edu/current-employee/compensation/staff-salary-grades-and-leveling-matrix) - additional information on Penn State's job and salary structure. CAMPUS SECURITY CRIME STATISTICS: Pursuant to the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act and the Pennsylvania Act of 1988, Penn State publishes a combined Annual Security and Annual Fire Safety Report (ASR). The ASR includes crime statistics and institutional policies concerning campus security, such as those concerning alcohol and drug use, crime prevention, the reporting of crimes, sexual assault, and other matters. The ASR is available for review here (https://police.psu.edu/annual-security-reports) .Employment with the University will require successful completion of background check(s) in accordance with University policies. EEO IS THE LAWPenn State is an equal opportunity, affirmative action employer, and is committed to providing employment opportunities to all qualified applicants without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. If you are unable to use our online application process due to an impairment or disability, please contact 814-865-1473.Federal Contractors Labor Law Poster (https://affirmativeaction.psu.edu/files/2022/01/Federal-Contractors-Labor-Law-Poster.pdf) PA State Labor Law PosterAffirmative Action (https://policy.psu.edu/policies/hr11) Penn State PoliciesCopyright Information (https://www.psu.edu/copyright-information) HotlinesUniversity Park, PA
