Job Seekers, Please send resumes to resumes@hireitpeople.com

POSITION SUMMARY-
As a member of the Data Warehouse team the Data Warehouse Developer will be responsible for the development, optimization, and documentation of data structures and ETL processes. Support of other data warehouse-related data management tasks such as the generation and review of inbound and outbound batch files for operational, encounter data, and regulatory requirements will also be required.

This role will be supporting production support items/small enhancements for the team.


PRINCIPAL DUTIES AND RESPONSIBILITIES:-

• Builds, documents, and maintains complex ETL jobs and data-flow processes using a combination of TSQL, SSIS, and .NET programming
• Optimization and automation of existing ETL and data-flow processes inclusive of file imports/exports, data-mart population, and data-refresh processes
• Participates as a key member of the data warehouse team to design and develop architectural structures in the data warehouse and associated data-marts per business requirements
• Assists in the identification and resolution of data quality and performance related issues
• Assists in the maintenance of the data dictionary, schema documentation, and jobs inventory for the data warehouse
• Provide team members and management with ongoing status of all activities and issues
• Escalate issues to appropriate management by recognizing severity and impact on users and other IT systems
• Ensure that all project activities are thoroughly documented and current, and that appropriate change management and version control practices/procedures have been followed

OTHER JOB FUNCTIONS:-

• Participates in departmental and interdepartmental meetings as appropriate and necessary
• Participate in projects as necessary
• Maintain professional growth and development through self-directed learning activities
• Encourages and precipitates a collaborative work environment among team members
• **Must have SSIS Experience***.