Application Developer- Business Intelligence

$61,800 - $115,100/Yr

Pennsylvania State University - State College, PA

Full-time - Entry Level

Remote - State College, PA

10,001+ employees

Educational Services

About the position

The Application Developer - Business Intelligence position at Penn State's Auxiliary and Business Services (A&BS) Information and Technology office focuses on designing and developing business intelligence applications and architecture. The role involves collaborating with business stakeholders to understand data requirements, optimizing BI tools, and addressing technical challenges. This position offers an opportunity to contribute to the Business Intelligence culture within the organization, emphasizing creativity, initiative, and effective communication.

Responsibilities

• Analyze data and present it through reports to aid in decision-making, identifying and monitoring key performance indicators (KPIs).
• Understand business requirements and customize data models to best fit user needs.
• 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 validity and compatibility.
• Engage with subject matter experts to gain operational insights and ensure data accuracy.
• Investigate data and/or program problems; determine the source of the problem and take corrective action.
• Define deliverables, timelines, and responsibilities through effective communication with clients, partners, and internal analysts.
• Create, publish, and schedule Power BI reports, integrating them into other applications using embedded services or API automation.
• Train users and stakeholders on self-service data solutions and provide ongoing support.

Requirements

• Minimum of an associate degree and 2+ years of relevant experience or an equivalent combination of education and experience.
• Strong understanding and experience of Power BI application layer models.
• Experience 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 with 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 and SQL Server Reporting Services (SSRS).

Nice-to-haves

• 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.

Benefits

• Competitive salary range of $61,800.00 - $115,100.00 based on experience and education.