Data Warehouse ETL Developer

Careers at Bloomberg

Back to Search

New York, NY

Posted Apr 12, 2016 - Requisition No. 49430

Sales and Analysis is responsible for a 3 TB SQL Server data warehouse, which will grow to over 20 TB in size within the next 12 months. This houses some of the company's most important information, ranging from sales leads to marketing information, and is used to meet the daily needs of the Customer Analytics team. If someone wants to perform analysis on how successful a source is for sales leads, they come to us.

You will connect different types of data to help analyze product usage and marketing efforts. In addition to ensuring that there's no hiccup in daily processes, you will work with product owners to gather requirements, manage scope and craft a maintainable solution. We offer flexibility in the way that you solve problems, while maintaining our goal to create a better product.

You'll need to have:

  • 5+ years of data warehousing experience
  • A solid understanding of database concepts and data warehousing implementation
  • Strong skills in MS SQL Server (stored procedures, performance tuning)
  • Knowledge of Informatica
  • Familiarity with Linux/shell scripting
  • Very Large Database and DW Implementation experience

We'd love to see:

  • MS SSIS experience
  • MPP database experience (Greenplum)
  • Data modeling skills (ERwin, ER/Studio)
  • An understanding of BI Reporting Tools (Cognos, QlikView)
  • Knowledge of the Hadoop ecosystem including HDFS, HBase, Hive, Sqoop or Spark
  • Programming experience in Java, C++ or Python

Similar jobs

    The Bloomberg Talent Network

    Stay connected with us and be among the first to learn about new job opportunities. We’ll use the information you provide to help us get in touch with you to align your expertise with our opportunities and better direct our conversations.

    CONNECT WITH US