Senior Data Engineer

Client: EdTech

Title: Senior Data Engineer

Duration: Long Term

Location: 100% Remote

Ideal Candidate Profile: 

·        Data Engineer/Analyst will work closely with Architects and leads in the Interflow team, key business stakeholders including program staff to support the organizations effort in the areas of data Analysis and information management.

·        Role should have strong experience in writing super complex SQL queries to extract data for reports.

·        Candidate should have experience working with large set of data.

·        These reports are very critical for the company, and we are looking for an expert who is capable of handling, consuming and extracting large sets of data for analysis and reports.  

About the Opportunity   

·        As a Senior Data Engineer, you’ll help ensure that the data powering our products, reporting, and operational workflows is accurate, complete, timely, and trustworthy.

·        You’ll design and implement data quality checks, monitoring, and remediation processes across pipelines and platforms, working closely with engineers, analysts, product teams, and business stakeholders.

·        Your work will help identify issues early, reduce operational risk, and improve confidence in the data used to support critical decisions and digital assessment experiences.

·        This role blends hands-on technical investigation, automation, and cross-functional collaboration.  

·        We use Tableau and Quicksight for Data Analysis; Apache Spark for Big Data Processing; and they should have used at least one AI tool: Amazon Q; Google Cloud AI; Google Cloud Smart Analytics; Tableau AI 

In this role you will: 

Data Quality Engineering & Monitoring (45%) 

·        Design and implement automated data quality checks for completeness, accuracy, consistency, freshness, and schema integrity across critical datasets and pipelines. 

·        Build monitoring, alerting, and observability solutions to detect anomalies, pipeline failures, data drift, and unexpected changes before they impact downstream consumers. 

·        Develop and maintain reconciliation processes across source systems, transformed datasets, reports, and operational outputs. 

·        Partner with engineers and analysts to define quality rules, acceptance criteria, and data validation requirements for new and existing systems. 

·        Create reusable frameworks, scripts, and tooling for profiling, testing, and validating data in production and non-production environments. 

Investigation, Analysis, & Remediation (35%) 

·        Investigate data issues by tracing data across systems, transformations, and business workflows to identify root causes and recommend fixes. 

·        Use SQL, Python, and cloud data tools to analyze large datasets, isolate anomalies, and validate business logic. 

·        Support incident response and issue resolution for data-related production problems, especially during high-priority operational periods. 

·        Work with cross-functional teams to remediate defects, improve upstream processes, and reduce recurrence of common data issues. 

·        Communicate findings clearly to both technical and non-technical stakeholders, including issue summaries, remediation recommendations, and quality trends. 

Governance, Documentation, & Team Success (20%) 

·        Document data definitions, validation logic, lineage, quality rules, and remediation procedures to improve transparency and operational readiness. 

·        Contribute to best practices for testing, version control, deployment, and ongoing maintenance of data quality solutions. 

·        Participate in Agile ceremonies, code reviews, and team planning, helping break work into manageable tasks and improve team productivity. 

·        Support the development of standards for data governance, ownership, and operational excellence across the team. 

·        Partner with stakeholders to improve trust in shared data assets and ensure quality considerations are built into delivery from the start. 

 About You  

·        BS degree in Engineering, Computer Science, or related field / equivalent experience   

·        10+ years of general experience in quality testing 

·        Strong SQL skills and experience writing complex queries to analyze, validate, and troubleshoot data across multiple systems. 

·        Professional experience in data engineering, analytics engineering, data quality, software Engineering, or a related field with a strong focus on data investigation and validation. 

·        Exposure to AI-assisted development tools (e.g., GitHub Copilot, Claude) and hands-on experience applying to build and deploy AI agents that automate data pipelines, write code and testing workflows. 

·        Experience working with cloud data platforms and tools such as AWS, Redshift, Athena, Snowflake, Databricks, or similar technologies. 

·        Proficiency in Python or type script language used for automation, testing, and data analysis. 

·        Experience designing or maintaining data quality checks, monitoring, alerting, or observability processes for production datasets or pipelines. 

·        Strong understanding of data structures, data modeling, transformations, lineage, and common sources of data defects. 

·        Experience working with BI/reporting tools such as Tableau, QuickSight, or similar platforms is helpful.