SQL Server BI Developer | ETL & Dashboards

AnovoRx Holdings LLC; Memphis, Northern (TN, KY); Ibrido; USD 90.000 - 125.000; Tempo pieno

Descrizione del lavoro

AnovoRx Holdings LLC in Memphis, TN is seeking a Database Programmer to design, develop, and maintain SQL Server database objects, ETL processes, and BI data sources to support operational reporting and analytics in a HIPAA-compliant environment.

You will collaborate with the Reporting and Business Analytics team to deliver production-ready datasets, dashboards, and data extracts, ensuring data quality and security.

Competenze

• 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.

Mansioni

• 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.

Conoscenze

SQL Server

T-SQL

ETL pipelines (SSIS)

Data modeling

Power BI/SSRS

HIPAA compliance

Python scripting

Azure SQL

Documentation

Formazione

Bachelor’s degree in Computer Science / related field

Strumenti

SSIS

CPR+

Descrizione del lavoro

AnovoRx Holdings LLC in Memphis, TN is seeking a Database Programmer to design, develop, and maintain SQL Server database objects, ETL processes, and BI data sources to support operational reporting and analytics in a HIPAA-compliant environment.

You will collaborate with the Reporting and Business Analytics team to deliver production-ready datasets, dashboards, and data extracts, ensuring data quality and security.