Job description

Summary This position is located with the Office of Information Technology (OIT), Division of Data Management & Analytics (DDMA). The purpose of this position is to serve as a software project architect and application engineer, specializing in database administration, data migration development, and structured query language (SQL) coding to support mixed software development lifecycle methodologies. The incumbent reports to the Supervisory Information Technology (I/T) Specialist or designee. Help Duties Total Compensation Package - Check out IHS's outstanding total compensation package for this job: IT Specialist Total Compensation | Pay (ihs.gov) Requirements Gathering And Data Analysis • Participate in requirements gathering sessions and confirm data requirements to meet the business needs. • Conduct analysis against the data definitions and identify requirements to support the data architecture definition. • Map data requirements to enterprise data models (conceptual or logical) to support the physical data architecture. • Determine the appropriate physical data model based on the requirement and business process. Data Governance, Architecture and Analysis • Conduct requirement analysis, define specifications, translate and architect functional requirements into technical and programming specifications in support of business intelligence (BI), reporting and analytic project initiatives both independently and as a team member. • Design, develop, and maintain data structures, data harvesting, and migration processes and queries to satisfy enterprise reporting requirements. • Evaluate, design, test, program, verify and validate, implement, support and maintain and or modify BI solutions reporting tools for both new and existing data domains (clinical, financial, administrative, engineering) within the enterprise data warehouse environment. • Review and direct the design, development, documentation, and customization of data structures to support the persistence of mission critical population health and patient care management information. Regulatory Control and Compliance Analysis • Review and evaluate technology trends in software application development in support of current or future DDMA reporting requirements. • Formulate and recommend approaches for incorporating new approaches and state-of-the-art I/T processes into the DDMA/National Patient Information Reporting System (NPIRS) Enterprise Data Management ecosystem. • May perform as a contractor technical monitor during the post-award administration of assigned contract(s) to monitor the contractor's technical progress and task orders as a representative of the program office, under delegated authority. • Write statements of work (SOW) for contract support activities. Help Requirements Conditions of Employment Selectee may be subject to a probationary period U.S. Citizenship is required Selective Service Registration is required for males born after 12/31/1959 Confidential Financial Disclosure Form required. Successfully pass the E-Verify employment verification check. To learn more about E-Verify, including your rights and responsibilities, visit www.dhs.gov/E-Verify/. You will need to set up direct deposit so we can pay you. Background Investigation: If you are selected for this vacancy, you must undergo a pre-employment fingerprint check and background investigation. Fingerprint results and background investigation documentation must be cleared prior to hire. After you begin your employment, your continued employment is contingent upon the outcome of a complete background investigation as determined by the sensitivity level of your position. The investigation must find that you are suitable for Federal employment in your position. If you are found not suitable, you will be terminated after you begin work. If you make a false statement in any part of your application, you may not be hired; you may be fired after you begin work; or subject to possible criminal charges. You may be subject to a credit check as a part of the background investigation process. Qualifications To qualify for this position, your resume must state sufficient experience and/or education, to perform the duties of the specific position for which you are applying. Experience refers to paid and unpaid experience, including volunteer work done through National Service programs (e.g., Peace Corps, AmeriCorps) and other organizations (e.g., professional; philanthropic; religious; spiritual; community; social). You will receive credit for all qualifying experience, including volunteer and part time experience. You must clearly identify the duties and responsibilities in each position held and the total number of hours per week. Basic Requirements • Attention to Detail - Is thorough when performing work and conscientious about attending to detail. • Customer Service - Works with clients and customers (that is, any individuals who use or receive the services or products that your work unit produces, including the general public, individuals who work in the agency, other agencies, or organizations outside the Government) to assess their needs, provide information or assistance, resolve their problems, or satisfy their expectations; knows about available products and services; is committed to providing quality products and services. • Oral Communication - Expresses information (for example, ideas or facts) to individuals or groups effectively, taking into account the audience and nature of the information (for example, technical, sensitive, controversial); makes clear and convincing oral presentations; listens to others, attends to nonverbal cues, and responds appropriately. • Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations. In addition to the Basic Requirements, you must also meet the Minimum Qualifications stated below. Minimum Qualifications GS-13: One (1) year of specialized experience equivalent to at least the GS-12 grade level. Your Resume Must Demonstrate At Least One (1) Year Of Specialized Experience Equivalent To At Least The Next Lower Grade Level In The Federal Service Obtained In Either The Private Or Public Sector Performing The Following Type Of Work And/or Tasks • Develop complex processes to interrogate and parse simple to complex data sources (Health Level 7 (HL7) files, flat files (comma separated value, delimited) and database structures). • Develop Extract Transform Load/Extract Load Transform (ETL/ELT) processes leveraging complex Structured Query Language (SQL) to parse and apply business rules as data transmission formats dictate. • Develop and maintain KORN SHELL scripts, in addition to development of Microsoft SQL Server Reporting Service (SSRS) and SQL Server Integration Services (SSIS) jobs and processes. • Design, development, test and maintain reporting solutions using SQL, Java/Java 2 Platform, Enterprise Edition (J2EE), Python, or comparable supported programming language to generate enterprise reports and/or develop scripts/scripting language to harvest and ingest data. NOTE: Your resume must demonstrate all specialized experience listed above. You must meet all qualification requirements within 30 days of the closing date of the announcement. Education There are no education requirements. Additional information Additional selection(s) of candidates may be possible within 240 days from the date the certificate of eligibles was issued for this announcement. Federal Employees earn annual leave at a rate (4, 6 or 8 hours per pay period) which is based on the number of years they have served as a Federal employee. IHS may offer newly-appointed Federal employees credit for their directly related previous non-federal experience or active duty uniformed military service. This credited service can be used in determining the rate at which they earn annual leave. This position is covered by a Bargaining Unit. This position has no promotion potential. This position is being announced concurrently under the Excepted Service Examining Plan/Merit Promotion (ESEP/MP) procedures. Review vacancy announcement number IHS-25-HQ-12748121-ESEP/MP for eligibility requirements. If you are interested and meet this eligibility requirement, please submit an application under the ESEP/MP vacancy announcement. Read more • Help A career with the U.S. government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new windowLearn more about federal benefits. Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time or intermittent. Contact the hiring agency for more information on the specific benefits offered.

Requirements