Job Summary
- Company
- Connolly
- Location
- Wilton, CT
- Industries
- Accounting and Auditing Services
- Job Type
- Full Time
- Employee
- Years of Experience
- 2+ to 5 Years
- Education Level
- Bachelor's Degree
- Career Level
- Experienced (Non-Manager)
- Job Reference Code
- 166
Senior Business Systems Analyst - Wilton,CT
About the Job
Summary:
Our growing internal data services team in Wilton Connecticut is looking for experienced, bright, highly motivated, and creative Senior Business Systems Analyst 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.
Interacts With:
Knowledge, Skills and Abilities:
Minimum Qualifications:
Success Factors:
Connolly's Non-Negotiable Traits
Testing Requirements
MS Access test involving both query writing and Visual Basic.
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~
Our growing internal data services team in Wilton Connecticut is looking for experienced, bright, highly motivated, and creative Senior Business Systems Analyst 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.
- Collaborate 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
- Minimal travel required (less than 5%)
- Experience with healthcare claims management systems or other high volume data sets in a production reporting environment a plus.
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'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'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~
