Senior Data Warehouse Developer

The Senior Data Warehouse Developer designs, develops and implements complex Extract, Transform, and Load (ETL) procedures to feed data into the Enterprise Data Repository from disparate clinical and non-clinical data sources. Collaborates with management to regarding data warehousing and BI system requirements. Ensures technical specifications and extracted information meets all business requirements of the organization and the end-users. Knowledge of and hands-on experience in Meditech: data extracts, data structures, reporting Designs, develops and implements complex Extract, Transform, and Load (ETL) procedures Strong SSIS skills, use of TFS, Visual Studio Knowledge of IBM DataStage is a big plus Implements business rules via stored procedures, middleware or other technologies Maps data between source systems, data warehouse and data mart. Writes new programs or modifies existing to meet project requirements Performs system analysis, data analysis or programming Selects methods, techniques or criteria for data warehousing evaluation procedures. Verifies structure, accuracy and quality of warehouse data. Investigates and tests new software solutions or products, as necessary Provides mentoring and coaching to team members and affiliated teams, as needed Reviews and provides guidance to the development team and recommendations to optimize the data extraction and loading using ETL jobs Develops and implements corrections and improvements according to change requests Collaborates and works with multiple technical and business units to resolve support issues Required: Bachelor's Degree in Computer Science, Information Technology or related technical field Minimum ten (10) years of experience in the design, development and implementation of databases/data warehouses Extensive experience with enterprise level ETL tools Strong understanding of ETL design and development such as direct-path loading and parallel SQL Must have extensive experience in SSIS. Knowledge of TFS, Visual Studio, comfortable with all aspects of SSIS programming Strong understanding of data warehouse concepts and architecture. Understanding of star/snowflake schema design; dimension and fact tables. Strong understanding of Oracle and SQL Server database architecture Understanding of data modeling and design including partitioning, indexing, constraints and optimizer statistics Experience with development methodologies such as Agile Full life cycle experience (requirements gathering through production deployment) in all aspects of Business Intelligence and Data Warehousing Analytic, process flow, problem solving, communication, customer service, organization skills Preferred: DataStage or Informatica a big plus Knowledge of web services (SOAP, REST) Knowledge of Health Industry and Healthcare Data Exchange Standards (HL7, CCD)
Salary Range: NA
Minimum Qualification
11 - 15 years

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Senior Data Warehouse Developer
New York City, NY Physicians Interactive, inc.
ETL Data Warehouse Developer - Senior
Rensselaer, NY CSRA Inc.
Sr. Data Warehouse Developer
Melville, NY Ctg
Senior Data Warehouse Engineer
New York City, NY OnDeck
Lead Data Warehouse Developer - Scientific Com...
New York City, NY Mount Sinai Medical Center
Senior Data Visualization Developer
New York City, NY Genesis10