The BI Report Developer role will be responsible for developing and maintaining reports for internal and external use utilizing SQL Server Reporting Services and Power BI. The specific responsibilities include, but are not limited to, the following:

• Create, troubleshoot, and maintain SSRS reports and their corresponding data sets.
• Create, troubleshoot, and maintain Power BI reports based on company endorsed data models.
• Collaborate with product owners, stakeholders and the BI team on reporting and analysis projects.
• Validate report functionality with internal staff and end-users.
• Collaborate with internal QA on acceptance testing and data validation.
• Adhere to development standard operating procedures including design specifications, unit testing and the BI development lifecycle.
• Abide by all obligations under HIPAA related to Protected Health Information (PHI).
• If a HIPAA violation is discovered, whether individually or by another, you must report the violation to the Compliance Officer and/or Human Resources.
• Attend, complete, and demonstrate competency in all required HIPAA Training offered by the company.
• Flexibility to understand, appreciate and embrace that this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Duties, responsibilities, and activities may change, or new ones may be assigned at any time with or without notice.

Our benefits package is designed to keep our employees health and happy - physically, mentally and financially.

• Medical, Dental, Vision Insurance
• Disability and Life Insurance
• Employee Assistance Program
• Remote Work Options
• Generous Paid-Time Off
• Annual Reviews and Development Plans
• Retirement Plan with Company Match Immediately 100% Vested

• Experience with SQL Server 2008 R2 or above.
• Deep understanding of relational databases and query development using TSQL.
• 3+ years of experience using SSRS development environments – Visual Studio and Report Builder 3.0.
• Experience developing Power BI reports.
• Strong communication skills.

• Understanding of Kimball/Star-Schema data warehouse database design.
• Development of reports using SQL Server Analysis Services Multidimensional.
• Knowledge of query development using MDX.
• Power BI modeling; DAX and M a plus.
• Experience with Agile Scrum and Kanban development methodologies.
• Experience in Healthcare/PBM/Pharmacy reporting.

Supervisory Responsibility

No direct supervisory responsibility.

• Full-time/Salaried/Exempt.
• Some flexibility in hours is allowed, but the employee must be available during the “core” work hours of 8:00AM to 5:00PM CT. We cover clients from West to East Coast, work times must be adjusted to cover meetings in all time zones. Ability to work extended hours, weekends and holidays pursuant with industry demands.

This position may require some travel.

• Undergraduate degree in Information Systems or similar.
• 3+ years SQL query development.
• 3+ years SSRS development.
• Or equivalent combination of education and experience.

Liviniti, LLC and all entities provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, Liviniti complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Liviniti expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Liviniti employees to perform their job duties may result in discipline up to and including discharge. EOE M/F/V/D