IT Specialist (Data Engineer)
Role details
Job location
Tech stack
Job description
The Division of Data (DoD or Division) serves as the leading authority on developing, implementing, and operating the Commission's data strategies. The Division is comprised of the Data Operations and Standards Branch (DOSB) and the Enterprise Data Analytics (EDA) section. This position is in the DOSB Branch., As a Data Engineer, you will:
- Design, implement, and maintain enterprise data environments including data lakes, data warehouses, and lakehouse architectures.
- Develop normalized, dimensional, star, and snowflake models to support advanced analytics.
- Build ETL/ELT pipelines for structured and semi-structured datasets and implement automated data quality monitoring.
- Develop and manage event-driven and streaming data pipelines using modern orchestration frameworks.
- Implement data governance, classification, retention, and stewardship practices aligned to federal standards.
- Apply Zero Trust security principles and support ATO processes consistent with NIST SP 800-53, FISMA, and FedRAMP., As a condition of employment for accepting this position, you may be required to serve a 1-year probationary period during which we will evaluate your fitness and whether your continued employment advances the public interest. In determining if your employment advances the public interest, we may consider:
- Your performance and conduct;
- The needs and interests of the agency;
- Whether your continued employment would advance organizational goals of the agency or the Government;
More than the number of positions listed may be filled through this vacancy announcement.
The overall salary range is provided for informational purposes as it represents the full range that is applicable to current employees in this occupation/grade. A new hire's direct and overall experience are critical factors in determining a salary offer, therefore, it is important that your resume fully reflects all of your work experience. Note that the upper end of each range is typically applicable only to candidates with significant years of work experience and qualifications Please review the CFTC Compensation Program website for additional information.
The law prohibits public officials from appointing, promoting, or recommending their relatives. The law prohibits requesting, making, transmitting, accepting, or considering political recommendations for employment or other personnel actions for non-political positions. This includes recommendations from Members of Congress, Congressional employees, elected state or local officials, and political party officials and any recommendation based on party affiliation.
Candidates should be committed to improving the efficiency of the Federal government, passionate about the ideals of our American republic, and committed to upholding the rule of law and the United States Constitution., Your application will be evaluated to determine if you meet the minimum qualifications required for this position. Applicants who meet the minimum qualifications will be evaluated against the core competencies required for this role using the assessment method(s) listed below.
SME Evaluative Review:
Your application will be evaluated through an SME Evaluative Review. Subject Matter Experts (SMEs) will independently review your resume to assess how well your experience demonstrates the required competencies for this position. SMEs will assign scores based on the strength, relevance, and clarity of the information provided in your resume. These individual evaluations will then be combined to determine your final score or rating category.
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; student; social). Volunteer work helps build critical competencies, knowledge, and skills and can provide valuable training and experience that translates directly to paid employment. You will receive credit for all qualifying experience, including volunteer experience., * Resume showing all relevant and related experience (two pages max). If selected, your resume will be used to determine your initial pay setting decision;
- Cover Letter (optional);
- Performance appraisal (optional);
Veterans Preference: If you are entitled to veteran preference, you should indicate the type of veteran preference you are claiming on your resume. In order to verify your veteran preference entitlement, please submit a copy of your veteran's documentation including a DD-214 (member 4 copy preferred, however, the documentation provided must contain dates and character of service); official statement of service from your command if you are currently on active duty; or other official documentation (e.g., documentation of receipt of a campaign badge or expeditionary medal) that shows your military service was performed under honorable conditions. In addition, if you are a disabled veteran, a Purple Heart recipient, or widow/widower of a veteran, the spouse of a disabled veteran or the natural mother of a disabled or deceased veteran, you must submit a Standard Form (SF) 15, "Application for 10-Point Veteran Preference," and the other required documentation identified on the reverse side of the SF-15 to support your preference claim. Although veteran preference points are not assigned under the category rating procedures described under "How You Will Be Evaluated," veteran preference eligibles are listed ahead of non-veterans within each category for which they are qualified., 3. A copy of your most recent SF-50 noting current or last position held, the grade level, and the duty location; and
- A copy of your notice of proposed removal for declining a directed reassignment or transfer of function outside the local commuting area or documentation showing you were separated as a result of RIF or declining a directed reassignment or transfer of function outside the local commuting area.
Requirements
Do you have experience in Security compliance frameworks implementation?, * Background/Security Investigation
- May be required to serve a one-year probationary period
- Selective Service Registration is required for males born after 12/31/1959
You will be evaluated on the basis of your level of competency (knowledge, skills and abilities) in the following areas:
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.
Information Management - Identifies a need for and knows where or how to gather information; organizes and maintains information or information management systems.
Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations., CT-13: To qualify for the CT-13 level you must have at least one year of specialized experience equivalent to the next lower grade (GS/CT-12 level). Specialized experience is defined that through which one has gained experience:
- Designing and implementing enterprise data architecture, pipelines, and modeling solutions
- Applying federal data governance and security frameworks
- Developing data integration and orchestration solutions
- Supporting BI, analytics, and/or machine learning workflows
- Applying DevOps practices to data engineering
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; student; social). Volunteer work helps build critical competencies, knowledge, and skills and can provide valuable training and experience that translates directly to paid employment. You will receive credit for all qualifying experience, including volunteer experience., This job does not have an education qualification requirement., Career Transition Assistance Program (CTAP): Provides eligible surplus and displaced competitive service employees in the CFTC with selection priority over other candidates for competitive service vacancies. If CFTC has notified you in writing that you are a surplus or displaced employee eligible for CTAP consideration, you may receive selection priority if: 1) this vacancy is within your CTAP eligibility, 2) you apply under the instructions in this announcement, and 3) you are found well-qualified for this vacancy. To be well qualified, you must rate equivalent to the Well Qualified or better category using established rating criteria. You must provide a copy of your written notification of CTAP eligibility with your application. Additional information about CTAP eligibility is at: http://www.opm.gov/ctap/index.asp., Position sensitivity and risk Moderate Risk (MR) Jobs require a background check and some require a security clearance. The type depends on the job. Background check type
- Suitability/Fitness
Financial disclosure required No Some jobs require financial disclosure to identify conflicts of interests.
Benefits & conditions
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.
Review our 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.