The Office of Research and Evaluation (ORE) combines empirical evidence and scientific methods to trace the Agency's progress in the fulfillment of its mission. The ORE reports findings to internal and external stakeholders to inform and guide their decisions. With a team of statisticians, analysts, and data management specialists, ORE supports CSOSA's mission and goals.
Summary
The Office of Research and Evaluation (ORE) combines empirical evidence and scientific methods to trace the Agency's progress in the fulfillment of its mission. The ORE reports findings to internal and external stakeholders to inform and guide their decisions. With a team of statisticians, analysts, and data management specialists, ORE supports CSOSA's mission and goals.
Serves as an agency data management authority and performs data management work to plan, develop, implement, and administer systems and databases used to store and retrieve data and develop standards for the handling of data.
Performs data management work to develop and administer databases used to store and retrieve data and develop standards for the handling of data. The work supports the ongoing availability of data that facilitates reporting, client population analysis, predictive studies, and other areas.
Develops interactive Power BI dashboards, reports, metrics, data sets and data flows using Power BI to meet business requirements. Collaborate with stakeholders to understand their data and reporting needs and translate them into effective Power BI solutions. Design and implement efficient data models, ensuring data integrity, accuracy, and optimal performance.
Create and maintain data connections and data refresh schedules to ensure up-to-date and reliable reporting. Design, implement and manage integration between Power BI and Microsoft Azure data platform. Conduct data analysis and provide insights to support business decision making. Optimize Power BI reports and dashboards for performance and usability. Collaborate with cross-functional teams, including data engineers, business analysts, and data scientists, to deliver comprehensive data solutions.
Provide technical guidance and support to end-users, ensuring effective adoption and utilization of Power BI solutions. Document data models, report specifications, and development processes for future reference.
Performs technical troubleshooting, code debugging, and problem solving for data warehousing solutions. Participates in and supports all phases of planning and problem resolution related to data warehousing.
Coordinates implementation of new database strategies on an enterprise-wide basis. Develops and enforces standards and procedures for the storage and retrieval of institutional data. Maintains an accurate and comprehensive inventory of data, data systems, and data storage.
Assists in implementing effective business analytics practices that drive improved decision making, efficiency, and performance.
Uses inductive reasoning and analogy to gain appreciation of how a collection of raw data may be transformed to address the relevant (data) question(s).
Plans and coordinates the development of data structures and access strategies in alignment with business and mission requirements. Communicates with non-technical business users to determine specific business requirements for reports and business intelligence solutions.
Delivers organized, scalable, and meaningful visualizations, and reports for a wide range of customer needs. Builds creative solutions within constraints of existing networks, systems, and policies. Research opportunities for data acquisition and new uses for existing data.
Listens to, and learns from, business process owners to understand the semantic meaning of transactional records and translates that understanding into the design of reports and visualizations that improve operational effectiveness.
Males born after 12-31-59 must be registered for Selective Service, if applicable
Background security investigation, drug test, and favorable adjudication
May be required to successfully complete a one year probationary period (unless already completed).
This is not a virtual or remote position; you must live within or be willing to relocate within a commutable distance of the duty location which is Washington D.C. (District of Columbia).
Qualifications
In order to qualify for this position, you meet all of the following Specialized Experience as stated below.
Basic Requirement: Applicants must have IT-related experience demonstrating each of the four competencies listed below (these competencies must be explained as demonstrated acquired experience in your resume':
Attention to Detail - experience reviewing my own information technology-related work or data and have been asked by others to review their work or data to ensure accuracy, completeness, and consistency with standards. An example of this IT-related experience demonstrating this competency may include Performing database and application performance monitoring.
Customer Service - experience maintaining relationships with customers, assessing current information technology needs of customers, and developing or identifying information technology products and services that are tailored to meet customer needs. An example of this IT-related experience demonstrating this competency may include Creating and maintaining user roles and assigning privileges in database applications.
Oral Communication - briefing mid-level management and IT staff on the status of information technology systems, projects, or daily operations, including the communication of technical information to a non-technical audience. An example of this IT-related experience demonstrating this competency may include Expressing information technology information recommendations to employees and managers.
Problem Solving - identifying alternatives to address complex information technology-related issues by gathering and applying information from a variety of sources that provide a number of potential solutions. An example of this IT-related experience demonstrating this competency may include Assessing and correcting database application configurations.
-AND-
In addition to meeting the Basic Requirement, you must also have: One year of Specialized Experience equivalent in level of difficulty and responsibility to that of the next lower grade (GS-13 or equivalent in other pay scales) within the federal service, which demonstrates the ability to perform the duties of the position, is required.
Specialized experience for this position is defined in four areas (must meet all four areas): 1. IT Data Business Systems Analyst or Business Systems Analyst
Working as an IT Data Business Systems Analyst or a position of similar role analyzing data to understand, document, and improve business processes, products, services, and software for a business, organization, or agency. Communicating the findings and recommendations to key stakeholders.
2. Microsoft (MS) Power BI
Experience using Microsoft (MS) Power BI and its associated software and cloud services as the cloud computing platform to integrate, transform, and consolidate data from various structured and unstructured data systems into a structure that is suitable for building analytics solutions in a data warehouse. Using analytical skills to assess how data-driven operations contribute to the success of an organization.
Developing interactive MS Power BI dashboards, reports, metrics, data sets and data flows using Power BI to meet business requirements. Provide technical guidance and support to end-users, ensuring effective adoption and utilization of Power BI solutions. Document data models, report specifications, and development processes for future reference.
3. Database Management Systems
Experience developing, managing, monitoring, and/or maintaining a major (large) database system or data warehouse and related software that requires the integration of different systems to control data storage, data retrieval, data security, and integrity of data for a sizeable company, organization, agency, or business.
Maintains an accurate and comprehensive inventory of data, data systems, and data storage.
4. Data Management
Which includes experience in the following areas:
Data Mining
Data Storytelling
Data Visualization
Data Modeling
Data Structure
Data Governance
Data Assets
Processing data extracts using data retrieval and management tools.
NOTE: Your resume' must show or demonstrate how you meet all the specialized experience requirements, or you may not receive credit as qualified for this position.
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.
Education
Education is not substitutable for specialized experience at this grade level.
Additional information
If you are a veteran with preference eligibility and are claiming 5-points veterans' preference, you must submit a copy of your DD-214 or other proof of eligibility. If you are claiming 10-point veterans' preference, you must also submit an SF-15, "Application for 10-Point Veterans' Preference" plus the proof required by that form. For more information on veterans' preference visit: https://www.usajobs.gov/Veterans.
If you are an eligible Career Transition Assistance Program (CTAP) or Interagency Career Transition Assistance Program (ICTAP) applicant, you may apply for special selection over other applicants for this position. Individuals who have special priority selection rights under the CTAP or ICTAP must be well qualified for the position. To be well qualified, applicants must satisfy all qualification requirements for the vacant position and meet the mid-level (scoring between 85 and 89) of the rating criteria for all factors or the established cutoff score. CTAP/ICTAP eligibles must submit one of the following as proof of eligibility for the special selection priority: a separation notice; a "Notice of Personnel Action" (SF-50) documenting separation; an agency certification that you cannot be placed after injury compensation has been terminated; an OPM notification that your disability annuity has been terminated; OR a Military Department or National Guard Bureau notification that you are retired under 5 U.S.C. 8337(h) or 8456. Additional information about ICTAP and CTAP eligibility is at: http://www.opm.gov/policy-data-oversight/workforce-restructuring/employee-guide-to-career-transition/.
This vacancy announcement may be used to fill future vacancies for identical positions within the next year.
Relocation expenses are not authorized.
Bargaining Unit Status: Eligible (This position is represented by American Federation of Government Employees, Local 0727)
All Federal employees are required to have Federal salary payments directly deposited into a financial institution of their choosing.
You must meet all qualification requirements within 30 days after the closing date of this announcement and before placement in the position.
CSOSA is an Equal Opportunity Employer.
CSOSA uses E-Verify, if you are selected for this position, the documentation that you present for purposes of completing the Department of Homeland Security (DHS) Form I-9 will be verified through the DHS "E-Verify" System. Federal law requires DHS to use the E-Verify System to verify employment eligibility of all new hires, and as a condition of continued employment obligates the new hire to take affirmative steps to resolve any discrepancies identified by the system.
Position is Mission Essential and is not subject to administrative dismissal in emergencies based on inclement weather conditions, or other emergency situations, as appropriate. A Mission Essential employee is required to report for, or remain at, work in emergency situations; dismissal or closure announcements do not apply to him/her unless his/her supervisor instructs otherwise.
If you are currently, or have been within the last 5 years, a political Schedule A, Schedule C, Non-career SES or Presidential Appointee employee in the Executive Branch, you must disclose this information to the Human Resources Office.
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.
Your application will be rated under Category Rating Procedures and be placed in one of three categories: Highly Qualified (highly proficient with an overall comprehensive level of knowledge, skills, and abilities of the job based on a complete review of experience, education and training), Well Qualified (competent in the position with an overall accomplished level of knowledge, skills, and abilities of the job based on a complete review of experience, education and training), or Qualified (an overall basic level of knowledge, skills and abilities of the job based on a complete review of your experience, education and training). With the exception of positions which are professional and scientific at the GS-09 (or equivalent) and above, qualified preference eligibles with a compensable service-connected disability of 30-percent or more (CPS) and those with a compensable service-connected disability of at least 10-percent but less than 30-percent (CP) move from the category in which they would otherwise be placed to the top of the highest quality category. Within these categories, applicants eligible for Veterans' Preference will receive selection priority over non-veteran preference eligibles.
Your qualifications will be evaluated on the following competencies (knowledge, skills, abilities and other characteristics):
Attention to Detail
Computer Skills
Customer Service
Data Business Systems Analyst
Data Engineering
Data Governance
Data Management
Data Modeling
Data Storytelling
Data Structure
Data Systems
Data Visualization
Database Administration
Database Management Systems
IT Business Systems Analyst (Analysis)
Oral Communication
Partnering
Problem Solving
Reasoning
Research
Technical Competence
Your application will be evaluated according to the extent and quality of experience, education, and training. If you meet the basic qualification requirements, your resume, online questionnaire and the documentation you submitted to support your responses will be evaluated against the knowledge, skills, and abilities and the result of the additional assessments required for this position. The assessments measure the critical competencies that are required to successfully perform the job. This evaluation determines which candidates will be referred to the selecting official for consideration.
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.
You must submit a complete Application Package which includes:
-Your responses to the Online Occupational Questionnaire (This is completed automatically during the apply online process).To apply for this position,
- Your resume' showing work schedule, hours worked per week, dates of employment and duties performed.
- Other supporting documents:
- Cover Letter, optional
- College transcript(s), if qualifying based on education
- Most recent SF-50, "Notification of Personnel Action" showing you are/were in the competitive service and the highest grade or promotion potential held (if applying as a status candidate with current or former Federal Service)
- DD-214, SF-15 Form and VA letter, or certification of expected discharge or release from active duty from Veterans for consideration under Veteran hiring authorities
- Noncompetitive appointment authority documentation, if applicable
- Career Transition Assistance Program/Interagency Career Transition Assistance Program Documentation, if applicable (e.g. Certification of Expected Separation, Reduction-In-Force Separation Notice, or Notice of Proposed Removal; SF-50 that documents the RIF separation action; and most recent performance appraisal.)
If you are relying on your education to meet qualification requirements:
Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.
To apply for this position, you must complete the online application and submit the documentation specified in the Required Documents section below.
A complete application package must be submitted by 11:59 PM (EST) on the closing date of the announcement to receive consideration.
- To begin, click Apply to access the online application. You will need to be logged into your USAJOBS account to apply. If you do not have a USAJOBS account, you will need to create one before beginning the application.
- Follow the prompts to select your resume' and/or other supporting documents to be included with your application package. You will have the opportunity to upload additional documents to include in your application before it is submitted. Your uploaded documents may take several hours to clear the virus scan process.
- After acknowledging you have reviewed your application package, complete the Include Personal Information section as you deem appropriate and click to continue with the application process.
- You will be taken to the online application which you must complete in order to apply for the position. Complete the online application, verify the required documentation is included with your application package, and submit the application.
To verify the status of your application, log into your USAJOBS account (https://my.usajobs.gov/Account/Login), all of your applications will appear on the Welcome screen. The Application Status will appear along with the date your application was last updated. For information on what each Application Status means, visit: https://www.usajobs.gov/Help/how-to/application/status/.
- If you are unable to apply online, you must request an alternative application which is available from the Human Resources Office. Please contact at or to obtain an alternative application.
CSOSA
800 North Capitol Street NW Suite 700
Washington DC, DC 20002
US
Next steps
Once you successfully complete the application process, you will receive an acknowledgement e-mail of receipt. Your application package will be reviewed to ensure you meet the basic eligibility and qualifications requirements. A review will be made of your online questionnaire and the documentation you submitted to support your responses. A list of highly qualified applicants will be created and sent to the selecting official, and you will be notified via email if this occurs. The selecting official may choose to conduct interviews, and once the selection is made, you will receive a notification of the decision.
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
You must submit a complete Application Package which includes:
-Your responses to the Online Occupational Questionnaire (This is completed automatically during the apply online process).To apply for this position,
- Your resume' showing work schedule, hours worked per week, dates of employment and duties performed.
- Other supporting documents:
- Cover Letter, optional
- College transcript(s), if qualifying based on education
- Most recent SF-50, "Notification of Personnel Action" showing you are/were in the competitive service and the highest grade or promotion potential held (if applying as a status candidate with current or former Federal Service)
- DD-214, SF-15 Form and VA letter, or certification of expected discharge or release from active duty from Veterans for consideration under Veteran hiring authorities
- Noncompetitive appointment authority documentation, if applicable
- Career Transition Assistance Program/Interagency Career Transition Assistance Program Documentation, if applicable (e.g. Certification of Expected Separation, Reduction-In-Force Separation Notice, or Notice of Proposed Removal; SF-50 that documents the RIF separation action; and most recent performance appraisal.)
If you are relying on your education to meet qualification requirements:
Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.
To apply for this position, you must complete the online application and submit the documentation specified in the Required Documents section below.
A complete application package must be submitted by 11:59 PM (EST) on the closing date of the announcement to receive consideration.
- To begin, click Apply to access the online application. You will need to be logged into your USAJOBS account to apply. If you do not have a USAJOBS account, you will need to create one before beginning the application.
- Follow the prompts to select your resume' and/or other supporting documents to be included with your application package. You will have the opportunity to upload additional documents to include in your application before it is submitted. Your uploaded documents may take several hours to clear the virus scan process.
- After acknowledging you have reviewed your application package, complete the Include Personal Information section as you deem appropriate and click to continue with the application process.
- You will be taken to the online application which you must complete in order to apply for the position. Complete the online application, verify the required documentation is included with your application package, and submit the application.
To verify the status of your application, log into your USAJOBS account (https://my.usajobs.gov/Account/Login), all of your applications will appear on the Welcome screen. The Application Status will appear along with the date your application was last updated. For information on what each Application Status means, visit: https://www.usajobs.gov/Help/how-to/application/status/.
- If you are unable to apply online, you must request an alternative application which is available from the Human Resources Office. Please contact at or to obtain an alternative application.
CSOSA
800 North Capitol Street NW Suite 700
Washington DC, DC 20002
US
Next steps
Once you successfully complete the application process, you will receive an acknowledgement e-mail of receipt. Your application package will be reviewed to ensure you meet the basic eligibility and qualifications requirements. A review will be made of your online questionnaire and the documentation you submitted to support your responses. A list of highly qualified applicants will be created and sent to the selecting official, and you will be notified via email if this occurs. The selecting official may choose to conduct interviews, and once the selection is made, you will receive a notification of the decision.
Fair and transparent
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
