{"schemaVersion":"jobsearcher.job.v1","id":"7306f2c4c293e98d6ff971bd","url":"https://jobsearcher.com/jobs/7306f2c4c293e98d6ff971bd","canonicalUrl":"https://jobsearcher.com/jobs/7306f2c4c293e98d6ff971bd","title":"Database Architect","description":"12+ years Data analysis/architecture experience in Waterfall and Agile Methodology in various domains (prefer Healthcare) in a data warehouse environment.Good knowledge of relational database, Hadoop big data platform and tools, data vault and dimensional model design.Strong SQL experience (prefer Oracle, Hive and Impala) in creating DDL's and DML's in Oracle, Hive and Impala (minimum of 8-9 years' experience).Experience in analysis, design, development, support and enhancements in data warehouse environment with Cloudera Bigdata Technologies (with a minimum of 8-9 years' experience in data analysis, data profiling, data model, data cleansing and data quality analysis in various layers using Database queries both in Oracle and Big Data platforms).Experience (minimum of 8-9 years) in working Erwin Data Model tool, hive/impala queries, Unix commands, scripting and shell scripting etc.Experience in migrating data from relational database (prefer Oracle) to big data - Hadoop platform is a plus.Experience eliciting, analyzing and documenting functional and non-functional requirements.Ability to document business, functional and non-functional requirements, meeting minutes, and key decisions/actions.Experience in identifying data anomalies.Experience building data sets and familiarity with PHI and PII data.Ability to establish priorities & follow through on projects, paying close attention to detail with minimal supervision.Effective communication, presentation, & organizational skills.Good experience in working with Visio, Excel, PowerPoint, Word, etc.Effective team player in a fast paced and quick delivery environment.Required Education: BS/BA degree or combination of education & experience. DESIRED Skill Sets:Demonstrate effective leadership, analytical and problem-solving skillsRequired excellent written and oral communication skills with technical and business teams.Ability to work independently, as well as part of a teamStay abreast of current technologies in area of IT assigned Establish facts and draw valid conclusionsRecognize patterns and opportunities for improvement throughout the entire organizationAbility to discern critical from minor problems and innovate new solutions","company":"Exaways","rawCompany":"exaways","city":"Denver","state":"CO","isRemote":false,"isActive":false,"createdAt":"2026-09-21T12:57:38.784Z","occupations":[{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"}],"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":"Database Architect","description":"12+ years Data analysis/architecture experience in Waterfall and Agile Methodology in various domains (prefer Healthcare) in a data warehouse environment.Good knowledge of relational database, Hadoop big data platform and tools, data vault and dimensional model design.Strong SQL experience (prefer Oracle, Hive and Impala) in creating DDL's and DML's in Oracle, Hive and Impala (minimum of 8-9 years' experience).Experience in analysis, design, development, support and enhancements in data warehouse environment with Cloudera Bigdata Technologies (with a minimum of 8-9 years' experience in data analysis, data profiling, data model, data cleansing and data quality analysis in various layers using Database queries both in Oracle and Big Data platforms).Experience (minimum of 8-9 years) in working Erwin Data Model tool, hive/impala queries, Unix commands, scripting and shell scripting etc.Experience in migrating data from relational database (prefer Oracle) to big data - Hadoop platform is a plus.Experience eliciting, analyzing and documenting functional and non-functional requirements.Ability to document business, functional and non-functional requirements, meeting minutes, and key decisions/actions.Experience in identifying data anomalies.Experience building data sets and familiarity with PHI and PII data.Ability to establish priorities & follow through on projects, paying close attention to detail with minimal supervision.Effective communication, presentation, & organizational skills.Good experience in working with Visio, Excel, PowerPoint, Word, etc.Effective team player in a fast paced and quick delivery environment.Required Education: BS/BA degree or combination of education & experience. DESIRED Skill Sets:Demonstrate effective leadership, analytical and problem-solving skillsRequired excellent written and oral communication skills with technical and business teams.Ability to work independently, as well as part of a teamStay abreast of current technologies in area of IT assigned Establish facts and draw valid conclusionsRecognize patterns and opportunities for improvement throughout the entire organizationAbility to discern critical from minor problems and innovate new solutions","datePosted":"2026-09-21T12:57:38.784Z","dateModified":"2026-09-21T12:57:38.784Z","hiringOrganization":{"@type":"Organization","name":"Exaways","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Denver","addressRegion":"CO","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"7306f2c4c293e98d6ff971bd"},"url":"https://jobsearcher.com/jobs/7306f2c4c293e98d6ff971bd"}}