{"schemaVersion":"jobsearcher.job.v1","id":"58e64a88557efe8488c4926d","url":"https://jobsearcher.com/jobs/58e64a88557efe8488c4926d","canonicalUrl":"https://jobsearcher.com/jobs/58e64a88557efe8488c4926d","title":"Jr Data Engineer","description":"SmartLight is building out its next-generation Snowflake data warehouse to power claims analytics, waste and abuse analytics, and client reporting at scale. We're looking for a Junior Data Engineer to join our Data Platform Team and grow alongside a modern, AI-augmented data stack. This is a hands-on role: you'll ingest and model real healthcare claims data, build transformation pipelines in dbt, and help shape the fact/dimensional models and semantic layer that our analysts and reporting tools depend on every day.\n\nThis role suits someone early in their data engineering career who has strong fundamentals and is comfortable working independently once given clear requirements — not someone who needs each task broken into small steps.\n\nWhat You'll Do\n\nDesign, build, and maintain data ingestion pipelines feeding SmartLight's Snowflake warehouse from claims, eligibility, and other healthcare data sources\n\nDevelop and maintain transformation models in dbt, following testing, documentation, and version-control best practices\n\nContribute to fact and dimensional modeling (star schema design, slowly changing dimensions, grain definition) supporting claims analytics use cases\n\nSupport and help maintain a semantic layer that gives consistent, governed metrics to downstream reporting tools (e.g., Sigma)\n\nTroubleshoot data quality issues, pipeline failures, and schema drift with minimal escalation\n\nWrite idempotent, reliable pipeline logic that can be safely rerun without creating duplicate or inconsistent data\n\nCollaborate with senior data engineers, analysts, and product stakeholders to translate business/reporting requirements into technical data structures\n\nUse AI-assisted development tools (Claude, Copilot, or similar) as a core part of your daily workflow — for code generation, debugging, documentation, and accelerating pipeline development — while maintaining human review and code quality standards\n\nFollow SmartLight's change management, SDLC, and data security practices, given the sensitivity of the healthcare data we handle\n\nWhat You'll Need\n\nRequired:\n\nSolid foundational knowledge of data engineering: ETL/ELT concepts, SQL proficiency, and data pipeline design\n\nWorking knowledge of dbt (or strong readiness to ramp quickly if exposure is limited) for transformation and modeling\n\nUnderstanding of fact and dimensional modeling principles (star/snowflake schemas, grain, SCDs)\n\nFamiliarity with the concept of a semantic layer and why it matters for consistent, trustworthy reporting\n\nStrong data translation fundamentals — the ability to take a business question or reporting requirement and reason through the correct data structure/logic to answer it accurately\n\nAbility to work independently and complete assigned tasks with minimal day-to-day supervision once requirements are clear\n\nComfort using AI tools as a core part of the development process — this is a non-negotiable expectation of how we build, not an optional add-on\n\nStrong written communication skills for documentation and cross-team collaboration\n\nPreferred:\n\nPrior experience in healthcare data (claims, eligibility, EHR, or similar) — familiarity with concepts like UB-04 revenue codes, claims adjudication, or payer/provider data structures is a plus\n\nExperience with Snowflake specifically\n\nExposure to Terraform or other infrastructure-as-code practices\n\nFamiliarity with Sigma, Looker, Power BI, or other modern BI/reporting tools\n\nUnderstanding of HIPAA-related data handling considerations\n\nWhat Success Looks Like\n\nYou can take a data ingestion or modeling task, ask clarifying questions up front, and deliver a working, tested solution without needing hand-holding through implementation\n\nYour dbt models are well-documented, tested, and follow the team's established modeling conventions\n\nYou proactively flag data quality issues or schema risks before they become downstream reporting problems\n\nYou use AI tools fluently to move faster without sacrificing code quality, security, or accuracy — especially given SmartLight's obligations around GenAI use disclosure in some client contracts\n\nYou grow into increasing ownership of the Snowflake buildout over time, with a path toward more senior data engineering responsibilities\nm8ElvgaNby","company":"Smartlight Analytics","rawCompany":"smartlight analytics","city":"Myrtle Point","state":"OR","isRemote":false,"isActive":false,"createdAt":"2026-09-28T11:38:37.946Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"}],"industries":[{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Jr Data Engineer","description":"SmartLight is building out its next-generation Snowflake data warehouse to power claims analytics, waste and abuse analytics, and client reporting at scale. We're looking for a Junior Data Engineer to join our Data Platform Team and grow alongside a modern, AI-augmented data stack. This is a hands-on role: you'll ingest and model real healthcare claims data, build transformation pipelines in dbt, and help shape the fact/dimensional models and semantic layer that our analysts and reporting tools depend on every day.\n\nThis role suits someone early in their data engineering career who has strong fundamentals and is comfortable working independently once given clear requirements — not someone who needs each task broken into small steps.\n\nWhat You'll Do\n\nDesign, build, and maintain data ingestion pipelines feeding SmartLight's Snowflake warehouse from claims, eligibility, and other healthcare data sources\n\nDevelop and maintain transformation models in dbt, following testing, documentation, and version-control best practices\n\nContribute to fact and dimensional modeling (star schema design, slowly changing dimensions, grain definition) supporting claims analytics use cases\n\nSupport and help maintain a semantic layer that gives consistent, governed metrics to downstream reporting tools (e.g., Sigma)\n\nTroubleshoot data quality issues, pipeline failures, and schema drift with minimal escalation\n\nWrite idempotent, reliable pipeline logic that can be safely rerun without creating duplicate or inconsistent data\n\nCollaborate with senior data engineers, analysts, and product stakeholders to translate business/reporting requirements into technical data structures\n\nUse AI-assisted development tools (Claude, Copilot, or similar) as a core part of your daily workflow — for code generation, debugging, documentation, and accelerating pipeline development — while maintaining human review and code quality standards\n\nFollow SmartLight's change management, SDLC, and data security practices, given the sensitivity of the healthcare data we handle\n\nWhat You'll Need\n\nRequired:\n\nSolid foundational knowledge of data engineering: ETL/ELT concepts, SQL proficiency, and data pipeline design\n\nWorking knowledge of dbt (or strong readiness to ramp quickly if exposure is limited) for transformation and modeling\n\nUnderstanding of fact and dimensional modeling principles (star/snowflake schemas, grain, SCDs)\n\nFamiliarity with the concept of a semantic layer and why it matters for consistent, trustworthy reporting\n\nStrong data translation fundamentals — the ability to take a business question or reporting requirement and reason through the correct data structure/logic to answer it accurately\n\nAbility to work independently and complete assigned tasks with minimal day-to-day supervision once requirements are clear\n\nComfort using AI tools as a core part of the development process — this is a non-negotiable expectation of how we build, not an optional add-on\n\nStrong written communication skills for documentation and cross-team collaboration\n\nPreferred:\n\nPrior experience in healthcare data (claims, eligibility, EHR, or similar) — familiarity with concepts like UB-04 revenue codes, claims adjudication, or payer/provider data structures is a plus\n\nExperience with Snowflake specifically\n\nExposure to Terraform or other infrastructure-as-code practices\n\nFamiliarity with Sigma, Looker, Power BI, or other modern BI/reporting tools\n\nUnderstanding of HIPAA-related data handling considerations\n\nWhat Success Looks Like\n\nYou can take a data ingestion or modeling task, ask clarifying questions up front, and deliver a working, tested solution without needing hand-holding through implementation\n\nYour dbt models are well-documented, tested, and follow the team's established modeling conventions\n\nYou proactively flag data quality issues or schema risks before they become downstream reporting problems\n\nYou use AI tools fluently to move faster without sacrificing code quality, security, or accuracy — especially given SmartLight's obligations around GenAI use disclosure in some client contracts\n\nYou grow into increasing ownership of the Snowflake buildout over time, with a path toward more senior data engineering responsibilities\nm8ElvgaNby","datePosted":"2026-09-28T11:38:37.946Z","dateModified":"2026-09-28T11:38:37.946Z","hiringOrganization":{"@type":"Organization","name":"Smartlight Analytics","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Myrtle Point","addressRegion":"OR","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"58e64a88557efe8488c4926d"},"url":"https://jobsearcher.com/jobs/58e64a88557efe8488c4926d"}}