Job Title: Python/Transact SQL Software Engineer

Company Name: Intellimed International Corporation

Job Url: https://www.simplyhired.com/job/kSb60T8uOTB6sfpHdni-SYR8WVm35nO2_-CLdRXcgR3j-8FSNszARw

Job Description: Python/Transact SQL Software Engineer
Intellimed International Corporation
Phoenix, AZ

Job Details
Full-time
19 hours ago
Benefits
Health savings account
Disability insurance
Health insurance
Dental insurance
Flexible spending account
Paid time off
Vision insurance
401(k) matching
Flexible schedule
Life insurance
Qualifications
Version control
PyCharm
Data Integration (Data management)
Automation
Mid-level
JavaScript frameworks
Analysis skills
Improving database performance
Software documentation
Technical writing
GitHub
Software testing
Developing and maintaining backend systems
Web applications
Technical troubleshooting support
Business requirements
SaaS
AI
Cross-functional collaboration
2 years
Python
MariaDB
T-SQL
Full Job Description
SUMMARY

Intellimed is a Healthcare company providing access to a broad spectrum of healthcare claim and discharge encounter data. This data includes office visits, outpatient surgeries, and hospital inpatient data at a detailed claim level. We process over 800 million claims quarterly. The applications we provide are web-based and include our own developed ad-hoc data mart, dashboard visualizations, Tableau workbooks, and more. Our customers include Hospital Systems, Medical device manufacturers, Physician groups, insurers, etc.

This role will be instrumental in the continuous development and improvement of our internal data processing and customer-facing applications, and will have creative control over methodology, business logic layer, Agentic AI development for automating data processing, and will be involved in the entire end-to-end process of the SAAS hosted applications.

What we are looking for:

Expertise with Python and Pycharm. (Required)
Expertise with GitHub for source control. (Required)
Extensive experience with ANSI SQL stored procedures in MariaDB, MySQL, or Oracle (Required)
Must have permanent residency status in the USA.
Experience with Java Script (Is a plus)
Experience with REACT. (Is a plus)
Experience with Healthcare data. (Is a plus)
Minimum 2 years experience as Python and Transact SQL programming (Required)
Key responsibilities include:

Developing, testing, and maintaining applications using Python.
Designing, optimizing, and maintaining complex T-SQL queries, stored procedures, and functions.
Collaborating with cross-functional teams (e.g., data scientists, analysts, front-end developers) to define requirements and deliver solutions.
Performing data extraction, transformation, and loading (ETL) processes.
Troubleshooting application and database performance issues and ensuring data integrity and security.
Developing scripts for task automation and system integration.
Creating and maintaining technical documentation and specifications.
Required Skills & Qualifications

A strong candidate for a Python and T-SQL role will possess a blend of programming and database expertise:

Proficiency in Python: Strong command of Python programming for backend development, data processing, and automation.
Strong SQL/T-SQL Expertise: Experience with writing and optimizing complex queries, joins, CTEs, views, and stored procedures.
Database Knowledge: In-depth knowledge of relational databases (e.g., Microsoft SQL Server) and data modeling principles.
Problem-Solving Abilities: Strong analytical and problem-solving skills to diagnose and resolve software and data issues.
Relevant Tools: ETL Tools (Navicat), Git, PyCharm or similar IDE. AI tools Claude, etc.
What we offer:

Full-time remote work with flexible work schedules.
Competitive starting salary commensurate with experience.
Potential bonus pay based on company performance.
Healthcare is a vast, fast-growing industry. We work with data for all aspects of the medical life cycle
Comprehensive Benefits Package which includes:
Quality health insurance plans
Traditional 401K plan + match
Vision, dental, disability, and life insurance
Flexible Spending Accounts and Health Savings Accounts
Generous PTO