Job Details


Consultant, Data Warehouse Engineer

Job Info:


Category: Data
Company Description: Leading global provider of data, news and analytics
Salary: Highly Competitive, Depending on Experience
Position Type: Consulting
Location:
Job Number: 9657

Job Description:


Our client is looking for a self-starting individual who is motivated and eager to learn and grow, with responsibility for the development of Greenplum based MPP (massively parallel processing) data warehouse. We are looking for a professional with expert level knowledge of Greenplum and/or PostgreSQL, with significant experience in writing ETL and with Python scripting. You will be able to apply your deep knowledge of data warehousing methodologies and best practices. You will be involved in all phases of development lifecycle and will be expected to work on design, architecture and implementation of our data warehouse environment, participate in code and technology reviews, and work closely with other members of the team. You will be exposed to a variety of data domains and have enormous opportunities to learn and contribute ideas.

You'll need to have:

  • 5+ years of related database experience developing complex SQL stored procedures/function, loading and processing large data sets and performing storage optimization and query tuning
  • Python scripting experience with data access and writing custom libraries
  • Deep-level understanding of analytical-level SQL, such as windowing functions and OLAP concepts
  • Excellent understanding of VLDB performance aspects - table partitioning, sharding, table distribution and extreme optimization techniques
  • Bachelor of Science/MS/PhD Degree in Computer Science, Engineering, Finance or related field (or equivalent experience)
  • Solid understanding of Kimball data warehousing methodologies, various stages of ETL processing and dimensional data modeling

We'd love to see:

  • Familiarity with other databases (SQL Server, Oracle, DB2)
  • Working knowledge of Linux scripting languages, e.g. ksh, Bash
  • Python experience with numpy/pandas/scipy

 

 


All qualified candidates are encouraged to apply by submitting their resume as an MS word document including a cover letter with a summary of relevant qualifications, highlighting clearly any special or relevant experience.


Please Note: All inquiries will be treated with the utmost confidentiality. Your resume will not be submitted to any client company without your prior knowledge and consent.


Contact Recruiter
cody.handshaw@andiamogo.com
Senior Technical Recruiter
Andiamo Partners | 90 Broad Street, Suite 1501, New York, NY 10004


Share Share this Job