COMPLETE Data Engineer II - New York, NY, USA

Job Posting Title:

Data Engineer II

Req ID:

10065011

Job Description:

We are seeking a Data Engineer who will partner with business, analytics and infrastructure teams to design and build datasets to facilitate measuring subscriber related metrics. Collaborating across disciplines, you will identify internal/external data sources to design table structure, define ETL strategy & automated Data Quality checks.

Responsibilities :

• Partner with technical and non-technical colleagues to understand data and reporting requirements.
• Work with engineering teams to collect required data from internal and external systems.
• Design table structures and define ETL strategy to build performant Data solutions that are reliable and scalable in a fast growing data ecosystem.
• Develop Data Quality checks and visualizations/dashboards
• Develop and maintain ETL routines using ETL and orchestration tools such as Airflow.
• Implement database deployments using tools like Liquibase
• Perform ad hoc analysis as necessary.
• Perform SQL and ETL tuning as necessary.
• Develop and maintain Dashboards/reports using Looker

Basic Qualifications :

• Bachelor’s degree in Computer Science, Information Systems, Software, Electrical or Electronics Engineering, or comparable field of study, and/or equivalent work experience.
• 3+ years of relevant Professional experience.
• 3+ years of work experience implementing and reporting on business key performance indicators in data warehousing environments. Strong understanding of data modeling principles including Dimensional modeling, data normalization principles etc.
• 3+ years of experience using analytic SQL, working with traditional relational databases and/or distributed systems such as Snowflake or Redshift.
• 3+ Years of experience programming languages (e.g. Python, Pyspark) preferred.
• 3+ years of experience with workflow management tools (Airflow, Nifi)
• Good understanding of SQL Engines and able to conduct advanced performance tuning
• Familiarity with data exploration / data visualization tools like Tableau, Looker, Chartio, etc.
• Ability to think strategically, analyze and interpret market and consumer information.
• Strong communication skills – written and verbal presentations.
• Excellent conceptual and analytical reasoning competencies.
• Comfortable working in a fast-paced and highly collaborative environment.
• Familiarity with Agile Scrum principles and ceremonies

The hiring range for this position in Santa Monica, CA is $102,500.00 to $137,500.00 per year and in Seattle, WA is $107,338.00 to $143,990.00 per year. The base pay actually offered will take into account internal equity and also may vary depending on the candidate’s geographic region, job-related knowledge, skills, and experience among other factors. A bonus and/or long-term incentive units may be provided as part of the compensation package, in addition to the full range of medical, financial, and/or other benefits, dependent on the level and position offered.

Job Posting Segment:

Cross Business Groups

Job Posting Primary Business:

Shared Service-Data & Analytics

Primary Job Posting Category:

Data Engineering

Employment Type:

Full time

Primary City, State, Region, Postal Code:

New York, NY, USA

Alternate City, State, Region, Postal Code:

USA - CA - 2450 Broadway, USA - WA - 925 4th Ave

Date Posted:

2023-10-10