Skip to main content
U.S. flag

IT Specialist (Data Mgmt/Ent Arch) (Open to both U.S. Citizens and Federal Employees)

Department of Transportation
Office of the Secretary of Transportation
This job announcement has closed

Summary

The Volpe Center is seeking an IT Specialist (Data Mgmt/Ent Arch) to serve as the primary information technology (IT) data architect for the Center's Data Warehouse working under the authority, policies, and directives of the DOT Chief Information Officer and in close regular partnership with the Volpe Director of the Office of Information Technology.
This technical lead provides design, development, data integrity, operations, and reporting services to Volpe Center staff.
 

Overview

Help
Hiring complete
Open date: 03/21/2022
Closed date: 04/11/2022
Location
1 vacancy in the following location:
Work site options
Telework eligible
Yes—as determined by the agency policy.
Relocation expenses reimbursed
No
Salary
$124,851 - $162,305 per year
Pay scale & grade
GS 14
Promotion potential
14
Pay scale and grade determines the salary of the job.
Work schedule
Full-time - Full Time
Travel Required
Occasional travel - Position may require some travel.
Appointment type
Permanent
Occupations and job series
Supervisory status
No
Federal service type
This job is in the Competitive Service
Drug test
No
Security clearance
Other
Position sensitivity and risk
Noncritical-Sensitive (NCS)/Moderate Risk
Jobs require a background check and some require a security clearance. The type depends on the job.
Background check type
Announcement number
OST.RVOLPE-2022-0024
Control number
643900500

Videos

Duties

Help

As a IT Specialist (Data Mgmt/Ent Arch), you will:

  • Design, develop, implement, and maintain effective, and cost-efficient data architecture that supports mission requirements in the context of the Volpe Center's Data Warehouse Architecture. Conduct data architecture analysis, documentation, and reporting activities and supervises the work of support contractors as a subject matter expert.
  • Work with end-users to establish and enforce database standards, procedures, and guidelines. Plan future database expansion, enhancements, and selections. Analyzes, reviews, and recommends upgrades for existing databases.
  • Plan and coordinate the design and development of Data Warehouses or Data Marts that meet business and mission requirements. Lead projects to develop and implement meta-schema.
  • Provide IT program/project management, leadership, and subject matter expertise to include Federal and industry approaches to IT strategic planning, best practices, IT systems development lifecycles, risk management, earned value management, acquisition planning, IT security practices, and Federal IT capital planning and investment management. Actively participates in and coordinates activities in the agency's Enterprise Architecture, IT Security, and IT Capital Planning processes, constructing detailed plans for IT programs/projects in accordance with Federal law, as well as guidance from DOT, and OMB. Participates in the Agency's IT strategic planning activities. Provide input for the long- and short-range strategies, including budget projects, and prepares annual plans and performance forecasts

The ideal candidate is an expert in the development and utilization of enterprise data warehousing and supporting data architecture who leads and manages the design, maintenance and implementation activities. The ideal candidate is an expert in database configuration and optimization, data integration from multiple sources, ensuring data quality, and developing reporting and analytical services, and has deployed and operated a data warehouse in a cloud environment. Additionally, the candidate has the knowledge and experience to help create and implement a shared vision of how to improve and enhance the current Volpe Center Data Warehouse and communicate the vision to upper management and staff. The ideal candidate also has expert knowledge of Microsoft SQL Server and associated services and tools. The ideal candidate has practical understanding of financial analysis and accounting concepts.

This position is telework eligible

Requirements

Help

Conditions of employment

  • You must be a U.S.Citizen and eligible for consideration.
  • You must meet specialized experience to qualify.
  • Required documents must be submitted by the closing date.
  • Submit application and resume online by 11:59 PM EST on the closing date.

CONDITIONS OF EMPLOYMENT:

  • SELECTIVE SERVICE: Males born after 12/31/1959 must be registered for the Selective Service.
  • PROBATIONARY PERIOD: You must complete a one-year probationary period (unless already completed).
  • TIME-IN-GRADE: Federal applicants must have served 52 weeks at the next lower grade in the competitive or excepted service in the executive branch to satisfy time-in-grade restrictions contained in 5 CFR 300, Subpart F.
  • DEU REQUIREMENTS: Applicants selected under delegated examining procedures may be required to successfully complete a one-year probationary period (unless already completed).
  • EEO STATEMENT: The Department of Transportation (DOT) maintains a model federal work environment that is free of discrimination. DOT ensures equal employment opportunity for employees and applicants for employment, regardless of race, color, national origin, religion, sex (including pregnancy and gender identity), genetic information, age, disability, sexual orientation, or protected activity.

Qualifications

To meet the minimum qualifications for this position, you must meet the specialized experience qualifications for the grade at which you are requesting consideration.

