Database Coordinator Details

Nan McKay & Associates - Doral, FL

Employment Type : Full-Time

We are currently seeking a qualified Database Coordinator to assist in maintaining the data in our CRM systems focusing on data integrity and CRM management. The ideal candidate will be process-oriented and possess a high attention to detail.

Responsibilities include:

Perform data cleansing by identifying duplicate or incomplete information in our CRM systems, including Microsoft SQL and Oracle MySQL

Establish data naming standards and consistent data definitions to improve overall quality

Accurately import data into various databases and tables

Review data for completeness and accuracy

Contact authors of source documents to address data inconsistencies and to gather missing data

Monitor data quality, data migrations, and data integration

Compile data from various sources to create custom reports.

Design comprehensive BI solutions, translating complex requirements into an optimal reports/BI designs

Design processes to minimize data quality risks and proactively identify potential data issues.

Build and enhance BI objects including Microsoft Power BI.

Maintain documentation on all system reports including, a description, system(s) used as source data, fields being pulled, departments & user using the report

Identify metrics and related reports that will be used after implementation to monitor process integrity and identify potential issues.

Must have the ability to manage multiple projects and work without close supervision.

Must be able to present information in professional and user friendly package, detailed oriented with strong organizational and communication skills.

Candidates should possess the following:

2 year Technical/Financial degree, MIS or Computer Science is preferred

2+ years of relevant experience with MySQL, Power BI, Microsoft SQL or other system-based reporting structures

Experience in database design and query/reporting tools

Strong analytical skills and demonstrated developing analytical solutions

CRM system experience, Citrix Podio

Job Type: Full-time

Pay: $40,000.00 - $60,000.00 per year

Benefits:

  • 401(k)
  • Dental insurance
  • Employee assistance program
  • Flexible spending account
  • Health insurance
  • Life insurance
  • Paid time off
  • Referral program
  • Tuition reimbursement
  • Vision insurance

Schedule:

  • Monday to Friday
  • Weekends

Education:

  • Bachelor's (Preferred)

Experience:

  • MySQL, Power Bl, Microsoft SQL: 2 years (Preferred)
  • Database design: 2 years (Preferred)

Work Location:

  • Fully Remote

Company's website:

  • www.nanmckay.com

Benefit Conditions:

  • Waiting period may apply
  • Only full-time employees eligible

Posted on : 3 years ago