Write and optimize complex SQL queries including nested joins, temp tables, aggregations, window functions, and CTEs
Identify patterns and relationships to evaluate, maintain, and enrich data quality across multiple systems and data sources
Perform root cause analysis (RCA) and impact analysis to identify data quality issues and report findings to stakeholders
Develop flexible, reusable, and efficient SQL code with minimal supervision while adhering to best practices
Create and maintain analytics reports and dashboards for business stakeholders using modern BI tools
Conduct data profiling and data quality validation to ensure high-quality data for downstream consumers
Perform code reviews on SQL and data scripts, providing constructive feedback to ensure quality
Collaborate with cross-functional teams including data engineering, product, and analytics teams in an Agile/Scrum environment

Requirements

Bachelor’s degree in Computer Science, Data Science, Information Systems, or related degree
5+ years of experience writing complex SQL queries including nested joins, temporary tables, aggregations, subqueries, window functions, and CTEs
5+ years of experience with relational databases (PostgreSQL, SQL Server, MySQL) and SQL query performance optimization
Experience with data profiling, data quality assessment, data validation techniques, and finding insights in large, complex data sets
Strong analytical skills including data mining and evaluation, with demonstrated ability to perform code/query reviews in Agile/Scrum environments

Benefits

health, vision, and dental insurance
accident and life insurance
401k matching
paid-time off
education reimbursement

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLnested joinstemporary tablesaggregationswindow functionsCTEsdata profilingdata quality assessmentdata validation techniquesquery performance optimization

Soft Skills

analytical skillscollaborationconstructive feedbackroot cause analysisimpact analysis