Programmer Analyst

• 
  CURRENT PENN STATE EMPLOYEE (faculty, staff, technical service, or student), please login to Workday to complete the i nternal application process . 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 . 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 .
  

JOB DESCRIPTION AND POSITION REQUIREMENTS:

If you’re interested in being a part of an Information Technology Team that works hard finding solutions and providing the best user experience for our students, faculty, and staff, all while still having fun with co-workers, then consider working for Penn State’s Outreach and Online Education Information Technology (OOE IT). We investigate, evaluate, and collaborate to find the best technical tools and setup for our future and the next generation of online learners.

The Database Developer will be a creative, analytical, and innovative individual who is passionate about database development and solutioning. They will be working with other developers, database administrators, quality analysts, solution architects, business analysts, data analysts, and other stakeholders to ensure high quality data products are being developed to meet the needs of the organization.

The candidate should have a solid understanding of database development, design and management, and should be able to perform quality control, transform data via ETL processes, debug and analyze code, and work with team members to ensure a high quality product. They will work with other developers and a data quality specialist to maintain the existing data products that have been developed on-premise and work to build out a data lake within Azure to move data that has been planned for migration to the cloud.

This position will be familiar with Azure database development and be able to mentor other developers on migrating and building pipelines, test plans, and maintaining source control within the Azure platform. You would be expected to lead teams to identify, categorize, prioritize and analyze data and information to plan cloud migration and develop architecture artifacts.

A full list of skills helpful in this position:

• Analytical mindset

• Creative approach to work

• Innovative thinker to solving problems

• Pays extra attention to details

• Can communicate well via email, teams, and video calls and selects the right medium for the content to communicate

• Comfortable having technical conversations with database developers, database administrators, and quality analysts, project conversations with project teams, and business conversations with stakeholders

• Mentoring and coaching abilities

• Willingness and ability to learn new technologies

SQL Development Skills

• Data migration skills and working experience with ETL concepts and tools

• Develop stored procedures, functions, packages, triggers and views using T-SQL

• Utilize SQL Management Studio to develop or modify database indexes, schema modification, and unit testing

• Create, maintain, and execute SQL Server jobs

• Create, maintain, and deploy SSIS packages

• Understanding of Azure platform capabilities

Data Architecture Skills

• Ability to understand data flows and create flow diagrams to represent data ecosystems from data source to delivery product

• Ability to create Entity-Relationship diagrams (ERD)

• Ability to document data mapping that show source to destination and logic used from data loading to column calculations

Quality Assurance Skills

• Conduct root cause analysis for issue resolution and documentation through meaningful explanation of failures with examples

• Brainstorming and implement new ways to verify and test data

• Incorporate testing automation and monitoring through Azure DevOps test plans

Project Skills

• Work with product owner or business analyst to fully understand business requirements and convert into appropriate technical solutions

• Ability to break down work into manageable tasks and convey to the project team

• Ability to provide hour estimates of individual tasks

• Regularly provide tasks updates and progress percentages

Further Skills

• Addressing current data documentation gaps

• Assist in planning and implementing a Data Lake ecosystem

OOE IT values customer-focused candidates with excellent written and oral communication, listening, presentation, and interpersonal skills. Candidates should communicate ideas in both specialized and audience appropriate language, be able to prioritize and execute tasks, possess keen attention to detail, think outside of the box, and challenge the status quo. We also look for individuals with the ability to persevere to find the best solution and prove adaptable and accountable.

Education and Experience:

Typically requires a Bachelor's degree and four (4) years of related experience. Or, an equivalent combination of education and experience.

Additional Information: This position can work fully remote. Candidates seeking remote working opportunities are welcome to apply.

This position will require successful completion of standard background checks.  

As a new team member, OOE IT will provide an appropriate onboarding period, along with check-ins with peers and supervisors to address any needs or concerns, and an open door to the Executive Director, ensuring your success.

Penn State Outreach and Online Education Information Technology, along with all of Outreach and World Campus endeavors to create an educational environment that embraces workforce diversity, cultural inclusiveness, and employment equity, with a mixture of life experiences, education, and individual perspectives. To that end, we will ask applicants to share with us their definition of diversity, or evidence of their ability to inspire and nurture diversity, equity, and inclusion when offered an interview. 

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.

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 .

Employment with the University will require successful completion of background check(s) in accordance with University policies. 

EEO IS THE LAW

Penn 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

PA State Labor Law Poster

Affirmative Action

Penn State Policies

Copyright Information

Hotlines

University Park, PA

Remote, PA

University Park, PA

,