ETL Developer (Ability to Obtain Public Trust)

Position Overview We are seeking a Senior ETL Developer with strong expertise in data warehousing, ETL pipeline development, and business intelligence reporting. The ideal candidate will design and develop scalable ETL solutions, manage large-scale data integrations, and build Tableau dashboards that support enterprise analytics and reporting initiatives. This role requires hands-on experience with Linux environments, ETL tools, large data warehouses, and complex SQL development. Key Responsibilities ETL Development & Data Integration Design and develop ETL processes supporting enterprise MI/BI initiatives. Build scalable ETL pipelines and develop automation scripts using Bash and Python. Integrate and load data from multiple source systems into Greenplum MPP databases. Implement data distribution, partitioning, and compression strategies. Design, develop, test, and optimize ETL processes for large-scale data processing. Develop and maintain migration processes across development, test, and production environments. Data Analysis & SQL Development Perform source-to-target mapping and data analysis across multiple data sources. Develop and maintain complex SQL queries in enterprise data warehouse environments. Work with multiple database platforms including: DB2 Oracle Greenplum PostgreSQL SQL Server Flat Files Business Intelligence & Visualization Design and develop Tableau dashboards and visualizations for enterprise reporting. Connect Tableau to enterprise data sources and warehouses. Develop calculated fields, parameters, scorecards, and interactive dashboards. Publish and manage workbooks on Tableau Server. Collaboration & Documentation Translate business requirements into technical specifications. Collaborate with Business Analysts, Data Architects, ETL Architects, and Enterprise Architects. Maintain technical documentation and knowledge transfer materials. Participate in design reviews, architecture discussions, and troubleshooting sessions. DevOps & Version Control Manage source code using Bitbucket / Git. Deploy ETL components following SSA change management standards. Ensure compliance with security, privacy, and enterprise data governance policies. Team Support Mentor junior developers on ETL best practices and performance optimization. Promote reusable ETL components to reduce technical debt. Minimum Qualifications Bachelor’s degree in Computer Science, Information Technology, or related field. 10+ years of ETL development experience (additional experience may substitute for degree). Required Technical Skills Operating Systems Linux / UNIX administration Bash shell scripting ETL Tools Informatica Ab Initio Syncsort / Precisely Databases Strong SQL development experience Experience working with: DB2 Oracle PostgreSQL Greenplum SQL Server Flat files Programming & Scripting Python scripting for ETL automation PL/pgSQL (PostgreSQL / Greenplum) PL/SQL (Oracle) Data Engineering Concepts SQL optimization Data granularity Cardinality Normalized vs denormalized models Data warehouse architecture Data Transfer FTP / SFTP integration Visualization Tableau dashboard development Tableau Server publishing Other Requirements Excellent analytical and troubleshooting skills Strong communication and documentation abilities Ability to obtain and maintain Public Trust Clearance Preferred Qualifications Active Public Trust clearance or higher Experience supporting Federal Government clients (SSA preferred) Strong database architecture knowledge Experience with Agile / Scrum development methodologies Familiarity with DevSecOps practices Experience using Jira and Confluence Knowledge of FISMA compliance and ATO framework Certifications (Preferred) Tableau Desktop Specialist Tableau Certified Data Analyst Informatica AXON Certification Ab Initio Certification Job Type: Contract Pay: $60.00 - $65.00 per hour Expected hours: 40 per week Work Location: In person