Work Schedule

Environmental Conditions

Job Description

Principal Programmer Analyst

Division/Department: Biostatistics – Center of Excellence
Reports To: Associate Director or above
People Management: No direct reports
Travel: No travel required

About the Role

We are seeking an experienced Principal Programmer Analyst to serve as a technical lead across multiple clinical technology initiatives supporting Biostatistics, Centralized Monitoring, and Clinical Data Management.

In this role, you will lead the design, development, maintenance, and support of enterprise applications, databases, and data integration solutions. You will work closely with cross-functional business stakeholders to understand requirements and deliver scalable technical solutions that improve operational efficiency, data quality, application performance, and business decision-making.

This is an individual contributor position with significant responsibility for technical leadership, mentoring, project leadership, and subject matter expertise across multiple technology initiatives.

Key Responsibilities

• Serve as the technical lead for clinical application development projects supporting Biostatistics, Centralized Monitoring, and Clinical Data Management.
• Lead technical decisions and establish development standards and best practices.
• Design, develop, maintain, and enhance GUI-based applications used by clinical teams to review, validate, modify, and manage clinical operational and study data.
• Develop and maintain applications using Microsoft .NET technologies and C++.
• Build and maintain enterprise integrations across .NET/C++ applications, Microsoft SQL Server databases, and Snowflake repositories.
• Design and develop SQL Server and Snowflake database structures, including tables, views, stored procedures, functions, and automated data integration processes.
• Develop data mapping, validation, transformation, and synchronization processes across enterprise platforms.
• Create and maintain REST API and system integrations.
• Develop scalable data pipelines that transform enterprise data into operational SQL Server databases and publish curated datasets to Snowflake for reporting and analytics.
• Partner with business stakeholders and management to gather requirements and translate business needs into effective technical solutions.
• Independently troubleshoot and resolve application and data integration issues while minimizing disruption to clinical operations.
• Evaluate new technologies and recommend improvements to application scalability, maintainability, performance, automation, and data quality.
• Collaborate with cross-functional teams to prioritize enhancements and contribute to long-term application roadmaps.
• Support validation, testing, release activities, and production support for business-critical applications.
• Develop and maintain technical documentation in accordance with internal policies.
• Provide technical leadership, mentoring, and subject matter expertise across multiple initiatives.
  

Education and Experience

• Bachelor's degree in Computer Science, Software Engineering, Information Systems, Bioinformatics, or a related discipline.
• 10+ years of relevant experience in GUI/application development, database programming, enterprise integrations, and application support.
  

Required Skills and Experience

• Strong programming experience with Microsoft .NET technologies.
• Strong programming experience with C++.
• Strong Microsoft SQL Server development experience.
• Advanced SQL programming skills, including stored procedures, views, functions, and query/performance optimization.
• Experience designing and developing Snowflake databases, views, data pipelines, and optimized queries.
• Experience developing REST APIs and system integrations.
• Experience designing and developing GUI-based applications based on business and user requirements.
• Strong experience with data integration, mapping, transformation, validation, and synchronization.
• Strong understanding of relational database architecture.
• Experience supporting enterprise or business-critical applications.
• Knowledge of the clinical trial or pharmaceutical industry.
  

Additional Skills

• Excellent analytical, troubleshooting, and critical-thinking skills.
• Demonstrated technical leadership and mentoring capabilities.
• Strong written and verbal communication skills.
• Ability to work independently and collaborate effectively with technical and business stakeholders.
• Strong customer-service orientation.
• Delivery and quality-focused approach.
• Ability to manage and contribute to multiple technical initiatives simultaneously.
  

What Success Looks Like

The successful candidate will combine strong hands-on technical expertise in .NET, C++, SQL Server, Snowflake, REST APIs, GUI development, and enterprise data integration with the ability to lead technical decisions and work directly with clinical business stakeholders. The role requires someone who can independently own complex technical solutions while providing leadership and guidance across multiple clinical technology initiatives.