• Update the delimited files using a text editor (e.g., WordPad or Excel).
• Review the logs for any errors during execution.
• Update the data refresh job schedule if needed. This job schedule is automated.
• In addition to ETL support, create and update technical documentation to support the refreshes.
• Execute the Bash scripts on a Linux terminal.
• Output summary data (from the previous step) into either the existing Excel or Tableau format, based on the instructions in the runbook.
• Update job schedule (using the IBM Process Manager) if needed.
• Review the log on the Linux server for the server-side execution.
• Re-start the process after addressing any issues (related to access, missing data, or lack of space).
• Update the Excel or Tableau report as documented in the runbook.
• Create a test plan if the scripts change (Bash, Perl and SAS).
• Create unit, system, integration, and regression test scripts when modifying scripts.
• Migrate code from the development to the production folders.
• Submit a monthly status report on the last Friday of the month.

• Energized when faced with complex technical challenges and diligently work to identify creative solutions.
• Ability to perform high quality work, both independently and with a team, in a fast-moving environment.
• Ability to plan and prioritize tasks to successfully meet/exceed customer expectations.

• Bachelor’s degree in Computer Science or related discipline from an accredited college or university and 5 years of experience. Additional experience may be substituted for degree.
• Experience using the Unix command line.
• Experience writing scripts using Bash.
• Five (5) years of experience using SAS to perform ETL.
• Five (5) years of experience developing and maintaining Linux shell scripting.
• Three (3) years of experience using Python to perform ETL functions.
• Three (3) years of experience using Perl to perform ETL functions.
• Experience developing in Java in a Unix environment.
• Experience developing with multiple programming languages such as C, Java, and Python.
• Experience with software development lifecycle, including Agile and CMMI.

Preferred qualifications include experience with cloud platforms. This includes the following (or similar):

• Two (2) years of experience working with applications using Amazon Redshift (or other Postgres- based databases).
• Two (2) years of experience working with applications using AWS Glue (or similar).
• Two (2) years of experience working with applications using Amazon S3 (or similar).