Information Technology Specialist (Power BI Developer)

Clarification from the agency

U.S. Citizens

As a GS-13 IT Specialist (Power BI Developer), your responsibilities will include, but are not limited to:

• Developing applications and configuring them based on design of such application under direction of Analysts, Subject Matter Experts or an Assistant Director
• Rapidly developing visualizations, dashboards and reusable components using Power BI and maintaining code in appropriate Development, User Acceptance Testing and Production repositories
• Using project management and code management tools for maintaining and managing development tasks in a team environment
• Developing reports that perform within expected response times and assist in identifying bottlenecks in the data flow
• Developing visually pleasing reports that convey maximum amount of information using the least amount of screen real estate
• Developing basic processes that seamlessly integrate data sources from disparate systems and present end results appropriately
• Quickly responding to customer needs by adjusting reports that meet and exceed customer expectations
• Conveying basic report structure and outcomes to team members for feedback and discussion
• Anticipating, identifying and resolving issues during the design phase to prevent problems in the development and deployment stages, thereby avoiding costly rework
• Utilizing advanced decision-making skills to assess complex data scenarios and choose strategies that provide optimal solutions aligned with business objectives
• Demonstrating strong interpersonal skills to build and maintain relationships with stakeholders, facilitating clear communication and understanding of reporting and analytics needs
• Collaborating effectively within a multidisciplinary team environment to ensure seamless integration of Power BI solutions and cross-functional alignment
• Monitoring application performance and conduct tuning when it falls short and also assist with user access requests so that compliance criteria are met
• Developing SQL, DAX, and Python code for data visualization that deliver fast and responsive reports

As a GS-14 IT Specialist (Power BI Developer), your responsibilities will include, but are not limited to:

• Developing applications, configuring them to integrate seamlessly with data stack and other applications, and ensuring attention to details while orchestrating inter-operable systems
• Rapidly developing visualizations, dashboards and reusable components using Power BI or equivalent tools
• Working in DataOps delivery environments such as Agile, Azure DevOps, GitLab, Business Intelligence and Data Analytics
• Designing and implementing analytical visualizations with Power BI associative data model and Script Editor
• Employing visual analytics best practices and development processes
• Developing visually pleasing reports that convey maximum amount of information using the least amount of screen real estate
• Integrating reporting components from multiple data sources
• Analyzing and documenting existing data, data flows, data requirements, and reporting needs
• Quickly responding to customer needs by adjusting reports that meet and exceed customer expectations
• Communicating reports to technical and non-technical audience through oral presentations, briefings, and seminars
• Anticipating, identifying and resolving issues during the design phase to prevent problems in the development and deployment stages, thereby avoiding costly rework
• Utilizing advanced decision-making skills to assess complex data scenarios and choose strategies that provide optimal solutions aligned with business objectives
• Demonstrating strong interpersonal skills to build and maintain relationships with stakeholders, facilitating clear communication and understanding of reporting and analytics needs
• Collaborating effectively within a multidisciplinary team environment to ensure seamless integration of Power BI solutions and cross-functional alignment
• Administering day-to-day application management tasks such as performance tuning and user management activities while ensuring attention to details related to data authorization for individual users and groups

Responsibilities will increase and assignments will become more complex as your training and experience progress.

Conditions of employment

• You must be a U.S. Citizen or National.
• You must be able to obtain and maintain a security clearance.
• You must be registered for the Selective Service, if applicable.
• You must successfully pass and are subject to random drug screenings.
• You must successfully pass and are subject to random drug screenings.
• You may be subject to a probationary period.

Qualifications

Specialized Experience

GS-13
To qualify for this position at the GS-13 grade level, applicants must have at least one year of specialized experience at or above the GS-12 grade level. Specialized experience is defined as experience that is typically in or related to work of the position to be filled and has equipped and has equipped you with the particular knowledge, skills, and abilities to successfully perform the duties of the position. For this position your specialized experience must demonstrate the following:

• Professional experience serving as a Power BI Developer in Azure and/or on-premises environments;
• Professional SQL development experience; and
• Familiarity with Python coding