To qualify for the GS-14, you must have at least one year of specialized experience equal or equivalent to the GS-13 grade level in the following:

  • Experience leading the design, administration, and performance enhancement functions for an enterprise data warehouse using Microsoft SQL Server and associated Microsoft SQL tools and services. This includes experience in data warehouse maintenance, optimization, data integration, data quality validation, and data reporting and visualization services.
  • Experience deploying and operating a data warehouse in a cloud environment and identifying data warehouse solutions, tools, visualizations, and enhancements to meet the enterprise organizational goals and objectives. This includes experience identifying current trends and innovations occurring in the database and data warehouse industry.
  • Experience collaborating with management and data warehouse users to obtain feedback on current system performance and suggested improvements and identify, design, and implement solutions to address feedback and suggested improvements.

KNOWLEDGE, SKILLS AND ABILITIES (KSAs): Your qualifications will be evaluated on the basis of your level of knowledge, skills, abilities and/or competencies in the following areas:

  • Information Technology Architecture - Knowledge of architectural methodologies used in the design and development of information systems, including the physical structure of a system's internal operations and interactions with other systems.
  • Database Administration - Knowledge of the principles, methods, and tools for automating, developing, implementing, or administering database systems.
  • Database Management Systems - Knowledge of the uses of database management systems and software to control the organization, storage, retrieval, security, and integrity of data
  • Project Management - Knowledge of the principles, methods, or tools for developing, scheduling, coordinating, and managing projects and resources, including monitoring and inspecting costs, work, and contractor performance.
  • 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.

For all types of consideration, 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.

For additional information about applying to Federal positions, please click on the following link: https://www.opm.gov/policy-data-oversight/classification-qualifications/general-schedule-qualification-policies/#url=e4

Other applicants must meet all qualification requirements by the closing date of this announcement.

Education

This job does not have an education qualification requirement.

Additional information

PLEASE NOTE: 

  • This is a Bargaining unit position represented by National Association of Government Employees (NAGE), Local R1-195.

COVID VACCINATION:  If selected, you will be required to provide information regarding your COVID-19 vaccination status for the purposes of implementing workplace safety protocols, such as protocols related to masking, physical distancing, testing, travel, and quarantine.

This announcement may be used to fill additional positions if similar vacancies occur within 90 days of the issue date of the referral certificate.

How you will be evaluated

You will be evaluated for this job based on how well you meet the qualifications above.

DESCRIBING YOUR EXPERIENCE: PLEASE BE CLEAR AND SPECIFIC. WE WILL NOT MAKE ASSUMPTIONS REGARDING YOUR EXPERIENCE. If your resume/ application does not support your questionnaire answers, we will not allow credit for your response(s). Your resume must contain sufficiently detailed information upon which to make a qualification determination. Please ensure that your resume contains specific information such as position titles, beginning and ending dates of employment for each position, average number of hours worked per week, and if the position is/was in the Federal government, you should provide the position series and grade level. 


To compete with U.S. Citizens:  If you meet the qualification requirements, your application will be placed in one of two categories: Qualified and Well Qualified which is based upon your responses to the vacancy questions. Within these categories, applicants eligible for veteran's preference that have provided supporting documents will receive selection priority over non-veterans. The top rated applications will be reviewed for the quality of your experience, education and training relevant to the position.


To compete with other competitive status government employees: If you meet the qualification requirements, your application will be scored based upon your responses to the vacancy questions. The top rated applications will be reviewed for the quality of your experience, education and training relevant to the position. If referred, all relevant documents including performance appraisals and awards submitted with your application package will be forwarded to the hiring official for review.

Eligible Federal employees also seeking consideration for noncompetitive reassignment for this position, must indicate interest in the assessment. In eligibility question 14: select Yes/Other/Former Incumbency of a Position brought into the Competitive Service. Noncompetitive federal candidates must have competitive status on a SF-50, meet minimum qualifications, have served at the same grade or higher, and held or exceeded the promotion potential of this position.

All applicants:  Your application will be rated on the extent and quality of your experience, education and training relevant to the position. The answers you select in the on-line process must be substantiated in your application package.  If upon review, it is determined that your described work history, competencies, and/or supporting documents do not support your answer choices, your application may be updated on your behalf or you may not be referred to the selecting official. Please ensure that your work history provides enough details to support your answers. The Automated Staffing Office is ultimately responsible for determining your final rating.


You may preview questions for this vacancy.

Office of the Secretary of Transportation

Agency contact information

Automated Staffing Office
Phone
000-000-0000
Fax
000-000-0000
Email
TRANSJOBS@dot.gov
Address
DOT, OFFICE OF THE SECRETARY
1200 New Jersey Ave., SE / HAHR-50
Washington, District of Columbia 20590
United States

Visit our careers page

Learn more about what it's like to work at Office of the Secretary of Transportation, what the agency does, and about the types of careers this agency offers.

https://www.youtube.com/embed/x_XVSqMtGno?rel=0

Your session is about to expire!

Your USAJOBS session will expire due to inactivity in 8 minutes. Any unsaved data will be lost if you allow the session to expire. Click the button below to continue your session.