This site uses cookies. To find out more, see our Cookies Policy

Data Analyst in Plano, TX at Pivotal Payments

Date Posted: 4/13/2018

Job Snapshot

Job Description

  Duties/Responsibilities

  • Analyze and model structured and unstructured data and implement solutions to support analysis
  • Proven track record at managing multiple projects in fast paced cross-functional team environment.
  • Lead in design, implementation, operation and maintenance of databases including monitoring, back up and recovery procedures, performance tuning and implementing database change management
  • Lead & manage data augmentation, clean up and data quality issue resolution.
  • Perform ad-hoc analysis and develop reproducible analytical approaches to meet business requirements.
  • Responsible for providing line of sight to data quality and gaps where issues need to be addressed.
  • Validate that programs are operating on clean, correct and useful data
  • Reviews, evaluates, designs, implements and maintains internal and external data.
  • Provides regular reports on system problems, resolutions and forecast of future utilization requirements
  • Performs other duties as assigned.
Thank you for your consideration.

Job Requirements

 Qualifications (skills/experience)

  • Indexes creation
  • New database design;
  • Understand database normalization;
  • Extensive knowledge of T-SQL  (procedure, trigger, and function);
  • DTS package coding, and VB scripts;
  • Knowledge of Data Warehouse. OLAP, Reporting services, and Star Schema;
  • Data staging (SSIS and ETL experience required)
  • Experience in payments processing industry (Preferable)
  • MS SQL server Security (Preferable)
  • Database backup/recovery (Preferable)

CHECK OUT OUR SIMILAR JOBS

  1. Business Analyst Jobs
  2. Business Management Jobs