Programmer Analyst III

Fairfax County•Fairfax (Ej26), VA

3d•Hybrid

About The Position

Fairfax County is seeking an innovative Programmer Analyst to join the Department of Planning and Development. This role will be the sole development resource within the department, focusing on building its data analytics and reporting program. The position involves developing SQL code, Power BI dashboards, Power Apps, Power Automate solutions, and SSRS reports to meet agency reporting needs. The Programmer Analyst will collect and interpret user requirements, work iteratively with users to propose and refine solutions, and implement final products. This role also coordinates the deployment of reporting and data visualization solutions to meet various agency reporting demands. This position is eligible for partial telework, subject to supervisor approval and County policy.

Requirements

Graduation from an accredited four-year college or university with a degree in Information Systems, Computer Technology, Business, Economics, or related field.
Three years programming/analysis experience in a complex information systems environment.
Considerable knowledge of position-relevant computer languages and technologies.
Considerable knowledge of programming principles, operating systems, and hardware.
Considerable knowledge of system development life cycle concepts and activities.
Considerable knowledge of modern information processing techniques and systems analysis.
Considerable knowledge of the capabilities and operating requirements of various platforms.
Considerable knowledge of centralized, distributed, client server, and Web architectures.
Considerable knowledge of computer / database programming process and related practices.
Considerable knowledge of conceptual and logical data, work flow, and process modeling.
Considerable knowledge of report design and procedural report writing.
Skill in defining and supervising the work of others in a project lead capacity.
Skill in finding and presenting a range of options to resolve complex problems.
Skill in writing advanced programs and debriefing changes made.
Skill in designing and developing complex applications and components.
Skill in performing unit testing and the related debugging of computer errors.
Ability to establish and maintain effective business relationships.
Ability to work independently, serves as a team lead, or add value as a team contributor.
Ability to elicit requirements from stakeholders to support development of specifications.
Ability to perform research and find relevant materials to assist in project tasks and assignments.
Ability to seek root cause(s) and appropriate solution(s) for resolving complex issues.
Ability to plan, to organize, and to conduct systems analysis and feasibility assessments.
Ability to evaluate processes/procedures, to suggest improvements, and to design specifications.
Ability to document necessary system modifications and enhancements to defined standard(s).
Ability to assist users in troubleshooting and solving systems and programming problems.
Ability to translate technical terminology into simple, non-technical language.
Ability to provide guidance and assistance to technical employees and review their work.
Ability to train less skilled technical workers and to plan, assign, and review their work.
Ability to prepare clear, detailed programs of instruction for efficient system utilization.
Ability to ask relevant questions to assure understanding of assignments and requirements.
Ability to write easy to follow systems documentation tailored to the end user audience.
Must complete a criminal background check.

Nice To Haves

Five years of experience developing and maintaining Power BI reports.
Experience analyzing user requirements.
Professional experience working with large datasets to develop complex metrics and data reporting.
Experience developing SQL queries and code.
Experience with IT support for planning, zoning, or related public sector work.
Professional experience in or exposure to GIS technology.
Experience managing and implementing all phases of the systems development life cycle.
Ability to engage effectively with business stakeholders and translate their needs into practical solutions.
Strong customer service and teamwork qualities.
Bilingual in English and another language.

Responsibilities

Serves as lead programmer for complex technology solutions.
Defines, designs, and delivers technically advanced code and objects for applications.
Writes, reviews, and deploys scripts, services, system interfaces, and integration logic.
Plans, packages, and implements complex programs, routines, jobs, and utilities.
Implements software in conformance with defined change / release control procedures.
Follows system lifecycle standards and development procedures.
Maintains and documents moderate to complex computer programs and/or application software.
Develops advanced test scripts and data; tests, evaluates, and debugs software systems.
Configures and/or provides administration of COTS applications and related databases.
Defines and designs inputs, outputs, work flows, error handling, and complex functional logic.
Monitors and evaluates efficiency/effectiveness of applications and underlying data structures.
Suggests design and solution options when user enhancements are not feasible as requested.
Seeks and identifies opportunities for new technology or system enhancements.
Interacts with customer agency in scoping requirements, evaluating feasibility and priority.
Confers with users to define requirements and validate conformance to acceptance criteria.
Interfaces with users to provide technical assistance, diagnose and resolve software problems.
Translates user requirements and interprets specifications of advanced complexity.
Defines tasks, estimates resource needs, and organizes work for assigned projects.
Prepares requests for programming, and recommends staff assignments.
Produces or contributes to advanced designs, specifications, and deliverables.
Prepares or delivers training, user manuals, and documentation for assigned projects.
Oversees tasks assigned to subordinate clerical, technical, contractor, or project team staff.
Supports a 24 x 7 environment, responding to emergencies and critical system failures.
Assists in detecting, analyzing, and resolving non-routine application-related problems.
Presents ideas and concepts to an audience and participates effectively in workgroup activities.
Proactively engages and works with relevant functional areas in DIT in accomplishing work.
Evaluates new tools and methodologies for software development effectiveness and applicability.
Assists in the development of requests for proposals and in the evaluation of responses.
Monitors contract performance and writes technical reports.
Assists in definition and adoption of new standards as needed.
Provides mentoring, assistance, training, and guidance to less experienced programmers.
Lends assistance and support to other staff as needed.
May require support beyond normal workdays to instrumental business operations or systems that require 24x7 support.
Performs other duties as assigned.