Career Opportunities | Conexess Skip to main content

Career Opportunities

BI Data Warehouse Developer

Job Title
BI Data Warehouse Developer
Job ID
King of Prussia,  PA 19406
Other Location

BI Data Warehouse Developer


Conexess Group is excited to be aiding a local healthcare client in their search for a BI Date Warehouse Developer Value Based Payment (VBP) team. This individual will need to have full stack experience but will be focusing on more back end development work. As part of the full stack development team that consists of multi-talented developers, we are looking for candidates who enjoy the variety, challenges, and learning opportunities that this job offers.

This individual will lead other developers as well as contribute directly to the development of our VBP solution, leveraging cutting-edge Azure services to solve business challenges faced by the world’s largest healthcare systems.


Duties and Responsibilities:

  • Design, develop and maintain VBP ETL solution using SSIS, T-SQL, and U-SQL in Azure PaaS (ASDB, ASDW, ADLS, ADLA).
  • Develop and implement best practices for data movement, data quality and cleansing.
  • Create ETL processes to transform health care claims data for ingestion into our analysis engine.
  • Help to define and assess deliveries of healthcare claims data from our clients.
  • Work closely with the business teams to understand requirements and help produce software estimates.
  • Work closely with product architect to design and document the platform as needed.
  • Work closely with development managers to monitor open tasks, create technical specifications, help to groom backlogged tasks, unblocking and helping other developers.
  • Participate in code reviews and provide guidance to other developers.
  • Assist in evaluating innovative technologies that may be helpful to the team.
  • Help to define testing strategies to assure the accuracy of our analysis.


Critical Qualifications:


  • 5+ years of experience working with Relational Databases and Data Warehouse concepts
  • 5+ years of experience with SQL Server 2012 or higher, T-SQL, SSIS
  • 2+ years of experience with Massively Parallel Processing technology
  • 2+ years of programming experience with C#


  • Previous healthcare claims knowledge
  • Exceptional troubleshooting skills to root cause complex issues
  • Experience with Business Intelligence software, such as Tableau
  • Experience with Massively Parallel Processing technology
  • Experience with cloud platforms, such as Microsoft Azure and Amazon Web Services
  • Experience with agile methodologies


Education:  BS in CS or equivalent related experience




Option 1: Create a New Profile

Apply with LinkedIn