Data Integration Specialist (Programmer-Analyst II)

About the role

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.

Responsibilities

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

Requirements

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

Qualifications

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

Skills

• Significant experience in designing, building, and deploying complex ETL (Extract, Transform, Load) workflows using enterprise tools (Talend preferred).
• 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).
• Strong proficiency in relational database management (MS SQL Server, Oracle) and designing schemas that support both transactional and reporting needs.
• Experience in translating legacy business logic (COBOL, Access VBA, or Mainframe processes) into modern, automated integration jobs.
• Experience with Object-Oriented Programming (Java/Python) to support custom data transformation scripts and API connectivity.

Benefits

• BlueChoice Advantage EPO
• BlueChoice Advantage PPO
• CIGNA Dental PPO (Buy-Up)
• CIGNA Dental PPO (CORE)
• CIGNA Dental HMO (DHMO)
• Vision Insurance
• Employee Life Insurance
• Supplemental & Dependent Life Insurance
• Disability Income Insurance
• Pension Plan
• Holidays
• Annual Leave
• Disability Leave
• Personal Leave
• Leave Sharing
• Employee Assistance Program
• Universal Life Insurance with Long Term Care Rider
• United Legal Benefits

Pay

Pay will be based on education and direct experience, generally within fifteen percent (15%) of the base pay.

Schedule

Normal work schedule is currently hybrid with 2 days per week in the Annapolis Office.