Sr. ETL Engineer

Virgin Pulse   •  

Providence, RI

Industry: Technology

  •  

5 - 7 years

Posted 28 days ago

Description

Who is Virgin Pulse?

Virgin Pulse, founded as part of Sir Richard Branson’s famed Virgin Group, helps organizations build employee health and wellbeing into the DNA of their corporate cultures. As the only company to deliver a powerful, mobile-first digital platform infused with live services, including coaching and biometric screenings, Virgin Pulse’s takes a high-tech-meets-high-touch-approach to engage employees in improving across all aspects of their health and wellbeing, every day – from prevention and building a healthy lifestyle to condition and disease management to condition reversal, all while engaging users daily in building and sustaining healthy habits and behaviors. A global leader in health and wellbeing, Virgin Pulse is committed to helping change lives and businesses around the world for good so that people and organizations can thrive, together. Today, more than 3100 organizations across the globe are using Virgin Pulse’s solutions to improve health, employee wellbeing and engagement, reduce costs and create strong workplace cultures.

Who are our employees?

At Virgin Pulse we’re passionate about changing lives for good. We want to make a difference in the world by helping people be healthy so they can perform at their best, every day, at work and home. Our award-winning solutions support leading employers in improving and simplifying the employee health and wellbeing journey and engaging people in all aspects of their health. But our world-class products and programs are nothing without our people – the employees who design, build, promote, sell, test and perfect the latest innovations in workplace health and wellbeing. Our people are our top priority and we invest in their health and happiness. At Virgin Pulse, we have so much more than a strong, supportive company culture – have a shared vision for a healthier, happier world.

Who you are.

We are looking for a Senior ETL/Data Engineer with skills tosupportour a fast-paced reporting pipeline. As a key member of the Data Systems & Reporting team, you will work closely with our ETL and reporting teams to provision, monitor, and automate our critical services on the AWS cloud.

*This position is full-time and located in our Providence, RI office. Candidates must be authorized to work in the United States.

As the Senior ETL/Data Engineer on the infrastructure side, you should have deep experience in operating and maintaining an enterprise data system. You will understand SQL deeply and have extensive experience is provisioning databases, monitoring database systems, and provisioning and maintaining applications on database servers. You should have an agile mindset and a deep commitment to the principles of agile software development. You should understand non-relational databases, relational databases, data pipelining, data cleansing, and database architecture. You should have excellent verbal and written communication skills and a strong team ethic.

In the role of Sr. ETL/Data Engineer you will wear many hats and your attention will be crucial in the following:

  • Provision and maintain AWS data services (Redshift, S3, Glue, Spark)
  • DBA and Developer proficiency on SQL Server Databases and SSIS
  • Integration of data processes into release tools such as Team City and Flyway
  • Expert level experience in large enterprise relational databases (SQL Server, Oracle, …)
  • Integrate external database sources using modern pipeline ETL processes (Glue, Spark, …)
  • Deep understanding of database architecture and storage issues
  • Eat, breath, and think agile

Our technology.
Our next generation SAAS platform is using an exciting mixture of technologies: Large scale, highly available, public-facing websites built in React/Angular/Angular2 and leveraging tools like Puppet, Pug, Grunt and NPM to make things automated and repeatable. Our Java/Scala/Kotlin-based REST API is built on Spring Boot and Hibernate which serves traffic to both web and mobile consumers. We’re using a combination of Mongo, MySQL, PostgreSQL, Cassandra and Redis. Redis, specifically, is used extensively in a distributed locking system, responsible for supporting real-time data processing. All of this uses Amazon Web Services extensively for stability and high availability.

We practice Continuous Integration and Continuous Delivery using TeamCity; as a result we have continual smaller releases to our environments (Development, QA, Staging, Production), with integrated unit tests and code coverage analysis while eliminating the risk taken on with only a few large releases/product updates.

What you bring to the team.

You are passionate about quality. Ensuring accuracy and elegance in your work is something you do every day. You think carefully about anything before writing code, you code with fastidious attention to detail, you test obsessively, and you take criticism enthusiastically and improve continually.

  • 5+ years of Database Architecture experience
  • 5+ years of SQL experience
  • 5+ years of procedural language experience (Python, TSQL, PL/SQL)
  • 1+ years of database operations on the cloud
  • 5+ years on an agile develop team
  • 2+ Experience with at least one non-relational database (Redshift, MongoDB, Cassandra, …)
  • Experience with Jira and Git
  • BS or equivalent in a relevant field.

Security Competencies:

Work to ensure system and data security is maintained at a high standard, ensuring the confidentiality, integrity and availability of the Virgin Pulse application is not compromised. Ensure industry best practice coding standards are adhered to in particular ensure all code developed at Virgin Pulse is free from bugs and security vulnerabilities, such as those defined and published by OWASP.

Why work here?

We believe a career should provide competitive pay and benefits, a collaborative and supportive work environment, strong employee culture and cutting-edge technology and services — so many reasons to love it here.

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to any protected class status.