Senior Data Analyst - Wilton, CT

Our growing internal data services team in Wilton Connecticut is looking for experienced, bright, highly motivated, and creative Business Systems Analysts to support our audit efforts for some of the largest, best run companies in the world.  Our 60+ analysts operate in both individual and team environments on a project by project basis, work in many disciplines, and are given latitude to create effective solutions to address business needs that directly impact profitability.  The ideal candidate would combine 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.


Summary:

Database Analyst needed in Wilton, CT to support our audit efforts for some of the largest, best run companies in the world. This individual will support our onsite audit team through client data conversion and the development and delivery of audit tools and reports.  The ideal candidate would combine 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.  This position requires strong project management, organizational and communication skills. 

Essential FunctionsCollaborate with business process owners to identify opportunities; define business requirements, and design and implement solutions designed to maximize efficiency and productivity. Perform complex data mining and aggregation; commingle multiple datasets to develop a streamlined, efficient representation of transaction lifecycles. Perform Data validation and massaging to ensure accuracy and quality of data Data mining for advanced analysis of data; presented in reports and/or interactive auditing tools Full life cycle project ownership from analysis to development to delivery of audit solutions. Design new or re-engineer existing processes to improve operational efficiency of the entire data processing team 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:Data Processing Management Data Analysts IT Management Auditors Corporate functions (Information Technology, Human Resources, Marketing, Finance) Clients

 Knowledge, Skills and Abilities 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. Advanced SQL Server skills – SQL Query Development and Performance Tuning (DBA Experience also helpful) Intermediate Visual Basic or similar programming skills. Report writing experience (Access, Crystal or R&R) Ability to recognize inefficiencies in processes (operational or technical) and the ability to design solutions to address these issues. Proficiency with large volume datasets (100 million+ row tables) Experience with ETL tools or data conversion processes a plus Data warehouse experience a plus 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%)

 Minimum Qualifications:3-5 years business experience in a complimentary role  BS/BA IS, Business, Finance, or Accounting degree preferred, but not required

 Success Factors:

Connolly Consulting’s Non-Negotiable Traits Customer Service Focused Integrity Self-Motivated Passionate Team Player Results Oriented Reliable Professional Boundaryless Behavior 

Testing Requirements 

MS Access test involving both query writing and Visual Basic 

 

Connolly Consulting'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.