DAS Senior Programmer Analyst II
Federal Reserve Bank of Kansas City
Full-time / Part-time
Tier II - No Credit Check
Independently performs highly complex application development, ETL, and automation of tasks and assignments in support of the Data Analytic processes on Greenplum Massively Parallel Processing (MPP) Appliance. Designs, develops, implements, and maintains complex PostgreSQL and Greenplum databases in a Linux/Unix environment. Directs the work of small to mid-sized teams. Prepares detailed specifications, diagrams, and other programming structures from which programs are written. Codes, tests, debugs, and documents highly complex programs and applications, in addition to performing advanced application maintenance tasks.
Creates and/or utilizes programming code and open source technology to support various department processes such as loading, matching, and transforming data, developing data models and simulations, and visualizations of the data. Independently uses development tools and utilities to develop, support, and customize moderately to highly complex business applications.
Oversees ongoing utilization and execution of data extraction and loading processes. Develops data models, collects, collates, organizes, and homogenizes data received from various sources to facilitate effective report development. Ensures data is accurately loaded and resolves compatibility issues.
Independently develops and debugs Bash, Perl, or Python scripts for loading data.
Analyzes requirements and participates in the resulting design activities for moderately to highly complex business applications in the context of the full software development life cycle. Develops technical requirements through interviews with business partners.
Performs in-depth analysis and design including utilization of UML, Use Cases, and Sequence and Class Diagrams.
Applies the Unified Process development framework and agile development concepts.
Develops and maintains required documentation for each phase of the development cycle.
Develops prototypes and/or functional/technical specifications to meet business needs.
Codes and tests software in accordance with department, System, and industry accepted standards.
Develops test plans and scripts for unit and integration testing.
Participates in, and occasionally directs, moderately to highly complex team projects. Provides direction and guidance to less-experienced staff.
Consistently increases depth and breadth of knowledge in programmer/analyst key result areas: application development tools, analysis & design, project management, and leadership.
Ensures integrity of data. Applies programming and statistical concepts to create test data and perform data validation. Codes automated data validation scripts and stored procedures to improve efficiency and accuracy of data validation. Monitors data validation progress, identifies and resolves issues.
Provides second level problem resolution support to customers, including SQL tuning and solving performance and/or connectivity problems. Provides guidance and training to less experienced staff.
Performs Database Management System design using data modeling tools.
May be required to provide other system administration and database administrator duties as assigned.
Performs other tasks as assigned.
Associate’s degree specializing in computer science, or equivalent experience required; Bachelor’s degree specializing in computer science preferred
At least six years of relevant work experience.
Advanced training and experience on Greenplum Massively Parallel Processing (MPP), Teradata, Netezza, Oracle Exadata and/or similar technology is preferred.
Knowledge and experience in open-source development, CVS, compilers, database libraries, kernel and system programming, and shell scripting (Bash, Perl, and/or Python).
Knowledge in additional programming languages (mod PERL, CGI, PHP, C, C++, and Java) on UNIX and Linux platforms is preferred
Advanced skill in SQL including creating functions and stored procedures, merge, widowing and external tables or other database query language. Experience with multiple languages preferred.
Experience with PostgreSQL and/or other RDBMS in a Linux/Unix environment.
Experience with large data sets and performance tuning required.
Experience in database design, referential integrity, and modeling preferred.
Experience with DBMS security preferred.
Working knowledge of installing and maintaining PostgreSQL, Greenplum, or Oracle DBMS in a Linux/Unix environment preferred.
Knowledge and working experience with OS and hardware setup, configuration, and security in a Linux/Unix environment preferred.
Strong interpersonal, customer service, communication, initiative, organization, project management, and leadership skills.
Ability to think logically.
United States citizenship or permanent residency is required for this position. Additional citizenship and/or permanent residency requirements may apply and will be discussed during the hiring process if applicable.
Follow us on LinkedIn, Twitter, and our YouTube channel - Kansas City Fed.
The Federal Reserve Bank of New York works within the Federal Reserve System and with other public and private sector institutions to foster...