Software Engineer In Test

**This is a remote position but prefer candidates local to Dallas, TX or Atlanta, GA**

The Software Engineer in Test accurately translates functional and non-functional requirements to maintainable and appropriate reliable machine executable code. The SEIT's responsibilities are 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 the 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.
• Involved in verification of the Interactive Power BI dashboards and verifying 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.

• Must have experience with healthcare Oncology pharma or Oncology EMR /PM systems or Clinical Data experience.
• Proficient in SQL and business intelligence tools.
• Experience working in Python or are excited to learn.
• Experience designing automated data quality validations and verifications.
• 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 of healthcare data.

Benefits:

Integra Connect, LLC provides a comprehensive benefits plan.

• Medical/Dental/Vision Insurance beginning the 1st of the month following your date of hire
• Paid Time Off
• 401k with employer match
• Paid Holidays and Floating Holiday

Equal Opportunity Employer

Important Notice:

At Integra Connect, we are committed to providing a safe and secure environment for our job applicants. Unfortunately, scammers may attempt to impersonate our company to deceive individuals seeking employment. We take this matter seriously and want to ensure your job search with us is free from any fraudulent activity.

Integra Connect has become aware of recent, fraudulent recruitment activity being conducted by individuals or groups who claim to be third party recruiters and/or points of contact for our Company. Examples include sending candidates a request for personal information, conducting online interviews or meetings, making offers of employment, demanding money for employment related services and activities, or asking the applicant to purchase a laptop or other work-related equipment for the job. The aim of the fraud is to obtain personally identifying information (e.g., identity theft) and/or money. The Company’s name, as well as the names of employees, are used to try to convey authenticity.

Here are some tips to help you identify and avoid job scams:

1. Always Check the Source:

Ensure that the job listing is on our official website or a reputable job board. Our official domain is https://www.integraconnect.com/resources/careers/. Be cautious of unsolicited emails, text messages, or social media messages offering job opportunities.

2. Be Wary of Requests for Personal Information:

We will never request sensitive personal information like your Social Security number, bank details, or payment for onboarding/equipment. If you encounter such requests, it's likely a scam.

3. Verify Contact Information:

Check that the contact information provided in the job posting, including email addresses and phone numbers, aligns with our official contact information. Scammers often use generic or non-company email addresses.

• What is the sender’s email address? Is it consistent with other job postings from this company? Email addresses that are slightly different from any business’s primary contact information (“Jane.Doe@IntegraConnect.org” vs “John.Doe@Integra Connect.com”) are a common warning sign.
• If you are contacted through LinkedIn, be sure to review the entire profile to verify their credentials.

If you suspect that a job offer is fraudulent, we recommend that you do not respond to it.

If you believe you are the victim of any fraudulent activity, you can report it to the appropriate authorities at https://www.myfloridalegal.com/consumer-protection/how-to-protect-yourself-job-listing-and-job-search-firms (Florida Department of State) and/or https://consumer.ftc.gov/articles/job-scams#report (U.S. Federal Trade Commission).

Integra Connect is not responsible for any fraudulent offers and advises prospective candidates to follow the guidance provided above.

Thank you for your interest in a career with Integra Connect. We look forward to connecting with genuine, talented individuals like you.