Salesforce & SQL Systems Analyst

APCO International; Daytona Beach (FL); On-site; USD 85,000 - 125,000; Full time

Job summary

APCO International is seeking a Senior System Analyst to serve as the subject matter expert for the organization’s software applications. The role focuses on analyzing business needs, designing technology solutions, and enhancing system functionality through development, upgrades, and process improvements.

The candidate will administer Salesforce, write SQL queries, support data and reporting needs, maintain SOPs, and manage requirements gathering and implementation planning in collaboration

Qualifications

• Knowledge of Salesforce reporting, dashboards, workflows, flow automation, security model, and integrations.
• Experience with relational databases, data migration, ETL processes, APIs, and web services.
• 5–8 years of directly related experience supporting help desk operations, cloud environments, or Salesforce administration.
• Bachelor's degree from an accredited college or university in a technical discipline such as Information Technology, computer science, systems engineering, or software engineering.
• Knowledge of SQL databases and database administration is preferred.

Responsibilities

• Administer Salesforce environments, including user provisioning/deprovisioning, security roles, profiles, workflows, page layouts, configurations, and system releases/updates.
• Develop, maintain, and optimize SQL queries, stored procedures, views, and database scripts to support applications, reporting, data integration, and operational processes.
• Assess risks associated with each solution design/project.
• Respond to help desk tickets, coordinating with stakeholders and vendors for resolution.
• Support a data audit plan, including deduplication and data training processes.
• Lead testing of fixes, patches, service packs, and upgrades.
• Support integration among data systems and web services; collaborate with vendors on new functionality and upgrades.
• Work with cross-functional teams to define business requirements and re-engineer processes; develop solutions for APCO's needs.
• Maintain up-to-date end-user documentation (SOPs, Process Guides) for training.
• Stay informed on current and future software developments.

Skills

Salesforce administration

SQL programming

Database support

Data reporting

ETL processes

API integrations

Requirements gathering

Problem-solving

Education

Bachelor's degree in IT/Computer Science/related field

Tools

Salesforce

SQL Server

CRM systems

Job description

APCO International is seeking a Senior System Analyst to serve as the subject matter expert for the organization’s software applications. The role focuses on analyzing business needs, designing technology solutions, and enhancing system functionality through development, upgrades, and process improvements.

The candidate will administer Salesforce, write SQL queries, support data and reporting needs, maintain SOPs, and manage requirements gathering and implementation planning in collaboration