General Assembly

New York
501-1,000 employees
We transform careers and teams — including more than one third of the Fortune 100 — through dynamic courses in coding, data, design, and business.

Senior Data Engineer

Senior Data Engineer

This job is no longer open

Who are we?

Our vision is of a global community of individuals empowered to pursue the work they love. Our mission is to grow that community by transforming millions of thinkers into creators.

Since 2011, General Assembly has transformed tens of thousands of careers through pioneering, experiential education in today’s most in-demand skills. As featured in The Economist, Wired, and The New York Times, GA offers training in web development, data, design, business, and more, both online and at campuses around the world. Our global professional community boasts 40,000 full- and part-time alumni — and counting.

GA has a remote-friendly culture with offices around the world. If you prefer the office, our headquarters are located in New York City. Twice a year, the entire Product team gets together in New York for a week of team building, workshops, lightning talks, urban adventures, and an epic hackathon.

As part of the Data Engineering team, we collaborate with application engineers and business owners to build and manage a wide variety of data sets, deliver near-real-time monitoring of key business metrics, model events, as well as provide longer term trend analysis.  We are proud of using new tech and always researching alternatives.  We are super happy with our new open source data pipeline and need more engineers to grow it.

The Data team at GA is made up of a VP of Data, a Director of Data, an Analytics Manager, a Data Engineer, and five Senior BI Analysts. Our current data technology stack primarily consists of Redshift, Python, SQL, Tableau, and a simple data replication tool.  The Data team is not only responsible for making sure that GA’s data solutions are speedy, intelligent, user-friendly and accessible to employees across the organization, but also works closely with GA’s leadership team, providing them with data-driven insights that drive greater business performance and strategy.

Responsibilities

We are looking for a Senior Data Engineer that loves data. Your responsibilities include…

  • Development of data marts and rollup tables
  • API feeds automation
  • Work on the data pipeline that feeds our data warehouse (Redshift) from a variety of sources
  • Assist with the development of a BI strategy to support current and future needs through technology, work closely with analysts on the data team
  • Support and advise all parts of the global business on their data needs
  • Write robust, well-tested, production code in support of the business intelligence systems.  Comfortable in Github and code deployment
  • Develop and maintain monitoring, alerting, and anomaly detection services
  • Understand what data is needed, how to create a data model, and how it will be presented in visualization tools like Tableau
  • Mentoring and recommending best practices, comfortable documenting
  • Work with information security and privacy teams to ensure our data flows are compliant with a patchwork of varying regulatory and legal requirements across many regions

Must have

  • 6+ years experience in the data engineering field
  • ETL/ELT/Data manipulation in Python
  • Advanced SQL skills. Experience developing data marts and ETL in SQL
  • Be able to translate business requirements into deliverables
  • Comfortable writing code that pulls data from API’s and storing in database
  • Excellent communications skills
  • Experience with Jira/Agile
  • Experience with debugging complicated issues such as concurrency, memory optimization, and run time optimizations across systems

Nice to have

  • Familiar with visualization tools like Tableau, Looker, or PowerBI.  Tableau preferred
  • Event modeling / Data modeling
  • Experience with a columnar datastore, preferably Redshift
  • Familiar with any monitoring systems like New Relic
  • Any Master Data Management or Data Governance experience

Who can apply?

Remote in the US following states: AZ, CA, CO, FL, GA, IL, KS, ME, MA, MI, MD, MN, MO, NC, NH, NY, OR, PA, RI, SC,TN, TX, UT, DC, WA, WI, VT, VA

This job is no longer open
Logos/outerjoin logo full

Outer Join is the premier job board for remote jobs in data science, analytics, and engineering.