Job Description

The KipuEMR is a full end-to-end Addiction Treatment EMR solution, with a purpose-built CRM and powerful Billing, trusted by 83,000 daily users worldwide. Built and constantly improved in an agile, cloud-based environment, and powered by Business Intelligence. No other EMR can compare to Kipu’s clean medical records, and that translates into higher reimbursements and more authorized days. And Kipu includes HIPAA-compliant Telehealth for one-to-one and group sessions. Once you’ve seen the Kipu platform, you’ll understand why no other technology can compare.

Job Description Kipu is looking for an experienced ETL Developer with Python expertise to join our Data Analytics team. You’ll be joining a dynamic, exceptional team to make huge impacts in a fun, exciting company with significant growth potential. Successful applicants for this position will be working on a wide variety of projects including ETL tasks, data quality analysis, data modeling, monitoring, and automation.

YOUR RESPONSIBILITIES

• Maintain and improve our ETL processes, primarily written using python, and using cloud services on AWS like Lambda functions, Glue, Database Migration Services, or pure python code that runs from Linux servers. 

• Acquiring clinical and financial data from primary or secondary data sources and maintaining Enterprise Data Warehouse, Data Marts, and Data Lakes (AWS S3)

• Explore, identify, analyze complex data sets, and infer relationships among data entities in the absence of explicit documentation.

• Collaborate closely with core developers to understand the structure of the modes/tables, data behind the main applications created in-house.

• Work with stakeholders to understand their data requirements and help them make data-related decisions using your ETL knowledge and experience.

• Developing and implementing data models and well-versed with dimensional model concepts.

• Interpret data, analyze results using visualization techniques and dashboards.

• Write complex SQL queries, with SQL standard, or T-SQL, combining multiple sets of data.

YOUR QUALIFICATIONS

• Proven working experience as a Python Developer, Data Engineer, Database Developer, or Data Warehouse implementation.
• In-depth Python experience building ETL pipelines (Python with data manipulation packages, ETL/ELT frameworks).
• Adept at queries, dashboard design, and presenting findings.
• Proficient with database systems, such as SQL Server, and Postgres, hosted in multiple cloud solutions like AWS, Heroku, Azure, or on-premises.
• Technical expertise regarding data warehouse design and operations based on AWS Redshift.
• Experience with data visualization solutions (Power BI, Tableau, or QuickSight), databases (Postgres, AWS Redshift, SQL Server), and Excel.
• Knowledge of AWS services: S3, Lambda, Kinesis Firehose, Kinesis Streams.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.

COMPENSATION

• Highly competitive salary based on your local market’s compensation data.
• Vacation, sick and paid time off.
• Health, Dental, and Vision Insurance.
• 401(K).

Kipu’s Mission Our mission is to make every Kipu Client, no matter how large or small, a reference client for Kipu.  We will work tirelessly to ensure that every client uses the system to its fullest potential, for the benefit of the people they serve, their employees, and shareholders.  We will do this with the highest regard for ethical standards, WITHOUT CONSIDERATION FOR KIPU’S OWN PROFITABILITY.

Kipu Health is an Equal Opportunity Employer

Company Description

The KipuEMR is a full end-to-end solution, with a purpose-built CRM and powerful Billing, trusted by 80,000 daily users worldwide. Built and constantly improved in an agile, cloud-based environment, and powered by BUSINESS INTELLIGENCE. No other EMR can compare to Kipu’s clean medical records, and that translates into higher reimbursements and more authorized days. And Kipu includes HIPAA-compliant TeleHealth for one-to-one and group sessions. Once you’ve seen the Kipu platform, you’ll understand why no other technology can compare.