Healthcare Data Warehouse and Integration Developer

Job Description

KGO Consulting is a growing technical consulting company that specializes in Business Intelligence and Reporting, Data Architecture, Data Integration, Database Administration, Data Security, SharePoint, Cloud Design and Migration, EDI Integration, Disaster Recovery, and Enterprise Architecture Planning. This position requires the employee to be in the office Monday through Friday. Please only apply if you are local.

We offer our team:

• Competitive compensation + bonuses
• Top-tier medical, dental, and vision benefits
• 401(k) with company match
• Paid time off and paid holidays
• Annual education/training expense reimbursement
• A culture that is dedicated to ongoing employee training and development

You Can Expect To:

• Build and maintain our client data warehouses
• Build Power BI and SSRS reports
• Build SQL Server Integration Services Packages
• Build Tabular Model OLAP Cubes
• Work closely with clients to identify their needs and execute projects

What You'll Need:

• Healthcare data experience on the payer (health insurance) or ACO (Accountable Care Organization) side – 3-5 years
• Healthcare claims experience
• Provider data experience
• EDI X12 data formats
• Encounter workflows

Technical Experience

• SQL Server T-SQL Development - Expert – min 5 years
• SQL Server Integration Services – min 5 year
• Power BI – 1 year
• SQL Server Reporting Services – 1 year
• SQL Server Analysis Services
• Excel Pivot Tables

The ability to successfully lead client projects to completion

• Must be comfortable leading projects and helping clients figure out what they need
• Be able to express creative ideas that will help healthcare clients
• Be able to manage multiple projects simultaneously
• Must be detail-oriented
• Must validate all data that we process

Preferred experience, but not required:

• SQL Server Analysis Service – DAX
• SQL Server Database Administration
• Windows Failover Cluster
• Powershell

Job Type: Full-time

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Paid time off
• Professional development assistance
• Tuition reimbursement
• Vision insurance

Schedule:

• Monday to Friday (Onsite)