GS-14
To qualify for this position at the GS-14 grade level, applicants must have at least one year of specialized experience at or above the GS-13 grade level. Specialized experience is defined as experience that is typically in or related to work of the position to be filled and has equipped and has equipped you with the particular knowledge, skills, and abilities to successfully perform the duties of the position. For this position your specialized experience must demonstrate the following:

1. Professional experience serving as a Power BI Senior Developer in Azure and/or on-premises environments;
2. Extensive professional experience in designing and developing code in SQL and Python.

In addition, for all positions your resume must display that you possess IT related experience (paid or unpaid experience and/or completion of specific, intensive training (e.g., IT certification), as appropriate) demonstrating each of the below competencies listed below.

1. Attention to Detail- Is thorough when performing work and conscientious about attending to detail; Minimum Proficiency Level: GS13 - Advanced; GS14 - Advanced
2. 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; Minimum Proficiency Level: GS13 - Advanced; GS14 - Advanced
3. Decision Making- Makes sound, well-informed, and objective decisions; perceives the impact and implications of decisions; commits to action, even in uncertain situations, to accomplish organizational goals; causes change; Minimum Proficiency Level: GS13 - Intermediate; GS14 - Intermediate
4. Information Management-Identifies a need for and knows where or how to gather information; organizes and maintains information or information management systems; Minimum Proficiency Level: GS13 - Advanced; GS14 - Advanced
5. Interpersonal Skills-Shows understanding, friendliness, courtesy, tact, empathy, concern, and politeness to others; develops and maintains effective relationships with others; may include effectively dealing with individuals who are difficult, hostile, or distressed; relates well to people from varied backgrounds and different situations; Minimum Proficiency Level: GS13 - Advanced; GS14 - Advanced
6. 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; Minimum Proficiency Level: GS13 - Intermediate; GS14 - Intermediate
7. Problem Solving-Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations; Minimum Proficiency Level: GS13 - Advanced; GS14-Advanced
8. Teamwork-Encourages and facilitates cooperation, pride, trust, and group identity; fosters commitment and team spirit; works with others to achieve goals; Minimum Proficiency Level: GS13 - Advanced; GS14 - Advanced
9. Technical Competence-Uses knowledge that is acquired through formal training or on-the-job experience to perform one's job; works with, understands, and evaluates technical information related to the job; advises others on technical issues; Minimum Proficiency Level: GS13 - Advanced; GS14-Advanced
10. Application Development- Uses programming languages to script and automate tasks; applies programming languages and skills across multiple platforms or frameworks; Minimum Proficiency Level: GS13 - Advanced; GS14 - Expert
11. Enterprise Report Development- Rapidly develops customer facing visualizations, dashboards and reusable components using Power BI. Works in DataOps delivery environments such as Agile, Azure DevOps, GitLab, Business Intelligence and Data Analytics. Ability to integrate maps from ArcGIS into PBI dashboards, connect external data sets from APIs for dynamic data updates; Minimum Proficiency Level: GS13 - Advanced; GS14 - Expert
12. Data Visualization- Utilizes tools, techniques, and software to generate reports or visualizations that convey data analyses, findings, and limitations; Minimum Proficiency Level: GS13 - Advanced; GS14 - Expert
13. Data Wrangling- Designs and implement analytical visualizations with Power BI associative data model and DAX Scripts. Employs visual analytics best practices, development processes. Integrates reporting components from multiple data sources. Analyzes and document existing data, data flows, data requirements, and reporting needs; Minimum Proficiency Level: GS13 - Advanced; GS14 - Expert

For OPM's definitions of proficiency levels search for "Proficiency Level Scale" at https://www.opm.gov/policy-data-oversight/classification-qualifications/competency-based-policy/general-schedule/2200/2210-competency-based-policy/competency-based-qualification-standard/

How you will be evaluated

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

You will be evaluated by a panel of subject matter experts through the following assessment process:

USA Hire Assessment: Applicants will be required to complete a USAHire Assessment. You will not be considered for the position if you score below the cut score or fail to complete the USAHire assessment. This assessment is online and measures the following competencies:

• Accountability
• Attention to Detail
• Customer Service
• Decision Making
• Flexibility
• Influencing/Negotiating
• Information Management
• Integrity/Honesty
• Interpersonal Skills
• Learning
• Oral Communication
• Problem Solving
• Reading Comprehension
• Reasoning
• Self-Management
• Stress Tolerance
• Teamwork
• Technical Competence

