Python developer Jobs in Allentown, PA

Intern-Enterprise Applications

OraSure Technologies Inc. (OTI) empowers the global community to improve health and wellness by providing access to accurate, essential information. Our ability to positively affect change is powered by the innovative tools and diagnostics we deliver to the market.
Together with its wholly owned subsidiaries, OTI provides its customers with end-to-end solutions.
Its first-to-market, innovative products include rapid tests for the detection of antibodies to HIV and Hepatitis C (HCV) on the OraQuick platform; sample self-collection and stabilization products for molecular applications; and oral fluid laboratory tests for detecting various drugs of abuse.
Overview Here at the OTI our innovative sampling tools and diagnostics unlock access to accurate, essential information that advances global health and well-being. Our products include molecular sampling kits for the genome and microbiome, and rapid diagnostics for infectious disease.
Summary OraSure Technologies is seeking a highly motivated and intellectually curious Enterprise Applications Intern to support our IT Enterprise Applications team. This position is ideal for a current student or recent graduate interested in gaining real-world experience with enterprise data systems, SQL Server, and operational application support.
The role will focus on SQL Server development and administration support, data quality investigation, reporting, and cleanup of legacy technical debt. The intern will work closely with business and functional stakeholders, along with IT staff. This position is best suited for someone who enjoys problem solving, logical thinking, and working independently. On-site presence is required.

Essential Functions & Responsibilities

SQL Server Development Support

• Assist with development and maintenance of SQL Server queries, views, and stored procedures
• Support technical debt cleanup including identifying and removing unused database objects

SQL Server Administration

• Assist with SQL Server security administration and cleanup activities
• Support transaction log monitoring and basic maintenance tasks

Operational Support

• 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

Requirements and Qualifications

Requirements:

Analytical Thinking, Logical Reasoning, Problem Solving, Intellectual Curiosity, Attention to Detail, Integrity, Time Management, Ability to Work Independently, Collaboration

Qualifications

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. Familiarity with AI-assisted tools such as Claude and Copilot is a plus.

Education / Experience

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. Prior professional experience is not required.

PHYSICAL REQUIREMENTS

• Must be capable of working in an office environment.
• Must be capable of giving and following written and oral directions.

TRAVEL REQUIREMENTS

This is an on-site only position (no remote work). Individual is required to transport themselves to and from work daily.

REPORTING STRUCTURE / RESPONSIBILITIES

This role is supervised by the Director of Enterprise Applications in the Information Technology department and works closely with a Business Data Analyst, a Database Developer and other technical and functional staff. Please refer to the current Organization Chart.

OTI encourages applications from all qualified candidates who represent the full diversity of the communities in which we operate. We apply a rigorous, consistent, and equitable standard to the assessment of all candidates, regardless of race, color, national origin, sex (including pregnancy), sexual orientation, gender identity, disability status, age, religion, veteran status or any other protected characteristic. We are committed to creating a diverse and inclusive environment where all employees are welcomed and belong. What we have to offer: - 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 - Depending on the role you may be eligible to work in a hybrid environment or fully remotely - Free Onsite Parking Please note, the above applies to full-time permanent positions.
Culture, People & Community
OTI recognizes that the long-term health of our business is directly connected to the health of the planet, local communities and the OTI family of companies employees.
- LIVE IT Committee committed to creating an environment that embodies our values - All Means U: Employee Committee on Belonging hosts various events across all company locations such as monthly book club and mentorship program - Wellness Committee empowers colleagues to make critical decisions to improve and protect health - Sustainability Committee aims to minimize impact on the environment - Social Committee who organize and run events for both remote and onsite employees, to create connection and community
At OTI, we have a clear vision; cultivate an environment of equal employment opportunity where we do not tolerate discrimination or allow the harassment of employees or applicants on the basis of sex, gender identity, sexual orientation, race, color, religious creed, national origin, physical or mental disability, protected Veteran status, or any other characteristic protected by law with regard to any employment practices.
OTI aims to create and foster workplaces that reflects and contributes to the global communities in which we do business and the customers and partners we serve. This includes all communities impacted by our corporate presence. As part of this commitment, OTI and its subsidiaries will ensure employees and applicants are provided reasonable accommodation per request. If you require disability-related accommodation during the recruitment process, please contact Katheryn Viau at katheryn.viau@dnagenotek.com. OTI will consult with all applicants who request disability-related accommodation during the recruitment process to ensure that the accommodation provided takes into account the applicant's individual accessibility needs.
$15 - $15 an hour

Compensation details: 15-15 Hourly Wage

PIaab495891489-30511-40507156