Database Programmer

Anovo; Memphis (TN); On-site; USD 90,000 - 125,000; Full time

Job summary

AnovoRx in Memphis, TN is seeking a Database Programmer to design, develop, and maintain SQL Server database objects, ETL pipelines, and BI reports for operational analytics in a specialty pharmacy environment. You will collaborate with the Reporting and Analytics team to deliver production-ready datasets while ensuring PHI safeguards and HIPAA compliance.

Responsibilities include building ETL processes, tuning performance, and maintaining documentation.

Qualifications

• Bachelor’s degree or equivalent professional experience.
• 3+ years hands‑on MS SQL Server, T‑SQL, and related database objects.
• Experience building ETL pipelines with SSIS or equivalent.
• Experience with SSRS/Power BI reporting.
• Knowledge of HIPAA data handling preferred.
• Familiarity with CPR+ specialty pharmacy system preferred.
• Cloud databases knowledge (Snowflake/Azure) preferred.
• Strong written communication and documentation skills.
• Ability to work independently and with cross‑functional teams.
• Ability to manage multiple priorities in a fast-paced environment.

Responsibilities

• Design, develop, test, implement, and maintain SQL Server database objects.
• Build and optimize ETL processes to prepare data for reporting and analytics.
• Develop and maintain reporting/dashboard data sources using SSRS/Power BI.
• Support Aperture and other initiatives with data extracts and development support.
• Tune queries, indexes, and logic for performance and scalability.
• Collaborate with analysts and stakeholders to translate data needs into production-ready solutions.
• Maintain data dictionaries, schemas, ETL docs, and technical specs.
• Troubleshoot data integrity, performance issues, and root causes.
• Ensure HIPAA compliance and safeguarding of PHI; follow change management.

Education

Bachelor’s degree in Computer Science or related field

Tools

SQL Server

SSIS

SSRS

Power BI

Azure SQL

CPR+

Aperture

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Database Programmer

Professional Memphis, TN, US

27 days ago Requisition ID: 1303

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. AnovoRx is an Equal Opportunity Employer.