Data Engineer

Data Engineer

Job : Full Time
Company : Compact Information Systems LLC
Location : Redmond, WA

Job Description:

About Deep Sync

Our parent company, Compact Information Systems LLC, is considered a pioneer of the data industry and was originally founded in 1988 as a mailing list company for direct marketers and print shops. Thirty-five years later, and combining the strength of our sister brands - AccuData Integrated Marketing, AlumniFinder, ASL Marketing, College Bound Selection Service (CBSS), Deep Sync Labs and HomeData - we have grown to become some of the foremost data suppliers in the U.S.

Today, we are Deep Sync. A company that powers agencies and brands with unmatched audience insights, unsurpassed reach, and unrivaled expertise by combining the industry's most comprehensive data with easy-to-activate solutions. We provide billions of privacy-first data connections annually to thousands of customers. Learn more about us here.

Role

We are seeking a Data Engineer with strong experience in SQL, Data Warehouse, and building scalable ETL pipelines. This role requires the design, development and implementation of data architecture and solutions. You will work closely with product/engineering/leadership teams to collect requirements for development of data products, application and data pipelines/etl processes.

You will be working with Deep Sync to build our next generation of data products.

Requirements:

  • 3+ years experience in SQL Query Design, SQL Performance Tuning and Query Optimization
  • 3+ years of relevant experience in Data Warehouse Design, Data Warehouse Technical Architectures, Development and Implementation
  • 3+ years of relevant experience in ETL Development, ETL Implementation, Unit Testing, Troubleshooting and Support of ETL Processes

Knowledge and Skills:

  • Strong Experience in SQL Query Design and Implementation
  • Strong Experience with Relational Data Warehouse Systems
    • Data Warehouse Management Systems
    • Optimization by Indexing, Partitioning and Denormalization
  • Strong Ability to build and optimize data sets, ‘big data' data pipelines and architecture
  • Strong analytical and problem-solving skills
  • Microsoft SQL Server Certifications
    • Equivalent SQL Certifications: Redshift, RDS, Snowflake, Big Query, etc. (or experience)

Additional Desirable Skills:

  • Experience in programming languages like Python, Scala & Java
  • Experience with graph databases

Skills

  • Data Warehouse, ETL , Indexing, Performance Tuning, Python, SQL Server, Scala, Unit Testing