Pay Plan, Series & Grade: CS-2210-14
Salary Range: $85,105.00 - $109,648.00
Agency: Office of the Chief Technology Officer (OCTO)
(Citywide Data Warehouse)
Area of Consideration: Open to the General Public
Opening Date: January 15, 2013
Closing Date: Open Until Filled
Duration of Appointment: Permanent
Number of Vacancies: One (1)
Promotion Potential: None
Tour of Duty: 8:30 A.M. - 5:30 P.M.
Collective Bargaining Unit (Non-Union): This position is not in a collective bargaining unit.
This position is located in the District of Columbia, Office of the Chief Technology Officer (OCTO), Application Services - Citywide Data Warehouse (CDW) group. The purpose of the position is to gather and understand business rules and functional and technical requirements, analyze data, develop and deploy complex scheduled and ad hoc reports delivering business intelligence, and create project documentation for District agency related projects or for projects related to the District¿s data catalog (data.dc.gov). The District of Columbia provides public access to city operational data through the Internet to be a more open and transparent government. Citizens can view crime data relative to their neighborhoods, as well as data focused on service requests, public space permits, construction projects, and District procurements.
The program provides a centralized access point for enterprise wide data with a focus on providing data that enables decision support and government transparency. Primary stakeholders include the Executive Office of the Mayor and the Office of the City Administrator whose initiatives are designed to help make the District government accountable and to make government operations as transparent as possible.
Interfaces independently with high level stakeholders via meetings, emails, and phone calls to manage data projects, gather and document requirements; and to gather sample data throughout all phases of the project to ensure data quality.
Works with District agency resources to analyze, compile, verify, and query data as part of data warehousing services. Develops complex SQL queries used by reporting environments and data-driven dashboard applications. Creates metadata and data dictionaries as required.
Creates scripts to identify and correct common errors and data inconsistencies in incoming data. The incumbent will make extensive use of structured query language (SQL).
Designs and implements reports using SQL as well as a variety of reporting and business intelligence tools.
Coordinates all activities with the project manager throughout the full software development life cycle (SDLC), to include, design, development, and testing.
Works with minimal oversight as a technical lead on data-driven reporting and applications development projects.
Performs other related duties as assigned.
Substitution of Education: A substitution of education for required experience will be allowed as defined in OPM's Qualification Standards. However, in order to receive credit, applicants must submit official proof of educational attainment at the time of application.
Time-in-Grade Restrictions: Time in grade restrictions must be met by the closing date of this vacancy announcement.
Specialized Experience: Experience that equipped the applicant with the particular knowledge, skills, and abilities to perform successfully the duties of the position, and that is typically in or related to the work of the position to be filled. To be creditable, at least one (1) year of specialized experience must have been equivalent to at least the next lower grade level in the normal line of progression for the occupation in the organization.
Selective Placement Factor(s): Please respond to the following selective placement factor(s) by either typing directly into the free form area provided or by pasting from a text document.
Selective Placement Factor #1: Five (5) years or more experience as a business analyst with a focus on requirements gathering data analysis. Five (5) years or more experience as a requirements analyst and five (5) years or more experience with SQL and Financial Dashboard creation.
Selective Placement Factor #2: Three (3) or more years of experience analyzing, compiling, verifying, extracting, converting data, validating data and identifying data inconsistencies and errors, experience with government projects and experience with a data warehouse project.
Submission of Ranking Factors: The following ranking factors will be used in the evaluation process. All applicants MUST respond to the ranking factors. Please respond specifically to the ranking factor(s) by either typing directly into the free form area provided or by pasting from a text document. Please describe specific incidents of sustained achievements from your experience that show evidence of the level at which you are applying. You may refer to any experience, education, training, awards, outside activities, etc. that include the degree to which you possess the job related knowledge, skills and abilities described in the ranking factors. The information given in response to the ranking factors should be complete and accurate to the best of your knowledge. FAILURE TO RESPOND TO ALL RANKING FACTORS WILL ELIMINATE YOU FROM CONSIDERATION.
Ranking Factor #1: Extensive experience creating metadata/data dictionaries, and designing and implementing reports, and creating database views used for the purposes of establishing live data feeds as well as the development of data-driven dashboard applications.
Ranking Factor #2: Strong requirements analysis, data analysis, and SQL code development skills.
Ranking Factor #3: Senior-level experience working through the full software development life cycle (SDLC), as well as, managing small IT projects with minimal oversight.
Ranking Factor #4: Demonstrated knowledge of data warehousing concepts and extensive experience working with data architects in the design of database schemas.
Conditions of Employment
Physical Effort: Work is primarily sedentary, and normal physical dexterity is sufficient to perform the various functions of the position.
Working Conditions: The work is performed in an office setting.
Other Significant Factors: A general background investigation is required for positions within the Office of the Chief Technology Officer.
Displaced Employee Priority Placement: Eligibles for the District of Columbia's Displaced Employee Program (DEP) and Agency Reemployment Priority Placement Program (ARPP) will be given priority consideration for this position if found qualified.
Employee Benefits: Selectee will be eligible for health and life insurance, annual (vacation) and sick leave and will be covered under the District of Columbia government's retirement plan. However, if selectee was previously employed in the District of Columbia government under an appointment for which he/she was eligible for Civil Service Retirement (CSR), contributions to CSR will resume upon re-employment.
A person applying for a position in the Career Service, Educational Service, Management Supervisory Service, an attorney position in the Legal Service (series 905) other than in the Senior Executive Attorney Service (SEAS), or an attorney position in the Excepted Service (series 905) who is a bona fide District resident AT THE TIME OF APPLICATION for the position, may be awarded a 10-point residency preference over non-District applicants, unless the person declines the preference points. If selected, the person shall be required to present no less than 8 proofs of bona fide District residency and maintain such residency for 7 consecutive years from the effective date of the appointment. Failure to maintain bona fide District residency for the 7-year period will result in forfeiture of employment.
Information to Applicants
Drug-Free Workplace: Pursuant to the requirements of the Drug-Free Workplace Act of 1988, the individual selected to fill this position will, as a condition of employment, be required to notify his/her immediate supervisor, in writing, not later than five (5) days after conviction of or a plea of guilty to a violation of any criminal drug statute occurring in the workplace.
Veterans Preference: Applicants claiming veterans preference must submit official proof at the time of application.
How to Apply
Disposition of Resume: Resumes received outside the area of consideration and/or after the closing date will not be given consideration. You must resubmit your resume to receive consideration for any subsequent advertised position vacancies. For the purpose of employment, resumes are not considered job applications. Therefore a DC 2000 job application or online job application is required to be submitted.
Contact Information: All inquiries related to employment and job applications should be directed to HR Answers at (202) 442-9700.
Where to Apply (Judiciary Square): D.C. Department of Human Resources (DCHR) Job Center located in the South Lobby at 441 - 4th Street, NW, Washington, D.C. 20001. All inquiries should be directed to HR Answers at (202) 442-9700.
Posting Cancellation: A non-competitive selection of an eligible candidate from the Agency Reemployment Priority Placement Program (ARPP) or the District's Displaced Employee Program (DEP) will result in the cancellation of this announcement.
Notice of Non-Discrimination: In accordance with the D.C. Human Rights Act of 1977, as amended, D.C. Official Code, Section 2-1401.01 et. seq., (Act) the District of Columbia does not discriminate on the basis of actual or perceived: race, color, religion, national origin, sex, age, marital status, personal appearance, sexual orientation, gender identity or expression, familial status, family responsibilities, matriculation, political affiliation, genetic information, disability, source of income, or place of residence or business. Sexual harassment is a form of sex discrimination which is also prohibited by the Act. In addition, harassment based on any of the above protected categories is prohibited by the Act. Discrimination in violation of the Act will not be tolerated. Violators will be subject to disciplinary action.
Equal Opportunity Employer: All qualified candidates will receive consideration without regard to race, color, religion, national origin, sex, age, marital status, personal appearance, sexual orientation, family responsibilities, matriculation, physical handicap, or political affiliation.
EEO Statement: The District of Columbia Government is an Equal Opportunity Employer.
Job Offers: Official Job Offers are made by the Office of Human Resources Only.
Closing Statement: Applicants will only be contacted if an interview is granted.