WAKE COUNTY, NC
Raleigh, North Carolina, United States
What You'll Be Doing Children in Wake County are in need of your support to ensure access to the resources they need to live happy and healthy lives. We are seeking a highly organized, dependable, caring, and professional Program Assistant to provide advanced administrative duties that include, preparing Court documents for electronic filing and completing initial administrative case management functions. Join #TeamWake, and experience why Wake County is an awesome place to live, work, and play! We offer a competitive benefits and compensation package, a hybrid (in office/remote) work schedule, and a work environment that encourages staff engagement, innovation, and opportunities for personal and professional growth. Primary responsibilities include: Processing legal pleadings for electronic delivery and acceptance by Clerk of Court, hard copy delivery for Sheriff service, and internal delivery to IV-D Attorney and Case Agent Researching legal documents, electronic document management system, and Administrative Office of the Courts systems to track legal document filing status Liaise with Clerk of Court to resolve missing and/or incorrectly filed pleadings Preparing private and IV-D child support cases transferred in or out of the Wake County jurisdiction for persons requesting IV-D child support services Completing limited financial adjustments to finalize the acceptance of new cases received from other NC County jurisdictions Reviewing child support applications, to include applicant’s public assistance status and demographic information to determine applicable fee, if any Reviewing for quality assurance to determine documents correctly scanned into electronic document management system Supporting Administrative Team, to include providing Receptionist duties and other administrative clerical functions as necessary to meet needs of the team Completing special projects and reports related to document filing as necessary Utilizing Onbase, electronic document management software and systems, and the Automated Collections & Tracking System (ACTS) About Our Team Wake County Health and Human Services (WCHHS) is the consolidation of programs and services that include social services, public health, job search assistance, child support, and transportation. Our mission, in partnership with the community, is to facilitate full access to high quality and effective health and human services for Wake County residents. In addition to our numerous standard programs, Wake County Health and Human Services (WCHHS) is engaged in a number of special initiatives that are impacting services and programs throughout our entire agency. Whether legislated down from the changing regulations on the Federal or State level or bubbling up from the entrepreneurial spirit of our staff, you can always look forward to Wake County Health and Human Services implementing new and exciting enhancements to our services and programs. The Basics (Required Education and Experience) Associate's degree One year of job-related experience Equivalent education and experience are accepted Please include ALL prior work experience on your application and resume. Beyond the Basics (Preferred Education and Experience) Child Support Enforcement Program experience, State or County Department of Social Services Income Maintenance Programs (Work first & Medicaid) experience, and or experience working in the Administrative Office of the Courts Experience with Hyland OnBase (PRIME) and/or other document management systems How Will We Know You're 'The One'? Knowledge of the local, state, and federal laws, rules, and regulations governing the Child Support Program Demonstrate proficiency working in ACTS, NCFAST, EIS, XPTR, Data Warehouse systems, Microsoft Office products, and Hyland OnBase (PRIME) Excellent verbal and written communication skills Ability to understand the impact and implications of decisions on the consumers and other State and local departments Ability to identify problems, determining possible solutions, and actively working to resolve the issues Ability to demonstrate a methodical and logical approach to addressing customer needs, utilizing innovative solutions and/or designs where appropriate Ability to communicate effectively with both staff and customers and external Agency partners including Medicaid, Work First, and Foster Care Programs Ability to accomplish tasks and processes accurately, timely, and completely Ability to be proactive, taking prompt action to accomplish objectives and goals beyond what is required Strong organizational skills and detail-oriented Ability to work well as a team member in a fast-paced environment Ability to multi-task Ability to work independently and strong decision-making skills Strong computer skills Strong time management skills Strong interpersonal skills About This Position Location: Waverly F. Adkins Office Building Raleigh, NC 27601 Employment Type: Regular Work Schedule: Mon - Fri 8:30 am - 5:15 pm Hiring Range: 18.20 - 24.33 Market Range: 18.47 - 31.40 Please include ALL prior work experience on your application and resume. Posting Closing Date: 7:00 pm on 5/17/2024 What Makes Wake Great Home to the State Capital, Wake County is one of the fastest growing areas in the nation and the most populous county in the state, with more than 1.1 million residents. The County has received national and international rankings and accolades from publications such as Money, Fortune, and Time magazines as being one of the best places to live, work and play. The central location of the County allows for a short drive to the spectacular mountains or coast. Wake County Government is governed by a seven-member Board of Commissioners, who are elected at-large to serve two-year terms. Wake County Government has a general operating budget of $1.874 billion, employs over 4400 employees, experiences minimal turnover, and is an award-winning leader in wellness and technology initiatives; such as offering employees and covered spouses free access to the Employee Health Center. Wake County Government offers a wide range of training and development opportunities, a stable career in public service with a balance of work and family life, flexible work schedules and a competitive salary and benefits package. Equal Opportunity Statement Wake County provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. Background Check Statement Position may require a background check that may include: criminal, credit, motor vehicle, education, and sexual offender registry or others based on job requirements. Unless required by state law, a record of conviction will not automatically exclude you from consideration for employment. Wake County Government is an Equal Opportunity Employer. Emergency Service Worker Statement In the event of an emergency, as determined by the County Manager or designee, participation in preparedness and response operations should be expected. Employee may be required to fill a temporary assignment in a role different from standard duties, work hours and/or work location in preparation for, during and after the emergency. Employee may also be required to participate in relevant exercises and regular preparedness training.
What You'll Be Doing Children in Wake County are in need of your support to ensure access to the resources they need to live happy and healthy lives. We are seeking a highly organized, dependable, caring, and professional Program Assistant to provide advanced administrative duties that include, preparing Court documents for electronic filing and completing initial administrative case management functions. Join #TeamWake, and experience why Wake County is an awesome place to live, work, and play! We offer a competitive benefits and compensation package, a hybrid (in office/remote) work schedule, and a work environment that encourages staff engagement, innovation, and opportunities for personal and professional growth. Primary responsibilities include: Processing legal pleadings for electronic delivery and acceptance by Clerk of Court, hard copy delivery for Sheriff service, and internal delivery to IV-D Attorney and Case Agent Researching legal documents, electronic document management system, and Administrative Office of the Courts systems to track legal document filing status Liaise with Clerk of Court to resolve missing and/or incorrectly filed pleadings Preparing private and IV-D child support cases transferred in or out of the Wake County jurisdiction for persons requesting IV-D child support services Completing limited financial adjustments to finalize the acceptance of new cases received from other NC County jurisdictions Reviewing child support applications, to include applicant’s public assistance status and demographic information to determine applicable fee, if any Reviewing for quality assurance to determine documents correctly scanned into electronic document management system Supporting Administrative Team, to include providing Receptionist duties and other administrative clerical functions as necessary to meet needs of the team Completing special projects and reports related to document filing as necessary Utilizing Onbase, electronic document management software and systems, and the Automated Collections & Tracking System (ACTS) About Our Team Wake County Health and Human Services (WCHHS) is the consolidation of programs and services that include social services, public health, job search assistance, child support, and transportation. Our mission, in partnership with the community, is to facilitate full access to high quality and effective health and human services for Wake County residents. In addition to our numerous standard programs, Wake County Health and Human Services (WCHHS) is engaged in a number of special initiatives that are impacting services and programs throughout our entire agency. Whether legislated down from the changing regulations on the Federal or State level or bubbling up from the entrepreneurial spirit of our staff, you can always look forward to Wake County Health and Human Services implementing new and exciting enhancements to our services and programs. The Basics (Required Education and Experience) Associate's degree One year of job-related experience Equivalent education and experience are accepted Please include ALL prior work experience on your application and resume. Beyond the Basics (Preferred Education and Experience) Child Support Enforcement Program experience, State or County Department of Social Services Income Maintenance Programs (Work first & Medicaid) experience, and or experience working in the Administrative Office of the Courts Experience with Hyland OnBase (PRIME) and/or other document management systems How Will We Know You're 'The One'? Knowledge of the local, state, and federal laws, rules, and regulations governing the Child Support Program Demonstrate proficiency working in ACTS, NCFAST, EIS, XPTR, Data Warehouse systems, Microsoft Office products, and Hyland OnBase (PRIME) Excellent verbal and written communication skills Ability to understand the impact and implications of decisions on the consumers and other State and local departments Ability to identify problems, determining possible solutions, and actively working to resolve the issues Ability to demonstrate a methodical and logical approach to addressing customer needs, utilizing innovative solutions and/or designs where appropriate Ability to communicate effectively with both staff and customers and external Agency partners including Medicaid, Work First, and Foster Care Programs Ability to accomplish tasks and processes accurately, timely, and completely Ability to be proactive, taking prompt action to accomplish objectives and goals beyond what is required Strong organizational skills and detail-oriented Ability to work well as a team member in a fast-paced environment Ability to multi-task Ability to work independently and strong decision-making skills Strong computer skills Strong time management skills Strong interpersonal skills About This Position Location: Waverly F. Adkins Office Building Raleigh, NC 27601 Employment Type: Regular Work Schedule: Mon - Fri 8:30 am - 5:15 pm Hiring Range: 18.20 - 24.33 Market Range: 18.47 - 31.40 Please include ALL prior work experience on your application and resume. Posting Closing Date: 7:00 pm on 5/17/2024 What Makes Wake Great Home to the State Capital, Wake County is one of the fastest growing areas in the nation and the most populous county in the state, with more than 1.1 million residents. The County has received national and international rankings and accolades from publications such as Money, Fortune, and Time magazines as being one of the best places to live, work and play. The central location of the County allows for a short drive to the spectacular mountains or coast. Wake County Government is governed by a seven-member Board of Commissioners, who are elected at-large to serve two-year terms. Wake County Government has a general operating budget of $1.874 billion, employs over 4400 employees, experiences minimal turnover, and is an award-winning leader in wellness and technology initiatives; such as offering employees and covered spouses free access to the Employee Health Center. Wake County Government offers a wide range of training and development opportunities, a stable career in public service with a balance of work and family life, flexible work schedules and a competitive salary and benefits package. Equal Opportunity Statement Wake County provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. Background Check Statement Position may require a background check that may include: criminal, credit, motor vehicle, education, and sexual offender registry or others based on job requirements. Unless required by state law, a record of conviction will not automatically exclude you from consideration for employment. Wake County Government is an Equal Opportunity Employer. Emergency Service Worker Statement In the event of an emergency, as determined by the County Manager or designee, participation in preparedness and response operations should be expected. Employee may be required to fill a temporary assignment in a role different from standard duties, work hours and/or work location in preparation for, during and after the emergency. Employee may also be required to participate in relevant exercises and regular preparedness training.
MASSACHUSETTS TRIAL COURT
Plymouth, Massachusetts, United States
Title: Fiscal Specialist-Plymouth Pay Grade: Grade 14 Starting Pay: $63,418.15/Yr. Departmental Mission Statement: The Facilities Management and Capital Planning department provides for the management and maintenance of 62 state-owned courthouses, and 42 leased facilities located in ten counties of the Commonwealth. The Department is committed to administering effective property management, facility operations, facility renewal, and the delivery of quality customer service in support of the administration of justice throughout the Commonwealth. Organizational Profile: https://www.mass.gov/orgs/trial-court-facilities-management-capital-planning-department Notes: This position is designated as a union position and is covered by the Collective Bargaining Agreement with O.P.E.I.U., Local 6. This position is for Region IV in Facilities and the primary location is Plymouth Trial Court. The hours for this position is 8:00am-4:00pm. Position Summary: Working within the Facilities Management Department of the Office of Court Management, a Fiscal Specialist serves as a member of the fiscal staff performing a variety of fiscal and administrative responsibilities and resolving moderate to complex fiscal issues that arise. The Fiscal Specialist also provides clerical support as needed. The position title above the entry level requires the performance of increasingly more responsible work which requires more knowledge of fiscal and administrative policies and the exercise of more independent judgment. Employees are hired at the entry level position title and are eligible for reclassification to the higher level position title within this series consistent with the specifications for the higher level position title. The position title reverts to the entry level when there is a vacancy Fiscal Specialist I - This is the entry level position title within this series. Employees at this level are expected to perform a variety of fiscal duties related to budgeting purchasing, and billing. Fiscal Specialist II - This is the second level position title within this series. Employees at this second level are expected to perform higher level fiscal duties in the areas of fiscal planning and projections, to recommend ways to improve activities, and to exercise more independent judgment. SUPERVISION RECEIVED: Receives general direction from the Regional Manager of Facilities Management or his/her designee in performing duties in accordance with established guidelines. Fiscal Specialist I Duties : Coordinates the annual budget process, including preparing spending plans and expansion budget requests based upon information provided by the manager; Maintains the budgetary control register and prepares and files the monthly expenditure reports; Determines the need, makes recommendations, and prepares requests for inter-subsidiary budget transfers; ensures that funds are properly encumbered for approved contracts and programs; Functions as a purchasing agent for the office purchasing all supplies and equipment; Provides ongoing advice and information on the availability of funding for the purchase of goods and services; maintains files for purchase order requests; Reviews and verifies accuracy of invoices and prepares payment vouchers and other fiscal documents required to pay vendors for goods and services; Monitors payment and encumbrance transactions on the Massachusetts Management and Accounting Reporting System (MMARS); tracks fiscal transactions and responds to inquiries on the status of accounts; Assists vendors with payment research and responds to related inquiries; Works with the Fiscal Affairs Department of the Administrative Office of the Trial Court concerning fiscal and administrative matters; Provides administrative support for programs and operations performed within the office; and Performs related duties as required. Fiscal Specialist II Duties: Performs fiscal planning, including providing financial projections and participating in the decision-making on how resources will be expended; Regularly evaluates fiscal and administrative activities and recommends ways to improve such activities; Reviews, investigates, and resolves complex billing problems; Generates ad-hoc reports from the warehouse to evaluate fiscal activities; Performs special projects; Develops and maintains data bases to assist in monitoring fiscal and administrative activities; and Performs all of the duties of the lower level of this series. Job Competencies: Ethics and Values Communicates and demonstrates the ethics and values of the Trial Court. Mission Understands, upholds, and communicates the Trial Court and Facilities Management Departmental missions. Applied Knowledge Knowledge and ability to support the Facilities Management fiscal staff in administering budgets, state contracts, procurement matters, and accounts management. Problem Solving Accurately identifies and assesses moderate to complex fiscal errors and fiscal procedural issues within the department and initiates corrective action. Continuous Learning Demonstrates a commitment to continuously improve himself or herself through professional development. Commitment to Diversity Promotes an environment of diversity through understanding, respect, and positive communication with persons of varied racial, ethnic, economic, and cultural backgrounds. Communication Demonstrates the capacity to ensure clear, informative and transparent communications to the facilities department and other Trial Court and government officials. Collaboration Works with others cooperatively, and promotes teamwork, contributing to a work environment that focuses on shared departmental goals. Minimum Requirements: These are the minimum requirements necessary to apply for the position of Fiscal Specialist: Fiscal Specialist I Requirements: Associates degree in accounting, bookkeeping, or related field and (2) two years' experience in accounting or office management; or and equivalent combination of education and experience; A Bachelor's degree is preferred; Knowledge of bookkeeping, account, and other administrative procedures; Strong organizational and administrative skills; Ability to work professionally with judges, court officials, court personnel, and the general public; Ability to communicate effectively in both oral and written form; Demonstrated ability to use personal computers, including MS Office and related word processing and spreadsheet software; Ability to perform Trial Court fiscal procedures in accordance with MMARS accounting system; and Ability to type accurately and to effectively draft correspondence. Fiscal Specialist II Requirements: A minimum of three years of experience as a Fiscal Specialist I; Considerable knowledge of Trial Court fiscal and administrative policies and procedures; Demonstrated ability to perform fiscal analysis and to make projections; Demonstrated ability to identify problems and to propose feasible solutions; and Demonstrated ability to perform duties with minimal supervision and to exercise independent judgment; Proven ability to maintain accurate records and to prepare all necessary reports; and Ability to handle highly confidential material with discretion. Closing Date/Time: 2024-08-11
Title: Fiscal Specialist-Plymouth Pay Grade: Grade 14 Starting Pay: $63,418.15/Yr. Departmental Mission Statement: The Facilities Management and Capital Planning department provides for the management and maintenance of 62 state-owned courthouses, and 42 leased facilities located in ten counties of the Commonwealth. The Department is committed to administering effective property management, facility operations, facility renewal, and the delivery of quality customer service in support of the administration of justice throughout the Commonwealth. Organizational Profile: https://www.mass.gov/orgs/trial-court-facilities-management-capital-planning-department Notes: This position is designated as a union position and is covered by the Collective Bargaining Agreement with O.P.E.I.U., Local 6. This position is for Region IV in Facilities and the primary location is Plymouth Trial Court. The hours for this position is 8:00am-4:00pm. Position Summary: Working within the Facilities Management Department of the Office of Court Management, a Fiscal Specialist serves as a member of the fiscal staff performing a variety of fiscal and administrative responsibilities and resolving moderate to complex fiscal issues that arise. The Fiscal Specialist also provides clerical support as needed. The position title above the entry level requires the performance of increasingly more responsible work which requires more knowledge of fiscal and administrative policies and the exercise of more independent judgment. Employees are hired at the entry level position title and are eligible for reclassification to the higher level position title within this series consistent with the specifications for the higher level position title. The position title reverts to the entry level when there is a vacancy Fiscal Specialist I - This is the entry level position title within this series. Employees at this level are expected to perform a variety of fiscal duties related to budgeting purchasing, and billing. Fiscal Specialist II - This is the second level position title within this series. Employees at this second level are expected to perform higher level fiscal duties in the areas of fiscal planning and projections, to recommend ways to improve activities, and to exercise more independent judgment. SUPERVISION RECEIVED: Receives general direction from the Regional Manager of Facilities Management or his/her designee in performing duties in accordance with established guidelines. Fiscal Specialist I Duties : Coordinates the annual budget process, including preparing spending plans and expansion budget requests based upon information provided by the manager; Maintains the budgetary control register and prepares and files the monthly expenditure reports; Determines the need, makes recommendations, and prepares requests for inter-subsidiary budget transfers; ensures that funds are properly encumbered for approved contracts and programs; Functions as a purchasing agent for the office purchasing all supplies and equipment; Provides ongoing advice and information on the availability of funding for the purchase of goods and services; maintains files for purchase order requests; Reviews and verifies accuracy of invoices and prepares payment vouchers and other fiscal documents required to pay vendors for goods and services; Monitors payment and encumbrance transactions on the Massachusetts Management and Accounting Reporting System (MMARS); tracks fiscal transactions and responds to inquiries on the status of accounts; Assists vendors with payment research and responds to related inquiries; Works with the Fiscal Affairs Department of the Administrative Office of the Trial Court concerning fiscal and administrative matters; Provides administrative support for programs and operations performed within the office; and Performs related duties as required. Fiscal Specialist II Duties: Performs fiscal planning, including providing financial projections and participating in the decision-making on how resources will be expended; Regularly evaluates fiscal and administrative activities and recommends ways to improve such activities; Reviews, investigates, and resolves complex billing problems; Generates ad-hoc reports from the warehouse to evaluate fiscal activities; Performs special projects; Develops and maintains data bases to assist in monitoring fiscal and administrative activities; and Performs all of the duties of the lower level of this series. Job Competencies: Ethics and Values Communicates and demonstrates the ethics and values of the Trial Court. Mission Understands, upholds, and communicates the Trial Court and Facilities Management Departmental missions. Applied Knowledge Knowledge and ability to support the Facilities Management fiscal staff in administering budgets, state contracts, procurement matters, and accounts management. Problem Solving Accurately identifies and assesses moderate to complex fiscal errors and fiscal procedural issues within the department and initiates corrective action. Continuous Learning Demonstrates a commitment to continuously improve himself or herself through professional development. Commitment to Diversity Promotes an environment of diversity through understanding, respect, and positive communication with persons of varied racial, ethnic, economic, and cultural backgrounds. Communication Demonstrates the capacity to ensure clear, informative and transparent communications to the facilities department and other Trial Court and government officials. Collaboration Works with others cooperatively, and promotes teamwork, contributing to a work environment that focuses on shared departmental goals. Minimum Requirements: These are the minimum requirements necessary to apply for the position of Fiscal Specialist: Fiscal Specialist I Requirements: Associates degree in accounting, bookkeeping, or related field and (2) two years' experience in accounting or office management; or and equivalent combination of education and experience; A Bachelor's degree is preferred; Knowledge of bookkeeping, account, and other administrative procedures; Strong organizational and administrative skills; Ability to work professionally with judges, court officials, court personnel, and the general public; Ability to communicate effectively in both oral and written form; Demonstrated ability to use personal computers, including MS Office and related word processing and spreadsheet software; Ability to perform Trial Court fiscal procedures in accordance with MMARS accounting system; and Ability to type accurately and to effectively draft correspondence. Fiscal Specialist II Requirements: A minimum of three years of experience as a Fiscal Specialist I; Considerable knowledge of Trial Court fiscal and administrative policies and procedures; Demonstrated ability to perform fiscal analysis and to make projections; Demonstrated ability to identify problems and to propose feasible solutions; and Demonstrated ability to perform duties with minimal supervision and to exercise independent judgment; Proven ability to maintain accurate records and to prepare all necessary reports; and Ability to handle highly confidential material with discretion. Closing Date/Time: 2024-08-11
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 .
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 .