WHAT WE DO MATTERS:

Here at The Knot Worldwide, we believe in doing work that matters. In 16 countries around the world, our leading family of brands (The Knot, WeddingWire, Bodas, Hitched, The Bash, The Bump, and more) inspire, inform, and celebrate our communities as they move through life’s milestones. Our couples and business partners depend on us. They're all in. So are we.

JOB PURPOSE:

The Data Engineering team plays a key role in supporting the data warehouse infrastructure that is used by the entire organization.  Our mission is to provide reliable, performant, timely and understandable centralized data services to The Knot Worldwide.  

This is a multi-disciplinary role that involves the operation and maintenance of our  infrastructure resources as well as utilizing technologies ranging from low level python and shell script coding, and enterprise ETL / ELT.  In this role, the data engineer assists in providing the data and information needed for The Knot WorldWide to be the leading data-driven software product company in the wedding events industry.

KEY RESPONSIBILITIES:

• Extract, load, and transform data from internal and external sources to our data warehouse for the consumption of our end users
• Design and develop solutions for integration between disparate systems which include cloud-based sources such as Salesforce and Salesforce Marketing Cloud, as well as internal TKWW services
• Maintain current ETL processes and resolve ETL job failures as they arise
• Resolve ad-hoc data questions from the organization in a timely and accurate manner
• Continuous improvement on current ETL processes to ensure accuracy, timeliness, and scalability as data volumes grow
• Document and publish information relating to processes, dataset content, and needed information to our data dictionary and other documentation stores

REQUIRED SKILLS/EXPERIENCE:

• A Bachelor’s Degree in Computer Science, Information Systems, or a related field is preferred. An advanced degree or professional licensing is a plus
• Experience and a demonstrated interest in statistical analysis, informatics, analytics, or business intelligence
• Minimum of 5+ years experience with SQL and data warehouse development and ETL
• Hands-on experience with at least one major relational database such as MYSQL, PostgreSQL, Snowflake, MSSQL, or Redshift
• Experience with standard warehousing concepts like Operational Data Stores,  Data Vault, and Dimensional Modeling
• Excellent communication skills, both verbal and written
• Present ideas, expectations, and information in a concise, well-organized way
• Conduct research and make recommendations on data requirements, products, and services
• Manage time well, correctly prioritizing tasks

DESIRED SKILLS/EXPERIENCE:

• Knowledge of data warehouse schema design and architecture
• Experience with at least one Business Intelligence tool such as Qlik and Metabase

• Experience with Big Data Solutions such as Snowflake, Redshift, Google BigQuery, or Hadoop
• Experience with ETL tools such as Matillion, Boomi, Informatica, SSIS, etc
• Experience working with non-relational data structures such as JSON and XML
• Functional knowledge of a common programming language (python, java, R, node.js, GoLang, etc)

At The Knot Worldwide, we believe you are more than a resume and invite you to go for it, take the leap of faith, and apply for this job if it sparks your passion to join TKWW and make a difference!   

WHAT WE LOVE ABOUT YOU:

• You Dream Big. You iterate and experiment to drive innovation.
• You Love Our Users. You keep our global community at the center of everything you do.
• You Do the Right Thing. You strengthen your team through respect, fairness, and inclusion.
• You Hustle Every Day. You favor urgency and own your outcomes. 
• You Win Together. People are at the heart of our success and you play as a team.

WHAT YOU LOVE ABOUT US:

The Knot Worldwide offers a unique employee experience and we are deeply proud of our award-winning culture. We offer a full benefits package including options for medical, dental and vision insurance and a 401k with company match. From flexible vacation and generous parental leave benefits to promoting wellness and giving back to our community, we believe in happiness above all else—in and out of the office.

--

The Knot Worldwide provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, or disability. In addition to federal law requirements, The Knot Worldwide complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. The Knot Worldwide expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status.

If you are a resident of California, by submitting your application, you acknowledge that you’ve read the California Privacy Notice.

#LI-KS1