Resume Review: Your resume will be reviewed to determine your technical qualifications.
Interview: Applicants who pass the resume review may be invited to an interview with an interview panel and/or selecting official.
For Category Rating: At the conclusion of the assessment process, qualified candidates will be placed into one of three categories. Best Qualified, Well Qualified, and Qualified.
Best Qualified Category = Meets the basic qualifications requirements described in the "Qualifications" section of this announcement and excels in the Competencies. The category assignment is a measure of the degree in which your background matches the competencies required for this position.
Well Qualified Category : Meets the basic qualifications requirements described in the "Qualifications" section of this announcement and demonstrates proficiency in the Competencies. (This category must be met to be considered under ICTAP procedures)
Qualified Category = Meets the basic qualifications requirements described in the "Qualifications" section of this announcement and demonstrates proficiency in the Competencies. (This category must be met to be considered under ICTAP procedures)

The Category Rating Process does not add veterans' preference points or apply the "rule of three," but protects the rights of veterans by placing them ahead of non-preference eligibles within each category. Preference eligibles who meet the minimum qualification requirements and have a compensable service-connected disability of at least 10 percent or higher will be listed in the highest quality category.

Overstating your qualifications and/or experience in your application materials or application questionnaire may result in your removal from consideration. Cheating on the online assessment may also result in your removal from consideration. If your resume or transcript is incomplete or does not support the responses you provided in your online questionnaire, or if you fail to submit all required documentation before the vacancy closes, you may be rated 'ineligible', 'not qualified', or your score may be adjusted accordingly.

Applicants must complete the USA Assessment and score above the cut score of fail, meet and display in the application package that you meet the Specialized Experience per GS-grade selection, and meet the IT related Competencies listed in this vacancy announcement.

To preview the application questionnaire, click the following link: https://apply.usastaffing.gov/ViewQuestionnaire/12962271

• Resume
  • Your resume must not exceed two (2) pages. If your resume exceeds the two-page limit, you will be removed from consideration for this announcement. The resume and required supporting documentation should provide the minimum qualifications and relevant experience for the announced 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, and 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.
• CTAP/ICTAP documentation (if applicable)
  • Interagency Career Transition Assistance Plan (ICTAP): The ICTAP provides eligible displaced Federal competitive service employees with selection priority over other candidates for competitive service vacancies. If your agency has notified you in writing that you are a displaced employee eligible for ICTAP consideration, you may receive selection priority if: 1) this vacancy is within your ICTAP 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 satisfy all qualification requirements for the vacant position and (for scored examining) score 85 or better on established ranking criteria OR (for category rating criteria) rate equivalent to the Highly Qualified or better category using established category rating criteria. You must provide proof of eligibility with your application to receive selection priority. Such proof may include a copy of your written notification of ICTAP eligibility or a copy of your separation personnel action form. Additional information about ICTAP eligibility is at: https://help.usajobs.gov/working-in-government/unique-hiring-paths/federal-employees/career-transition.
  • The Career Transition Assistance Plan (CTAP): provides eligible surplus and displaced competitive service employees in the Department of Justice with selection priority over other candidates for competitive service vacancies. If your Department of Justice component 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 satisfy all qualification requirements for the vacant position and (for scored examining) score 85 or better on established ranking criteria OR (for category rating criteria) rate equivalent to the Highly Qualified or better category using established category rating criteria. You must provide a copy of your written notification of CTAP eligibility with your application. Additional information about CTAP eligibility is at: https://help.usajobs.gov/working-in-government/unique-hiring-paths/federal-employees/career-transition.
• Veterans' Preference documentation (if applicable)
  • If you are a veteran and you are claiming 5-point veterans' preference, you must submit a copy of your DD-214, Member Copy #4 or other proof of eligibility.
  • If you are a veteran and 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 click here.
• Schedule A documentation (if applicable)
  • DOJ welcomes and encourages applications from persons with disabilities and is firmly committed to satisfying its affirmative obligations under the Rehabilitation Act of 1973 to ensure that persons with disabilities have every opportunity to be hired and advanced on the basis of merit within the Department. DOJ also encourages eligible Schedule A applicants to submit their resumes.

Next steps