The Senior Programmer is responsible for managing the inflow of a variety of healthcare claims, EMR databases, and Registry databases, checking quality, developing specifications, transforming data to a common data model, and publishing data for use by hundreds of statistical programmers, analysts and data scientists across the company. The programmer will oversee data scheduling and deliveries through the production lifecycle and address any issues encountered during the process.
The qualified candidate must also be able to provide reports, presentations and detailed explanations to epidemiologists, analysts and programmers and work in collaboration with both internal and external partners. Prior experience with large databases and data management methods are strongly desired, as well as experience with SQL, Python, SAS, and visualization tools such as Spotfire.
In addition to technical acuity, strong documentation, communication, and time management skills are essential.
Basic Qualifications
• Bachelor’s degree in Data Engineering, Computer Science, Statistics, Mathematics, or other subject with high statistical and programming content
• 5 years of SAS statistical programming experience specifically for data ingestion workflows.
• Extensive experience with Data profiling, Database querying, transformation and quality control using SQL
• Moderate experience with Python and R (1-2 years) to support broader data engineering and data handling tasks
• Experience with real world healthcare data, such as Optum, PharMetrics, Flatiron and/or Registry databases
• Experience with OMOP specifications and conversions
• Experience communicating with data vendors and holding vendors accountable on data quality and support inquiries
• Working knowledge of Smartsheet for tracking and reporting
• Proficient in leveraging AI tools (e.g., Databricks Genie, MS Copilot) to enhance productivity and decision-making
• Ability to work independently and on teams
• Is a self-starter who manages their own time
• Demonstrates exceptional attention to detail and accuracy in all deliverables
• Exceptional attention to detail in managing data ingestions, including gathering requirements, creating data load assignments, following up with stakeholders, and performing thorough data quality checks.
• Collaboration with the data steward on data deletions, which requires strong judgment, thoughtful decision making, and careful coordination with meticulous attention to both small and large details.
• Excellent coordination and communication skills, given the cross functional nature and visibility of the work.
Preferred Qualifications
• Master’s degree in Data Engineering, Epidemiology, Biostatistics, Computer Science, or other subject with statistical and programming content
• Experience with the Databricks programming environment (Spark SQL, Python, R)
• Reporting and visualization with Spotfire, MS Power BI
• Experience in software development & design life cycle, ideally using Agile methodology
• Pharmaceutical industry experience
