{"schemaVersion":"jobsearcher.job.v1","id":"374b04dcd778355f19dab5fa","url":"https://jobsearcher.com/jobs/374b04dcd778355f19dab5fa","canonicalUrl":"https://jobsearcher.com/jobs/374b04dcd778355f19dab5fa","title":"Data Engineer Analytics & Migration Validation (Hands-On SQL)","description":"Remote/Hybrid\r\n4 - 7+ years\r\nHands-On SQL\r\nAbout BuildingBlocks\r\nRegardless of whether accomplishing astounding customer work or aiding assemble our organization from the inside, our different gifted organization shares a solitary mission: to fabricate lovely encounters that decidedly affect individuals' lives and the organizations we serve.\r\nOur way of life is more reason than work, mixing the quest for certified human association with a fastidious way to deal with the things we make. All with an idealistic soul. We're an organization that is adequately youthful to be fun and defiant – yet intense and driven enough to immensely affect the business.\r\nRole Overview\r\nWe're looking for a hands-on Data Engineer to own the data layer of customer go-lives — ensuring migrations are validated, analytics pipelines are hardened, and business dashboards are powered by accurate, performant data. You'll be responsible for validating and signing off on end-to-end data migrations, building high-quality SQL models, and implementing automated data quality checks to catch issues early.\r\nThis is a highl technical and impact-driven role focused on migration testing, SQL performance tuning, and data quality automation — aligning with AWS and industry best practices.\r\nKey Responsibilities\r\nEnd-to-End Migration Validation: Design and execute functional and performance validation for data migrations — including parity, nullability, PK/FK, duplication, and sampling checks — with complete documentation and sign-off aligned to AWS migration testing guidelines.\r\nAdvanced SQL Development: Write and optimize analytical SQL (CTEs, window functions, incremental loads). Use EXPLAIN plans to tune query performance and ensure indexes and statistics support BI workloads.\r\nAutomated Data Quality Frameworks: Implement and maintain data validation frameworks using Great Expectations, Deequ, or similar tools. Automate validation and publish Data Docs to ensure transparency across teams.\r\nModeling & Documentation (dbt): If using dbt, build models with tests, exposures, and documentation to ensure traceability between dashboards and upstream data sources.\r\nOrchestration & Reliability: Productionize data validation and transformation jobs within Airflow DAGs, ensuring welldefined SLAs, alerts, and reliable pipeline operations.\r\n(Optional) Cloud Data Engineering: Build incremental pipelines and optimize batch processing for Snowflake (Streams & Tasks) or PostgreSQL , ensuring performance and cost efficiency.\r\nMinimum Qualifications\r\nExperience: 4–7+ years as a Data Engineer or Analytics Engineer.\r\nSQL Expertise: Advanced proficiency in SQL and strong RDBMS fundamentals (PostgreSQL required), with proven experience in query tuning using EXPLAIN/analyze.\r\nMigration Validation: Hands-on experience designing and executing data migration validation (parity, integrity, and performance testing).\r\nTooling Knowledge: Experience with one or more of the following — dbt, Great Expectations or Deequ/PyDeequ, Airflow.\r\nVersion Control: Comfortable with Git-based workflows and CI/CD integration.\r\nNice to Have\r\nExperience with Snowflake (Streams, Tasks, cost optimization, and warehouse tuning).\r\nExposure to BI tools such as Looker, Power BI, Tableau, or Metabase .\r\nWorking knowledge of Python for lightweight data transformations and validation frameworks.\r\nTranscend your experience!\r\nPlease select the services you are looking for\r\nJ-18808-Ljbffr","company":"Buildingblocks Software Services","rawCompany":"buildingblocks software services","city":"Snowflake","state":"AZ","isRemote":false,"isActive":false,"createdAt":"2026-05-23T06:48:27.032Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Data Engineer Analytics & Migration Validation (Hands-On SQL)","description":"Remote/Hybrid\r\n4 - 7+ years\r\nHands-On SQL\r\nAbout BuildingBlocks\r\nRegardless of whether accomplishing astounding customer work or aiding assemble our organization from the inside, our different gifted organization shares a solitary mission: to fabricate lovely encounters that decidedly affect individuals' lives and the organizations we serve.\r\nOur way of life is more reason than work, mixing the quest for certified human association with a fastidious way to deal with the things we make. All with an idealistic soul. We're an organization that is adequately youthful to be fun and defiant – yet intense and driven enough to immensely affect the business.\r\nRole Overview\r\nWe're looking for a hands-on Data Engineer to own the data layer of customer go-lives — ensuring migrations are validated, analytics pipelines are hardened, and business dashboards are powered by accurate, performant data. You'll be responsible for validating and signing off on end-to-end data migrations, building high-quality SQL models, and implementing automated data quality checks to catch issues early.\r\nThis is a highl technical and impact-driven role focused on migration testing, SQL performance tuning, and data quality automation — aligning with AWS and industry best practices.\r\nKey Responsibilities\r\nEnd-to-End Migration Validation: Design and execute functional and performance validation for data migrations — including parity, nullability, PK/FK, duplication, and sampling checks — with complete documentation and sign-off aligned to AWS migration testing guidelines.\r\nAdvanced SQL Development: Write and optimize analytical SQL (CTEs, window functions, incremental loads). Use EXPLAIN plans to tune query performance and ensure indexes and statistics support BI workloads.\r\nAutomated Data Quality Frameworks: Implement and maintain data validation frameworks using Great Expectations, Deequ, or similar tools. Automate validation and publish Data Docs to ensure transparency across teams.\r\nModeling & Documentation (dbt): If using dbt, build models with tests, exposures, and documentation to ensure traceability between dashboards and upstream data sources.\r\nOrchestration & Reliability: Productionize data validation and transformation jobs within Airflow DAGs, ensuring welldefined SLAs, alerts, and reliable pipeline operations.\r\n(Optional) Cloud Data Engineering: Build incremental pipelines and optimize batch processing for Snowflake (Streams & Tasks) or PostgreSQL , ensuring performance and cost efficiency.\r\nMinimum Qualifications\r\nExperience: 4–7+ years as a Data Engineer or Analytics Engineer.\r\nSQL Expertise: Advanced proficiency in SQL and strong RDBMS fundamentals (PostgreSQL required), with proven experience in query tuning using EXPLAIN/analyze.\r\nMigration Validation: Hands-on experience designing and executing data migration validation (parity, integrity, and performance testing).\r\nTooling Knowledge: Experience with one or more of the following — dbt, Great Expectations or Deequ/PyDeequ, Airflow.\r\nVersion Control: Comfortable with Git-based workflows and CI/CD integration.\r\nNice to Have\r\nExperience with Snowflake (Streams, Tasks, cost optimization, and warehouse tuning).\r\nExposure to BI tools such as Looker, Power BI, Tableau, or Metabase .\r\nWorking knowledge of Python for lightweight data transformations and validation frameworks.\r\nTranscend your experience!\r\nPlease select the services you are looking for\r\nJ-18808-Ljbffr","datePosted":"2026-05-23T06:48:27.032Z","dateModified":"2026-05-23T06:48:27.032Z","hiringOrganization":{"@type":"Organization","name":"Buildingblocks Software Services","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Snowflake","addressRegion":"AZ","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"374b04dcd778355f19dab5fa"},"url":"https://jobsearcher.com/jobs/374b04dcd778355f19dab5fa"}}