Healthcare Data Warehouse and Integration Developer

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)