Data Extraction Specialist (ETL and FME Workbench) | Oklahoma, OK

HR & Recruiting Jobs refer to the roles within an organization focused on attracting, hiring, and retaining employees. Such positions include HR Managers, Recruiters, Talent Acquisition Specialists, and HR Generalists. These roles typically involve tasks such as developing job descriptions, screening candidates, conducting interviews, onboarding new employees, managing benefits and payroll, as well as handling employee relations and compliance with labor laws. A characteristic feature of these jobs is the combination of interpersonal skills with knowledge of HR processes and labor regulations to enhance the workforce and aid in organizational growth.

Guard (ARNG). The purpose of this position is to provide technical expertise and guidance for all military personnel assigned in the State, and oversees the functions of one of the following human resource programs: Officer Personnel Management (OPM), Enlisted Personnel Management (EPM), Personnel Systems, SIDPERS Interface Branch (SIB), or the Personnel Services Section.

Serves as an advisor to commanders on assigned unit human resources (HR) program. Interprets policy and provides procedural guidance to commanders, supervisors, staff members and individual military members. Provides training to supervisors and guidance and assistance to military members on program for which assigned.

Participates in Soldier Readiness Processing (SRP) and unit mobilizations and de-mobilizations. Reviews, evaluates, and interprets regulatory guidance, policies, and procedures applicable to military personnel programs and provides guidance to all users.

Drafts and implements State policy based on the aforementioned policies. Publishes guidance to enhance and simplify completion and submission of personnel actions. Conducts command inspections, staff visits and trains personnel within the unit in all programs for which responsible. Responsible for and oversees the direction of the EPM/OPM or Incentives program and functions as the technical expert. Determines the methods and procedures

for conducting military career guidance and counseling to ensure officer or enlisted personnel have an optimal and established career pattern.

Provides direction, information, and/or counseling to MILPO staff and commanders of Major Army Command (MACOMM) through unit commanders, supervisors, as well as individual military members as required. Provides information and ensures regulatory compliance regarding area of responsibility which may include, but is not limited to: accessions, appointments, assignments, reassignments, transfers, promotions, Selected Reserve Incentive Program (SRIP), discharges, separations, retirements, Officer Evaluation Reports (OER) Non-Commissioned Officer Evaluation Reports (NCOER), awarding of Area of Concentration (AOC), Functional Areas (FA), Additional Skill Identifiers (ASI), Special Qualification Identifiers (SQI), Military Occupational Specialty (MOS) identifiers (primary or secondary), Stop Loss programs, and National Guard Bureau (NGB) waivers, casualty assistance, and requests for retention beyond mandatory removal date.

Responsible for and oversees the direction of SIDPERS and internal/external interfaces, and functions as the technical expert. Responsible for and ensures the timely and accurate processing of submitted military personnel actions.

Manages a control log to maintain document control and an audit trail of all transactions received and dispersed in SIDPERS. Notifies units and higher echelons of rejected or incomplete transaction/documentation, necessary steps or processes required to resolve the problem, and maintains a database for tracking and suspension of submissions for identification of trends and problems. Identifies problem areas in the types of submissions (based on rejects/incomplete documentation), the locations where training is needed, and creates and provides training material.

Responsible for and oversees the direction of the Personnel Services Section and functions as the technical expert. Oversees the performance of document handling, records maintenance, and the Integrated Personnel Electronic Records Management System (i PERMS). Directs staff in performance of periodic record reviews and inventories to ensure total record accountability. Establishes access control lists to restrict unauthorized personnel from gaining access to personnel files other than their own or for those they are responsible for. Requirements Conditions of Employment Federal employment suitability as determined by a background investigation.

May be required to successfully complete a probationary period. Participation in direct deposit is mandatory. Must be able to obtain and maintain the appropriate security clearance of the position. This position is covered by the Domestic Violence Misdemeanor Amendment (30 Sep 96) of the Gun Control Act (Lautenberg Amendment) of 1968. An individual convicted of a qualifying crime of domestic violence may not perform the duties of this position. Ability to establish effective professional working relationships with coworkers and customers, contributing to a cooperative working environment and successful accomplishment of the mission.

Irregular and/or overtime (compensatory) hours may be required to support operational requirements or contingencies or may be required to work hours outside of the normal duty day. The duties and responsibilities of your job may significantly impact the environment. You are responsible to maintain awareness of your environmental responsibilities as dictated by legal and regulatory requirements, your organization, and its changing mission. This position is designated as Essential Personnel and may be subject to duty in preparation for, or in response to, a state emergency or disaster declaration.

