View job on Handshake

Employer: Idaho Department of Lands

Expires: 09/03/2021

The Idaho Department of Lands is looking for an IT Database Analyst III working from our Director’s office in Boise, Coeur d’Alene and possibly other locations in Idaho.  Other locations in Idaho may be considered but would require up to 25% travel.EXAMPLE OF DUTIES:Develop and support ETL routines for enterprise systems in a SQL Server environmentDesign, develop, and maintain reportsResolve routine to complex database programming problems and determine appropriate solutionsAnalyze and resolve database performance issuesDesign, develop, and monitor Business Intelligence solutionsReview contractor technical designs for database systems (ERDs, SSIS packages, SQL scripts)Researches opportunities to improve technology and architectureIdentify best practicesMINIMUM QUALIFICATIONS:Minimum Qualifications Notice:You must possess all the minimum qualifications listed below to pass the exam for this position. Click on the Questions tab associated with this announcement for the details regarding minimum qualification requirements. The Supplemental Questions on the application are the exam questions. If it is a written answer, please make sure you answer each question with enough detail to determine how you meet the requirements. Do not put “See resume” as your answer to written questions. Answer each written question thoroughly. Failure to do this may result in not passing the exam and disqualify you from being considered for this position. Good knowledge of: Relational database principles and data normalizationStructured Query Language (SQL)Experience: Installing, administering, and monitoring production databases and database serversInteracting directly with clients to analyze customer needs SUPPLEMENTAL INFORMATION:Equal Employment Opportunity:Hiring is done without regard to race, color, religion, national origin, sex, age or disability. If you need special accommodations to satisfy testing requirements, please contact the Division of Human Resources at (208) 334-2263. Veterans’ Preference:Preference may be given to veterans who qualify under state and federal laws and regulations. Supplemental Questions Instructions: Per IDAPA 15.04.01, only the top 25 applicants will be provided to the hiring manager. The top 25 will be determined by the answers applicants provide in the supplemental questions. A subject matter expert (SME) will review each answer and determine if the applicant meets the qualifications described in each question.  Work experience must include: positions held, dates of employment, and responsibilities/duties performed. Education and/or training must include: field of course work, degree title, and additional applicable coursework. Please contact the IDL careers at careers@idl.idaho.gov for questions regarding the application process. Overtime/Vacation Accrual/FLSA:The Fair Labor Standards Act (FLSA) code for this position is Administrative (A) Based on the FLSA code for this position, compensatory time will accrue at a rate of 1 hour for every 1 hour of overtime worked. Vacation accrual is based on the FLSA code and accrual rates can be found at: https://dhr.idaho.gov/PDFs/Section2Vacation.pdf (Exception: Employees engaged in Fire Suppression activities for which overtime hours are earned will be paid at the rate of 1.5 times the hourly rate for each one hour of overtime worked. Payment will be made on the regular pay date corresponding to the pay period in which the overtime work occurred.)  About IDL:Become part of an organization where you will work with dedicated people who are committed and skilled in managing and protecting Idaho’s natural resources. The Idaho Department of Lands (IDL) believes in its employees and values stewardship, service, accountability and cohesiveness. Our goals emphasize our people and processes, financial stewardship, and customer focus. We strive for a culture in which leadership equips, entrusts and expects employees to make decisions in fulfillment of our mission. View our Strategic Plan here. Under the direction of the Idaho State Board of Land Commissioners, IDL manages more than 2.4 million acres of state endowment trust land under a constitutional mandate to produce maximum long-term financial returns for public schools and several other State of Idaho institutions. Leases and other contracts are used to authorize revenue generating activities such as timber harvest, grazing, farming, mining, commercial use, residential use, and conservation in a prudent and sustainable manner. Managing endowment trust lands is only part of our story. We also protect public resources such as water quality, fish, wildlife habitat, and recreation on public trust lands, and ensure the protection of water quality and other resources by overseeing forestry and mining practices across all ownerships in the state. We also work to reclaim abandoned mines in Idaho. One of our most important resource protection responsibilities is fire prevention and suppression. We also provide assistance to landowners to manage their forest lands, work with communities to plant trees in urban settings, help keep working forests working through the Forest Legacy Program, and work with many partners to promote healthy forests on a landscape level. IDL also is the administrative arm of the Idaho Oil and Gas Conservation Commission.  Trouble Applying Call:   Applicant Support Toll-free number: 1-855-524-5627 Monday through Friday 6:00 a.m. – 5:00 p.m. Pacific Time