E

ExactCare

Long-term care pharmacy and medication management

Senior Data Engineer

Data EngineeringConfirmed live in the last 24 hours
Full-timeRemote in USANo salary listed

About the Job

Requirements

  • A bachelor's degree in Computer Science, a similar technical field, or at least four years of related experience and/or an equivalent combination of education and experience is required.
  • Proficiency in database design, normalization, and data modeling.
  • Strong ability with dimensional data modeling and online analytical processing principles.
  • At least 10 years of SQL database development using the full Microsoft SQL Server toolset, including SQL Server Integration Services, SQL Server Reporting Services, SQL Server Management Studio, SQL Server Analysis Services, and relational database management systems.
  • At least five years of experience with data warehouse methodologies.
  • Expertise in query tuning, performance optimization, and troubleshooting.
  • Familiarity with cloud-based database solutions such as Azure SQL Database and AWS Relational Database Service.
  • Advanced SQL skills, including data modeling, database object creation and management, and indexing.
  • Experience implementing high-availability, high-throughput, scalable systems.
  • Expertise identifying and diagnosing application- and database-related issues, performing root cause analysis, and recommending corrective actions.
  • Experience with PowerShell and Python.
  • Experience using AWS, GitLab, and Visual Studio.
  • Familiarity with .NET, C#, JavaScript Object Notation, Extensible Markup Language, VisualCron, and Power BI.
  • Familiarity with reporting and visualization tools such as Power BI and Tableau.
  • Knowledge of non-relational databases such as MongoDB and Cassandra, and big data technologies such as Hadoop and Spark.
  • Knowledge of pharmacy industry standards such as National Council for Prescription Drug Programs, Health Level Seven, and ANSI X12, and/or related drug database terminologies and classifications.
  • Knowledge of Medicare Part D, prescription drug event submissions and returns, pharmacy claims, and benefit management.
  • Ability to architect, design, develop, and implement solutions using microservice and monolithic architectures.
  • Written and verbal communication skills, with the ability to work collaboratively with a team and independently as needed.
  • Initiative and follow-through on projects with minimal supervision or guidance.
  • Ability to work in multiple technical areas or disciplines.
  • Interest and ability to learn other coding languages and technologies as needed.
  • Applicants must be eligible to work in the United States.
  • Must be able to commute to multiple site locations within the assigned territory.
  • Must be available to work outside normal business hours on an ad hoc basis as needed.

Responsibilities

  • Work in an Agile development environment and actively participate in and contribute to all Scrum ceremonies.
  • Design, develop, and deliver solutions according to requirements and committed schedules.
  • Work closely with the Product Owner to evaluate current systems and make decisions about future development.
  • Test, debug, and enhance existing code, processes, and reports.
  • Maintain existing processes, including VisualCron schedules, SQL and extract-transform-load procedures, and reporting.
  • Assist with troubleshooting pharmacy-claim-related issues, reports, and processes.
  • Support existing .NET applications and the related SQL code for NCPDP Pharmacy Encounter data submissions.
  • Produce detailed technical specifications based on requirements and design.
  • Monitor and optimize database performance, including query tuning and indexing strategies.
  • Review new and existing processes and recommend reliable, maintainable code.
  • Analyze and research software requirements to determine the feasibility of designs and market requirements within time and cost constraints.
  • Serve as a technical expert in designing, developing, coding, testing, and debugging new software or complex enhancements to existing software.
  • Learn new technologies and resolve challenges involved in integrating them with cloud and product infrastructure.
  • Proactively raise problems and solutions to staff engineers and management.
  • Communicate and propose solutions concerning updates, changes, and risks to stakeholders.
  • Share knowledge through mentorship to help develop and advance the team.
  • Keep abreast of emerging trends and best practices in database development and related technologies.

Desired Qualifications

  • A master's degree in Computer Science or a similar technical field.
  • Experience with Agile methodologies such as Scrum, Kanban, or Lean.
  • Experience in healthcare technology and online pharmacy claims adjudication.

About the Company

ExactCare

Long-term care pharmacy and medication management

ExactCare Pharmacy provides medication management for patients with complex regimens in long-term care, offering reconciliation, refill management, pre-sorted packaging, and home delivery. It coordinates with patients, families, and healthcare providers to review medications, reduce errors, and ensure timely dispensing, with packaging organized by dose and administration time. The company differentiates itself through HITRUST-certified data security and by delivering end-to-end medication management within existing provider and insurer care plans. Its goal is to simplify complex regimens, improve adherence, minimize adverse events, and support caregivers and healthcare teams.

Company size
201-500
Company stage
Not listed
Total funding
Not listed
Headquarters
Valley View, OH
Founded
2009

Recently Posted Jobs

Explore more opportunities at ExactCare

See more jobs