Senior Data Engineer with ETL Quality Experience

Job Description

City: Seattle, WA or Santa Monica, CA

Onsite/ Hybrid/ Remote: Hybrid (2 days a week onsite)

Duration: 12 months

Rate Range: $92.5/hr on W2 depending on experience (no C2C or 1099 or sub-contract)

Work Authorization: GC, USC, All valid EADs except H1b

Must Have

* Python
* SQL
* Data Engineering experience
* Test Cases
* This is Data Engineering and QA Hybrid role – QA with no Data Engineering will not work for this role

Job Qualifications

* 3 – 5 years’ experience in Quality validating ETL pipelines and Data Warehouses
* Expert SQL knowledge and experience working with relational databases as well as a working familiarity with a variety of databases.
* Good experience in data analytics, data engineering, data modeling, data warehousing, and big data platform
* Strong programming (Scala/Java) or scripting skills (Python)
* Experience with but not limited to JUnit/TestNG/BDD or similar tools
* Experience in a range of common big data tools & technologies such as Airflow, Hive, Snowflake, Databricks, Spark etc.
* Experience in working with large datasets (Terabytes or more)
* Ability to operate effectively in a team-oriented and collaborative environment
* Excellent communication skills and ability to interact with all levels of end users and technical resources

Basic Description

* Test and validate ETL logic and Data Pipelines
* Own the quality of every release into production with a data-driven approach
* Create, deliver and continuously improve our quality processes for delivering operational

data to address all types of subscriber and commerce operations to our stakeholders.

* Partner with Data Analysts, Product and Engineering teams to deeply understand the underlying transactional systems behavior and business use cases.
* Translate reporting and operational technical specifications, including calculations, custom groups, parameters, filtering criteria and/or aggregations into test requirements.
* Build automated and reusable tests for data stores to improve quality and development velocity
* Diagnose issues, report defects, and propose regression tests to catch recurring bugs
* Mentor fellow Test Engineers on the team to ramp up on automation concepts and contribute towards expanding test coverage

Required Education

Bachelor’s degree