ETL Developer - Red Cedar Consultancy, LLC : Job Details

Join to apply for the ETL Developer role at Red Cedar Consultancy, LLC

Join to apply for the ETL Developer role at Red Cedar Consultancy, LLC

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from Red Cedar Consultancy, LLC

LOOKING FOR SOMEONE WITH ACTIVE IRS MBI CLEARANCE

Summary:

The Data Pipeline Specialist is responsible for the end-to-end design, development, deployment, and maintenance of robust data pipelines supporting the Enterprise Data Platform (EDP). This role drives the ingestion, transformation, and integration of large-scale, complex datasets from diverse customer's legacy and modern source systems into cloud-based analytic environments. Leveraging advanced expertise in ETL/ELT development, cloud-native data engineering (e.g., Databricks, AWS RDS/Postgres, Redshift, MongoDB, DynamoDB), and scripting languages, the Data Pipeline Specialist ensures data accuracy, security, and continuous availability across transactional, analytical, and API data stores. The Specialist works closely with data engineers, analysts, and project stakeholders to convert business requirements and legacy code (such as PL/SQL, Greenplum, Oracle) into efficient, scalable, and compliant pipelines. This position also supports ongoing operations and maintenance, including troubleshooting, enhancements, and performance tuning, and plays a vital role in enabling advanced analytics, reporting, and real-time data access to empower customers IT modernization and analytics goals. The Data Pipeline Specialist ensures all solutions are developed in alignment with customer's standards, OneSDLC, and compliance mandates such as FISMA, FedRAMP, Section 508.

Responsibilities:

• Develop robust, scalable data pipelines for the ingestion, transformation, and load (ETL/ELT) of customer's source system data into the EDP platform (with focus on Databricks, AWS RDS/Postgres, Redshift, MongoDB, DynamoDB, etc.).
• Convert and optimize legacy ETL processes—including complex PL/SQL, Greenplum, and Oracle stored procedures—to modern, scalable cloud-native data processing using Databricks and Informatica ETL tools.
• Implement data integration and orchestration workflows ensuring data accuracy, completeness, and integrity across transactional, analytical, and API data stores.
• Develop and document pipeline designs, deployment scripts, test plans, and system interfaces in accordance with EDP and Solution Engineering standards.
• Partner with data engineering and analytics teams to deliver high-quality, production-ready data products supporting advanced analytics and reporting use cases.
• Support the creation of API-based data access services, enabling secure and efficient integration with internal and external customer's programs.
• Perform all required testing (system, integration, performance, Section 508, security), remediate defects
• Participate in operations and maintenance support for pipeline issue resolution and enhancement

Requirements:

• Must have demonstrated development experience with at least 2 project similar in size and scope to transform and load data into Databricks.
• Hold both an active IRS and an active or non-active MBI clearance

Preferred Qualifications:

• Prior experience working with the IRS as a contractor or employee

• Seniority levelMid-Senior level

• Employment typeFull-time

• Job functionInformation Technology
• IndustriesIT Services and IT Consulting, Government Relations Services, and Government Administration

Referrals increase your chances of interviewing at Red Cedar Consultancy, LLC by 2x

Medical insurance

Vision insurance

401(k)

Disability insurance

Get notified about new ETL Developer jobs in Washington DC-Baltimore Area.

Reston, VA $175,000 - $225,000 8 months ago

Greenbelt, MD $80,000 - $90,000 2 weeks ago

Gaithersburg, MD $96,058.56 - $144,081.59 1 month ago

Washington, DC$100,000.00-$120,000.002 weeks ago

Owings Mills, MD$60.00-$70.003 weeks ago

Ashburn, VA$103,800.00-$218,100.003 weeks ago

Washington, DC$114,000.00-$171,000.001 week ago

Washington, DC$112,597.33-$152,810.661 month ago

Washington, DC$100,732.00-$151,099.001 week ago

McLean, VA$110,000.00-$130,000.001 month ago

Baltimore, MD$112,597.33-$152,810.661 month ago

Baltimore, MD $112,597.33 - $152,810.66 1 month ago

Arlington, VA $112,597.33 - $152,810.66 1 month ago

Arlington, VA $112,597.33 - $152,810.66 1 month ago

Rockville, MD $112,597.33 - $152,810.66 1 month ago

Tysons Corner, VA $112,597.33 - $152,810.66 1 month ago

We're unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.