ETL Developer with Cloud Technology Experience

Acumen Solutions; McLean (VA); On-site; USD 80,000 - 100,000; Full time

Benefits offered by this job

Competitive base salary

Annual performance-based incentives

Medical benefits

401k plan

Job summary

Acumen Solutions located in McLean, Virginia, is seeking a full-time ETL Developer to support data transformation and integration projects. The ideal candidate will have 3-6 years of experience in data analysis and ETL processes. Responsibilities include understanding data interrelationships, creating documentation, and performing data extraction and analysis.

Benefits include a competitive salary, annual incentives, and medical benefits. Candidates must be authorized to work in the U.S. and be willing to travel 35-50%.

Qualifications

• 3-6 years of documented experience in data analysis and manipulation.
• Experience with ETL tools and procedures.
• Strong verbal and written communication skills.

Responsibilities

• Develop an understanding of data interrelationships and domains.
• Create documentation and maintain it throughout the project.
• Perform data extraction, manipulation, and analysis.

Skills

Data analysis

Data manipulation

ETL processes

Relational database concepts

MS Office Suite

Salesforce.com Cloud

Tools

Informatica

Pentaho

Job description

ETL Developer with Cloud Technology Experience

Acumen Solutions is a global cloud consultancy that is looking for a full‑time ETL Developer to support our data transformation and integration projects.

Responsibilities

• Develop an in-depth understanding of the interrelationships of data and multiple data domains
• Create thorough documentation artifacts and maintain them for the duration of the project
• Identify and document data migration paths and processes
• Maintain industry and technical knowledge, facilitate and maintain industry relationships
• Demonstrate commitment to providing customer‑focused quality service
• Support assigned systems through transition periods
• Perform additional duties as required to fulfill customer needs
• Develop and perform standard queries to ensure data quality, identify inconsistencies, missing data, and resolve as needed
• Standardize data naming, definitions, and modeling
• Perform data extraction, storage, manipulation, processing, and analysis
• Collect, profile, collate, and map appropriate data for new or existing solutions and ongoing analysis activities
• Interpret customers’ functional and information needs and translate them into functional or data requirements and process models

Qualifications

• 3–6 years of documented experience in data analysis, data manipulation, and decision support
• Knowledge and application of relational database concepts
• Experience or exposure to Extract, Transform, Load (ETL) processes
• Skilled at completing technical design via iterative mockups
• High proficiency with MS Office Suite (especially Word and Excel)
• Openness to learning new skills and software as required
• Demonstrated ability to manage simultaneous workflows while maintaining quality and meeting deadlines
• Demonstrated ability to learn new and exciting technologies with little assistance
• Experience with ETL tools and procedures such as Informatica or Pentaho
• Prior experience working in the Salesforce.com Cloud
• Strong verbal and written communication skills, with the ability to communicate at different organizational levels
• Ability to perform ad‑hoc analysis and maintain clear documentation of decision‑making, data preparation, and processes
• Must be authorized to work for any U.S. employer
• Willingness to travel (35–50%)

Benefits

• Competitive base salary
• Annual performance‑based incentives
• Medical benefits
• 401k plan

Equal Opportunity Employer

EOE M/F/V/D. VEVRAA Federal Contractor.