Summary

The OIG's Office of Data Analytics is seeking highly motivated technology professionals to support the agency's mission to promote integrity, efficiency, and accountability within the Department of Justice. The Office of Data Analytics collaborates across the OIG and is committed to innovation and delivering results. The incumbent will serve as a Power BI Developer in the Office of Data Analytics. We offer excellent work-life flexibility.

Duties

Help

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.

Requirements

Help

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/

Education

There are no education requirements for this position.

Additional information

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