This designation will not exceed 14 calendar days per year unless otherwise approved in advance by the TAG. Qualifications BASIC QUALIFICATIONS: To qualify an applicant for any GS-0201 position, apply and evaluate the applicant's competencies (knowledge, skills, abilities, and behaviors) that may include military and civilian experiences, completed education, learned skills, obtained knowledge, endorsed abilities, and training program accomplishments. The following seven basic qualification competency factors are applicable to the Series GS-0201 career levels: -Skilled in collecting and analyzing data effectively, efficiently, and accurately; -Ability to clearly enunciate English without impediment of speech that would interfere or prohibit efficient communication; -Ability to write English in reports and presentation formats; -Ability to communicate clearly and effectively; -Skilled in presenting formal training presentations and briefings; -Ability to backss body language and perceive emotional and/or distress levels; and, -Skilled in applying procedures and directives by reading and interpreting program material.

GENERAL EXPERIENCE : Experiences gained through civilian and/or military technical training schools within the human resources business programs are included as general experience qualifications. An applicant must have a validated understanding of the basic principles and concepts of the occupational series and grade. SPECIALIZED EXPERIENCE : Must have at least one year of specialized experiences at the GS-07 level or the equivalent which provided a working knowledge of National Guard missions, organizations, and federal civilian or military personnel programs.

Must have experiences in executing personnel programs and Human Resources Information Systems, as applicable to the specific position and its position description. Must have knowledge and understanding of the personnel and manpower core competencies: Organization Structure; Requirements Determination; Program Allocation and Control; and, Performance Improvement. Have a working knowledge of organizational structures; manpower standards; manpower resources; manpower data systems; or, commercial services to include strategic sourcing. Experienced in performing personnel program requirements that involve advising supervisors and managers; and, experienced in completing accession planning and processing; classification and position management; and, civilian promotions.

Experienced in advertising positions, processing assignments or reassignment actions; reviewing human resources development programs; applying education and training policy requirements; discussing retraining procedures; and/or providing retirement options. Competent in discussing the equal opportunity and interactionual assault prevention and response programs. Have experiences in career counseling; completing or editing performance evaluations; and, conducting educational and skill development personnel course programs.

Competent in merit principles, personnel plans, programs, and policies to guide or advise others on their implementation activities. Skilled in applying program policies, directives, publications, and training manuals. Knowledgeable on allocating manpower resource budgets or execution procedures. Experienced in performance management and productivity programs; or, advising on process improvement, best practices, and performance techniques. Knowledge of, and skill in applying, fundamental military human resource management principles and practices; and standardized analytical and evaluative methods and techniques in order to provide technical expertise and guidance as well as management advisory services to resolve factual and procedural issues within the particular area of assignment.

In-depth knowledge of applicable regulations relating to the field of military human resources management and the area of assignment. Knowledge of the organizational structure and requirements of the ARNG for that State suitable to provide advice to commanders, unit administrators, and military members concerning the area of program specialty.

Ability to communicate effectively both orally and in writing, with individuals, supervisors, and management.How You Will Be Evaluated You will be evaluated for this job based on how well you meet the qualifications above. Once the announcement has closed, your resume and supporting documentation will be used to determine if you meet the qualifications listed on this announcement. If you are minimally qualified, your resume and supporting documentation will be compared to your responses on the backssment questionnaire to determine your level of experience.

If you rate yourself higher than is supported by your application package, your responses may be adjusted and/or you may be excluded from consideration for this position. If you are found to be among the top qualified candidates, you will be referred to the selecting official for employment consideration. Your qualifications will be evaluated on the following competencies (knowledge, skills, abilities and other characteristics): Technical Competence Required Documents To apply for this position, you must submit a complete Application Package which includes: 1. Your resume: Your resume may be submitted in any format and must support the specialized experience described in this announcement.

If your resume includes a photograph, other PII (Personally Identifiable information) or other inappropriate material or content, it will not be used to make eligibility and qualification determinations and you may not be considered for this vacancy. For qualifications determinations your resume must contain hours worked per week and the dates of employment (i. e. Hours per week and month/year to month/year or month/year to present ex. 03/2020-06/2022 or 03/2020-Present). If your resume does not contain this information, your application may be marked as incomplete, and you may not receive consideration for this position.

For additional information see:2. Other supporting documents (as applicable): Certifications DD-214 or NGB 22 SF-50 Official Transcripts If you are relying on your education to meet qualification requirements: Education must be accredited by an accrediting institution recognized by the U. S. Department of Education in order for it to be credited towards qualifications. Therefore, provide only the attendance and/or degrees from. Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.

