Job Requirements
Remote Washington, DC
Public Trust Polygraph not specified
Career Level not specified
$110,000 - $120,000
Job Description
ETL Developer
Location: Washington, DC – potentially up to 5 days onsite (50% onsite)
Clearance: Public Trust
Required Qualifications
• 5+ of ETL/ELT development or data engineering experience, including leading complex transformation pipelines.
• Experience with ETL/ELT and data integration tools, specifically SAP Data Services and SAP BusinessObjects
• Advanced SQL expertise, including optimization, indexing strategies, and large scale data manipulation.
• Proven ability to lead design and architecture discussions for data integration solutions.
• Demonstrated experience translating complex business rules into scalable, enterprise ready transformation logic.
• Significant experience with scripting and automation (Python, Bash, PowerShell) for orchestration, validation, and operational support.
• Ability to independently diagnose and resolve complex workflow, performance, and data quality issues.
• Experience mentoring junior and mid level developers.
Preferred Qualifications
• Deep experience with ETL/ELT and data integration platforms
• Expertise in SQL query tuning, stored procedures, partitioning strategies, and performance analysis.
• Strong mastery of Python or similar scripting languages for automation and data processing.
• Strong knowledge of data modeling, schema design, optimization, and large scale data architecture patterns.
• Advanced understanding of data warehousing, dimensional modeling, normalization/denormalization, ELT patterns, and MPP database environments.
• Experience with CI/CD pipelines, automated testing frameworks, and cloud data platforms (Azure, AWS, GCP).
• Prior experience contributing to or defining engineering standards and best practices.
Education
• Associate’s degree in computer science, Information Systems, Data Analytics, or related field (minimum).
• Bachelor’s degree strongly preferred
Masters Degree or higher (in a related discipline), More than Five years
Substitute additional four (4) years of experience for a Bachelors Degree.
• Substitute a Bachelor’s Degree and two additional years of experience for a Master’s Degree.
Key Responsibilities
• Lead the design, development, testing, and maintenance of complex ETL/ELT workflows and data transformation pipelines across enterprise systems.
• Architect scalable data engineering solutions supporting analytics, reporting, and application integration.
• Establish and enforce best practices around data integration, modeling, pipeline development, and performance tuning.
• Develop comprehensive documentation for data flows, transformation logic, workflow patterns, and technical architecture.
• Proactively identify and implement pipeline optimization opportunities, including refactoring, architecting, and system performance improvements.
• Monitor enterprise data systems for integrity, performance, and stability; lead complex troubleshooting efforts.
• Refactor and modernize legacy ETL/ELT processes into scalable, cloud ready frameworks.
• Install, configure, and support advanced data related tools, platforms, and integrations.
• Lead integration, regression, performance, and functional testing for data systems to ensure enterprise reliability.
• Develop robust automation and orchestration scripts to eliminate manual processes and enhance operational scalability.
• Evaluate, recommend, and implement advanced tools, frameworks, and engineering controls.
• Collaborate with analysts, architects, developers, and senior stakeholders to gather, refine, and validate data engineering requirements.
• Represent data engineering needs in design reviews, solution architecture sessions, and project planning.
• Communicate complex technical concepts clearly to leadership, business partners, and cross functional teams.
• Lead security, governance, and data protection efforts across ETL/ELT workflows, including redundancy and backup design.
• Troubleshoot and resolve complex technical and network related issues affecting data pipelines across multiple platforms.
• Provide mentorship, guidance, and code reviews for junior and mid level engineers.
• Drive multi platform integration efforts, deployments, and environment configuration across dev/test/prod.
Compensation and Benefits
Salary Range: $110,000 - $120,000 (Compensation is determined by various factors, including but not limited to location, work experience, skills, education, certifications, seniority, and business needs. This range may be modified in the future.)
Benefits: Gridiron offers a comprehensive benefits package including medical, dental, vision insurance, HSA, FSA, 401(k), disability & ADD insurance, life and pet insurance to eligible employees. Full-time and part-time employees working at least 30 hours per week on a regular basis are eligible to participate in Gridiron’s benefits programs.
Gridiron IT Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status or disability status.
Gridiron IT is a Women Owned Small Business (WOSB) headquartered in the Washington, D.C. area that supports our clients' missions throughout the United States. Gridiron IT specializes in providing comprehensive IT services tailored to meet the needs of federal agencies. Our capabilities include IT Infrastructure & Cloud Services, Cyber Security, Software Integration & Development, Data Solution & AI, and Enterprise Applications. These capabilities are backed by Gridiron IT's experienced workforce and our commitment to ensuring we meet and exceed our clients' expectations.
Location: Washington, DC – potentially up to 5 days onsite (50% onsite)
Clearance: Public Trust
Required Qualifications
• 5+ of ETL/ELT development or data engineering experience, including leading complex transformation pipelines.
• Experience with ETL/ELT and data integration tools, specifically SAP Data Services and SAP BusinessObjects
• Advanced SQL expertise, including optimization, indexing strategies, and large scale data manipulation.
• Proven ability to lead design and architecture discussions for data integration solutions.
• Demonstrated experience translating complex business rules into scalable, enterprise ready transformation logic.
• Significant experience with scripting and automation (Python, Bash, PowerShell) for orchestration, validation, and operational support.
• Ability to independently diagnose and resolve complex workflow, performance, and data quality issues.
• Experience mentoring junior and mid level developers.
Preferred Qualifications
• Deep experience with ETL/ELT and data integration platforms
• Expertise in SQL query tuning, stored procedures, partitioning strategies, and performance analysis.
• Strong mastery of Python or similar scripting languages for automation and data processing.
• Strong knowledge of data modeling, schema design, optimization, and large scale data architecture patterns.
• Advanced understanding of data warehousing, dimensional modeling, normalization/denormalization, ELT patterns, and MPP database environments.
• Experience with CI/CD pipelines, automated testing frameworks, and cloud data platforms (Azure, AWS, GCP).
• Prior experience contributing to or defining engineering standards and best practices.
Education
• Associate’s degree in computer science, Information Systems, Data Analytics, or related field (minimum).
• Bachelor’s degree strongly preferred
Masters Degree or higher (in a related discipline), More than Five years
Substitute additional four (4) years of experience for a Bachelors Degree.
• Substitute a Bachelor’s Degree and two additional years of experience for a Master’s Degree.
Key Responsibilities
• Lead the design, development, testing, and maintenance of complex ETL/ELT workflows and data transformation pipelines across enterprise systems.
• Architect scalable data engineering solutions supporting analytics, reporting, and application integration.
• Establish and enforce best practices around data integration, modeling, pipeline development, and performance tuning.
• Develop comprehensive documentation for data flows, transformation logic, workflow patterns, and technical architecture.
• Proactively identify and implement pipeline optimization opportunities, including refactoring, architecting, and system performance improvements.
• Monitor enterprise data systems for integrity, performance, and stability; lead complex troubleshooting efforts.
• Refactor and modernize legacy ETL/ELT processes into scalable, cloud ready frameworks.
• Install, configure, and support advanced data related tools, platforms, and integrations.
• Lead integration, regression, performance, and functional testing for data systems to ensure enterprise reliability.
• Develop robust automation and orchestration scripts to eliminate manual processes and enhance operational scalability.
• Evaluate, recommend, and implement advanced tools, frameworks, and engineering controls.
• Collaborate with analysts, architects, developers, and senior stakeholders to gather, refine, and validate data engineering requirements.
• Represent data engineering needs in design reviews, solution architecture sessions, and project planning.
• Communicate complex technical concepts clearly to leadership, business partners, and cross functional teams.
• Lead security, governance, and data protection efforts across ETL/ELT workflows, including redundancy and backup design.
• Troubleshoot and resolve complex technical and network related issues affecting data pipelines across multiple platforms.
• Provide mentorship, guidance, and code reviews for junior and mid level engineers.
• Drive multi platform integration efforts, deployments, and environment configuration across dev/test/prod.
Compensation and Benefits
Salary Range: $110,000 - $120,000 (Compensation is determined by various factors, including but not limited to location, work experience, skills, education, certifications, seniority, and business needs. This range may be modified in the future.)
Benefits: Gridiron offers a comprehensive benefits package including medical, dental, vision insurance, HSA, FSA, 401(k), disability & ADD insurance, life and pet insurance to eligible employees. Full-time and part-time employees working at least 30 hours per week on a regular basis are eligible to participate in Gridiron’s benefits programs.
Gridiron IT Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status or disability status.
Gridiron IT is a Women Owned Small Business (WOSB) headquartered in the Washington, D.C. area that supports our clients' missions throughout the United States. Gridiron IT specializes in providing comprehensive IT services tailored to meet the needs of federal agencies. Our capabilities include IT Infrastructure & Cloud Services, Cyber Security, Software Integration & Development, Data Solution & AI, and Enterprise Applications. These capabilities are backed by Gridiron IT's experienced workforce and our commitment to ensuring we meet and exceed our clients' expectations.
group id: 91017793