Senior Data Engineer (Hybrid)

Description

About Deep Sync:

Deep Sync is the industry leader in deterministic identity. Leveraging our 35-year foundation of compiling direct mail-grade datasets, Deep Sync develops data-first technologies that power marketing, measurement, AI, and business intelligence for agencies and brands with our fully deterministic identity graph, privacy-first audiences, comprehensive data solutions, and integrations with leading platforms and cloud providers.

Position Overview:

We are seeking a Senior Data Engineer with a robust background in data engineering to join our team. The ideal candidate will be pivotal in designing, developing, and maintaining our data infrastructure. This role emphasizes not on building machine learning models but on integrating and deploying these models into our data pipelines to enhance our capabilities in advanced analytics and machine learning processes. The successful candidate will contribute expertise to improve and scale our data engineering practices, ensuring the seamless incorporation of machine learning models into our operational workflows.

The Foundational team supports Deep Sync’s mission critical data processing pipelines, where we ingest vast amounts of data from a large number of data sources, along with our own data to deliver our foundational data products offered to thousands of customers nationwide. The data products your team supports span nationwide consumer, business, student/young adult, new mover/new homeowner, and other data assets for use in analytics, sales, marketing and AI applications.

Key Responsibilities:

Data Pipeline Development:

• Design, implement, and maintain scalable data pipelines to collect, process, and store data from various sources.
• Ensure data quality, accuracy, and consistency throughout the pipeline.

Data Modeling Integration:

• Design and implement existing data models for predictive analytics, machine learning, and data exploration.
• Optimize data structures and storage to support predictive analytics/machine learning processes.

Data Integration:

• Work closely with cross-functional teams to integrate data from diverse sources, including databases, APIs, and external data providers.
• Develop and maintain ETL processes to transform and enrich raw data into actionable insights.

Performance Tuning:

• Monitor and optimize the performance of data pipelines and databases to meet business requirements.
• Identify and resolve bottlenecks and performance issues.

Continuous Learning and mentoring:

• Stay up-to-date with the latest advancements in data engineering and data science technologies.
• Share knowledge and mentor junior team members.

Requirements

Experience:

• Required: Experience transforming traditional ETL with SSIS to modern Data Engineering tech stack
• Technical leadership driving projects
• 5+ years experience in SQL Query Design, SQL Performance Tuning and Query Optimization
• 5+ years of relevant experience in Data Warehouse Design, Data Warehouse Technical Architectures, Development and Implementation
• 5+ years of relevant experience in ETL Development, ETL Implementation, Unit Testing, Troubleshooting and Support of ETL Processes
• End to end data pipeline build experience

Knowledge and Skills:

• Proficiency 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 end to end, ‘big data’ data pipelines and architecture
• Experience with data security
• Programming languages: Python, SQL
  • BONUS: C# / .NET  or Java or JavaScript
• Strong analytical and problem-solving skills
• Tech Stack:
  • Cloud Provider Experience: AWS
  • Data Storage and Warehousing Analytics Engine
    • Snowflake
  • Amazon Services
    • AWS Glue
    • AWS Elastic MapReduce (EMR)
    • AWS Lambda
  • Data Processing and Computation
    • Apache Spark
  • Workflow & DataOps 
    • Apache Airflow® DAGs  (Directed Acyclic Graph) for orchestration
  • SQL Services Experience
    • SSIS (SQL Server Integration Services)
    • BONUS: SSAS (SQL Server Analysis Services)
    • BONUS: SSRS (SQL Server Reporting Services

Location:

•  Hybrid to Kirkland, WA ( Tu-Th in office) 

Benefits:

• Flexible Time Off and Paid Holidays
• Salary $130,000 - $160,000, commensurate with experience and expertise.
• Medical/Vision/Dental Insurance, Voluntary Life & AD&D Insurance, Short-Term & Long-Term Disability, Critical Illness & Accident Insurance
• 401(k) with employer matching
• Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time. 

Please Contact:

Human Resources

888-970-7248

hr@deepsync.com

Equal Opportunity Employer