PDN-9ac9c498-c26b-4ffa-9fea-a069c1933316

policy and provides procedural guidance to commanders, supervisors, staff members and individual military members. Provides training to supervisors and guidance and assistance to military members on program for which assigned. Conducts periodic briefings for staff, commanders, and administrative personnel to promote full understanding of all aspects of the assigned program.

Provides commanders, supervisors, and MILPO staff with a variety of statistical data or reports pertaining to military HR issues to assist in HR management decisions. Responds to correspondence (general, other agency, congressional, etc. ) regarding military personnel issues. Researches, prepares response, and maintains

action file. As required, forwards response for review and/or response for the MILPO Director and/or State Adjutant General. Estimates and projects future travel and funding requirements and submits request to MILPO Director.

Oversees one of the following programs identified in duties 2 through 4: Responsible for and oversees the direction of the EPM or OPM program and functions as the technical expert. Determines the methods and procedures for conducting military career guidance and counseling to ensure officer or enlisted personnel have an optimal and established career pattern. Provides direction, information, and/or counseling to MILPO staff, commanders of Major Army Command (MACOMM)

through unit commanders, supervisors, as well as individual military members as required.

PStop Loss programs, and National Guard Bureau (NGB) waivers. Convenes or participates in various boards which may include: promotion, awards, selective retention, MOS Medical Review Board (MMRB), Incapacitation Review Boards, etc. Initiates action for the issuance of all military orders relating to military personnel actions and distributes accordingly. Reviews Table of Distribution and Allowances (TDA), Table of Organization and Equipment (TOE), Modified TOE (MTOE), and/or Unit Manning Report (UMR) for the requirements, authorizations and movements of military personnel.

Responsible for the review and verification of promotion actions (officer - 01 through 03, enlisted - E5 though E9) and/or the review and forwarding of packets for promotion board actions. Responsible for and oversees the direction of the SIDPERS program and functions as the technical expert. Responsible for and ensures the timely and accurate processing of submitted military personnel actions. Establishes a control log to maintain document control and an audit trail of all transactions received and dispersed in SIDPERS. Notifies units and higher echelons of rejected or incomplete documentation, necessary steps or processes required to resolve the problem, and maintains a database for tracking and suspension of submissions for identification of trends and problems.

Identifies problem areas in the types of submissions (based on rejects/incomplete documentation), the locations where training is needed, andcreates and provides training material. Responsible for and oversees the direction of the Personnel Services Section and functions as the technical expert. Oversees the performance of document handling, records maintenance, and the personnel electronic records management system (PERMS).

Directs staff in performance of periodic record reviews and inventories to ensure total record accountability. Establishes access control lists to restrict unauthorized personnel from gaining access to personnel files other than their own or for those they are responsible for. Selects staff members to accompany files on an as needed basis i. e. review boards, SRP's, mobilizations/demobilizations, etc. Ensures staff members provide military members with information regarding their benefitselections (i. e. life insurance and designation of beneficiary), identify documentation required to update Defense Enrollment Eligibility Reporting System (DEERS), understand requirements to issue identification cards, etc.

Provides oversight on the processing of records for separation/discharge to include: proper identification and crediting of MOS, awards, training, dates of service, type of discharge, computation of total creditable service, etc. Accomplishes and oversees the accomplishment of technical support work in the program area assigned with the assistance of subordinate employees which may be Active Guard Reserve (AGR), full time Technician, or civilian. Performs limited supervisory duties which include assignment and review of work on a daily, weekly, or monthly basis; assure that production and accuracy requirements are met; approval of leave; effect minor disciplinary actions i.

e. warnings or reprimands; identify training needs; and recommend performance standards and ratings. Requirements Conditions of Employment NATIONAL GUARD MEMBERSHIP IS REQUIRED. If you are not sure you are eligible for military membership, please contact a National Guard recruiter prior to applying for this position. This is an excepted service position that requires membership in a compatible military assignment in the employing state's National Guard, required prior to the effective date of placement.

Selectee will be required to wear the military uniform. Acceptance of an excepted service position constitutes concurrence with these requirements as a condition of employment. Applicants who are not currently a member of the National Guard must be eligible for immediate membership and employment in the National Guard in the military grade listed in this announcement. Males born after 31 December 1959 must be registered for Selective Service. Federal employment suitability as determined by a background investigation.

