Database Engineer (Information Systems Specialist 6)

Initial Posting Date: 09/03/2024 Application Deadline: 09/17/2024 Agency: Department of Human Services Salary Range: $5,660 - $8,572 Position Type: Employee Position Title: Database Engineer (Information Systems Specialist 6) Job Description: The Oregon Department of Human Services is proud to be an Equal Opportunity Employer. We are guided by our Equity North Star and our vision for a positive... RiSE organizational culture that advances equity and diversity. We encourage applications from members of historically underrepresented racial/ethnic groups, women, individuals with disabilities, veterans, LGBTQIA2S+ community members, and others to help us achieve our vision of a diverse and inclusive community. Opportunity awaits! Imagine being a guiding light for those in need. You have an opportunity to embrace diversity, equity, inclusion, and respect as you build trust during difficult moments. Make a difference in people's lives while nurturing your career from the comfort of remote work. Summary of Duties As a Database Engineer you will: Work with professionals from various programs to identify data needs and design and develop optimized database/tabular/semantic models that are both high-performing and user-friendly. Restructure and prepare data from the ORRAI Data Warehouse for statistical analysis, data discovery, and algorithm development, ensuring accuracy and consistency. Retrieve and integrate data from state agencies and external partners to support comprehensive reporting and analysis. Partner with business stakeholders to gather and understand their requirements, translating them into actionable insights and features for dashboards and reports. Develop and maintain data structures that meet the diverse analytical needs of various projects, ensuring scalability and reliability. Identify, develop, and implement methods to extract, transform, and load (ETL) data in preparation for the data warehouse. This includes normalizing and de-normalizing data from a wide range of sources and databases. Play a key role in the ongoing migration from our in-house SQL Database Warehouse to a modern Snowflake/Azure environment, optimizing our data infrastructure for enhanced scalability, security, and performance. Ensure all work aligns with ORRAI Data Warehouse standards, including comprehensive documentation, clear and consistent communication, and a collaborative approach that avoids siloed work. Minimum Qualifications Five (5) years of information systems experience OR An Associate's degree in Computer Science, Information Technology, or related field, OR completion of a two (2) year accredited vocational training program in information technology or related field; AND three (3) years of information systems experience OR A Bachelor's degree in Information Technology, Computer Science, or related field AND one (1) year of information systems experience Essential Attributes We are looking for candidates with: Strong knowledge of relational database management systems (RDBMS), including design, implementation, and optimization. Proven experience in working effectively within teams, demonstrating strong collaboration skills to achieve shared goals. Demonstrated ability to provide outstanding customer service, addressing the needs of managers and partner agencies with professionalism and efficiency. Experience working in cloud environments, particularly with cloud-based data warehouse platforms (Snowflake, Azure, AWS), leveraging these tools to enhance data management and reporting capabilities. A strong dedication to promoting and supporting DEIA principles in all aspects of work, fostering an inclusive and equitable environment. Attention all candidates! A cover letter is required. Clearly describe how you meet the minimum qualifications and essential attributes in your application materials. Your application materials will determine if you are selected to move forward in the selection process. Please include detailed work and education history. Working Conditions This position typically follows a standard work week but may occasionally require irregular hours during periods of project implementations and during Legislative session. Infrequent travel throughout the state may be required to attend meetings, trainings, or collaborate with team members and partners. This position is fully remote, offering the flexibility to work from any location with reliable internet access. However, working hours must align with the Pacific Time Zone to ensure collaboration with the team and stakeholders. Background Checks and Requirements If selected as a finalist, we will conduct a criminal history and background check. Adverse criminal history or background check may lead to disqualification. Additional background check information. The Oregon Department of Human Services does not offer visa sponsorship. Within three days of hire, you will be required to complete the US Department of Homeland Security?s I-9 form confirming authorization to work in the United States. ODHS will use E-Verify to confirm that you are authorized to work in the United States. Benefits ODHS Employee Resource Group communities that promote shared learning. Cost of Living Adjustments. Annual salary increases (until you reach the top of the listed salary range). Amazing benefits package. Possible eligibility for the Public Service Loan Forgiveness Program. Employment Preference Veterans? preference: Veterans? preference information. How to submit your Veteran documents for preference. Please do not attach your Veterans? preference documentation in the Resume/CV field of your application. General Information This is a permanent, full-time position and is represented by the Service Employees International Union (SEIU). This recruitment may be used to fill future vacancies in the same classification. Contact Information We invite you to contact the recruiter for accommodation requests under the Americans with Disabilities Act (ADA), application questions or job-specific questions. The recruiter for this position is Bonnie Nyssen. If you contact the recruiter, please include the job requisition number. Email: bonnie.nyssen@odhs.oregon.gov Oregon state government is a large organization by nearly any standard. With over 40,000 employees working all over the state, in small communities and large, we are proving that government can be innovative. We work as a team, challenging ourselves to be better, faster and more efficient with taxpayer dollars. After all, when every day we are responsible for caring for the needs of a diverse population and thriving business community, we simply must have the best and brightest workforce. If you take responsibility for your actions, are passionate about helping others succeed, and have a reputation for excellence and honesty, why not make Oregon state government your next career move? Joining our team means you open the door to many possibilities. From entry level to executive, outdoor work to policy setting, we have a role for nearly every calling, expertise and background. If you?re looking at us from across the country (or beyond!), know that Oregon is one of the most beautiful places on earth. Made up of seven diverse regions, Oregon has the ocean, mountains, valleys, high desert, cities, small towns, and almost everything in between. Oregon ?flies with her own wings.?

Apply Job!