WATERTOWN, MA, USA
4 days ago
T/SQL Data Warehouse Developer
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 programmingOptimization and automation of existing ETL and data-flow processes inclusive of file imports/exports, data-mart population, and data-refresh processesParticipates 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 requirementsAssists in the identification and resolution of data quality and performance related issuesAssists in the maintenance of the data dictionary, schema documentation, and jobs inventory for the data warehouseProvide team members and management with ongoing status of all activities and issuesEscalate issues to appropriate management by recognizing severity and impact on users and other IT systemsEnsure 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 necessaryParticipate in projects as necessaryMaintain professional growth and development through self-directed learning activitiesEncourages and precipitates a collaborative work environment among team members**Must have SSIS Experience***.
Confirm your E-mail: Send Email