May be required to successfully complete a probationary period. Participation in direct deposit is mandatory. Must be able to obtain and maintain the appropriate security clearance of the position. This position is covered by the Domestic Violence Misdemeanor Amendment (30 Sep 96) of the Gun Control Act (Lautenberg Amendment) of 1968. An individual convicted of a qualifying crime of domestic violence may not perform the duties of this position. Ability to establish effective professional working relationships with coworkers and customers, contributing to a cooperative working environment and successful accomplishment of the mission.

May occasionally be required to work other than normal duty hours; overtime may be required. The duties and responsibilities of your job may significantly impact the environment. You are responsible to maintain awareness of your environmental responsibilities as dictated by legal and regulatory requirements, your organization, and its changing mission. Qualifications Military Grades : E5 - E7 GENERAL EXPERIENCE : Experiences gained through military or civilian technical training schools, within the human resources business programs, are included as general experience qualifications.

An applicant must have a validated understanding of the basic principles and concepts of the occupational series and grade. SPECIALIZED EXPERIENCE : Must posses at least 12 months experiences that prepared the applicant to perform the duties of the position. The applicant's educational-degree study program or military or civilian academic courses may substitute for some specialized experience. An applicant must demonstrate the specialized experience competencies (skills, knowledge, abilities and behaviors) to qualify for a position identified by its position grade and career level.

How You Will Be Evaluated You will be evaluated for this job based on how well you meet the qualifications above. Once the announcement has closed, your resume and supporting documentation will be used to determine if you meet the qualifications listed on this announcement. If you are minimally qualified, your resume and supporting documentation will be compared to your responses on the backssment questionnaire to determine your level of experience. If you rate yourself higher than is supported by your application package, your responses may be adjusted and/or you may be excluded from consideration for this position.

If you are found to be among the top qualified candidates, you will be referred to the selecting official for employment consideration. Your qualifications will be evaluated on the following competencies Clarical and Technical. Required Documents To apply for this position, you must submit a complete Application Package which includes: 1. Your resume: Your resume may be submitted in any format and must support the specialized experience described in this announcement. If your resume includes a photograph, other PII (Personally Identifiable information) or other inappropriate material or content, it will not be used to make eligibility and qualification determinations and you may not be considered for this vacancy.

For qualifications determinations your resume must contain hours worked per week and the dates of employment (i. e. Hours per week and month/year to month/year or month/year to present ex. 03/2020-06/2022 or 03/2020-Present). If your resume does not contain this information, your application may be marked as incomplete, and you may not receive consideration for this position. For additional information see:2.

Other supporting documents (as applicable): Certifications DD-214 or NGB 22 SF-50 Official Transcripts If you are relying on your education to meet qualification requirements: Education must be accredited by an accrediting institution recognized by the U. S. Department of Education in order for it to be credited towards qualifications. Therefore, provide only the attendance and/or degrees from. Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating. PDN-9ac5baf4-6f95-449b-ab72-38063253d152

and care options, including Active Independent Living, Assisted Living, Memory Care, Skilled Nursing and available, short-term Respite Care. Morada Senior Living is looking for a Concierge to join our community Dorset Place Assisted Living and Memory Care.

POSITION SUMMARY Responsible for greeting guests, residents, and employees, managing both external and internal calls, taking and communicating messages, and providing information of a general nature. Responsibilities: Carries out telephone answering and reception duties as required. Takes complete messages with pertinent information and communicates messages to the intended recipient. Greets residents and visitors. Answers inquiries

and gives directions. Collates brochures for the marketing department. Prepares meal tickets for team members and family members, tallies meal count sheets for the Dining staff.

Updates the Resident Phone List and Roster and Move-In and Move-Out Register daily; Guest and Sign-In Logs as necessary. Manages appointments for residents and family members such as but not limited to hairdresser, transportation, etc. Maintains and keeps desk and entry area neat and organized. Organizes, distributes mail to residents, Executive Director and Department Coordinators. Maintains resident forms for miscellaneous credits. Maintains adherence to all company personnel policies and established operating

policies and procedures. Other duties as assigned. Qualifications: High school diploma or general education degree (GED) preferred.

One to three years customer service experience and/or training; or equivalent combination of education and experience. Benefits: In addition to a rewarding career and competitive salary, Morada offers a comprehensive benefits package. Eligible team members are offered a comprehensive benefits package including medical, dental, vision, life and disability insurances, paid time off, and paid holidays. Team members are eligible to participate in our outstanding 401(k) plan with company match our Employee Assistance Program and accident insurance policies.

Thank you for your interest in Morada Senior Living careers. If you have any questions about the position you are applying for, please contact the community directly. EOE D/V