Job Description

• Strong technical knowledge in SQL, SSIS, SSRS.

• Extensive experience with writing batch routines involving complex business scenarios and scheduling them.

• Strong healthcare domain knowledge (Healthcare Terminology)

• Good understanding of the Facets Data Model

• Good understanding and working experience in Member Enrolment, Claims Processing, and Stars Measures.

• Ability to develop relationship with stakeholders and understand the requirements through excellent listening and effective written and verbal communication

• Self-driven, innovation, motivated, well-organized, willingness to work on an onsite/offshore model and ability to work in remote setting.

• Exemplary personal and professional integrity

• Minimum of three to five years’ experience in software development required, with demonstrated expansion of skills over that time.

• Experience working in a project integrating data with MDM platforms preferred.

• Experience writing and tuning complex SQL statement and reporting in RDBMS such as SQL Server, Oracle, DB2, SSRS, Performance Point or Teradata required.

• Java or C# and .Net along with scripting, python and cypher experience preferred.

• Experience with common ETL tools (SSIS, IBM Datastage, Ab Initio, Informatica, Talend) is a plus.

• Experience working with GitHub / source-control systems.

• Knowledge or experience interfacing with Restful or SOAP API’s in both real-time and batch applications is required.

• Must have and maintain a valid driver’s license unless otherwise noted.
• Basic knowledge of CLI tools / dotnet cli build commands.

• Extensive knowledge of SQL Server including the writing of complex stored procedures, functions and SSIS packages as well as basic knowledge of database administration

• Strong understanding and experience of database development methodologies (Agile and Scrum)

• Expert level knowledge of SQL administration, engineering, and monitoring tools

• Demonstrated expertise in performance tuning including both query and server optimization

• Experience with the LOOKML, SQL reporting/data visualization with Looker
• Use Looker tools such as Looker IDE, SQL Runner, & LookML Validator

• Strong knowledge and experience in data modeling, relational database design, optimization for performance, T-SQL, stored procedures, SSIS packages

• Expertise in understanding complex business needs, analyzing, designing and developing solutions

Job Features