Associate Business Systems Analyst - Healthcare - Conshohocken, PA
(one block from the train station)  Compensation range: $40-55K depending on experience   Summary
  Hands-on technical role to support our onsite audit team through client data conversion and the development and delivery of audit tools and reports. Ideal candidate combines experience with very large datasets (SQL Server or similar), business application programming tools (VB, VBA, or similar), and business understanding to mine data and automate workflows focused on identifying anomalies and errors in our clients business transactions.   Essential Functions

• Provide 1st level support for system related problems
• Perform complex data mining and aggregation; commingle multiple datasets to develop a streamlined, efficient representation of transaction lifecycles. 
• Data mining for advanced analysis of data; presented in reports and/or interactive auditing tools 
• Collaborate with business process owners to identify opportunities; define business requirements, design solutions to map to and in support of new or existing business processes and / or workflows, 
• Rapidly implement technical solutions designed to maximize operational efficiency and productivity. 
• Perform Data validation and massaging to ensure accuracy and quality of data 
• Large volume data conversion, data cleansing, production report generation, and upholding scheduled data delivery standards. 
• Contribute to documentation initiatives as needed
• Contribute to group knowledge and best practices 
• Interacts with Auditors and other end users, other analysts and management, Corporate Functions
   

• SQL Server skills; SQL Query Development
• Visual Basic or similar programming skills. 
• Report writing experience (Access, Crystal or R&R) 
• Proficiency with large volume datasets (100 million+ row tables) a plus
• Experience with ETL tools or data conversion processes a plus 
• Data warehouse experience a plus 

Non-Technical

• Strong analytical/problem solving skills 
• Strong communication skills, ability to translate end user needs into an IT solution 
• Excellent organizational skills, attention to detail is critical to the success of all candidates. 
• Ability to recognize inefficiencies in processes (operational or technical) and the ability to design solutions to address these issues. 
• Experience with healthcare claims management systems or other high volume data sets in a production reporting environment a plus Minimal travel required (less than 5%)
   

• 1-3 years of experience in a programming or development role
  • BS / BA Computer Science or Information Systems degree preferred; Business, Finance, or Accounting degree would be considered as would equivalent experience 

Testing Requirements 

• MS Access test involving both query writing and Visual Basic 

Success Factors

 Connolly’s Non-Negotiable Values

• Customer Service Focused
• Integrity
• Self-Motivated 
• Passionate 
• Team Player 
• Results Oriented 
• Reliable 
• Professional 
• Boundaryless
   

Connolly's most important resource is experienced, committed and creative employees. The open and inclusive team-oriented culture encourages contribution and enables employees to go beyond to fulfill his or her potential. Connolly is unique in its uncompromising commitment to provide the highest level of quality in auditing services. Connolly offers careers with plenty of challenge and opportunity, in a rewarding atmosphere. If you have a proven track record of accomplishment, commitment, and passion for success than Connolly is the right choice for you.

*CB*   ~Y~