Job Summary:The Database Programmer is responsible for designing, developing, and maintaining SQL Server database objects, ETL processes, reports, dashboards, and data extracts that support operational reporting and business analytics across AnovoRx. This role partners with the Reporting and Business Analytics team and business stakeholders to translate raw operational data into reliable, well-structured, production-ready datasets that support decision-making in a specialty pharmacy environment serving patients with rare diseases. The position also supports key initiatives, including Aperture, while ensuring data handling practices protect PHI and comply with HIPAA requirements.
Primary Duties and Responsibilities- Design, develop, test, implement, and maintain SQL Server database objects, including stored procedures, views, functions, triggers, tables, and related structures.
- Build, enhance, and optimize ETL processes to extract, transform, validate, and prepare data from core systems, including CPR+, for reporting, dashboards, analytics, and operational use.
- Develop and maintain reporting and dashboard data sources using tools such as SSRS, Power BI, or similar business intelligence platforms.
- Support the Aperture project and other active initiatives by delivering accurate, timely, and well-documented data extracts, queries, and database development support.
- Tune queries, indexes, and database logic to improve performance, scalability, and reliability across growing data volumes.
- Partner with analysts, business stakeholders, and cross-functional teams to understand ad hoc and recurring data needs and translate them into sustainable, production-ready database solutions.
- Maintain data dictionaries, schema documentation, ETL documentation, and technical specifications to support transparency, continuity, and knowledge transfer.
- Troubleshoot database, reporting, data integrity, and performance issues; identify root causes and recommend or implement corrective actions.
- Ensure database development, data extraction, and data handling practices are consistent with HIPAA requirements and Company policies for safeguarding PHI and confidential information.
- Follow database development best practices, coding standards, testing procedures, and change management processes to promote quality and reliability.
- Other work-related duties as assigned by supervisor/manager.
Minimum Knowledge, Abilities, and Skills Required- Bachelor's degree in Computer Science, Information Systems, a related field, or equivalent professional experience required.
- Minimum of three years of hands-on experience with Microsoft SQL Server, including T-SQL development, stored procedures, views, functions, and related database objects.
- Experience building, maintaining, and optimizing ETL pipelines using SSIS or an equivalent ETL tool.
- Strong understanding of relational database design, normalization, indexing strategy, query tuning, and database performance optimization.
- Experience supporting reporting and business intelligence tools such as SSRS, Power BI, or similar platforms.
- Ability to translate ad hoc and recurring business data needs into accurate, reliable, production-ready SQL queries, data extracts, and reporting datasets.
- Snowflake, Azure, a strong understanding of cloud databases, and project/data migration
- Strong written communication skills, including the ability to document data structures, schemas, ETL processes, technical specifications, and recurring reporting logic.
- Experience in healthcare, pharmacy, specialty pharmacy, or another regulated data environment preferred.
- Familiarity with specialty pharmacy systems, including CPR+, preferred.
- Working knowledge of HIPAA data handling requirements and safeguards for PHI preferred.
- Scripting experience, such as Python or PowerShell, for automation preferred.
- Exposure to Azure SQL or other cloud-hosted SQL Server environments preferred.
- Must have excellent computer skills and proficiency with Microsoft Office Suite, including Excel, Word, and PowerPoint.
- Must have history evidencing reliability and consistency in timeliness, attendance, and quality of work.
- Must articulate thoughts well and communicate clearly, both orally and in writing.
- Able to work independently as well as collaboratively with analysts, business stakeholders, and cross-functional teams.
- Willingness to work in a fast-paced environment and manage multiple priorities effectively.
- Must not have history evidencing dishonesty, lack of trustworthiness, or workplace violence.
- Must pass the Company's drug test and background screening prior to start of employment.
- Cannot be disqualified or suspended from participation in any state or federal healthcare program.
This description is intended to be only a general outline of major activities. It is expected that the employee performs these and any other activities which may be assigned, or which may occur in the normal course of work. This description is not a contract or guarantee of employment. 
