Previous Job
Data Warehouse Engineer
Ref No.: 18-14496
Location: Boston, Massachusetts
Position Type:Direct Placement
Title: Data Warehouse Engineer
Downtown Boston location

Contractor or Full time

Data Warehouse Engineer

Position Overview:
Be part of our firm-wide initiative to build a next generation research and investment platform. Leveraging a blend of traditional RDBMS and Big Data technologies, this initiative will provide a collaboration platform to help our investment teams continue to set the standard for investment performance for our clients. We are seeking an experienced Data Warehouse (DW) Engineer to join the SQL DW team to help refactoring the existing platform and gradually help build and integrate the future platform and its leading-edge capabilities. Experience in the financial industry is preferred, but we are open to experts from any industry with an interest in learning about investment management.

Experience and Expectation:
  • Minimum 6-7 years of DW engineering experience, and at least 1 - 3 years hands-on experience with scale-out technologies
  • Must be result-oriented; takes commitments and deadlines seriously
  • Willing to work diligently and deliver solutions on schedule and within given budget parameters
  • Self-starter, able to work with minimal supervision and independently

Hands-on experience and knowledge with the following:
  • Strong, set-based T-SQL programming skills and deep-dive knowledge of SQL internals
  • Experience with SQL Server performance tuning and execution plans
  • Strong understanding of DW concepts such as persistent staging, date packing, SLCD, map and reducing, time series objects
  • Implemented efficient ETL and ELT processes for large data sets, preferably with market and trading data related providers
  • Must be detail-oriented and able to prioritize work and effectively manage multiple tasks
  • Possess solid knowledge and experience with relevant programming languages and tools such as Scala, Python, unit test frameworks, CI/CD, C#, .NET framework
Nice to have experience in:
  • Complex time series and multi-dimensional data
  • Experience with NoSQL databases (e.g., MongoDB, Cassandra, HBase, CouchDB, BigTable, DynamoDB, CosmosDB)
  • Building Big Data solutions using Hadoop and Spark or equivalent DW scale-out solutions
  • Production experience with public clouds such as Azure (preferred) or AWS
  • Designing and building PaaS/DaaS data architecture and systems
  • Financial industry knowledge
  • Artificial intelligence (specifically machine-learning or deep-learning)
  • Advanced degree in computers, math or science preferred