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. Responsibilities 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 Conditions of Employment 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: Professional experience serving as a Power BI Senior Developer in Azure and/or on-premises environments; 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. Attention to Detail- Is thorough when performing work and conscientious about attending to detail; Minimum Proficiency Level: GS13 - Advanced; GS14 - Advanced 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 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 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 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 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 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 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 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 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 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 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 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 DOJ EEO Statement/Policy: http://www.justice.gov/jmd/eeos/08-eeo-policy.pdfAs the federal agency whose mission is to ensure the fair and impartial administration of justice for all Americans, the Department of Justice is committed to fostering a diverse and inclusive work environment. To build and retain a workforce that reflects the diverse experiences and perspectives of the American people, we welcome applicants from the many communities, identities, races, ethnicities, backgrounds, abilities, religions, and cultures of the United States who share our commitment to public service. Reasonable Accommodation (RA) Requests: If you believe you have a disability (i.e., physical or mental), covered by the Rehabilitation Act of 1973 as amended and Americans with Disabilities Act 1990 as amended, that would interfere with completing the USA Hire Competency Based Assessments, you will be granted the opportunity to request a RA in your online application. Requests for RA for the USA Hire Competency Based Assessments and appropriate supporting documentation for RA must be received prior to starting the USA Hire Competency Based Assessments. Decisions on requests for RA are made on a case-by-case basis. If you meet the minimum qualifications of the position, after notification of the adjudication of your request, you will receive an email invitation to complete the USA Hire Competency Based Assessments. You must complete all assessments within 48 hours of receiving the URL to access the USA Hire Competency Based Assessments, if you received the link after the close of the announcement. To determine if you need a RA, please review the Procedures for Requesting a Reasonable Accommodation for Online Assessments here: https://help.usastaffing.gov/Apply/index.php?title=Reasonable\Accommodations\for\USA\Hire Selective Service: If you are a male applicant born after December 31, 1959, you must certify that you have registered with the Selective Service System, or are exempt from having to do so under the Selective Service Law. Additional information is found at: www.sss.gov.
