About the role

The Business Systems Analyst will monitor and maintain CRM data systems while troubleshooting data flow and integration issues. They will also collaborate with cross-functional teams to gather business requirements, design solutions, and support project rollouts.

What they look for

SQL Server Database maintenance Troubleshooting Data analysis Reporting API Data integration CRM ERP Quality assurance Technical documentation UML SSIS MySQL Oracle Business requirements gathering

Requirements

Candidates must have an Associate's degree with 4+ years of SQL/database experience or a Bachelor's degree in Information Technology. Proficiency in database-driven applications and strong analytical and communication skills are required.

Benefits

Hybrid work flexibility

Full description

Are you someone who enjoys solving problems, working with data, and improving the systems that help a business succeed? We’re looking for a collaborative and detail-oriented Business Systems Analyst to join our IT team and play a key role in supporting and enhancing critical business applications and data systems.

In this role, you’ll partner with teams across the organization to analyze business needs, troubleshoot system and data issues, and help deliver technology solutions that drive efficiency and innovation. From supporting CRM operations and data integrations to contributing to enterprise-wide projects, you’ll have the opportunity to make a meaningful impact in a fast-paced, team-oriented environment.

If you’re analytical, curious, and passionate about using technology and data to improve business processes, we’d love to connect with you.

What You’ll Do

System Monitoring & Support

Monitor and maintain daily CRM data imports and exports
Ensure the stability and performance of CRM-related systems and databases
Troubleshoot data flow, API, replication, backup, and validation issues
Collaborate with vendors and external partners to resolve system and data concerns
Support CRM software deployments and production updates
Maintain development, testing, and training databases

Business & Data Analysis

Investigate and analyze data issues reported by end users
Perform ad-hoc database queries and technical analysis
Support business requirement gathering and solution design
Assist with identifying opportunities to improve system performance, scalability, and reliability
Analyze import/export processes to ensure data integrity and operational efficiency

Project Collaboration

Participate in projects from planning through production rollout and post-launch support
Help create and maintain technical documentation, process diagrams, release notes, and project materials
Partner with stakeholders across departments to deliver effective solutions on aggressive timelines

Testing & Quality Assurance

Develop and execute testing plans for CRM and integrated systems
Document and communicate bugs, enhancements, and fixes with development teams
Coordinate User Acceptance Testing (UAT) and gather business sign-off

Teamwork & Support

Collaborate closely with IT and business teams across the organization
Occasionally assist with help desk and general IT support as needed

What We’re Looking For

Required Qualifications

Associate’s Degree in Information Technology or related field with 4+ years of relevant SQL/database experience

OR

Bachelor’s Degree in Information Technology or related discipline
Experience supporting database-driven applications (SQL Server, MySQL, or Oracle)
Strong analytical and problem-solving skills
Excellent written and verbal communication abilities
Ability to work independently while also thriving in a collaborative team environment

Preferred Experience

SQL Server and data/business analysis experience
CRM and/or ERP systems experience
Data import/export and SSIS experience
Insurance industry experience or licensing knowledge is a plus
UML or technical documentation experience preferred

Technical Skills

Microsoft SQL Server (preferred), MySQL, or Oracle
Database maintenance and troubleshooting
Data analysis and reporting
API and data integration concepts
CRM/ERP platforms
Attention to detail and quality assurance practices

Why Join Us?

At our company, our culture is built around five core values: Caring, Drive, Integrity, Resilience, and Passion. We believe great work happens when people feel supported, empowered, and inspired to make an impact. We’re looking for individuals who bring curiosity, accountability, and a collaborative mindset to everything they do.

Opportunity to work on impactful, enterprise-level projects
Collaborative and supportive team environment
Hybrid work flexibility
Exposure to multiple systems, technologies, and departments
Career growth within a data-driven organization

This position requires you to be in the office in Orange, CT at least three days a week.