Current Job Openings

Data Modeler: 335 Adams Street, Brooklyn NY 11201 or 2 Metrotech Center, Brooklyn NY 11201 or alternate DIIT locations

Due Date:
Wednesday, July 1, 2020 12:00 PM

Job Title:
Data Modeler

Location:
335 Adams Street, Brooklyn NY 11201 or 2 Metrotech Center, Brooklyn NY 11201 or alternate DIIT locations

Scheduled Work Hours:
Full Time - 9 to 5 - 35hrs/wk

Service Scope:
• Creates conceptual, logical and physical data models for transactional systems in Erwin.
• Leads business discovery sessions with the end users.
• Plans, implements and manages systems initiatives with IT and customer teams.
• Establishes and maintains data technical standards as described in data dictionaries and source to target mapping documents.
• Conducts database performance monitoring, capacity planning, trend Forecasting.
• Documents and improves upon processes, procedures, and best practices to align with industry standards and customer needs.
• Adheres to disaster recovery requirements to ensure business resumption requirements are met.
• Provides high-level of customer satisfaction to internal and external customers, applying necessary sense of urgency and creativity in problem identification and prompt incident resolution.
• Provides advanced database systems administration.
• Analyzes system performance and suggest/implement tuning as needed.
• Administers MS SQL server database.

Mandatory Skills:
• 7+ years of experience in the following:
• Data Modeling/Architecture (conceptual, logical, physical, understanding of the data)
• Database Management performing installation, configuration, customization, implementation and support of SQL Server Database
• Creating Data Dictionaries and Data Mappings documents.
• Experience and expertise in monitoring and troubleshooting ETL, DTS, SSIS and Data warehouse queries.
• Hands-on experience in SQL Server Performance Tuning, Query Optimization and Production support.
• Hands-on experience writing complex Stored Procedure/ Functions in PL/T-SQL and MS SQL. Writing complex Shell Scripts to support SQL and other functions

Apply for this job

« Back to Current Job Openings