12 days old

Senior SQL Server Data Warehouse Engineer

Boston, MA 02110
  • Job Code
  • Payrate
    $120,000 To $140,000

Position Overview:

We are looking for a Senior SQL Research Data Warehouse (DW) Engineer to join our team and focus on architecting and implementing innovative solutions for our investment divisions. You will be working with data and research departments, implementing databases used for research and portfolio construction. Data is at the core of our process and the solutions we build can give us an edge over our competitors by providing access to more datasets, deeper history, broader investable universe and better quality of data. This position offers a unique opportunity to learn about all facets of the investment process while being part of a very talented team of developers and contributing to one of the firm's most critical business areas.

Long term, the Engineer will work on our strategic firm-wide initiative to build its next generation research and investment data platform utilizing the latest in emerging Big Data and Cloud technologies. Near-term goals of this initiative are to evaluate and decide on the tools, technology, techniques, and architecture for this platform.


  • Work closely with research members and data analysts to support portfolio managers, comprehend the data needs and data usage
  • Propose and design DW features and solutions and supports the systems developed
  • Implement database systems based on the solutions proposed and work closely with users to test and integrate the system into the current production environment
  • Senior role in next generation research platform initiative.


  • 10+ years of experience developing application with the focus on data and data access
  • Experience building research and data platforms using traditional RDBMS systems like SQL Server and similar products
  • Strong T-SQL skills and deep-dive knowledge of SQL internals
  • Experience with performance tuning and execution plans
  • Strong understanding of DW concepts such as persistent staging, data packing, SLCD, map and reducing, time series objects
  • Implementation efficient ETL and ELT processes for large data sets, preferably with market and trading data related providers
  • Familiarity with C# and the .NET Framework
  • Advanced degree in computers, math or science preferred
  • Mathematics or other analytical background strongly preferred
  • Must be result-oriented; takes commitments and deadlines seriously
  • Willing to work diligently and deliver solutions on schedule and within given budget parameters
  • Ability to astutely operate within the organization; well-respected and influential; able to emphasize methodology, modeling, and governance; technologically unbiased; articulate, persuasive, enthusiastic, and adept at written and oral communication
  • Self-starter, able to work with minimal supervision with a team and independently
  • Must be detail-oriented and able to prioritize work and effectively manage multiple tasks

Emerging tech initiatives including the following would be a plus:

  • Experience building scale-out DW platform solutions in the cloud and/or on-prem.
  • Expertise with row, columnar, document stores, key-value stores
  • Hands-on work with non-RDBMS file systems such as HDFS
  • Demonstrates understanding of map and reduce concept, experience with Hive
  • Worked with multidimensional, in-memory and time series databases
  • Hands-on experience implementing data platforms with HDFS-based products such as Cloudera, MapR, Hortonworks, EMR, or HDInsight, etc.
  • Massive parallel processing experience using Spark, Polybase, or any equivalent product
  • Conceptual and/or hand-on experience with No-SQL solutions such as Mongo DB, Cassandra, HBASE, CouchDB, BigTable
  • Experience building DW platform with any cloud providers (such as Azure (preferred) and/or AWS) and/or in a hybrid hosting model
  • R&D experience in evaluating tools and platforms
  • Experience building distributed systems with a flexible and open architecture
  • Have worked with any of the following hosting platform models: IaaS, SaaS, DaaS, PaaS
  • Experience dealing with both structured and unstructured data
  • Experience building Data Lake and Enterprise Data Hub (EDH)
  • Good understanding what microservice architecture entails and means


  • Information Technology

Randstad utilizes a technology-driven focus with a human touch to provide better staffing and business solutions to organizations around the world. Our team of experts match professionals with available career opportunities in a variety of fields.

Featured Jobs

Career News

Share this job:

Senior SQL Server Data Warehouse Engineer

Randstad Technologies
Boston, MA 02110

Share this job

Senior SQL Server Data Warehouse Engineer

Randstad Technologies
Boston, MA

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast