Senior ETL Developer

Location: SF Bay Area, California

360Decisions is looking for a Data Warehouse Engineer – ETL to help build and maintain a data warehouse. This role will create batch processes that generate content which propagate to production databases. The ideal candidate will have a deep understanding of technical and functional designs for Database, Data Warehousing, Reporting, and Data Mining areas.

Job Responsibilities:

  • Contribute at a senior-level to the data warehouse design and data preparation batch processes by implementing a solid, robust, extensible design that supports key business flows.
  • Build and maintain code to populate our data warehouse with data loaded from production databases.
  • Perform optimized data transformations to populate warehouse for reporting.
  • On-going Warehouse Maintenance – Quickly assess the impact of production system changes to the existing analytics and implement changes to the warehouse ETL and reporting code to ensure consistent.
  • Design, build and maintain batch processes that derive data from Data warehouse database and propagate it into production environment.
  • Establish efficient design and programming patterns for engineers as well as for non-technical peoples.

Qualifications:

  • 5+ years experience working extensively with SQL, including the ability to write, analyze, and debug queries.
  • Experience with Data Warehouse design, ETL (Extraction, Transformation & Load), architecting efficient software designs.
  • Experienced implementing data warehouses using MPP databases is a plus.
  • Strong familiarity with data warehouse best practices.
  • Knowledge of database modeling and design in a data warehousing context
  • Problem solving and meta-data skills, analyze query plans, indexes, and locking behavior.
  • Proficiency in scripting languages (Shell, Python, Perl).
  • Ability to efficiently QA your own work to ensure that processes built generate high quality output.
  • Experience working with Web Technologies (i.e  java, xml, cookies, tomcat, php, etc)