Data Integration Specialist; Programmer-Analyst II

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.

Work involves analyzing the data of an organization and developing data exchanges and transforms. The role includes designing and implementing APIs, knowledge of database schemas and data access, use of ETL tools (Talend, SSIS, Informatica, etc.), and Object‑Oriented Programming. Responsibilities also encompass planning, scheduling, and supervising the preparation of programs to process fiscal, statistical, and other data relevant to the County.

This includes systems analysis, creating flow charts, block diagrams, and program design; establishing work schedules; approving completed programs; and participating in testing, debugging, and analysis of test results. The team leader supervises subordinate programming personnel primarily on project work and works independently within technical guidelines.

• 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 or modification; supervises the development of test plans.
• Implements and maintains purchased or leased software program products.
• Conducts on‑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 converting mechanical and clerical processing to a computerized system.
• Ability to see relevant 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.
• ETL & Integration
  
  Experience:
  
  Significant experience in designing, building, and deploying complex ETL (Extract, Transform, Load) workflows using enterprise tools (Talend preferred).
• Data Pipeline Orchestration:
  Proven ability to manage file‑based exchanges (sFTP), API‑based integrations (REST/SOAP), and batch processing across hybrid environments (On‑premise SQL Server to Cloud).
• Database Expertise:
  Strong proficiency in relational database management (MS SQL Server, Oracle) and designing schemas that support both transactional and reporting needs.
• Modernization:
  Experience in translating legacy business logic (COBOL, Access VBA, or Mainframe processes) into modern, automated integration jobs.
• Programming Proficiency:
  Experience with Object‑Oriented Programming (Java/Python) to support custom data transformation scripts and API connectivity.

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 of experience 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…