View Our Website View All Jobs

Data Management Programmer

eiWorkflow Solutions, LLC is a cloud software consulting firm based in Albany, NY. eiWorkflow Solutions, LLC is currently looking for a consultant for the following role.

Data Management Programmer

Tasks the role will be performing:

  •  Design, develop, and implement ETL processes for loading an enterprise data warehouse and data marts.
  •  Create and optimize queries in multiple applications.
  •  Identify and recommend solutions for database performance issues and optimization.
  •  Design, develop, and modify views and stored procedures in support of system and business requirements, using Microsoft SQL Server Management Studio.
  • Work with the Database Administrator to create and execute DDL scripts.
  • Recommend solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
  • Assist in the improvement and integration of automation and tools designed to support work.
  • Advise program area with data modeling and best practices around data architecture for large enterprise data-sets.
  • Test all changes in multiple applications to ensure functionality.
  •  Document all ETL processes needed for the dashboard's continued functionality and performance.

Requirements for the position:

  1. 60 months of practical experience with data management and integration, involving multiple types of data sources.
  2. 48 months of experience in SQL Server with experience defining a data model, creating and maintaining tables, optimizing via indexes, writing stored procedures, and ETL development.
  3. 24 Months of practical experience using SQL Server Integration Services (SSIS). 
  4. 36 months of experience in generating technical and end-user documentation, training, and job aids.
  5. Bachelor’s Degree

Date First Created: 07/25/2017

Read More

Apply for this position

Apply with Indeed
Attach resume as .pdf, .doc, .docx, .odt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Human Check*