Custom ETL Developer

Custom ETL Developer Description of Work: • Database developer with custom ETL scripting skills, UNIX shell scripting, and Python • 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. • All other duties as assigned or directed. Basic Qualifications: Minimum knowledge, skills, abilities needed. • 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 • 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 • Must be able to obtain and maintain a US Public Trust clearance. Preferred Qualifications: Candidates with these skills will be given preferential consideration. • 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)