ETL Developer

IMAGINEEER LLC; Arlington (VA); Remote; USD 70,000 - 110,000; Full time

Job summary

An established industry player is on the lookout for a talented ETL Developer who is passionate about data integration. In this remote role, you will design and support complex applications to extract, transform, and load data, ensuring accuracy and security throughout the process. You will leverage your expertise in SQL and various ETL tools to build and optimize data pipelines, contributing significantly to the organization's data management strategy. If you thrive in a collaborative environment and are eager to tackle challenges in data warehousing, this opportunity could be the perfect fit for you.

Benefits

401(k)

Competitive salary

Dental insurance

Health insurance

Paid time off

Vision insurance

Qualifications

• 2+ years of experience as an ETL Developer with strong SQL skills.
• Experience with ETL tools like Informatica, Talend, and Pentaho.

Responsibilities

• Design and support applications for data extraction, transformation, and loading.
• Build reliable data pipelines and ensure data integrity.

Skills

SQL

Data Integration

Problem-Solving

Communication Skills

Education

Bachelor's degree in Computer Science

Advanced degree preferred

Tools

Informatica

Talend

Pentaho

Power BI

Job description

Benefits:

• 401(k)
• Competitive salary
• Dental insurance
• Health insurance
• Paid time off
• Vision insurance

About this Role:

We are seeking a talented and experienced ETL Developer to join our team. In this role, you will be responsible for designing, developing, automating, and supporting complex applications to extract, transform, and load (ETL) data. If you have a passion for data integration and a strong background in SQL, Informatica, Talend, Pentaho, and BI tools, we want to hear from you.

Key Responsibilities:

1. Design, develop, automate, and support complex applications to extract, transform, and load (ETL) data from various sources.
2. Identify data storage requirements and determine the storage needs of the project, building a data warehouse tailored to the needs of the project or organization.
3. Build and support a reliable data pipeline to bring data to the user, ensuring data integrity and security.
4. Extract data from the data warehouse and deliver it to the new system, ensuring accuracy and completeness.
5. Continuously run tests to ensure data warehouse stability and performance, troubleshooting and resolving issues as needed.
6. Perform ongoing analysis of data warehouse performance and user requirements, making recommendations for improvements and optimizations.

Qualifications:

1. Bachelor's degree in Computer Science, Information Technology, or related field; advanced degree preferred.
2. Proven experience as an ETL Developer, with a minimum of 2 years in a similar role.
3. Strong proficiency in SQL, with experience in writing complex queries and optimizing database performance.
4. Experience with ETL tools such as Informatica, Talend, and/or Pentaho, including designing and implementing ETL processes.
5. Familiarity with Power BI or other BI tools for data visualization and reporting.
6. Solid understanding of data warehouse concepts and methodologies.
7. Ability to work independently and as part of a team, with strong problem-solving and communication skills.
8. Certifications in ETL tools or database technologies are a plus.
9. Must be a United States citizen.
10. Must be willing/able to obtain a clearance.
11. May substitute years of experience for education.

This is a remote position.