The Role:

Design and own the data layer for the NEXiA platform modernization — a customer-deployed pharmacy automation system running on SQL Server. This is a database developer and data modeler, not an analytics or data platform role. The mission: re-architect the data storage underneath a legacy application being incrementally decomposed, ensuring the data design reflects real pharmacy workflows rather than the accumulated technical debt of the current schema.

This person lives in the database but understands the application. They design schemas that enforce domain invariants, model the real relationships between pharmacy entities (medications, prescriptions, dispensing events, inventory), and make deliberate decisions about normalization, denormalization, key strategies, and temporal data patterns. They also introduce caching where it's never existed — identifying access patterns that demand it and implementing it cleanly.

The data design must support incremental modernization: legacy and modernized modules will coexist for an extended period, reading and writing overlapping data. This person designs the migration path so the application team can decompose the monolith without a big-bang data migration.

What you’ll do:

Data Modeling & Schema Design

• Design domain-aligned data models for modernized NEXiA bounded contexts, working closely with application engineers and domain experts to ensure schemas reflect real pharmacy workflows
• Model complex entity relationships: static reference records with volatile operational attributes (dispensing events, inventory positions, status changes, audit trails)
• Apply normalization rigorously where data integrity matters; denormalize deliberately where query performance demands it — and document the trade-off
• Design key strategies appropriate to each context: natural/composite keys for domain identity, surrogate keys where decoupling is needed, understanding when each approach creates problems at scale
• Own temporal data patterns: versioned records, slowly changing dimensions, point-in-time queries for audit and compliance

Database Development & Performance

• Write and optimize complex SQL — stored procedures, views, functions, and queries against large transactional datasets
• Design and maintain indexing strategies; identify and resolve performance bottlenecks through execution plan analysis and query tuning
• Implement data migration scripts that move data from legacy schema to domain-aligned structures incrementally, without downtime
• Establish and enforce data integrity constraints at the database level — not just application-level validation

Testing & Performance Validation

• Design and execute database performance tests — load testing against realistic data volumes, identifying bottlenecks before they hit customer environments
• Build automated validation for schema migrations: data integrity checks, constraint verification, rollback testing
• Establish performance baselines and regression detection for critical query paths
• Validate that migrations preserve data correctness across the old/new boundary — not just "it ran without errors" but "the data means the same thing it did before"

Caching Architecture

• Evaluate application access patterns and introduce caching where it provides meaningful performance improvement (Redis or equivalent)
• Design cache invalidation strategies that maintain data consistency with the source of truth in SQL Server
• Define caching boundaries that align with domain module ownership — prevent the cache from becoming another source of hidden coupling

Modernization Partnership

• Partner with application engineers on the data implications of bounded context decomposition: which modules own which data, how do they share it, where are the seams?
• Design anti-corruption layers at the data level — views, APIs, or synchronization mechanisms that let legacy and modern modules coexist without schema entanglement
• Ensure data migration is incremental and reversible; big-bang data migrations are not an option with customers running the system daily
• Participate in domain modeling sessions to validate that data structures support (not constrain) the domain model

AI Tooling & Evolving Practice

• Adopt AI-assisted tools for SQL optimization, schema analysis, data migration scripting, and test data generation
• Use AI tooling to accelerate understanding of the legacy schema — reverse-engineering implicit relationships, identifying dead columns, mapping actual usage patterns
• Demonstrate willingness to evolve tooling and workflows as AI capabilities mature; the database development workflow of 2027 won't look like today's

Mentorship & Standards

• Mentor application developers on data modeling principles — when to add an index vs. restructure a query, why normalization matters, how to think about data ownership
• Establish database development standards: naming conventions, migration patterns, review processes for schema changes
• Provide technical guidance that helps the broader team make better data decisions without creating a bottleneck

Who you are:

• 8+ years of database development experience, with meaningful time spent on production transactional systems (not just reporting or analytics)
• Deep expertise in SQL Server — schema design, query optimization, execution plan analysis, indexing strategies, stored procedures
• Strong data modeling fundamentals: normal forms (through BCNF at minimum), denormalization strategies, temporal data patterns, key design (natural, surrogate, composite)
• Experience designing data layers for systems undergoing modernization or migration — not just greenfield schema design, but evolving a live schema under an active application
• Ability to model data around business domains: pharmacy, healthcare, logistics, manufacturing, or similar operationally complex domains where the data reflects real-world physical processes
• Systems thinking — understanding how data design decisions cascade into application behavior, query performance, and migration complexity
• Comfort reading and reasoning about application code (C#/.NET preferred) to understand data access patterns and domain intent

Even better if you have:

• Experience with caching technologies (Redis, Memcached) and cache invalidation patterns
• Experience with DDD and bounded context decomposition from a data perspective
• Healthcare, pharmacy automation, or regulated-environment experience (audit trail requirements, data retention, compliance)
• Familiarity with on-prem deployment constraints: customer-specific data configurations, upgrade migrations, backward-compatible schema changes
• Active use of AI-assisted tools for database development with concrete examples of impact — hands-on experience with Claude Code, Opus, or Sonnet is a significant plus

Applicants must be authorized to work for ANY employer in the U.S. Employer will not sponsor applicants for work visas.

Compensation:

The estimated base annual salary range for this position is $116,000 to $185,000, though a candidate’s base annual salary shall be determined on a range of factors, including, but not limited to, qualifications and experience. This position may additionally be eligible for an annual discretionary bonus.

What are the perks?

• Generous time off policy that allows you to put your family first
• Opportunity to work on the cutting edge of pharmacy automation in a high growth tech company
• Competitive benefits, salary, and talent development opportunities
• Commitment to professional development and working for a company where your voice is heard

More about iA:

iA® (Innovation Associates®) is a pharmacy fulfillment company that provides an integrated platform of capabilities to support Centralized and Community Pharmacy Fulfillment Solutions. With over 30 years of experience in the pharmacy fulfillment business, we have developed and implemented a suite of automation and software solutions that help deliver quick and sustainable business results. Our integrated Pharmacy Fulfillment Platform enables scalable solutions that helps run the prescription fulfillment process from prescription acceptance to delivery, supporting dynamic design flexibility to service pharmacies in a variety of volumes and settings. Our solutions improve workflow, and increase efficiency, while enabling more time for pharmacists to focus on their patients. iA works with pharmacy providers in the Commercial, Health Systems, Government, and Mail Order/eCommerce markets. iA can help customers transform their pharmacy. For more information, visit iARx.com.

Our Mission: We partner with providers to transform pharmacy through our leading-edge software enabled fulfillment technology and partners to deepen the patient-pharmacist relationship, enhancing patient safety and choice while increasing operational efficiency. iA empowers pharmacists to focus on patient care. iA can run the prescription fulfillment process from start to finish, helping pharmacies manage fulfillment and inventory to help lower costs, improve efficiency, increase safety, and provide comprehensive Rx tracking and real-time support.

Our Products:

• Software
• Modular Hardware
• Sophisticated Counting and Collation Devices

Our Core Values:

• Solutions Driven
• Customer Centric
• Championing Diversity
• Empowering Ownership
• Trust Daringly

To learn more about iA’s product, people and culture visit us at iARx.com OR check us out on LinkedIn, Facebook, or YouTube!

iA provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.