DNA Genotek→
Intern-Enterprise Applications at DNA Genotek in Bethlehem, PA
InternshipOn-siteBethlehem, PA$31k–$31k/yr
Skills
sql serversql queriesstored proceduresdatabase security administrationtransaction log monitoringpower bi gateway administrationdata quality investigationlogical reasoning
Job Description
Summary: OraSure Technologies Inc. is seeking a highly motivated and intellectually curious Enterprise Applications Intern to support their IT Enterprise Applications team. The role focuses on SQL Server development and administration support, data quality investigation, reporting, and cleanup of legacy technical debt, providing a valuable opportunity for students or recent graduates interested in enterprise data systems.
Responsibilities:
- Assist with development and maintenance of SQL Server queries, views, and stored procedures
- Support technical debt cleanup including identifying and removing unused database objects
- Assist with SQL Server security administration and cleanup activities
- Support transaction log monitoring and basic maintenance tasks
- Generate standard and ad-hoc reports
- Assist with data quality investigations and corrective actions
- Support data transfer failure investigations and root cause analysis
- Assist with Power BI Gateway administration and monitoring
Required Qualifications:
- Analytical Thinking
- Logical Reasoning
- Problem Solving
- Intellectual Curiosity
- Attention to Detail
- Integrity
- Time Management
- Ability to Work Independently
- Collaboration
- Foundational understanding of relational databases and SQL concepts
- Coursework or hands-on experience with SQL queries, joins, and basic database structures
- Strong logical and analytical skills, typically demonstrated through Computer Science, Mathematics, or related coursework
- Interest in enterprise systems, data quality, and operational reliability
- Currently pursuing or recently completed an undergraduate degree in Computer Science, Information Systems, Mathematics, Data Analytics, or a related field
- Academic, project-based, or internship experience involving databases or reporting is acceptable
- Must be capable of working in an office environment
- Must be capable of giving and following written and oral directions
- This is an on-site only position (no remote work). Individual is required to transport themselves to and from work daily
Preferred Qualifications:
- Familiarity with AI-assisted tools such as Claude and Copilot is a plus
Required Skills: SQL Server, SQL Queries, Stored Procedures, Database Security Administration, Transaction Log Monitoring, Power BI Gateway Administration, Data Quality Investigation, Logical Reasoning
Benefits: Tiered Medical PPO, EPO, Vision and Dental coverage, Disability and Life Insurance Benefits, Generous 401K plan and company-matching contributions, Highly competitive paid time-off, Maternity Leave and Parental Leave Coverage, Employee Referral Program – you may be eligible for a cash bonus if your referrals are hired, Employee Assistance Program, Employee Service Recognition, Job-related Training Programs, Ability to participate in Teams, Committees, Events and Clubs, Free Onsite Parking
Benefits
Tiered Medical PPO, EPO, Vision and Dental coverage
Disability and Life Insurance Benefits
Generous 401K plan and company-matching contributions
Highly competitive paid time-off
Maternity Leave and Parental Leave Coverage
Employee Referral Program – you may be eligible for a cash bonus if your referrals are hired
Employee Assistance Program
Employee Service Recognition
Job-related Training Programs
Ability to participate in Teams, Committees, Events and Clubs
Free Onsite Parking