Senior Business Intelligence Developer (Remote)

Vaya Health; North Carolina; Remote; USD 110,000 - 140,000; Full time

Job summary

Vaya Health seeks a Senior BI Developer to design, architect, and implement advanced BI solutions, including reports, ETL, and data visualizations. You will mentor BI developers, coordinate with stakeholders, and ensure data quality and security in a healthcare setting.

The role requires strong SQL Server skills, SSRS/SSIS, and Power BI, with 5–7 years in BI or healthcare IT. Remote-friendly, with residency in certain states.

Qualifications

• Bachelor's degree in a related field and 5–7 years in BI or healthcare tech.
• Experience designing BI solutions with SSRS/SSIS and Power BI.
• Strong requirements gathering and documentation skills.

Responsibilities

• Design and implement BI solutions including reports, ETL, and visualizations.
• Collaborate with teams to gather requirements and sign off on specs.
• Lead testing, UAT coordination, and deployment of BI products.
• Document processes and maintain BI solution health and security practices.
• Mentor junior BI developers and promote best practices.

Skills

Mentoring

Communication

Agile

Education

Bachelor's degree in Computer Engineering

Bachelor's degree in Computer Science

Bachelor's degree in MIS

Tools

SQL Server

SSRS

SSIS

Power BI

T-SQL

SSMS

PowerShell

Git

Visual Studio

Job description

LOCATION: Remote – This is a home based, virtual position that operates Monday -Friday from 8:30am-5:00pm EST. Vaya Health welcomes applications from NC, SC, GA, TN, VA, MD, and FL.

GENERAL STATEMENT OF JOB

The Senior Business Intelligence Developer works independently, and collaboratively, to elicit requirements and create specifications. They then design, architect, and implement complex and visually compelling reporting and business intelligence (BI) solutions (data visualizations, extract-transform-load (ETL), ad hoc querying, etc.)

The individual in this position interfaces with various functional teams as required to support the BI solution delivery. They proactively identify needs or issues, develop strategies, and propose/implement technical and process solutions. The Senior BI Developer leads large, complex, or specialized projects and is the subject matter expert for the most complex BI solutions with responsibility for mentoring and training all levels of BI developers as well as customers.

The Senior BI Developer interprets internal or external business issues and recommends best practices. They adapt precedent and may make significant departures from traditional approaches.

Note: This position requires access to and use of confidential healthcare information or protected health information (PHI) as described in laws addressing patient confidentiality, including, but not limited to, the federal HIPAA law, the Confidentiality of Alcohol and Substance Abuse Patient Records law, 42CFRPart2, and various state laws. As such, the individual filling this position shall be required to be trained regarding such laws and shall be required to observe those laws in his/her capacity as an employee of Vaya Health. The individual filling this position shall also sign a confidentiality statement as an employee of Vaya Health.

ESSENTIAL JOB FUNCTIONS

• Business Intelligence (BI) Development:

  This position is responsible for designing and implementing BI solutions to enable the analysis of data to support strategic initiatives and ongoing business requirements. Solutions include, but are not limited to, end-user reports, ad hoc requests, data visualizations, extract-transform-load (ETL) systems, master data management (MDM), and other BI Solutions. This position is expected to proactively approach business units and create the best solution to address business needs and current infrastructure. Care will be given to provide accurate data to fulfill the requirements of the developed solutions. Care will also be given to design and build reusable and reliable code that ensures quality, performance, and responsiveness of reports.

• BI Planning, Design, and Implementation:

  This position will perform requirements analysis, design, and implementation of end-user requested BI solutions. As the Senior BI Developer, this position will work with the Business Intelligence Analyst to further define business requirements and provide specifications for end user sign off prior to development. This position will work with the Analytics Tester and other development team members to coordinate User Acceptance Testing, obtain end user satisfaction with developed product, and implement the final solution.

• BI Solution Administration and Documentation:

  This position shall demonstrate day-to-day adherence with change control procedures and practices and write basic technical documentation for all created BI products. This position will monitor the health and performance of supported systems and communicate potential service problems by identifying patterns occurring across separate BI solutions.

• Professional Development:

  This position is responsible for learning and improving upon the skills necessary to stay competitive in the field and coincide with the advances in technology. This position will participate in conferences, seminars, certification programs, etc. as applicable to ensure continued skill development and technical competency.

• Development and Execution of Industry Security Standards:

  This position is responsible for the development and execution of industry security standards as they relate to BI development and as supported by adopted policy. This position shall follow industry standards and best practices to ensure the security of information, communications, data, etc. when developing BI solutions.

• Other Duties as Assigned.

KNOWLEDGE OF JOB

• Must have extensive development, architecture, and configuration skills in Microsoft SQL Server.
• Must have extensive experience with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
• Must possess expert level competence with Microsoft T-SQL including complex queries and stored procedures.
• Must possess a high- Level of competence with Microsoft Visual Studio and Microsoft SQL Server Management Studio (SSMS)
• Must have proven experience in developing Business Intelligence solutions (reports, ETL, data visualizations, data extracts)
• Must have experience in gathering business and technical requirements and in preparing and documenting specifications.
• Must have experience with Microsoft PowerShell
• Must have a high- level of computer literacy with desktop and cloud-based productivity software such as Office365, Microsoft Office desktop applications, Microsoft Teams, SharePoint, and Skype.
• Experience using a source code control system is required; experience using Git for source code control is desirable.
• Knowledge of Microsoft Power Bi to develop and architect data visualizations is preferred.
• Experience working within an agile development process is preferred.
• Strong knowledge and experience in the development of BI solutions
• Proven ability to meet development commitments and manage expectations
• A proven ability to analyze end user needs, make proactive recommendations to improve existing processes and identify where BI development may create opportunities for improvement
• Proven ability to understand business processes and interact directly with internal customers and peers to provide sound business solutions
• Strong interpersonal skills including mentoring, coaching, collaborating, and team building
• Excellent verbal and written communication skills, ability to articulate ideas clearly
• Proven problem solver, with ability to debug complex processes
• Desire for constant improvement
• Must be able to work independently and as a strong team player
• Ability to work in a fast-paced, deadline driven environment running multiple projects simultaneously
• Must possess the integrity and decision-making skills necessary to work with and protect confidential personal health information.

EDUCATION & EXPERIENCE REQUIREMENTS

Bachelor’s degree in Computer Engineering, Computer Science, Management Information Systems, or related business field required.

5-7 years of development experience with computer industry related degree.

5-7 years of development experience in a healthcare or insurance related environment with any bachelor’s degree.

Degrees other than those listed can be accepted if there is significant work experience in a field related to the duties of this position.

PHYSICAL REQUIREMENTS

Close visual acuity to perform activities such as preparation and analysis of documents; viewing a computer terminal; and extensive reading. Physical activity in this position includes crouching, reaching, walking, talking, hearing and repetitive motion of hands, wrists and fingers. Sedentary work with lifting requirements up to 10 pounds, sitting for extended periods of time. Mental concentration is required in all aspects of work.

RESIDENCY REQUIREMENT

The person in this position must live in NC, SC, GA, TN, VA, MD, or FL for this role.

SALARY

Depending on qualifications & experience of candidate. This position is exempt and is not eligible for overtime compensation.

DEADLINE FOR APPLICATION

Open until filled.

Vaya Health is an equal opportunity employer.