Description:
The Sr. Software Engineer in Test accurately translates functional and non-functional requirements to maintainable and appropriate reliable machine executable code. The SEIT responsibility is testing products in development. This includes but is not limited to reports, dashboards, data extracts, automated ETL processes, verifying standards are met, and ensuring accurate data validation. Individuals in this role will have a background in planning, managing, and performing software testing within the responsibility areas described.
Responsibilities:
- Develop and optimize the healthcare data analytics application.
- Maintain SQL databases and objects like indexes, triggers, and views, and write complex queries and stored procedures to test the task in place.
- Design, develop, implement, and document high-quality BI solutions using Microsoft BI stacks like SSIS, SSAS, MDX queries, Power BI, and SQL Stored procedures as per the requirements and specifications are verified.
- Create complex activities and pipelines in Azure Data Factory for historical and incremental data loads into Microsoft Azure cloud data warehouse and monitor Azure Data Lakes.
- Prepare and review the high-level technical design for the release.
- Extract, transform, and load large data sets for automated and manual integration of data from internal and external sources using SSIS.
- Improve / Verify / Modify Power BI dashboards for healthcare analytics for providers and care managers as directed by the business.
- Perform data analysis and troubleshoot data issues with BI solutions and data integration processes.
- Follow Agile principles, working in a mix of Scrum, Kanban, and any hybrid development processes as needed.
- Design and implement data solutions which include locating and extracting data from a wide range of sources for making use of reporting and analysis to drive continuous development.
- Design, develop, and implement harnesses to ensure testability of physical and logical database implementation from application requirements.
- Design and develop automated test frameworks for Data Analytics.
- Design, Develop, and implement automated unit and smoke test frameworks.
- Work with customers, users, and other stakeholders to identify test cases and scenarios to validate the result.
- Create, Maintain, and Execute Automatic test plans, and analyze and report results to the team regularly.
- Prepare and Deploy release candidate software into test and production environments.
- Involve in verification of the Interactive Power BI dashboards and verifying that the developed Power BI dashboards also match the requirements.
- Ensure implementation and maintenance of database backup and recovery procedures for the processing environments, and ensure that data integrity, security, and recoverability are built.
- Monitor and maintain the backups for database recoverability for all production databases.
- Process and maintain SFTP functionality between client and company for inbound data.
- Create, optimize, and utilize multiple sets of data and apply strong data mining, data processing, and data analysis skills to generate insights to drive business initiatives within various levels of the organization.
- Develop comprehensive knowledge of business area processes and information needs and apply them in developing BI content for other users.
Qualifications:
- 3 – 5 years experience working with healthcare data from different sources.
- Must have oncology care and data analytics experience.
- Deep awareness of healthcare data from payors, EHRs, and labs.
- Good understanding of dependencies between data sets and their relevancy within the context of healthcare.
- Experience implementing database processes for healthcare analytics through the use of SQL and stored procedures.
- Knowledge and a solid understanding of the requirements for testing healthcare data.