Data Systems Administrator and Analyst
Company: Schmitt-Sussman Enterprises Inc
Location: Orange
Posted on: April 2, 2026
|
|
|
Job Description:
Data Systems Administrator & Analyst Job Summary 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 Work Environment This is a hybrid position, requiring
work onsite 3 days per week, with flexibility for remote work on
remaining days. Standard office equipment and professional systems
are used regularly. Qualifications 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 Preferred Experience Experience in the insurance
sales industry Education Bachelor’s degree in Information
Technology, Computer Science, or related field (or equivalent
professional experience) 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 Core Values We
are looking for candidates who embody our values: Caring •
Integrity • Drive • Passion • Resilience
Keywords: Schmitt-Sussman Enterprises Inc, New England , Data Systems Administrator and Analyst, IT / Software / Systems , Orange, Northeast
