State of Missouri
Jefferson City, Missouri, United States
SALARY: $46,423.00 Annual Salary DESCRIPTION: A vacancy currently exists within the Division of Alcohol and Tobacco Control. The position works from the Jefferson City District Office and will be assigned a designated territory within the boundaries of District 2 (see https://atc.dps.mo.gov/about/contact_us.html). Agents of the Division are responsible for enforcing all Missouri statutes and regulations relating to the manufacture, distribution and sale of alcoholic beverages as set out in Chapter 311, RSMo. BENEFITS: Agents are provided a state vehicle for work-related travel, and scheduling allows for some flexibility when not assigned to the district office. The State of Missouri also offers a comprehensive benefits package, which can be reviewed here, https://oa.mo.gov/state-employees-new#mini-panel-state-employees-tabs2. Annual grant programs also provide Agents an opportunity to earn overtime pay. EXAMPLES OF WORK PERFORMED: Business hours for the district office are 8:00 a.m. to 4:30 p.m., Monday through Friday; however, an Agent's hours will routinely vary, and will generally consist of approximately 40% office work and 60% field work, with fluctuations based on seasonal demand and staffing. Each district is responsible for conducting weekly enforcement activities which may consist of late nights, extended hours, weekend work, and possible overnight stays. Office/administrative duties include, but are not limited to: serving as the primary point of contact for liquor license applicants, licensees, city/county clerks and local law enforcement agencies within a designated territory, and to review liquor license applications for completeness and eligibility. Field work includes, but is not limited to: conducting retailer education training programs, completing routine inspections and site visits, investigating citizen complaints/surveillance, conducting joint enforcement activities with local law enforcement agencies, and conducting self-initiated and supervisor-directed enforcement activities primarily consisting of plainclothes operations. QUALIFICATIONS: To qualify for the position, the applicant must: Be a United States citizen and taxpaying resident of Missouri at time of hire; Possess a valid Missouri driver license; Be proficient in the English language; Possess a high school diploma or an equivalent certificate; Possess a Class A Missouri POST license at the time of appointment; Possess ordinary physical strength; Have a minimum of two (2) years law enforcement experience; College coursework in criminal justice or a closely related field or military police service may be substituted on a year-for-year basis. Reside within 60 miles of the office or relocate within six months; and, Be able to pass a job-related assessment exam, oral interview, criminal record check and background investigation, drug screening, polygraph, and psychological evaluation. ASSESSMENT TESTING AND INTERVIEWS: Computerized assessment tests will be conducted at the Jefferson City district office. Candidates meeting the minimum qualifications will be contacted for scheduling purposes. Interviews will be scheduled at a later determined date. EQUAL OPPORTUNITY STATEMENT: The Division of Alcohol and Tobacco Control is an equal opportunity employer. All qualified applicants will be considered for employment without regard to race, color, religion, sex, national origin, age, disability status, or any other non-merit factor.
Apr 20, 2024
Full Time
SALARY: $46,423.00 Annual Salary DESCRIPTION: A vacancy currently exists within the Division of Alcohol and Tobacco Control. The position works from the Jefferson City District Office and will be assigned a designated territory within the boundaries of District 2 (see https://atc.dps.mo.gov/about/contact_us.html). Agents of the Division are responsible for enforcing all Missouri statutes and regulations relating to the manufacture, distribution and sale of alcoholic beverages as set out in Chapter 311, RSMo. BENEFITS: Agents are provided a state vehicle for work-related travel, and scheduling allows for some flexibility when not assigned to the district office. The State of Missouri also offers a comprehensive benefits package, which can be reviewed here, https://oa.mo.gov/state-employees-new#mini-panel-state-employees-tabs2. Annual grant programs also provide Agents an opportunity to earn overtime pay. EXAMPLES OF WORK PERFORMED: Business hours for the district office are 8:00 a.m. to 4:30 p.m., Monday through Friday; however, an Agent's hours will routinely vary, and will generally consist of approximately 40% office work and 60% field work, with fluctuations based on seasonal demand and staffing. Each district is responsible for conducting weekly enforcement activities which may consist of late nights, extended hours, weekend work, and possible overnight stays. Office/administrative duties include, but are not limited to: serving as the primary point of contact for liquor license applicants, licensees, city/county clerks and local law enforcement agencies within a designated territory, and to review liquor license applications for completeness and eligibility. Field work includes, but is not limited to: conducting retailer education training programs, completing routine inspections and site visits, investigating citizen complaints/surveillance, conducting joint enforcement activities with local law enforcement agencies, and conducting self-initiated and supervisor-directed enforcement activities primarily consisting of plainclothes operations. QUALIFICATIONS: To qualify for the position, the applicant must: Be a United States citizen and taxpaying resident of Missouri at time of hire; Possess a valid Missouri driver license; Be proficient in the English language; Possess a high school diploma or an equivalent certificate; Possess a Class A Missouri POST license at the time of appointment; Possess ordinary physical strength; Have a minimum of two (2) years law enforcement experience; College coursework in criminal justice or a closely related field or military police service may be substituted on a year-for-year basis. Reside within 60 miles of the office or relocate within six months; and, Be able to pass a job-related assessment exam, oral interview, criminal record check and background investigation, drug screening, polygraph, and psychological evaluation. ASSESSMENT TESTING AND INTERVIEWS: Computerized assessment tests will be conducted at the Jefferson City district office. Candidates meeting the minimum qualifications will be contacted for scheduling purposes. Interviews will be scheduled at a later determined date. EQUAL OPPORTUNITY STATEMENT: The Division of Alcohol and Tobacco Control is an equal opportunity employer. All qualified applicants will be considered for employment without regard to race, color, religion, sex, national origin, age, disability status, or any other non-merit factor.
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
Apr 04, 2024
Full Time
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
State of Missouri
Jefferson City, Missouri, United States
Job Location: This position is located at the Howerton Building; 615 Howerton Court, Jefferson City, MO. The Department of Social Services partners with families and communities to protect children, rehabilitate youth and move families to self-sufficiency so that Missourians can lead safe, healthy and productive lives. Why you'll love this position: This position is an entry-level programmatic position with room for growth within the Medicaid Program. The person in this position will work independently as part of a team performing Medicare Buy-in to pay Medicare premiums for eligible Medicaid participants. The right person for this position is self-motivated and can perform research and work independently. Review system reports to determine Medicare eligibility, update MHD eligibility records to reflect Medicare entitlement, and refer cases to appropriate Medicare Unit staff. Review and respond to Medicare eligibility inquiries/issues from internal and external sources. Work closely with the Family Support Division regarding Medicaid Research and process standard Buy-Ins from working a variety of unit reports, referring any cases that require further research to the Benefit Program Answer and respond to the Unit Agent phone line and email in a professional and accurate manner. Utilize strong verbal and written communication skills to relay information to the Social Security Administration, Family Support Division, MHD providers and Interpret regulations, policies and procedures of the Medicare program as it relates to MHD participants and convey information to others in an effective and professional Cross-train in duties and provide back up to other staff as Assist supervisor with special projects as Minimum Qualifications 1-3 years of relevant experience. (Substitutions may be allowed) Preferred Qualifications The person in this position should have the ability to work independently, be a team player, and have great time management skills. Experience with Medicaid, Medicare, Health Insurance, or Medical Billing a bonus. Ability to interpret and apply policies and procedures. Good analytical skills with attention to detail. Lack of post-secondary education will not be used as the sole basis denying consideration to any applicant. 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 about this position please contact: Marsha Scrivner at Marsha.N.Scrivner@dss.mo.gov or Robin Breid at robin.r.breid@dss.mo.gov If you experience accessibility issues while applying, please contact Courtney Hall at Courtney.A.Hall@dss.mo.gov . Recruitment Area : All qualified applicants. Application Deadline : April 29, 2024 The State of Missouri is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Closing Date/Time: 2024-04-29
Apr 16, 2024
Full Time
Job Location: This position is located at the Howerton Building; 615 Howerton Court, Jefferson City, MO. The Department of Social Services partners with families and communities to protect children, rehabilitate youth and move families to self-sufficiency so that Missourians can lead safe, healthy and productive lives. Why you'll love this position: This position is an entry-level programmatic position with room for growth within the Medicaid Program. The person in this position will work independently as part of a team performing Medicare Buy-in to pay Medicare premiums for eligible Medicaid participants. The right person for this position is self-motivated and can perform research and work independently. Review system reports to determine Medicare eligibility, update MHD eligibility records to reflect Medicare entitlement, and refer cases to appropriate Medicare Unit staff. Review and respond to Medicare eligibility inquiries/issues from internal and external sources. Work closely with the Family Support Division regarding Medicaid Research and process standard Buy-Ins from working a variety of unit reports, referring any cases that require further research to the Benefit Program Answer and respond to the Unit Agent phone line and email in a professional and accurate manner. Utilize strong verbal and written communication skills to relay information to the Social Security Administration, Family Support Division, MHD providers and Interpret regulations, policies and procedures of the Medicare program as it relates to MHD participants and convey information to others in an effective and professional Cross-train in duties and provide back up to other staff as Assist supervisor with special projects as Minimum Qualifications 1-3 years of relevant experience. (Substitutions may be allowed) Preferred Qualifications The person in this position should have the ability to work independently, be a team player, and have great time management skills. Experience with Medicaid, Medicare, Health Insurance, or Medical Billing a bonus. Ability to interpret and apply policies and procedures. Good analytical skills with attention to detail. Lack of post-secondary education will not be used as the sole basis denying consideration to any applicant. 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 about this position please contact: Marsha Scrivner at Marsha.N.Scrivner@dss.mo.gov or Robin Breid at robin.r.breid@dss.mo.gov If you experience accessibility issues while applying, please contact Courtney Hall at Courtney.A.Hall@dss.mo.gov . Recruitment Area : All qualified applicants. Application Deadline : April 29, 2024 The State of Missouri is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Closing Date/Time: 2024-04-29
State of Missouri
Jefferson City, Missouri, United States
Job Location: The office for this position is located at the Harry S. Truman State Office Building, 301 W High Street, Jefferson City, MO. 65101. Why you'll love this position: Do you want to see the impact of your efforts in action? Then this may be a great opportunity for you! This Data Analyst position is a vital member of our Application Development Support Team responsible for running queries, loading data, and creating custom SQL solutions that move and transform data to ensure accuracy and availability. A variety of work includes new project work, researching and resolving support tickets for live applications within the portfolio, and creating and maintaining documentation for training purposes. Duties may also include data modeling and database work. The successful candidate must be a motivated problem solver who can work independently or in a team environment. They must also have a desire to continually develop new skills through self-study and assigned training or attendance at user group presentations. By joining this team you will have the chance to deliver meaningful impact supporting DOC and the citizens of Missouri. This position is with the Office of Administration, Information Technology Services Division (OA-ITSD) supporting the Department of Corrections (DOC). ITSD Core Values - We Innovate and Partner with Passion, Respect, and Integrity United as #OneTeam. What you'll do: Develop and maintain SQL queries and system data databases, relationships, indexes, views, tables, and fields. Develop and support complex stored procedures and custom functions. Analyze, solve, and correct production issues and provide/edit documentation. Communicate with business users to establish database and report requirements. Effectively prioritize and execute tasks in a high-pressure environment. Analyze, design, develop, peer review, test, and implement code for projects. Create, adhere to, and enforce technical standards. Work independently and as part of a team. Continuous learning (technical and professional development). All you need for success: The following Knowledge, Skills, and Abilities are critical to the success of this position: SQL and DB2LUW proficiency is strongly preferred. Development of SQL agent jobs and complex stored procedures. SQL query performance tuning. Design of databases, including relationships, indexes, views, tables, and fields. 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. Strong written and verbal communication skills, be organized, and self-motivated, can work on a team or independently as required, and have the desire to continually develop new skills and improve existing skills. Knowledge of data modeling and design. Ability to think methodically and critically. Ability to identify, evaluate, and resolve database performance issues. Ability to organize work assignments, multi-task, and take initiative toward innovative solutions 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 modeling and design. Ability to think methodically and critically. Ability to identify, evaluate, and resolve database performance issues. Ability to organize work assignments and multi-task. The classification for this position is Data Analyst : click for more information. More reasons to love this position: 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
Mar 27, 2024
Full Time
Job Location: The office for this position is located at the Harry S. Truman State Office Building, 301 W High Street, Jefferson City, MO. 65101. Why you'll love this position: Do you want to see the impact of your efforts in action? Then this may be a great opportunity for you! This Data Analyst position is a vital member of our Application Development Support Team responsible for running queries, loading data, and creating custom SQL solutions that move and transform data to ensure accuracy and availability. A variety of work includes new project work, researching and resolving support tickets for live applications within the portfolio, and creating and maintaining documentation for training purposes. Duties may also include data modeling and database work. The successful candidate must be a motivated problem solver who can work independently or in a team environment. They must also have a desire to continually develop new skills through self-study and assigned training or attendance at user group presentations. By joining this team you will have the chance to deliver meaningful impact supporting DOC and the citizens of Missouri. This position is with the Office of Administration, Information Technology Services Division (OA-ITSD) supporting the Department of Corrections (DOC). ITSD Core Values - We Innovate and Partner with Passion, Respect, and Integrity United as #OneTeam. What you'll do: Develop and maintain SQL queries and system data databases, relationships, indexes, views, tables, and fields. Develop and support complex stored procedures and custom functions. Analyze, solve, and correct production issues and provide/edit documentation. Communicate with business users to establish database and report requirements. Effectively prioritize and execute tasks in a high-pressure environment. Analyze, design, develop, peer review, test, and implement code for projects. Create, adhere to, and enforce technical standards. Work independently and as part of a team. Continuous learning (technical and professional development). All you need for success: The following Knowledge, Skills, and Abilities are critical to the success of this position: SQL and DB2LUW proficiency is strongly preferred. Development of SQL agent jobs and complex stored procedures. SQL query performance tuning. Design of databases, including relationships, indexes, views, tables, and fields. 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. Strong written and verbal communication skills, be organized, and self-motivated, can work on a team or independently as required, and have the desire to continually develop new skills and improve existing skills. Knowledge of data modeling and design. Ability to think methodically and critically. Ability to identify, evaluate, and resolve database performance issues. Ability to organize work assignments, multi-task, and take initiative toward innovative solutions 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 modeling and design. Ability to think methodically and critically. Ability to identify, evaluate, and resolve database performance issues. Ability to organize work assignments and multi-task. The classification for this position is Data Analyst : click for more information. More reasons to love this position: 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