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.
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.
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.
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.
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.
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.
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.
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.
RESUME - All applicants must provide a resume created within USA Jobs Resume Builder, that shows relevant experience, education and support the required specialized experience. Formatted resumes can by uploaded later in the application process.
PERFORMANCE APPRAISALS/INCENTIVE AWARDS: If applicable, performance appraisals and/or Incentive award documentation may be submitted and forwarded to the selecting official in consideration of your application. To receive credit, submit a recent performance appraisal (dated within 18 months) showing the official rating of record, signed by a supervisor, or statement why the performance appraisal is unavailable (do not submit a performance plan) and/or incentive award documentation dated within the last 18 months (i.e. performance awards, special act or achievement awards, quality step increases, etc.).
VETERANS: Your last DD214 (member 4 copy), Certificate of Release or Discharge From Active Duty, that shows the type of discharge and all dates of active duty is required to verify your eligibility.
If applying to a vacancy opened to all US Citizens under category rating and wish to be considered as a preference eligible, you need to submit a copy of your DD214 (member-4 copy).
If claiming preference eligibility as a disabled veteran, you must submit proof of entitlement of this preference which is normally a valid letter from the Department of Veterans Affairs certifying to the present existence of the service-connected disability and indicating the percentage of your disability. An SF-15 is desired, but not required.
If applying to a vacancy opened Status and you are requesting consideration under Veteran's Employment Opportunity Act (VEOA) (https://www.fedshirevets.gov/job/shav/#veoa), you need to provide a copy of your last DD214 (member-4 copy), which verifies your military service dates, reason for separation, OR certification of separation that shows a discharge date within 120 days of the closing of this announcement, and eligibility for consideration under the Veterans Employment Opportunity Act.
FEDERAL APPLICANTS: You must submit SF-50(s) that verify your highest competitive grade, full performance level, and eligibility as a federal applicant. DO NOT submit an award SF-50 as these often do not verify grade or eligibility. For consideration for a promotion, Box 4 of the SF-50 must show a date that is at least 52 weeks prior to the job announcement closing. We recommend submitting your last promotion SF-50 or within-grade increase SF-50. Pay adjustment raise SF-50s for the current year will not support the 52 weeks’ time-in-grade requirements. https://www.usajobs.gov/Help/working-in-government/service/SF-50/
NON COMPETITIVE APPLICANTS: If requesting concurrent consideration for Non-competitive (NC) appointment eligibility, you must provide the appropriate SPECIAL APPOINTING AUTHORITY DOCUMENTS, such as PCS orders (military spouse) describing move & marriage certificate; letter from VA or DD214 describing 100% disability of spouse; letter from State Vocational Office certifying disability (schedule A), etc. For more information, visit military spouse NC appointments or Persons with Disabilities NC appointments.
DISPLACED EMPLOYEES: If requesting consideration under the Career Transition Assistance Program (CTAP) or Interagency CTAP program (ICTAP), you must meet the well qualified standards for this vacancy (meeting minimum requirements for position and scoring at least an 85) and provide all of the following documents:
your most recent performance appraisal,
the proof of eligibility letter from the Agency, and
your most current SF-50, displaying current series and grade.
Failure to submit any of the required documents by the closing date of the vacancy will result in your removal from consideration for this position. Please review your application prior to final submission and ensure you have submitted all appropriate documents. Uploading documents to USA Jobs does NOT ensure inclusion with your application to our system. You must verify that the documents are in the system with your application prior to final submission.
You must submit a complete application package (including resume, vacancy questions and supporting documents) no later than 11:59 (EST) on the closing date of the announcement.
To begin, click the "Apply Online" button on the job announcement posting.
Follow the directions to register, submit all required documents and complete the assessment questionnaire.
You may review your saved application(s) at https://my.usajobs.gov.
If you are having difficulty applying online, please contact the DOT Automated Staffing Office via email at: Transjobs@dot.gov
DOT, OFFICE OF THE SECRETARY
1200 New Jersey Ave., SE / HAHR-50
Washington, District of Columbia 20590
United States
Next steps
You may check your application status by logging into USAJobs.com. (Select "My USAJOBS" and click "Applications"). Within two weeks of the closing date, a Human Resources Specialist will evaluate your application. Ratings will be determined based on the documents and information received by the closing date. Qualified candidates will be assigned a category, not including points that may be assigned for veterans' preference. If the vacancy is advertised under status, your application will be scored on a scale between 70 - 100. The most highly qualified candidates are then referred to the hiring manager for further consideration. If the vacancy was advertised under category rating, then the appropriate veteran's preference will be applied. If you are selected for an interview, the hiring agency will contact you directly. Once the position is filled, we will notify all applicants of their final status.
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
RESUME - All applicants must provide a resume created within USA Jobs Resume Builder, that shows relevant experience, education and support the required specialized experience. Formatted resumes can by uploaded later in the application process.
PERFORMANCE APPRAISALS/INCENTIVE AWARDS: If applicable, performance appraisals and/or Incentive award documentation may be submitted and forwarded to the selecting official in consideration of your application. To receive credit, submit a recent performance appraisal (dated within 18 months) showing the official rating of record, signed by a supervisor, or statement why the performance appraisal is unavailable (do not submit a performance plan) and/or incentive award documentation dated within the last 18 months (i.e. performance awards, special act or achievement awards, quality step increases, etc.).
VETERANS: Your last DD214 (member 4 copy), Certificate of Release or Discharge From Active Duty, that shows the type of discharge and all dates of active duty is required to verify your eligibility.
If applying to a vacancy opened to all US Citizens under category rating and wish to be considered as a preference eligible, you need to submit a copy of your DD214 (member-4 copy).
If claiming preference eligibility as a disabled veteran, you must submit proof of entitlement of this preference which is normally a valid letter from the Department of Veterans Affairs certifying to the present existence of the service-connected disability and indicating the percentage of your disability. An SF-15 is desired, but not required.
If applying to a vacancy opened Status and you are requesting consideration under Veteran's Employment Opportunity Act (VEOA) (https://www.fedshirevets.gov/job/shav/#veoa), you need to provide a copy of your last DD214 (member-4 copy), which verifies your military service dates, reason for separation, OR certification of separation that shows a discharge date within 120 days of the closing of this announcement, and eligibility for consideration under the Veterans Employment Opportunity Act.
FEDERAL APPLICANTS: You must submit SF-50(s) that verify your highest competitive grade, full performance level, and eligibility as a federal applicant. DO NOT submit an award SF-50 as these often do not verify grade or eligibility. For consideration for a promotion, Box 4 of the SF-50 must show a date that is at least 52 weeks prior to the job announcement closing. We recommend submitting your last promotion SF-50 or within-grade increase SF-50. Pay adjustment raise SF-50s for the current year will not support the 52 weeks’ time-in-grade requirements. https://www.usajobs.gov/Help/working-in-government/service/SF-50/
NON COMPETITIVE APPLICANTS: If requesting concurrent consideration for Non-competitive (NC) appointment eligibility, you must provide the appropriate SPECIAL APPOINTING AUTHORITY DOCUMENTS, such as PCS orders (military spouse) describing move & marriage certificate; letter from VA or DD214 describing 100% disability of spouse; letter from State Vocational Office certifying disability (schedule A), etc. For more information, visit military spouse NC appointments or Persons with Disabilities NC appointments.
DISPLACED EMPLOYEES: If requesting consideration under the Career Transition Assistance Program (CTAP) or Interagency CTAP program (ICTAP), you must meet the well qualified standards for this vacancy (meeting minimum requirements for position and scoring at least an 85) and provide all of the following documents:
your most recent performance appraisal,
the proof of eligibility letter from the Agency, and
your most current SF-50, displaying current series and grade.
Failure to submit any of the required documents by the closing date of the vacancy will result in your removal from consideration for this position. Please review your application prior to final submission and ensure you have submitted all appropriate documents. Uploading documents to USA Jobs does NOT ensure inclusion with your application to our system. You must verify that the documents are in the system with your application prior to final submission.
You must submit a complete application package (including resume, vacancy questions and supporting documents) no later than 11:59 (EST) on the closing date of the announcement.
To begin, click the "Apply Online" button on the job announcement posting.
Follow the directions to register, submit all required documents and complete the assessment questionnaire.
You may review your saved application(s) at https://my.usajobs.gov.
If you are having difficulty applying online, please contact the DOT Automated Staffing Office via email at: Transjobs@dot.gov
DOT, OFFICE OF THE SECRETARY
1200 New Jersey Ave., SE / HAHR-50
Washington, District of Columbia 20590
United States
Next steps
You may check your application status by logging into USAJobs.com. (Select "My USAJOBS" and click "Applications"). Within two weeks of the closing date, a Human Resources Specialist will evaluate your application. Ratings will be determined based on the documents and information received by the closing date. Qualified candidates will be assigned a category, not including points that may be assigned for veterans' preference. If the vacancy is advertised under status, your application will be scored on a scale between 70 - 100. The most highly qualified candidates are then referred to the hiring manager for further consideration. If the vacancy was advertised under category rating, then the appropriate veteran's preference will be applied. If you are selected for an interview, the hiring agency will contact you directly. Once the position is filled, we will notify all applicants of their final status.
Fair and transparent
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.