What are the responsibilities and job description for the Data Integration Specialist (Programmer-Analyst II) position at Anne Arundel County Office of Personnel?
Position Description
This announcement will be used to fill a full-time permanent Programmer-Analyst II position in the Office of Information Technology located in Annapolis, MD.
NATURE AND VARIETY OF WORK
Work involves a nalyzing the data of an organization and developing reports/dashboards to be consumed by end users for decision-making, d esigning and creating relational database schemas as well as NoSQL databases, using SQL and report writing packages such as Crystal Reports and MS SQL Server Reporting Services, d esigning and implementing APIs, and an open data portal, u se of ETL tools (Talend, SSIS, Informatica, etc) and Object-Oriented Programming
Work involves the responsibility for planning, scheduling, and technically supervising the preparation of programs to process fiscal, statistical, and other data relevant to the County and its operations. Work includes systems analysis detail work; coordinating and participating in the preparation of flow charts, block diagrams, and programs involved in the application of advanced computer programming and analysis work; establishing work schedules and approving completed programs; participating in test and debugging procedures; and analyzing test results to determine causes of equipment or program malfunction. Supervision as a team leader is exercised over subordinate programming personnel and is usually limited to project work. Work is performed with considerable latitude for initiative and independent judgment within technical guidelines and procedures and is reviewed by a technical superior through conferences and review of reports.
Examples Of Duties And Knowledge, Skills And Abilities
(Note: The duties and responsibilities enumerated in this class specification are for the purpose of determining a common set of minimum qualifications and salary level for all positions in this class. They are not intended to include all of the essential functions of all positions in the class.)
Graduation from an accredited four-year college or university with a bachelor's degree, including or supplemented by courses in electronic computer programming, system analysis, and operating systems; and four (4) years experiences in the field of electronic computer programming
NOTE: Graduation from an accredited four-year college or university with a bachelor's degree may be substituted on a year-for-year basis for a total of eight (8) or more years of experience in electronic computer programming and/or a system support, application development or related field. Experience must still include or be supplemented by courses in electronic computer programming, system analysis, and operating systems
NOTE: This position requires a full background check.
Note: Starting salary will be within 15% of the base of the range
Note: Normal work schedule is currently hybrid with 2 days per week in the Annapolis Office
Note: Accredited University or College is the recognition from an accrediting agency that an institution maintains a certain level of educational standards. The U.S. Department of Education maintains a database of accrediting agencies it recognizes for schools within the United States. For a University or College outside the United States, the applicant must provide documentation of accreditation and educational equivalency, which can be accomplished through a credential evaluation service. Applicants with a foreign degree must provide this documentation upon the close of the announcement.
Supplemental Qualifications
Preference will be given to applicants who possess the following:
This announcement will be used to fill a full-time permanent Programmer-Analyst II position in the Office of Information Technology located in Annapolis, MD.
NATURE AND VARIETY OF WORK
Work involves a nalyzing the data of an organization and developing reports/dashboards to be consumed by end users for decision-making, d esigning and creating relational database schemas as well as NoSQL databases, using SQL and report writing packages such as Crystal Reports and MS SQL Server Reporting Services, d esigning and implementing APIs, and an open data portal, u se of ETL tools (Talend, SSIS, Informatica, etc) and Object-Oriented Programming
Work involves the responsibility for planning, scheduling, and technically supervising the preparation of programs to process fiscal, statistical, and other data relevant to the County and its operations. Work includes systems analysis detail work; coordinating and participating in the preparation of flow charts, block diagrams, and programs involved in the application of advanced computer programming and analysis work; establishing work schedules and approving completed programs; participating in test and debugging procedures; and analyzing test results to determine causes of equipment or program malfunction. Supervision as a team leader is exercised over subordinate programming personnel and is usually limited to project work. Work is performed with considerable latitude for initiative and independent judgment within technical guidelines and procedures and is reviewed by a technical superior through conferences and review of reports.
Examples Of Duties And Knowledge, Skills And Abilities
(Note: The duties and responsibilities enumerated in this class specification are for the purpose of determining a common set of minimum qualifications and salary level for all positions in this class. They are not intended to include all of the essential functions of all positions in the class.)
- Plans, supervises, and participates in the development of software applications for the County and its operations.
- Leads other technical employees engaged in computer programming and related activities.
- Participates with systems analysts and others to maintain, debug, and troubleshoot systems and software.
- Prepares the details of systems design under the direction of a systems analyst.
- Reduces software problems to written logical procedural steps and recommends appropriate software, hardware, and method solutions.
- Reviews completed programs for accuracy and effectiveness; determines the need for revision/modification; supervises the development of test plans.
- Implements and maintains purchased or leased software program products.
- Conducts on-the-job training of subordinate programmers-analysts.
- Performs related work as required.
- Thorough knowledge of the capabilities, programming techniques, and intricacies of modern programming languages.
- Thorough knowledge of program requirements for conversion of mechanical and clerical processing to a computerized system.
- Ability to see pertinent detail in symbols when reading, interpreting, or preparing charts, diagrams, and code sheets.
- Ability to understand and analyze complex oral and written statements concerning a variety of fiscal and statistical problems.
- Ability to interpret diagrammatic representations of workflow, visualize the flow of data through computer systems, and prepare logical flow charts.
- Ability to establish and maintain effective working relationships with administrative officials, employees, and the public.
- Ability to communicate effectively, orally and in writing.
- Ability to lead others in the performance of their duties.
Graduation from an accredited four-year college or university with a bachelor's degree, including or supplemented by courses in electronic computer programming, system analysis, and operating systems; and four (4) years experiences in the field of electronic computer programming
NOTE: Graduation from an accredited four-year college or university with a bachelor's degree may be substituted on a year-for-year basis for a total of eight (8) or more years of experience in electronic computer programming and/or a system support, application development or related field. Experience must still include or be supplemented by courses in electronic computer programming, system analysis, and operating systems
NOTE: This position requires a full background check.
Note: Starting salary will be within 15% of the base of the range
Note: Normal work schedule is currently hybrid with 2 days per week in the Annapolis Office
Note: Accredited University or College is the recognition from an accrediting agency that an institution maintains a certain level of educational standards. The U.S. Department of Education maintains a database of accrediting agencies it recognizes for schools within the United States. For a University or College outside the United States, the applicant must provide documentation of accreditation and educational equivalency, which can be accomplished through a credential evaluation service. Applicants with a foreign degree must provide this documentation upon the close of the announcement.
Supplemental Qualifications
Preference will be given to applicants who possess the following:
- Experience with AI platforms, including Google Gemini and AWS Bedrock.
- Experience with reporting and business intelligence software.
- Experience analyzing the data of an organization and developing reports/dashboards to be consumed by end users for decision making
- Experience designing and creating relational database schemas as well as NoSQL databases
- Experience with SQL and report writing packages such as Crystal Reports and MS SQL Server Reporting Services.
- Experience designing and implementing APIs and open data portals
- Experience with ETL tools (Talend, SSIS, Informatica, etc)
- Object-Oriented Programming experience
- Familiarity with State and Local Government IT