Data Warehouse Developer Enterprise Analytics FT Days (40hrs) Job Listing at Boston Medical Center in Boston, MA

Healthcare

Description Participates in and is responsible for the creation and maintenance of the Clinical Data Warehouse. Works closely with the data warehouse development team lead, customers, business analysts and other colleagues in the ITS department to analyze operational data sources, determine data availability, define the data warehouse schema and develop ETL processes for the creation, maintenance, administration and overall support of the data warehouse. From a day to day operations and project perspective, the work of the data warehouse developer will be directed by the data warehouse team lead.

Qualifications

• Bachelor's degree in Computer Science, Business, or Engineering or equivalent work experience is required.
• Oracle and/or Informatica certifications would be a plus.
• Three to five years of experience maintaining and administering a multi terabyte sized Oracle data warehouse in a UNIX (AIX) environment. Hands-on experience using Informatica Power Center for loading and maintaining a data warehouse is required. Demonstrated analytical, problem-solving and conceptual skills. Excellent oral and written communication skills and the ability to communicate effectively with non-technical people.
• Thorough understanding of the relational database model and experience in designing, modeling, developing and supporting data warehouses. Experience working with diverse data sources. Knowledge of SQL query optimization and performance tuning. Experience in entity relationship data modeling and data modeling tools. Knowledge of star and snow-flake schemas.