Data Analyst - PT

Acosta, Inc.; Toronto; On-site; CAD 38,000 - 43,000; Part time

Benefits offered by this job

Part-time

Office environment

Job summary

Acosta, Inc. in Toronto, Ontario is seeking a part-time Data/Database Administrator to maintain and enhance the Sales Trak database via web interface and SQL scripting. Responsibilities include gathering requirements, validating modification viability, and creating SQL queries for data updates.

The role emphasizes data integrity, location-specific data changes, and routine reporting. English is primary; bilingual ability may be required. Office environment with part-time hours.

Qualifications

• 2+ years of college or related work experience.
• 1–2 years relational database management experience.
• 1 year SQL.

Responsibilities

• Requirement gathering of essential information.
• Analysis of viability of modification request.
• Generate queries to modify/insert using SQL language.
• Responsible for location specific data modification.
• Create/develop corporate level database projects for store level tasks.
• Perform scheduled and daily reporting tool maintenance and administrative functions.
• Perform organizational (Sales Trak) data maintenance on demand quickly and efficiently.
• Provide consistent communication of work completed or to be completed.
• Maintain a proactive approach to data integrity.
• Have a basic understanding of CROSSMARK business units.

Skills

SQL scripting

DTS packages

Microsoft Office

Education

2+ years college or related work experience

Tools

Microsoft Office

Job description

DESCRIPTION

Responsible for enhancements and maintenance of the Sales Trak database utilizing the web interface and SQL scripting.

RESPONSIBILITIES

Essential Duties and Responsibilities:

• Requirement gathering of essential information.
• Analysis of viability of modification request.
• Generate queries to modify/insert using SQL language.
• Responsible for location specific data modification.
• Create/develop corporate level database projects for store level tasks.
• Perform scheduled and daily reporting tool maintenance and administrative functions.
• Perform organizational (Sales Trak) data maintenance on demand quickly and efficiently.
• Provide consistent communication of work completed or to be completed.
• Maintain a proactive approach to data integrity.
• Have a basic understanding of CROSSMARK business units.

NOTE: This job description does not imply that the above functions are the only tasks that may be performed. Associates will be expected, if possible, to follow any other job-related instructions and perform any other job-related tasks as directed by management.

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties.

Education/Experience: 2+ years of college or related work experience. 1 –2 years relational database management experience. 1 year SQL.

Computer Skills: SQL scripting, DTS packages, Microsoft Office

Certificates, Licenses, Registrations: None required

Supervisory Responsibilities: None required

Work environment: Office environment.

Language Skills: English is the primary language skill; however, bilingual skills may be required based on business necessity.

ABOUT US

Acosta, and its subsidiaries, is an Equal Opportunity Employer

Job Category: Administration

Position Type: Part time

Business Unit: Sales

Salary Range: $27.29 - $31.57

Company: Acosta Services Canada Co

Req ID: 40613