*** Selected candidate must RESIDE WITHIN TWO (2) HOURS of SSA Headquarters in Woodlawn, MD***
- Experience working with complex data warehouse projects
- Design custom ETL processes to populate the data warehouse
- Analyze source data for potential data quality issues and address these issues
- Use scripting (Shell scripting, python, Java) and automation and DevOps
- Prepare technical documents and presentations
- Utilize Atlassian product suites, git, bitbucket, confluence, Jira.
Skills Requirements:
Basic Qualifications:
- Bachelor's Degree in Computer Science, Mathematics, Engineering, or a related field
- 2-4+ years of combined experience with SQL and/or PL/pgSQL
- 2+ years of combined experience with Jira and Confluence
- The ideal candidate will have a strong desire to learn new skills, embed with a team, solicit ideas, and feedback.
- Excellent communication skills
- Expert in Shell scripting including but not limited to regular expressions, and automating tasks
- Experience creating custom ETL using Python
Required Skills:
- Experience working with complex data warehouse projects
- Experience designing custom ETL processes to populate the data warehouse (not Tool based ETL)
- Ability to analyze source data for potential data quality issues and address these issues
- Ability to effectively communicate information, both verbally and written to end users, team members and management
- High-level knowledge of various industry leading data warehouse components (databases, ETL tools, BI/reporting tools)
- Experience in scripting (Shell scripting, python, Java) and automation
- Experience with DevOps
- Prepare technical documents and presentation
- Familiarity with Atlassian product suites: Git, BitBucket, Confluence, Jira.
- High availability to support On-Call rotations for 24/7 Production database environment
- Be comfortable working independently as well as in a team with a collaborative attitude
Desired Skills:
- Ansible scripting
- Experience with cloud environment, AWS
- Database Administration (DBA) skills
- Ability to work individually and as part of a team
- Basic knowledge of relational databases (PostgreSQL, DB2, and Oracle)
Education:
- Bachelor's degree 4 years of prior relevant experience or Master's degree +2 years of prior relevant experience.
- Must be able to obtain a Public Trust