Seeking a Software Engineer with responsibilities for delivering software in Java or Python as well as scripting complex SQL solutions and database stored procedures for reporting. The engineer will also work with other developers in optimizing SQL queries, redesigning database table structures, and establishing best practices for high performance software. The engineer will also be creating automated test suites to ensure that the software is robust and remains defect-free through maintenance and enhancements.
The ideal candidate will be comfortable working with internal and external customers to understand their information needs and have the ability rapidly prototype solutions. He or she will also be able to clearly communicate new features and issues at all levels in the organization.
Design, implement, test and deliver software using a modern Object-oriented language like Java or Python, with unit tests and other automated regression testing methodologies.
Develop SQL queries and stored procedure to satisfy data and reporting requirements.
Design, build and maintain ETL pipelines to support data and analytical needs.
Build integrations with third-parties to link their data to our systems based on standardized formats such as HL7.
Troubleshoot data issues, and build repeatable processes to handle data feeds reliably.
Maintain and enhance data warehouse platform, capabilities, data schemas, and models.
Build custom reports that help visualize various facets of the data.
Identify and correct issues relating to database performance, reliability, and scalability.
Ensure the quick implementation of mass data change requests and complex report/data extraction requests ensuring the impact on existing applications is adequately analyzed.
Work incrementally in a Lean/Agile environment using practices like Scrum or Kanban.
Document production process flows.
Bachelor's degree from an accredited college or university required with major course work in computer science, business information systems, or a related field.
2+ years of experience with a modern object-oriented language like Java/C#/Python.
3+ years of experience creating and tuning SQL queries with Postgres, Oracle, or MS SQL Server.
1+ years of experience designing table structures in Relational Database Systems.
1+ years of experience creating or maintaining stored procedures, preferably in a Healthcare industry.
2+ years of experience with version control systems like Git, Subversion, or Mercurial.
Familiarity with an automated build system like Jenkins, Jenkins Pipeline, or Concourse.
Familiarity with tools that can aid with profiling and optimizing server resource usage.
Ability to troubleshoot common database performance issues.
Proficiency with Linux scripting and tools like crontab, bash.
Understanding of ETL design, data cleansing and processing.
Experience with Data Mining (i.e., SQL, ETL, complex data warehouses).
EMR and Healthcare claims data experience.
Comfortable with building analytics using BI tools such as Qlikview or Tableau.
Comfortable working in an entrepreneurial environment where continuous innovation is desired and ambiguity is the norm.