ETL Developer

US-NY-New York
Category
Development
Everyday Health, Inc.
Type
Regular Full-Time

Overview

The Everyday Health Pro team is looking for an ETL Developer to join our team.  As a member of the Data Engineering team, you will be at the epicenter of our most powerful data assets and innovations.  Projects will include:  enhancing the depth and breadth of our data warehouse; streamlining existing data pipelines and ETL jobs; preparing powerful, actionable datasets for modeling and predictive analytics; investigative querying and data exploration.

Responsibilities

About the Job:

  • Design, develop and maintain ETL to support business requirements
  • Independently co-ordinate and work with team of ETL/API developers located at three different locations (NYC, Asheville and India)
  • Performance tune ETL processes and SQL queries, and recommend new techniques
  • Provide support to the QA team to ensure data quality on collection, storage and computation standards
  • Document processes and applications, author best practice standards as they pertain to existing and future service layers

Qualifications

About You

  • Minimum of 5 years of work experience with excellent oral and written communication skills
  • Demonstrated proficiency with Microsoft SQL Server (version 2008 or higher)
  • Strong knowledge of SQL coding (stored procedures, functions, indexing), general database technologies, and best business database practices
  • Strong knowledge of relational database management systems
  • Experience with SQL Server Integration Services (SSIS) or other ETL tool
  • Experience with database design applications, including Visio and Erwin
  • Experience with source control tools like BitBucket,TFS, github, etc.
  • Exposure to data warehousing, OLAP (SSAS) or similar type environments.
  • A strong background with software development lifecycles, including familiarity with Agile and iterative development
  • Strong conceptual, analytical, problem solving, decision making and planning skills
  • Have a collaborative work style with strong desire to work in dynamic, fast paced environment that requires flexibility and ability to manage multiple priorities
  • Experience working in a team-oriented, collaborative environment
  • Minimum BS in Computer Science, Engineering and/or Mathematics or related area
  • You have experience scripting in Python or Shell

 

Who We are

Ziff Davis, a subsidiary of j2 Global, Inc., is a leading global digital-media company operating in four core verticals: Technology, Gaming, Healthcare and Shopping. Its brands – PCMag, Speedtest, ExtremeTech, Geek, Toolbox, IGN, Everyday Health, AskMen, Offers.com, TechBargains, emedia and Salesify – produce and distribute premium content across multiple platforms and devices. Ziff Davis delivers advertising, performance marketing, data services and licensing solutions to thousands of clients worldwide. Ziff Davis publishes in 25 languages and successfully partners with local publishing operators across 114 countries.

 

Everyday Health, Inc., a wholly-owned subsidiary of Ziff Davis, LLC, is a leading provider of digital health marketing and communications solutions. Everyday Health attracts a large and engaged audience of over 46 million consumers and over 730,000 practicing physicians in the U.S. to its premier health and wellness properties, and utilizes its data and analytics expertise to deliver highly personalized content experiences and efficient and effective marketing and engagement solutions. Everyday Health enables consumers to manage their daily health and wellness needs, healthcare professionals to stay informed and make better decisions for their patients, and marketers, health payers and providers to communicate and engage with consumers and healthcare professionals to drive better health outcomes. Everyday Health’s content and solutions are delivered through multiple channels, including desktop, mobile web, and mobile phone and tablet applications, as well as video and social media.

 

What We Offer
Alongside a dynamic and fun working environment that include amazing views of the Hudson, and on-going career development opportunities, Everyday Health offers top tier medical, dental and vision insurance options including membership to One Medical Group, fully-stocked kitchens with complimentary organic snacks and beverages, and a 401(k) plan with matched contributions. We also have a Flexible Time Off policy so you can take time off as you need it, a Commuter Benefits plan and employee discounts on various services, such as gym memberships and pet insurance.

 

**Everyday Health is an Equal Opportunity Employer**

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed