Python/Transact SQL Software Engineer

Intellimed

• $90K — $120K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Expertise with Python and Pycharm is mandatory.
  • Proficiency in GitHub for source control is required.
  • Extensive experience with ANSI SQL stored procedures in databases such as MariaDB, MySQL, or Oracle.
  • Permanent residency status in the USA is necessary.
  • Minimum of 2 years experience in Python and Transact SQL programming is essential.
  • Familiarity with JavaScript and REACT is beneficial but not required.
  • Experience handling Healthcare data is a plus.

Responsibilities

  • Develop, test, and maintain Python applications.
  • Design and optimize complex T-SQL queries and stored procedures.
  • Collaborate with cross-functional teams to define project requirements.
  • Perform data extraction, transformation, and loading (ETL) operations.
  • Troubleshoot performance issues and maintain data integrity.
  • Develop scripts for automating tasks and integrating systems.
  • Create and update technical documentation and specifications.

Benefits

  • Full-time remote work with flexible schedules.
  • Comprehensive benefits package including health insurance, 401K, and dental.
  • Generous paid time off (PTO) policy.
  • Potential for bonus based on company performance.
Full Job Description
SUMMARY

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

Similar Jobs

More Information Technology Jobs

Find similar Python/Transact SQL Software Engineer jobs: