Programmer Analyst III

Austincc; Fairfax (VA); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Fairfax County's Department of Planning and Development seeks an innovative Programmer Analyst to build our data analytics and reporting program. You will serve as the sole development resource, developing SQL code, Power BI dashboards, Power Apps, Power Automate solutions and SSRS reports to meet agency reporting needs.

You will collect, interpret, and analyze user requirements, work iteratively with users, deploy solutions, and support daily, monthly, and annual reporting.

Qualifications

• Bachelor's degree in Information Systems, Computer Technology, Business, Economics, or related field.
• Five years of experience developing and maintaining Power BI reports.
• Experience analyzing user requirements and translating them into practical solutions.
• Experience developing SQL queries and code.

Responsibilities

• Develop SQL code, Power BI dashboards, Power Apps, Power Automate solutions and SSRS reports to meet agency reporting needs.
• Coordinate deployment of reporting solutions with end users for daily, monthly, and annual reporting.
• Provide mentoring and guidance to less experienced staff as needed.
• Support 24x7 environment and respond to critical system issues when required.

Skills

Power BI

SQL

Data analysis

Stakeholder communication

SSRS

Troubleshooting

Teamwork

Mentoring

Education

Bachelor's degree in Information Systems, Computer Technology, Business, Economics, or related field

Tools

Power BI

SQL

Power Apps

Power Automate

SSRS

Job description

You are viewing a preview of this job. Log in or register to view more details about this job.

Fairfax County is one of the largest jurisdictions in the Commonwealth of Virginia with more than 1.1 million people and is strategically located near the federal government in neighboring Washington, D.C. Our vibrant community boasts excellent schools, award-winning parks, a highly educated workforce and a quality of life that makes the county a highly desirable location to live and work. The Department of Planning and Development is shaping the landscape of Fairfax County by promoting equitable, livable and sustainable communities for present and future generations. At DPD we value meaningful work, diversity, innovative approaches, and thrive in a highly collaborative team environment.

The Department of Planning and Development is looking for an innovative Programmer Analyst to help build our data analytics and reporting program. This position will work as the sole development resource within DPD, developing SQL code, Power BI dashboards, Power Apps, Power Automate solutions and SSRS reports to meet agency reporting needs. Collects, interprets, and analyzes user requirements and specifications and works with users in an iterative process to propose solutions, develop prototypes, incorporate feedback and implement a final product. Coordinates deployment of reporting and data visualization solutions with end users to meet agency management, daily, monthly, and annual reporting needs.

Note: In accordance with current Fairfax County telework and personnel policies, this position is eligible for partial telework. Telework enrollment and continuance are subject to supervisor approval and County policy.

Illustrative Duties

(The illustrative duties listed in this specification are representative of the class but are not an all-inclusive list. A complete list of position duties and unique physical requirements can be found in the position job description.)

• 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.

Required Knowledge Skills and Abilities

(The knowledge, skills and abilities listed in this specification are representative of the class but are not an all-inclusive list.)

• 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.

Employment Standards

MINIMUM QUALIFICATIONS: Any combination of education, experience, and training equivalent to the following:

(Click on the aforementioned link to learn how Fairfax County interprets equivalencies for "Any combination, experience, and training equivalent to")

Graduation from an accredited four-year college or university with a degree in Information Systems, Computer Technology, Business, Economics, or related field, plus three years programming/analysis experience in a complex information systems environment.

NECESSARY SPECIAL REQUIREMENTS: The appointee to this position will be required to complete a criminal background check to the satisfaction of the employer.

• 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.

PHYSICAL REQUIREMENTS: Position is primarily sedentary. Employee may be required to do some walking, standing, bending and carrying items under 10 pounds in weight. Work requires the ability to operate keyboard driven equipment. All duties performed with or without reasonable accommodations.

SELECTION PROCEDURE: Panel interview and may include exercise.

Fairfax County is home to a highly diverse population, with a significant number of residents speaking languages other than English at home ( including Spanish, Asian/Pacific Islander, Indo-European, and many others .) We encourage candidates who are bilingual in English and another language to apply for this opportunity.

Fairfax County Government prohibits discrimination on the basis of race, color, religion, national origin, sex, pregnancy, childbirth or related medical conditions, age, marital status, disability, sexual orientation, gender identity, genetics, political affiliation, or military status in the recruitment, selection, and hiring of its workforce.

Reasonable accommodations are available to persons with disabilities during application and/or interview processes per the Americans with Disabilities Act. TTY 703-222-7314. [e-mail] EEO/AA/TTY.