Software Engineer III

MedImpact Healthcare Systems, Inc.•San Diego, CA

9d•Onsite

About The Position

MedImpact Healthcare Systems, Inc. is looking for extraordinary people to join our team! Why join MedImpact? Because our success is dependent on you; innovative professionals with top notch skills who thrive on opportunity, high performance, and teamwork. We look for individuals who want to work on a team that cares about making a difference in the value of healthcare. At MedImpact, we deliver leading edge pharmaceutical and technology related solutions that dramatically improve the value of health care. We provide superior outcomes to those we serve through innovative products, systems, and services that provide transparency and promote choice in decision making. Our vision is to set the standard in providing solutions that optimize satisfaction, service, cost, and quality in the healthcare industry. We are the premier Pharmacy Benefits Management solution! Job Description The Software Engineer III works with team to provide complex software programming for new software, production support and maintenance for existing software, as well as ad-hoc support of key departmental initiatives which drive business functions. The Software Engineer III receives general instructions on new projects and works autonomously to complete deliverables.

Requirements

BS/BA and 6+ years’ experience or equivalent combination of education and experience, and 2 years of SME in respective areas
Proven experience in Python programming and advanced SQL for handling complex data operations.
Demonstrated expertise in designing and deploying robust ETL pipelines.
Experience with backend API development using FastAPI and managing database systems, primarily PostgreSQL and Oracle.
Familiarity with containerization technologies like Docker and Kubernetes, and experience in deploying CI/CD with GitHub Actions or Jenkins.
Strong ability to collaborate with cross-functional teams and adapt to dynamic project requirements.
Demonstrated ability to work collaboratively on project teams and/or matrix-managed teams.
Ability to appropriately schedule and prioritize multiple projects to ensure timely and effective delivery of IT solutions.
Excellent written and verbal communications skills with emphasis on translating technical concepts to non-technical audiences.
Results oriented and ability to juggle multiple concurrent projects with changing priorities and deadlines
Engage in system design and architecture planning to deliver effective and sustainable solutions.
Execute debugging and root cause analysis to troubleshoot issues and ensure system reliability.
Collaborate effectively with cross-functional teams, including Product and QA, to deliver high-quality data solutions.
Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists.
Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.
Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent and to draw and interpret bar graphs.
Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.
Ability to write reports, business correspondence, and procedure manuals.

Nice To Haves

Implement caching solutions with Redis to enhance system performance (optional but beneficial).
Familiarity with PBM business model (plans, programs, and practices) as well as pharmaceutical practices (nomenclature, medications) helpful.

Responsibilities

Utilize expert-level Python knowledge, emphasizing object-oriented programming (OOP), functional programming, and optimization, to build robust ETL solutions.
Apply advanced SQL skills for complex joins, window functions, query performance tuning, and schema design to ensure efficient data manipulation and storage.
Use Shell/Bash scripting to automate tasks and manage server-side operations.
Design and implement robust ETL/ELT data pipelines for handling large datasets, ensuring data is processed efficiently and accurately.
Create, schedule, and monitor Directed Acyclic Graphs (DAGs) in Apache Airflow; write custom operators to enhance workflow capabilities.
Engage in data modeling, normalization, and apply data warehousing concepts to improve data accessibility and maintenance.
Facilitate data integration using FTP/SFTP communications, manage multi-source data ingestion, and achieve schema normalization for a seamless data flow.
Develop high-performance RESTful APIs using Fast API with Python, leveraging async capabilities and managing request handling effectively.
Design APIs adhering to Swagger/OpenAPI standards and implement authentication mechanisms such as JWT or OAuth.
Work mainly with PostgreSQL and Oracle databases, ensuring data integrity and accessibility.
Implement caching solutions with Redis to enhance system performance (optional but beneficial).
Build optimized Docker images for application deployment and manage basic orchestration using Kubernetes to ensure scalable infrastructure.
Understand private server deployment within cloud platforms to maintain application availability and performance.
Implement CI/CD pipelines using GitHub Actions or Jenkins to facilitate automated deployment and reduce downtime.