What are the responsibilities and job description for the ETL Developer (Mid - SME Level) - Top Secret with FS Poly position at Xcelerate Solutions?
ETL Developer – TS/SCI with Full Scope Polygraph
Xcelerate Solutions is seeking an experienced ETL Developer to play a pivotal role in shaping, leading, and implementing cutting-edge data flow solutions centered around Apache NiFi. This role supports the design, development, and deployment of Extract, Transform, and Load (ETL) processes that power enterprise-level data lakes and analytics ecosystems. The ideal candidate will define architectural best practices, optimize performance in large-scale environments, and mentor junior developers, ensuring the delivery of robust, scalable, and secure data flow solutions aligned with mission-critical customer objectives.
Security Clearance: Top Secret / SCI with Full Scope Polygraph
Location: Bethesda, MD
Responsibilities:
- Architect complex data pipelines: Design and implement enterprise-level NiFi-based ETL architectures for large-scale data ingestion, transformation, and processing from diverse structured and unstructured sources.
- Optimize and tune performance: Configure and fine-tune NiFi processors, manage system memory, and balance workloads to ensure optimal throughput and efficiency for both batch and real-time data flows.
- Advanced troubleshooting: Identify and resolve complex data flow issues, performance bottlenecks, and integration challenges to maintain consistent and reliable operations.
- Integrate with big data and cloud technologies: Connect NiFi with databases, cloud platforms (AWS, Azure, OCI), and big data services (e.g., Kafka, Elasticsearch, S3, SQS/SNS) to enable seamless end-to-end data movement.
- Establish best practices: Define and enforce NiFi development, deployment, and governance standards, ensuring alignment with enterprise data management policies and DevOps practices.
- Documentation and knowledge sharing: Develop comprehensive documentation, including data flow mappings, architectural diagrams, and SOPs, to support scalability and continuity across teams.
- Cross-functional collaboration: Partner closely with data architects, data engineers, and application developers to translate complex business requirements into robust technical implementations.
- Mentorship and leadership: Provide technical guidance, conduct code reviews, and mentor junior team members to enhance team capability and foster a culture of continuous improvement.
Minimum Requirements:
- Proven experience designing, developing, and managing complex NiFi data flow solutions in large-scale, enterprise environments.
- Deep understanding of NiFi architecture, including processors, configurations, clustering, and NiFi Registry.
- Proficiency in Java and Python for developing custom NiFi processors and automation scripts.
- Experience managing relational and NoSQL databases (e.g., PostgreSQL, Elasticsearch, DynamoDB) and writing optimized queries.
- Strong background in real-time streaming and REST API integration for dynamic data movement.
- Hands-on experience with cloud platforms (AWS, Azure, OCI) and related data services.
- Ability to analyze complex data challenges, identify root causes, and implement effective, sustainable solutions.
- Excellent communication and collaboration skills, with the ability to clearly convey technical concepts to diverse audiences.
Education/Experience:
- HS diploma plus 12 - 16 years of relevant experience
- BS degree plus 8 - 12 years of relevant experience
- Master’s degree plus 6 - 10 years of relevant experience
- Active TS/SCI with polygraph required.
Preferred Qualifications:
- Demonstrated experience deploying and managing ETL solutions within AWS environments, leveraging native cloud data tools and automation frameworks.
About Xcelerate Solutions:
Founded in 2009 and headquartered in McLean, VA, Xcelerate Solutions (www.xceleratesolutions.com) is one of America's fastest-growing companies. Xcelerate’s culture is defined by our diversified workforce of dynamic and versatile professionals, supported with growth and development opportunities that contribute to individual and company growth. This strong commitment to our employees has been recognized by our inclusion on the Washington Business Journal’s “50 Best Places to Work” list as well as being a “Great Place to Work” certified company with a 4.6 star, and a 99% CEO approval Glassdoor rating. Come find out why Xcelerate Solutions is one of the DC Metro top employers!
Xcelerate Solutions is an Equal Employment Opportunity/Affirmative Action Employer. We evaluate qualified applicants without regard to race, color, national origin, religion, age, equal pay, disability, veteran status, sex, sexual orientation, gender identity, genetic information, or expression of another protected characteristic. As part of this commitment to the full inclusion of all qualified individuals, Xcelerate provides reasonable accommodations if needed because of an applicant's or an employee's disability.
Pay Transparency Notice: Xcelerate Solutions will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.
Xcelerate Solutions is an Equal Employment Opportunity/Affirmative Action Employer. We evaluate qualified applicants without regard to race, color, national origin, religion, age, equal pay, disability, veteran status, sex, sexual orientation, gender identity, genetic information, or expression of another protected characteristic. As part of this commitment to the full inclusion of all qualified individuals, Xcelerate provides reasonable accommodations if needed because of an applicant's or an employee's disability.
Pay Transparency Notice: Xcelerate Solutions will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.