{"schemaVersion":"jobsearcher.job.v1","id":"ceb7ea4eeee4da6e36ce4af9","url":"https://jobsearcher.com/jobs/ceb7ea4eeee4da6e36ce4af9","canonicalUrl":"https://jobsearcher.com/jobs/ceb7ea4eeee4da6e36ce4af9","title":"BI SQL Developer-Boise, ID/Remote","description":"BI SQL DeveloperLocation: Boise, ID/Remote Duration: 6 months Contract Rate: DOE w2 onlyRequired Skills:Ability to describe/document/design basic data model concepts (PK/FK relationships Star Schema/Snowflake models and their pro's/con's physical model vs logical model common RDBMS Enterprise features like Partitioning)Ability to articulate common ETL designs and describe their pro's/con's (kill & fill Delta loads Batch/Micro-Batch Realtime data pipeline loads are a plus)Familiar with common DW concepts (and associated design considerations) such as Slowly Changing Dimensions Large Volume Table design/maintenance Data Retention Policy impacts on DW object designQuery Performance Tuning (Index Design and Maintenance Ability to read/interpret SQL Execution Plans Knowledge of SQL Server Profiler and/or Database Engine Tuning Advisor are a solid Plus)Basic understanding of OLAP Cubes (SSAS) different types of SSRS reportsBasic knowledge of SAP HANA SAP BWKnowledge of/Experience designing Automated Testing/Data Validation/Data Cleansing (big plus)","company":"Staffing","rawCompany":"staffing","city":"Boise","state":"ID","isRemote":true,"isActive":false,"createdAt":"2026-06-26T06:03:19.384Z","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":"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":"BI SQL Developer-Boise, ID/Remote","description":"BI SQL DeveloperLocation: Boise, ID/Remote Duration: 6 months Contract Rate: DOE w2 onlyRequired Skills:Ability to describe/document/design basic data model concepts (PK/FK relationships Star Schema/Snowflake models and their pro's/con's physical model vs logical model common RDBMS Enterprise features like Partitioning)Ability to articulate common ETL designs and describe their pro's/con's (kill & fill Delta loads Batch/Micro-Batch Realtime data pipeline loads are a plus)Familiar with common DW concepts (and associated design considerations) such as Slowly Changing Dimensions Large Volume Table design/maintenance Data Retention Policy impacts on DW object designQuery Performance Tuning (Index Design and Maintenance Ability to read/interpret SQL Execution Plans Knowledge of SQL Server Profiler and/or Database Engine Tuning Advisor are a solid Plus)Basic understanding of OLAP Cubes (SSAS) different types of SSRS reportsBasic knowledge of SAP HANA SAP BWKnowledge of/Experience designing Automated Testing/Data Validation/Data Cleansing (big plus)","datePosted":"2026-06-26T06:03:19.384Z","dateModified":"2026-06-26T06:03:19.384Z","hiringOrganization":{"@type":"Organization","name":"Staffing","sameAs":"https://jobsearcher.com"},"jobLocationType":"TELECOMMUTE","applicantLocationRequirements":{"@type":"Country","name":"US"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Boise","addressRegion":"ID","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"ceb7ea4eeee4da6e36ce4af9"},"url":"https://jobsearcher.com/jobs/ceb7ea4eeee4da6e36ce4af9"}}