2U HQ - Lanham Office

Returning Candidate?

Sr. Data Warehouse Engineer

Sr. Data Warehouse Engineer

ID 
2017-4269
Job Locations 
US-NY-New York
Category 
Technology

More information about this job

What We're Looking For

Engineering at 2U is fast paced, innovative and full of people passionate about delivering on the promise of higher education via technology. We’re growing rapidly and are seeking collaborative and results-driven individuals to join us. In return, we can offer you a fun learning environment where your skills, experience and creativity will make a material impact on the company’s success and its overall mission. Your tenure at 2U will be a highlight of your career.

 

We strive for our teams to be cross-functional, self-organizing and autonomous. You’ll be working directly with product managers and business analysts in a highly collaborative manner.

 

About The Role

 

We are looking for a collaborative and results-driven data engineer with experience in system management and monitoring within AWS infrastructure, automated testing and continuous deployment. Agile techniques like test driven development (TDD) is a plus.

 

Above all, you care about delivering quality software in a sustainable and timely manner and about software craftsmanship. You have experience in, and passion for, high-quality, maintainable code that confers low operating costs, high change velocity and is a point of professional pride for you and the team.

Responsibilities Include, But Are Not Limited To

You are a competent data engineer and a technical leader with the following competencies:

  • Strong database background:
    • Data Warehouse architecture and data modeling
    • Monitoring, administration and performance tuning of the database servers
    • Design and implementation of ETL data flows
    • Data governance and security
  • Writing maintainable high-performance code
  • Refactoring to keep code maintainable
  • Conducting exploratory and automated testing
  • Job scheduling and monitoring
  • Debugging complex problems under time constraints
  • Lead technical design of applications and participate in larger system design efforts
  • Providing technical guidance and mentoring more junior team-members
  • Stay current with the industry trends and best practices 

You have experience in:

  • Collaborating with the stakeholders (product managers, business analysts, and data science teams) to define and refine requirements
  • Planning and estimating development tasks and short-term projects
  • Relating your project deliverables to products you are building and strategy behind them
  • Advocating for end user needs in software you are building

Over time, we expect engineers in this role to grow by learning and practicing the following skills:

  • Participating in application and system level technical design
  • Conducting technical interviews
  • Participating in planning staffing needs on your team
  • Metrics driven software development

This role reports to Director of Engineering for Data Systems team.

Other Attributes That Will Help You in This Role

About The Team

 

The Data Systems team maintains and develops a reliable, well-supported, and frequently updated data lake comprising raw and processed data from 2U's platforms. We provide a curated set of standardized and consolidated data from all of 2U's programs, as well as financial data that can be used by the business to build mission critical reporting services. We also strive to provide generic facilities for product engineering teams to move data between systems. All our hardware infrastructure is in deployed on the Amazon Web Services cloud and we make extensive use of SAAS services like Salesforce, Segment, Streamsets and others.  


We are motivated to build a team where members bring sound computer science fundamentals and a diverse set of skills and experiences to the table. We looking for experience and expertise in the following technologies:

  • T-SQL using Postgres and MS SQL
  • Python and Shell Scripting
  • AWS: Aurora, Redshift, Kinesis, CloudWatch
  • Big Data applications (Spark SQL, Apache Drill, AWS Athena) and Data Visualization tools (e.g. Tableau) are a plus

EEO statement:

2U is an equal opportunity employer that does not discriminate against applicants or employees and ensures equal employment opportunity for all persons regardless of their race, creed, color, religion, sex, sexual orientation, pregnancy, national origin, age, marital status, disability, citizenship, military or veterans’ status, or any other classifications protected by applicable federal, state or local laws. 2U’s equal opportunity policy applies to all terms and conditions of employment, including but not limited to recruiting, hiring, training, promotion, job benefits, pay and dismissal.

 

Note: The above statements are intended to describe the general nature and level of work performed by individuals assigned to this position, and are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required. All employees may be required to perform duties outside of their normal responsibilities from time to time, as needed.

 

About 2U (NASDAQ: TWOU)

2U partners with leading colleges and universities to deliver the world’s best online degree programs. Our Platform, a fusion services and technology, enables schools to attract, enroll, educate, support and graduate students around the world. Our company culture is united by our No Back Row® philosophy; the idea that when we each lean in and do our part, we are better individually and collectively.

 

2U Diversity and Inclusion Statement

At 2U, we are committed to creating and sustaining a culture that embodies diverse walks of life, ideas, genders, ages, races, cultures, sexual orientations, abilities and other unique qualities of our employees. We strive to offer a workplace where every employee feels empowered by the ways in which we are different, as well as the ways in which we are the same.

 

Why It’s Great to Work at 2U

2U offers a high-energy work environment that’s both challenging and fun. We work hard, but our offices are casual and social places. We wear jeans to work and fuel brainstorming sessions with snacks and seltzer.

 

Benefits

2U offers a comprehensive benefits package:

  • Medical, dental, and vision coverage
  • Life insurance, disability and 401(k)
  • Unlimited snacks and drinks
  • Generous paid leave policies including a PTO allowance for your vacation, personal, or sick days
  • Additional time off benefits include:
    • time off to volunteer for non-profit organizations
    • parental leave after 12 months of employment
    • holidays that include a winter break from Christmas through New Year and more!
  • Tuition reimbursement program