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