:\n\nAbout the Northwest Portland Area Indian Health Board (NPAIHB) The Northwest Tribes have long recognized the need to exercise control over the design and development of health care delivery systems in their local communities. To this end, they formed the Northwest Portland Area Indian Health Board (also referred to as NPAIHB or "the Board") in 1972. Guided by a vision of "Health and Wellness for the Seventh Generation," NPAIHB is a 501(c)3 designated (non-profit) organization and Tribal organization, P.L. 93-638, under the Indian Self-Determination and Education Assistance Act (ISDEAA) serving the 43 federally recognized Tribes in the states of Idaho, Oregon, and Washington (Northwest Tribes). Tribes become voting members of the Board through resolutions passed by their governing body. Each member Tribe designates a delegate to serve on the NPAIHB Board of Directors. Led by our Board of Directors, NPAIHB's mission is to "eliminate health disparities and improve the quality of life of American Indians and Alaska Natives by supporting Northwest Tribes in their delivery of culturally appropriate, high-quality health programs and services." We have a staff of over 120 professionals dedicated to advancing Tribal health for the 7th generation in the Pacific Northwest. The NPAIHB's Strategic Plan 2020-2025 can be found here. Position Summary The Data Engineer plays a crucial role in designing, building, and maintaining a modern data infrastructure for the NPAIHB Northwest Tribal Data Hub ("Data Hub") and other data systems within the organization. The Data Engineer works closely with the Data Hub and other teams and to create the architecture needed for data storage, processing, analysis, and secure transfer to Tribal leaders, public health professionals, and clinical staff. The Data Engineer's work is pivotal in enhancing the capacity of Tribal public health departments to conduct data-driven activities, advancing Tribal data sovereignty, and empowering Northwest Tribes to improve health outcomes within their communities. The Data Engineer collaborates with epidemiologists, data content experts, Information Technology staff, project directors, and others to develop and implement scalable solutions which align with the objectives of the NPAIHB. The Data Engineer reports to the IDEA-NW Project Director. This scope of work is housed within the Northwest Tribal EpiCenter (NWTEC or "EpiCenter") Division. This position is based at NPAIHB's offices in Portland, Oregon. Local travel and/or overnight travel outside of the area is required approximately 10% of the time. Essential FunctionsData Engineering Excellence and SuccessSupports the creation and implementation of capacity building and quality improvement strategies based on the needs and priorities of Northwest TribesCarries out updated Data Hub, EpiCenter, and organizational priorities throughout the year, as directed by Northwest Tribes, and through the NPAIHB Strategic Planning process and/or annual federal and state policy prioritiesCreates new and enhances existing systems and pipelines which enable efficient, reliable, and secure flow of data, including data ingestion, processing, and storageLoads data into storage systems and/or data warehouses, and transforms, cleans, and organizes data with dimensional modeling techniques to ensure accuracy, consistency, and efficient queryingStructures and transforms data to ensure it is optimized for use in data visualization software, and enabling accurate and effective visual representations of epidemiological dataClearly and thoroughly documents database architecture and workflows to promote sustainability, consistency, and ease of maintenanceApplies rigorous data quality checks and validation processes to guarantee the accuracy and reliability of the data released, emphasizing the importance of delivering correct and trustworthy data to support public health initiativesOptimizes data pipelines, infrastructure, and workflows for performance and scalabilityMonitors data pipelines and systems for performance issues errors, and anomalies, and implements solutions to address themImplements security measures to protect sensitive informationEnsures all project data is maintained with complete confidentiality in accordance with the Federal Privacy Act, Institutional Review Board (IRB) specifications, and organizational policies regarding data management, analysis, and disseminationEnsures the accuracy, completeness, and consistency of data by implementing and maintaining Extract, Transform, and Load (ETL) processesMaintains and applies up-to-date knowledge of industry trends, best practices, and emerging technologies in data engineering, and incorporates these into the organization's data infrastructure as needed and appropriateCommunicates effectively with partners at all levels of the organization to gather requirements, provide updates, and present findingsCollaborates with epidemiologists, analysts, and other partners to understand current and future data needs and requirements as well as ensure data infrastructure supports organizational needs and objectivesIn collaboration with cross-functional teams, designs scalable solutions that meet organizational needs and demonstrate a clear understanding of data requirementsProvides training and technical guidance to NPAIHB staff and others on preparing and structuring of data for visualization, and leveraging knowledge of visualization tools to support the creation of meaningful and insightful visual outputs Administrative and Reporting FunctionsSupports organizational workgroups and other collaborative activities related to improving the NWTEC's data science capabilities and servicesAssists with the identification and preparation of grant applications which support project goals and objectives as neededParticipates in and leads workgroups, meetings, site visits, and conferences to achieve project and organizational objectives as requiredMaintains well-organized filing systems for required documentation and supporting records (both electronic and hard copy) in compliance with both NPAIHB and funding agency requirements, including securely archiving files as appropriateSubmits a Monthly Activity Report (MAR) to the IDEA-NW Project Director at the end of each month, and any additional reports required to track project activities as neededOther DutiesPerforms other duties as assigned by the EpiCenter Director and/or Executive Director or designee Standards of ConductAct in service to the Tribes and Tribal communities we serveUphold the Mission, Values, and Vision of the NPAIHBMaintain the highest level of confidentiality with all NPAIHB information and documentationConsistently exhibit professional behavior and a high degree of personal and professional integrity and impartiality appropriate to the responsible and confidential nature of the positionExercise good judgment and initiative in performance of duties and responsibilitiesDemonstrate high emotional intelligence in the performance of all duties and responsibilitiesOrientation toward learning, innovation, service, and the building of second-line leadershipCommitment to building an organizational culture which centers NPAIHB's service to Tribes, promotes professional excellence, and builds an environment where employees grow and thriveCommitment to build an inclusive workplace across a range of identities and experiences, including (but not limited to) geography, age, gender identity, gender expression, sexual orientation, ethnicity, class, language, disability, religion, spiritual practices, and immigration statusSees diversity as a strength, and equity as a baselineWork in a cooperative manner with all levels of management and with all NPAIHB staffEffectively plan, organize workload, and schedule time to meet workload demandsUse reasonable judgment to consistently display professional work attire during normal business hours, and/or dress appropriately for the workday, space, or event in lieu of a formal dress codeBe present, available, and responsive for meetings and calls during regular working hoursCommit to sharing knowledge and building expertise by participating in all virtual spaces in our workplace with cameras onShow consideration by communicating effectively and building collective understandingRecognize relationships are the cornerstone of NPAIHB's work by treating all NPAIHB delegates/ alternates, partners, staff, and American Indian/Alaska Native people with dignity and respectParticipate willingly in NPAIHB activities QualificationsEducation Minimum education required:Bachelor's degree in Computer Science, Information Technology, Data Science or related field Additional education preferred:Master's degree in Computer Science, Information Technology, Data Science or related fieldExperience Minimum experience required:At least five (5) years of experience in a data engineering roleDemonstrated experience building Structured Language Query (SQL) relational databasesDemonstrated experience transitioning non-relational data into structured relational format, while ensuring seamless integration and optimized performanceExperience gathering requirements, and designing and planning data models based on those requirementsExperience transforming and preparing data into formats suitable for data visualization software, and structured for optimal use in dashboards and other visual outputsExperience providing training and technical assistance to upskill teams in data engineering and data science methodsExperience with cloud computing platformsExperience working in a virtual environment with remote partners and teams Additional experience preferred:Direct experience working with Tribes or Tribal organizationsAt least two (2) years of experience in a lead data engineering roleExperience handling complex public health, health care, or other non-business data requiring advanced processing and analysis techniquesExperience implementing data suppression techniques and familiarity with Health Insurance Portability and Accountability Act (HIPAA), Protected Health Information (PHI), and other data confidentiality regulationsExperience transitioning Statistical Analysis System (SAS) datasets and analyses into relational database structuresExperience with dimensional modeling in scenarios where dimensions and fields change over timeExperience in an Amazon Web Services (AWS) cloud computing environment, including building data pipelines such as AWS Relational Database Services (RDS), Amazon Aurora Serverless, AWS Glue, and LambdaExperience creating complex fields and visuals in AWS QuickSight or similar data visualization tools (Tableau, Microsoft Power BI, etc.) Required Knowledge, Skills, and Abilities Minimum knowledge, skills, and abilities required:Demonstrated knowledge, discretion, tact, judgment, and overall ability in working effectively with federal, Tribal, and other professionals, and facilitating participation and partnership in the activities of the NWTEC and Data HubStrong understanding of database systems, including relational databases (such as MySQL or PostgreSQL) and NoSQL databases (such as MongoDB or Cassandra), with PostgreSQL preferredComprehensive knowledge of data warehousing concepts and toolsExpertise in data modeling, ETL (Extract, Transform, and Load) processes, and data integration techniquesFamiliarity with agile development methodologies, software design patterns, and best practicesProficiency in SQL programming and other languages commonly used in data engineering, such as Python, Java, and ScalaProficiency with computer applications (specifically Word, Excel, PowerPoint, and other Microsoft Office Suite programs)Strong analytical thinking and problem-solving skillsExcellent verbal and written communication skillsExcellent interpersonal and teamwork skillsMust be sensitive to cross-cultural differences, and able to work effectively within their contextAbility to work with minimal supervision, exercise initiative, and make independent decisions and recommendationsAbility to be flexible in adapting to evolving project requirements and prioritiesAbility to develop productive working relationships with colleagues and partnersAbility to effectively convey technical concepts to non-technical partnersAbility to make professional oral presentations in settings at the national, regional, and community levels, as well as in Tribal settingsAbility to complete tasks in a timely and accurate mannerAbility to travel occasionally (approximately 10% of the time) Additional knowledge, skills, and abilities preferred:Proficiency in the object-relational database system Postgre SQL Probationary Period External applicants must agree to serve a minimum six-month probationary period during which time their employment can be terminated at will. For the purpose of evaluating job performance, internal applicants must agree to serve a minimum six-month probationary period when job duties change significantly. Work ConditionsPhysical Demands This position:Frequently involves sedentary work (exerting up to 10 pounds of force and/or a negligible amount of force to lift, carry, push, pull or otherwise move objects, including the human body)Occasionally involves light work (exerting up to 20 pounds of force and/or up to 10 pounds of force and/or a negligible amount of force to move objects) Physical Requirements This position:Consistently requires the ability to receive detailed information through oral communication and expressing or exchanging ideas or important instructions accurately, loudly, or quicklyConstantly requires working with fingers, rather than the whole hand or armConstantly requires repetitive movement of the wrists, hands, and/or fingersOften requires walking or moving about to accomplish tasksOccasionally requires standing and/or sitting for sustained periods of timeOccasionally requires ascending or descending stairs or ramps using feet and legs and/or hands and armsOccasionally requires raising objects from a lower to a higher position, or moving objects horizontallyOccasionally requires stooping, which entails the use of the lower extremities and back musclesInfrequently requires crouching Typical Environmental Conditions The worker is frequently subject to inside environmental conditions, which provide protection from weather conditions, but not necessarily from temperature changes, and is occasionally subject to outside environmental conditions. Travel Requirements Local and/or overnight travel outside of the area is infrequently required. Attendance at quarterly NPAIHB Board Meetings is occasionally required. These meetings are held both locally and hosted by our member tribes on a rotating basis, typically taking place during the third or fourth weeks of January, April, July, and October, and typically require a minimum stay of two overnights per meeting. Disclaimer The individual must p