State of Missouri
Jefferson City, Missouri, United States
Job Location: The office for this position is located at the Department of Mental Health, 1706 East Elm Street, Jefferson City, MO. 65101.. Why you'll love this position: Are you looking for a position that will allow you to work with a team of dedicated IT professionals? Are you interested in being a key player in a partnership between ITSD and DMH? If so, this position with the Office of Administration, Information Technology Services Division, supporting the Department of Mental Health (DMH) might be for you! ITSD-DMH has an opening for a Data Specialist. In this position, you will have the opportunity to develop complex SSIS packages and SQL agent jobs that make data available to users of our data warehouse and applications and assist users with their own data queries as a member of an agile, well-organized team. You will have the ability to learn new tools for data integration and grow your skill set in a positive environment. You will have the chance to deliver a meaningful impact supporting DMH and the citizens of Missouri. This position is with the Office of Administration, Information Technology Services Division (OA-ITSD) supporting the Department of Mental Health (DMH). ITSD Core Values - We Innovate and Partner with Passion, Respect, and Integrity United as #OneTeam. Develop and maintain ETL processes using Microsoft SSIS and SQL agent jobs. Develop and support complex stored procedures and custom functions. Develop and support cloud interfaces and APIs for use with databases, data warehouses or application infrastructure. Analyze, solve, and correct production issues and provide documentation. Communicate with business users to establish database and SSIS package requirements. Effectively prioritize and execute tasks in a high-pressure environment using Agile methodology. Analyze, design, develop, peer review, test, and implement code for projects. Create, adhere to, and enforce technical standards. The ideal candidate will have the following technical and soft skills: SQL Server 2016/2019 preferred. Development of SSIS packages, SQL agent jobs, and complex stored procedures. Familiarity with Azure and/or AWS cloud platform. Familiarity with MuleSoft or other API development platforms. SQL Server query performance tuning. Design of databases, including relationships, indexes, views, tables, and fields. Familiar with Azure DevOps and Agile development concepts. Strong data investigation and problem-solving skills. Knowledge of data warehousing, data architecture, and design concepts with practical experience in the implementation of these concepts. Be self-motivated and have the desire to continually develop new skills and improve existing skills. Strong written and verbal communication skills and organization skills. Successful background check results are required for employment in this position. This may include background checks involving a candidate's name and/or fingerprints and other screenings as needed for the specific position. Lack of post-secondary education will not be used as the sole basis denying consideration to any applicant. Knowledge of data architecture, quality, mapping, and structures. Skill in providing direction in a clear and concise matter. The classification for this position is Data Specialist : click for more information. The State of Missouri offers an excellent benefits package that includes a defined pension plan, generous amounts of leave and holiday time, and eligibility for health insurance coverage. Your total compensation is more than the dollars you receive in your paycheck. To help demonstrate the value of working for the State of Missouri, we have created an interactive Total Compensation Calculator. This tool provides a comprehensive view of benefits and more that are offered to prospective employees. The Total Compensation Calculator and other applicant resources can be found here . If you have questions please contact: ITSDRecruiting@oa.mo.gov
Job Location: The office for this position is located at the Department of Mental Health, 1706 East Elm Street, Jefferson City, MO. 65101.. Why you'll love this position: Are you looking for a position that will allow you to work with a team of dedicated IT professionals? Are you interested in being a key player in a partnership between ITSD and DMH? If so, this position with the Office of Administration, Information Technology Services Division, supporting the Department of Mental Health (DMH) might be for you! ITSD-DMH has an opening for a Data Specialist. In this position, you will have the opportunity to develop complex SSIS packages and SQL agent jobs that make data available to users of our data warehouse and applications and assist users with their own data queries as a member of an agile, well-organized team. You will have the ability to learn new tools for data integration and grow your skill set in a positive environment. You will have the chance to deliver a meaningful impact supporting DMH and the citizens of Missouri. This position is with the Office of Administration, Information Technology Services Division (OA-ITSD) supporting the Department of Mental Health (DMH). ITSD Core Values - We Innovate and Partner with Passion, Respect, and Integrity United as #OneTeam. Develop and maintain ETL processes using Microsoft SSIS and SQL agent jobs. Develop and support complex stored procedures and custom functions. Develop and support cloud interfaces and APIs for use with databases, data warehouses or application infrastructure. Analyze, solve, and correct production issues and provide documentation. Communicate with business users to establish database and SSIS package requirements. Effectively prioritize and execute tasks in a high-pressure environment using Agile methodology. Analyze, design, develop, peer review, test, and implement code for projects. Create, adhere to, and enforce technical standards. The ideal candidate will have the following technical and soft skills: SQL Server 2016/2019 preferred. Development of SSIS packages, SQL agent jobs, and complex stored procedures. Familiarity with Azure and/or AWS cloud platform. Familiarity with MuleSoft or other API development platforms. SQL Server query performance tuning. Design of databases, including relationships, indexes, views, tables, and fields. Familiar with Azure DevOps and Agile development concepts. Strong data investigation and problem-solving skills. Knowledge of data warehousing, data architecture, and design concepts with practical experience in the implementation of these concepts. Be self-motivated and have the desire to continually develop new skills and improve existing skills. Strong written and verbal communication skills and organization skills. Successful background check results are required for employment in this position. This may include background checks involving a candidate's name and/or fingerprints and other screenings as needed for the specific position. Lack of post-secondary education will not be used as the sole basis denying consideration to any applicant. Knowledge of data architecture, quality, mapping, and structures. Skill in providing direction in a clear and concise matter. The classification for this position is Data Specialist : click for more information. The State of Missouri offers an excellent benefits package that includes a defined pension plan, generous amounts of leave and holiday time, and eligibility for health insurance coverage. Your total compensation is more than the dollars you receive in your paycheck. To help demonstrate the value of working for the State of Missouri, we have created an interactive Total Compensation Calculator. This tool provides a comprehensive view of benefits and more that are offered to prospective employees. The Total Compensation Calculator and other applicant resources can be found here . If you have questions please contact: ITSDRecruiting@oa.mo.gov
City of Portland, Oregon
Portland, Oregon, United States
The Position Job Appointment: Regular Fulltime Work Schedule: Flexible Schedule; Eight/Nine/Ten - Hour Shifts Monday - Friday Work Location: Multiple Locations: 2929 North Kerby Avenue, Portland, OR 97227 and 3150 North Mississippi Avenue, Portland OR 97227 Benefit: Please check our benefits tab for an overview of benefits for this position Union Representation: This classification is represented by Portland City Laborers 483 (PCL). To view this labor agreement, please go to http://www.portlandoregon.gov/bhr/27840 and click on the appropriate link. If you are a PCL-represented employee, see labor agreement for additional information or talk to your union representative. Application Material: Please click APPLY to submit your application via the City of Portland’s online portal. You will need to complete a work history form and submit responses to Supplemental Questions. The City of Portland is seeking a Materials Specialist II (Storekeeper/Acquisition Specialist II-CL) to join the Portland Bureau of Transportation! About the position: The Materials Specialist II (Storekeeper/Acquisition Specialist II - CL) is a member of a team responsible for performing work tasks in support of managing materials, such as purchasing, receiving, storing, and disbursing goods and services including stock and non-stock items working in outside yard areas and/or indoor storage facilities, as well as maintaining control of bureau assets in accordance with acceptable inventory control principles and practices. May work at an independent or autonomous location or unsupervised work site. What you’ll get to do: Contribute in the City’s accomplishment of work assignments and strategic goals by providing excellent levels of service while satisfying the material needs of customers Advise ( and ensure adherence to appropriate purchasing procedures/regulations to) other bureau staff. Requisition and or purchase supplies, equipment, and services up to delegated limit. Receive, stock, issue, disburse, ship, and dispose of materials, coordinates efforts with other staff, various end users, and vendors; assures compliance of received materials with applicable technical specifications and communicates any special handling and storage requirements. Reconcile procurement card statements; prepare invoices for payment and may maintain petty cash Create and maintain computer records and perform other tasks as assigned while maintaining a safe, orderly, clean distribution environment Serve as the primary resource on technical issues related to the function, responds to calls to work during emergencies and will be trained and appointed as a team member of City of Portland/Bureau Emergency Management Structure for Logistics. Operate forklifts, pallet jacks, hand trucks, overhead cranes and other material handling equipment, including use of large articulated front-end loaders. Who you are: Organized: Able to work on a multitude of tasks and maintain flexibility and understanding when reacting to various situations in a fast-paced work environment. Excellent Communicator: A effective communicator to diverse groups of technical and non-technical individuals, and who is proficient verbally, electronically, and in writing while utilizing confidentiality when needed Problem Solver: You can identify problems early & utilize active listening & effective communication to find resolutions. Results Driven: This position is high pace, dynamic, and requires a candidate who can hit the ground running with a focus on finish tasks in a timely, accurate and professional manner. Ethically minded: Public employees have an absolute obligation to put the public's interest before their own direct or indirect personal interests. This position has a direct relationship to maintain the public’s trust and confidence while investing the City’s funds. Equity Focused: So much of what we do within the City involves pausing and looking at each project through an equity lens. In this case, fiscal responsibility is extremely important. You have the ability and are passionate about ensuring fiscal responsibility in your role as a purchasing agent. Although the current vacancy is with the Bureau of Transportation, this recruitment may be used to fill future vacancies in other bureaus throughout the City. Current Vacancy Information: Position Summary: Portland Bureau of Transportation (PBOT) Maintenance Operations: This position will provide goods and services through our Materials Distribution Centers located at our Albina Yard facility on North Mississippi Avenue and the Kerby MDC on N. Kerby Avenue. Each position will flex/rotate between both locations with other staff. This position also will provide training for the incumbent to receive their forklift certification as well as their Construction Equipment Operator Certification. To keep Portland moving, our MDC's supply all the materials to maintain the transportation infrastructure and we equip and support its craftspeople. This will involve using multiple sizes and types of material handling equipment including large articulated front loaders in a heavy industrial environment in all weather conditions. This includes using City fleet to pick up and transport materials to warehouse/yard locations or crew worksites in the field. Maintenance Operations Group is considered essential during emergency conditions and all employees are called on to support and respond to the City's transportation and logistics needs as first-line responders. This position is also considered essential, and will require reporting to work during inclement weather emergencies. About the bureaus: The Portland Bureau of Transportation is a community partner in shaping a livable city. We plan, build, manage, and maintain an effective and safe transportation system that provides people and businesses access and mobility. We keep Portland moving. For more information about the Portland Bureau of Transportation, please visit Transportation | Portland.gov . The Portland Bureau of Transportation embraces diversity, models inclusivity, and promotes equity through its service delivery, internal operations, organizational culture, and in its work with partners and the community. The Bureau of Environmental Services (BES) is re-imagining the work we do to ensure it aligns with Our Values: We implement equity in our workplace, business practices, and service delivery. We value our customers and partners. We carefully manage our watersheds, wastewater and stormwater infrastructure, and financial resources. We encourage leadership among our employees in our City and community. We support a diverse, collaborative, healthy, and engaged workforce. We urge respectful communication and transparency. We advance innovative, sustainable, and resilient solutions. BES is now hiring talented individuals from diverse backgrounds seeking opportunities to collaborate, innovate and invest in their futures. To learn more about the work we do at BES, click on the link: www.portlandoregon.gov/bes/ Our BES 10-Year Strategic Plan can be found here: https://www.portlandoregon.gov/bes/75720 Questions? Anna Morgan, Senior Recruiter Anna.Morgan@portlandoregon.gov To Qualify Applicants should specifically address and demonstrate in their resume and answers to supplemental questions how their education, training, and/or experience meet each of the following minimum qualifications: Experience with sound inventory and materials management principles with the ability to apply those principles, effectively and efficiently, to maintain multiple material distribution center sites under various and sometimes challenging conditions. Experience evaluating, selecting, and purchasing goods/services/materials and following applicable laws/regulations/codes as they relate to purchasing. Experience communicating effectively and providing excellent customer service to a variety of diverse customers. Ability to read & apply technical specifications related to a product and effectively explain the range and application of goods and services to diverse customers. Experience using standard computer software and computer-assisted business software such as automated inventory control and asset management database control software like SAP, Oracle (Synergen), MAXIMO, MicroMain, Bartender, and/or other similar software programs. Ability to work independently with minimum supervision and utilize problem solving skills to create solutions and process improvements. Must also possess: A valid state driver's license and acceptable driving record at the time of hire Forklift certification - within 3 months of hire for assigned equipment (training provided) The Recruitment Process STEP 1: Apply online between April 15 , 2024 - May 6, 2024 Required Application Materials: Resume Answer the Supplemental Questions (click on the Questions tab to preview the questions) Optional Application Materials: Veteran documents to request for Veteran Preference (ex, DD214-Member 4, VA Benefit Letter, etc.) Application Tips: The City of Portland has How to Apply Videos and offers How to Apply Classes once per month. If you have questions after watching the videos you are invited to contact the recruiter listed on the announcement. Your responses to the supplemental questions should include details describing your education, training, and/or experience, and where obtained, which clearly reflects your qualifications for each of the numbered items in the "To Qualify" section of this announcement. Your resume should support the details described in your responses to the supplemental questions. Salary Range/Equity Pay Analysis : Please note per the Oregon State Pay Equity Law your salary is determined based on the experience and education listed in your resume/application. It is strongly encouraged to include any transferable experience (paid or unpaid regardless of how recent) to ensure your offer is reflective of all directly related and equivalent experience. Do not attach materials not requested. All completed applications for this position must be submitted no later than the closing date and time of this recruitment. All applications must be submitted via the City's online application process. E-mailed and/or faxed applications will not be accepted. Step 2: Minimum Qualification Evaluation: Week of May 6 , 2024 An evaluation of each applicant's training and paid and unpaid experience, as demonstrated in their resume and supplemental questions, weighted 100%. Your resume and responses to the supplemental questions will be the basis for our evaluation of your qualifications for this position. Incomplete or inappropriate information may result in disqualification. You have 14 days from the notice of the minimum qualification evaluation results to let us know if you like to review and discuss your evaluation result. Please read the City of Portland Administrative Rule 3.01 for complete information. Additional evaluation may be required before the establishment of the eligible list and/or final selection. Step 3: Establishment of Eligible List: Week of May 13, 2024 Candidates who meet the minimum qualifications will be placed on the equally ranked eligible list. Step 4: Selection (Interview): Late May 2024 The hiring bureau will review and select candidates to interview. Please note, the selection process may take up to 90 days from the notification of being placed on the eligible list. Step 5: Offer of Employment: June 2024 Step 6: Start Date: June 2024 A start date will be determined after all conditions of employment have been met. *Timeline is approximate and subject to change* Additional Information Click here for additional information regarding the following: Veteran Preference ADA, Pregnancy, and Religious Accommodations Work Status Equal Employment Opportunity An Equal Opportunity / Affirmative Action Employer A Career with the City of Portland offers many Employee Benefits We offer a comprehensive benefits package, including but not limited to Health Care (Medical, Vision and Dental) Carrot Fertility Wellness Benefits Life Insurance Short- and Long-term disability coverage to eligible employees and their families. Employee Assistance Plan Flexible Spending Accounts Retirement Oregon Public Employees Retirement System (PERS), including contributions to the PERS IAP plan paid by employer Family Medical Leave City Paid Parental Leave AND SO MANY MORE! Benefits may vary depending on bargaining unit and employment status. Click here to review the many different benefits the City of Portland offers . Closing Date/Time: 5/6/2024 11:59 PM Pacific
The Position Job Appointment: Regular Fulltime Work Schedule: Flexible Schedule; Eight/Nine/Ten - Hour Shifts Monday - Friday Work Location: Multiple Locations: 2929 North Kerby Avenue, Portland, OR 97227 and 3150 North Mississippi Avenue, Portland OR 97227 Benefit: Please check our benefits tab for an overview of benefits for this position Union Representation: This classification is represented by Portland City Laborers 483 (PCL). To view this labor agreement, please go to http://www.portlandoregon.gov/bhr/27840 and click on the appropriate link. If you are a PCL-represented employee, see labor agreement for additional information or talk to your union representative. Application Material: Please click APPLY to submit your application via the City of Portland’s online portal. You will need to complete a work history form and submit responses to Supplemental Questions. The City of Portland is seeking a Materials Specialist II (Storekeeper/Acquisition Specialist II-CL) to join the Portland Bureau of Transportation! About the position: The Materials Specialist II (Storekeeper/Acquisition Specialist II - CL) is a member of a team responsible for performing work tasks in support of managing materials, such as purchasing, receiving, storing, and disbursing goods and services including stock and non-stock items working in outside yard areas and/or indoor storage facilities, as well as maintaining control of bureau assets in accordance with acceptable inventory control principles and practices. May work at an independent or autonomous location or unsupervised work site. What you’ll get to do: Contribute in the City’s accomplishment of work assignments and strategic goals by providing excellent levels of service while satisfying the material needs of customers Advise ( and ensure adherence to appropriate purchasing procedures/regulations to) other bureau staff. Requisition and or purchase supplies, equipment, and services up to delegated limit. Receive, stock, issue, disburse, ship, and dispose of materials, coordinates efforts with other staff, various end users, and vendors; assures compliance of received materials with applicable technical specifications and communicates any special handling and storage requirements. Reconcile procurement card statements; prepare invoices for payment and may maintain petty cash Create and maintain computer records and perform other tasks as assigned while maintaining a safe, orderly, clean distribution environment Serve as the primary resource on technical issues related to the function, responds to calls to work during emergencies and will be trained and appointed as a team member of City of Portland/Bureau Emergency Management Structure for Logistics. Operate forklifts, pallet jacks, hand trucks, overhead cranes and other material handling equipment, including use of large articulated front-end loaders. Who you are: Organized: Able to work on a multitude of tasks and maintain flexibility and understanding when reacting to various situations in a fast-paced work environment. Excellent Communicator: A effective communicator to diverse groups of technical and non-technical individuals, and who is proficient verbally, electronically, and in writing while utilizing confidentiality when needed Problem Solver: You can identify problems early & utilize active listening & effective communication to find resolutions. Results Driven: This position is high pace, dynamic, and requires a candidate who can hit the ground running with a focus on finish tasks in a timely, accurate and professional manner. Ethically minded: Public employees have an absolute obligation to put the public's interest before their own direct or indirect personal interests. This position has a direct relationship to maintain the public’s trust and confidence while investing the City’s funds. Equity Focused: So much of what we do within the City involves pausing and looking at each project through an equity lens. In this case, fiscal responsibility is extremely important. You have the ability and are passionate about ensuring fiscal responsibility in your role as a purchasing agent. Although the current vacancy is with the Bureau of Transportation, this recruitment may be used to fill future vacancies in other bureaus throughout the City. Current Vacancy Information: Position Summary: Portland Bureau of Transportation (PBOT) Maintenance Operations: This position will provide goods and services through our Materials Distribution Centers located at our Albina Yard facility on North Mississippi Avenue and the Kerby MDC on N. Kerby Avenue. Each position will flex/rotate between both locations with other staff. This position also will provide training for the incumbent to receive their forklift certification as well as their Construction Equipment Operator Certification. To keep Portland moving, our MDC's supply all the materials to maintain the transportation infrastructure and we equip and support its craftspeople. This will involve using multiple sizes and types of material handling equipment including large articulated front loaders in a heavy industrial environment in all weather conditions. This includes using City fleet to pick up and transport materials to warehouse/yard locations or crew worksites in the field. Maintenance Operations Group is considered essential during emergency conditions and all employees are called on to support and respond to the City's transportation and logistics needs as first-line responders. This position is also considered essential, and will require reporting to work during inclement weather emergencies. About the bureaus: The Portland Bureau of Transportation is a community partner in shaping a livable city. We plan, build, manage, and maintain an effective and safe transportation system that provides people and businesses access and mobility. We keep Portland moving. For more information about the Portland Bureau of Transportation, please visit Transportation | Portland.gov . The Portland Bureau of Transportation embraces diversity, models inclusivity, and promotes equity through its service delivery, internal operations, organizational culture, and in its work with partners and the community. The Bureau of Environmental Services (BES) is re-imagining the work we do to ensure it aligns with Our Values: We implement equity in our workplace, business practices, and service delivery. We value our customers and partners. We carefully manage our watersheds, wastewater and stormwater infrastructure, and financial resources. We encourage leadership among our employees in our City and community. We support a diverse, collaborative, healthy, and engaged workforce. We urge respectful communication and transparency. We advance innovative, sustainable, and resilient solutions. BES is now hiring talented individuals from diverse backgrounds seeking opportunities to collaborate, innovate and invest in their futures. To learn more about the work we do at BES, click on the link: www.portlandoregon.gov/bes/ Our BES 10-Year Strategic Plan can be found here: https://www.portlandoregon.gov/bes/75720 Questions? Anna Morgan, Senior Recruiter Anna.Morgan@portlandoregon.gov To Qualify Applicants should specifically address and demonstrate in their resume and answers to supplemental questions how their education, training, and/or experience meet each of the following minimum qualifications: Experience with sound inventory and materials management principles with the ability to apply those principles, effectively and efficiently, to maintain multiple material distribution center sites under various and sometimes challenging conditions. Experience evaluating, selecting, and purchasing goods/services/materials and following applicable laws/regulations/codes as they relate to purchasing. Experience communicating effectively and providing excellent customer service to a variety of diverse customers. Ability to read & apply technical specifications related to a product and effectively explain the range and application of goods and services to diverse customers. Experience using standard computer software and computer-assisted business software such as automated inventory control and asset management database control software like SAP, Oracle (Synergen), MAXIMO, MicroMain, Bartender, and/or other similar software programs. Ability to work independently with minimum supervision and utilize problem solving skills to create solutions and process improvements. Must also possess: A valid state driver's license and acceptable driving record at the time of hire Forklift certification - within 3 months of hire for assigned equipment (training provided) The Recruitment Process STEP 1: Apply online between April 15 , 2024 - May 6, 2024 Required Application Materials: Resume Answer the Supplemental Questions (click on the Questions tab to preview the questions) Optional Application Materials: Veteran documents to request for Veteran Preference (ex, DD214-Member 4, VA Benefit Letter, etc.) Application Tips: The City of Portland has How to Apply Videos and offers How to Apply Classes once per month. If you have questions after watching the videos you are invited to contact the recruiter listed on the announcement. Your responses to the supplemental questions should include details describing your education, training, and/or experience, and where obtained, which clearly reflects your qualifications for each of the numbered items in the "To Qualify" section of this announcement. Your resume should support the details described in your responses to the supplemental questions. Salary Range/Equity Pay Analysis : Please note per the Oregon State Pay Equity Law your salary is determined based on the experience and education listed in your resume/application. It is strongly encouraged to include any transferable experience (paid or unpaid regardless of how recent) to ensure your offer is reflective of all directly related and equivalent experience. Do not attach materials not requested. All completed applications for this position must be submitted no later than the closing date and time of this recruitment. All applications must be submitted via the City's online application process. E-mailed and/or faxed applications will not be accepted. Step 2: Minimum Qualification Evaluation: Week of May 6 , 2024 An evaluation of each applicant's training and paid and unpaid experience, as demonstrated in their resume and supplemental questions, weighted 100%. Your resume and responses to the supplemental questions will be the basis for our evaluation of your qualifications for this position. Incomplete or inappropriate information may result in disqualification. You have 14 days from the notice of the minimum qualification evaluation results to let us know if you like to review and discuss your evaluation result. Please read the City of Portland Administrative Rule 3.01 for complete information. Additional evaluation may be required before the establishment of the eligible list and/or final selection. Step 3: Establishment of Eligible List: Week of May 13, 2024 Candidates who meet the minimum qualifications will be placed on the equally ranked eligible list. Step 4: Selection (Interview): Late May 2024 The hiring bureau will review and select candidates to interview. Please note, the selection process may take up to 90 days from the notification of being placed on the eligible list. Step 5: Offer of Employment: June 2024 Step 6: Start Date: June 2024 A start date will be determined after all conditions of employment have been met. *Timeline is approximate and subject to change* Additional Information Click here for additional information regarding the following: Veteran Preference ADA, Pregnancy, and Religious Accommodations Work Status Equal Employment Opportunity An Equal Opportunity / Affirmative Action Employer A Career with the City of Portland offers many Employee Benefits We offer a comprehensive benefits package, including but not limited to Health Care (Medical, Vision and Dental) Carrot Fertility Wellness Benefits Life Insurance Short- and Long-term disability coverage to eligible employees and their families. Employee Assistance Plan Flexible Spending Accounts Retirement Oregon Public Employees Retirement System (PERS), including contributions to the PERS IAP plan paid by employer Family Medical Leave City Paid Parental Leave AND SO MANY MORE! Benefits may vary depending on bargaining unit and employment status. Click here to review the many different benefits the City of Portland offers . Closing Date/Time: 5/6/2024 11:59 PM Pacific