Data Engineer – PSQA

DeWinter Group; Foster City (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

DeWinter Group is seeking a Data Engineer to design and maintain dashboards that monitor PSQA metrics in Foster City, CA. You will query and transform release data using SQL and Python, and build robust ETL pipelines to support quality insights across multiple components.

The role emphasizes collaboration with PSQA and stakeholders, data modeling for longitudinal analysis, and clear documentation to ensure future scalability. Onsite in Foster City with no travel.

Qualifications

• Strong SQL for querying, aggregation, and modeling.
• Proficient Python for data transformation and ETL (Pandas/PySpark).
• Experience building dashboards with Tableau, Power BI, or QuickSight.
• Ability to model release/version data for longitudinal analysis.

Responsibilities

• Design, build, and maintain dashboards and scorecards to monitor PSQA metrics.
• Query, aggregate, and transform release/version data using SQL and Python.
• Develop and optimize ETL pipelines for quality and release data from multiple sources.
• Model release- and version-based data for long-term tracking and trends.
• Conduct exploratory data analysis to uncover quality insights.
• Collaborate with PSQA and stakeholders to translate requirements into dashboards and reports.
• Own data deliverables, ensuring accuracy and timely issue resolution.
• Document data models, pipelines, and dashboard specs for maintainability.

Skills

SQL

Python

BI Tools

Data Modeling

AWS

Git

Communication

Education

Bachelor's degree in CS/DS/Engineering or related field

Tools

Git

Job description

Join Our Team as a Data Engineer – PSQA in Foster City, CA!

Are you passionate about transforming complex data into actionable insights that drive quality and excellence? We’re seeking a talented Data Engineer to play a pivotal role in enhancing the PSQA (Product Software Quality Assurance) processes through innovative data solutions. This onsite position offers an exciting opportunity to collaborate with cross-functional teams, develop robust dashboards, and deliver impactful insights in a dynamic, fast-paced environment.

What You’ll Do:

• Design, build, and maintain insightful dashboards and scorecards to monitor PSQA release and quality metrics.
• Query, aggregate, and transform release and version data utilizing SQL and Python.
• Develop and optimize ETL pipelines to process complex quality and release data from various components.
• Model release- and version-based data to facilitate long-term tracking and trend analysis.
• Conduct exploratory data analysis to uncover insights that inform quality decisions.
• Collaborate effectively with PSQA and other stakeholders to translate requirements into tangible dashboards and reports.
• Take ownership of data deliverables, ensuring timely resolution of issues and ongoing accuracy.
• Document data models, pipeline workflows, and dashboard specifications for maintainability and future scalability.

Required Skills:

• Strong SQL expertise for data querying, aggregation, and modeling.
• Proficiency in Python, especially with Pandas or PySpark, for data transformation and ETL tasks.
• Experience building dashboards with BI tools such as Tableau, Power BI, or Amazon QuickSight.
• Ability to model release/version-based data for longitudinal analysis.
• Familiarity with basic data science concepts — statistics, exploratory data analysis, and notebook-based analysis.
• Knowledge of AWS services including S3, Athena, or Redshift.
• Experience with version control systems like Git.
• Excellent written and verbal communication skills for clear documentation and stakeholder engagement.

Nice to Have Skills:

• Experience with data pipeline scheduling tools like Airflow or similar workflows.
• Practical use of AI tools (such as ChatGPT, Copilot, or Cursor) to enhance productivity.
• Background in QA, release management, or software quality metrics to better understand the context.

Preferred Education & Experience:

• Bachelor’s degree in Computer Science, Data Science, Engineering, or a related field.
• 3+ years of professional experience in data engineering, especially within software release or quality assurance environments.

Additional Requirements:

• This is an onsite role based in Foster City, CA, requiring 5 days in the office.
• Must be eligible to work in the U.S. (W2 only).
• No travel required.