Data Systems Administrator and Analyst

This position is located in Connecticut and requires travel to our corporate headquarters in Orange, CT.

We are unable to provide work visa sponsorship for this position; applicants must be authorized to work in the United States without sponsorship now or in the future.

We are seeking a Data Systems Administrator and Analyst to oversee multiple corporate SQL environments and support enterprise-wide data transformation and movement. This role is a key driver of SQL system administration, development, project management, and data integration efforts across the organization.

The ideal candidate will collaborate with internal teams and external vendors to maintain data integrity, ensure system reliability, and provide support throughout the full project lifecycle—from development through post-deployment.

Key Responsibilities

SQL System Administration

• Configure, upgrade, and maintain SQL Server instances, including patches and updates
• Implement database security measures, manage user access, permissions, and policies
• Serve as the first line of defense for database issues, resolving disruptions in real time
• Manage all data feeds into and out of the CRM, including internal personnel-related data movement
• Maintain corporate-developed SQL import/export operations engine
• Monitor and tune performance across SQL environments and ETL processes

SQL Development

• Design and implement ETL processes to extract and transform data from internal and external sources
• Create and optimize complex SQL queries, stored procedures, functions, triggers, and workflows
• Automate and schedule ETL jobs within the SQL import/export operations engine
• Develop and maintain database schemas, custom queries, and reporting workflows
• Troubleshoot technical issues involving imports/exports, updates, and inserts between systems

Project Management

• Lead SQL IT projects, ensuring deadlines, budgets, and priorities are met
• Collaborate with stakeholders to coordinate, document, and execute projects effectively
• Analyze business procedures and develop system specifications, workflows, and requirements
• Provide management-level reporting on project progress and outcomes
• Ensure successful UAT (User Acceptance Testing) and deployment to production

Documentation, Support & Maintenance

• Partner with business analysts, data architects, and technical teams to deliver data solutions
• Create and maintain technical documentation for ETL processes, mappings, and integrations
• Ensure databases and data elements comply with security and regulatory standards
• Monitor and maintain system backups in coordination with the Network Administrator

Required Experience

• 4–6 years of SQL database-driven application support, development, and maintenance
• 3 years of project management involvement (scoping, development, documentation, testing)
• 1–2 years managing on-premises SQL databases
• Experience in the insurance sales industry preferred

Education

• Bachelor’s degree in Information Technology, Computer Science, or related field

Required Skills

• Expert knowledge of T-SQL, SQL Server, MS Integration Services (SSIS), and MS Reporting Services (SSRS)
• Strong experience with on-premises SQL management and development
• Excellent written and verbal communication skills
• Exceptional organizational ability and multitasking in deadline-driven environments
• Critical thinking and strong problem-solving capabilities
• Proficiency in Microsoft Office Suite and Windows Server environments
• Experience with CRM and/or ERP systems
• Database design and data warehouse experience
• Leadership and collaboration skills in cross-functional teams

We are looking for candidates who embody our values:

Caring • Integrity • Drive • Passion • Resilience

*Failure to pass an internet speed test will suspend the employment onboarding process, as all employees are required to have a secure and reliable internet connection*