ETL Developer

Guidehouse

. Design, develop, test, and maintain enterprise ETL/ELT solutions integrating data from multiple source systems .

Posted 10/12/2026full-timeRemote • United StatesMid-LevelSenior💰 $113,000 - $188,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in ETL development, data integration, and data warehousing, with a strong focus on optimizing performance and ensuring data quality. Proficient in collaborating with cross-functional teams to design and implement scalable data solutions in compliance with governance and security standards.

Highest-signal resume keywords

ETL DevelopmentData IntegrationData WarehousingSQL ProficiencyETL Tools Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

ETL DevelopmentData IntegrationData WarehousingSQLData TransformationPerformance TuningData MigrationData Quality ChecksMetadata ManagementCloud-Based Data Services

Soft Skills

Analytical SkillsProblem-Solving SkillsCommunication Skills

Tools & Technologies

InformaticaSSISTalendDataStageAWS GlueSQL ServerOraclePostgreSQLMySQL

Industry Keywords

Data GovernanceAgile DevelopmentDimensional ModelingStar SchemaSnowflake Schema

Tech Stack

Tools & technologies

AWSCloudCyber SecurityETLInformaticaMySQLOraclePostgresSQLSSIS

About the role

Key responsibilities & impact

Design, develop, test, and maintain enterprise ETL/ELT solutions integrating data from multiple source systems
Develop scalable, high-performance data pipelines for batch and near real-time data processing
Build and maintain data integration workflows using modern ETL tools and cloud-based data platforms
Analyze source systems and business requirements to create data mapping, transformation, and validation rules
Optimize ETL performance, troubleshoot data processing issues, and implement tuning strategies
Collaborate with data architects, database administrators, business analysts, and application teams
Develop and maintain data warehouses, operational data stores, and reporting data marts
Implement data quality checks, reconciliation processes, and exception handling frameworks
Create and maintain technical documentation, design specifications, and operational runbooks
Support production deployments, incident resolution, and continuous improvement initiatives
Ensure compliance with data governance, security, privacy, and organizational standards

Requirements

What you’ll need

U.S. Citizenship or Green Card required, with the ability to obtain a Public Trust clearance
Bachelor’s degree in computer science, cybersecurity, engineering, or a related field; four additional years of relevant experience may be substituted in lieu of a degree
Minimum 6 years of hands-on experience in ETL development, data integration, and data warehousing
Strong experience with ETL tools such as Informatica, SSIS, Talend, DataStage, AWS Glue, or similar platforms
Proficiency in SQL and database technologies including SQL Server, Oracle, PostgreSQL, or MySQL
Experience designing complex data transformation, data migration, and integration
Strong understanding of data warehousing concepts, dimensional modeling, and star/snowflake schemas
Experience working with cloud-based data services and modern data platforms
Knowledge of data quality, data governance, and metadata management best practices
Experience with performance tuning, error handling, and troubleshooting large-scale ETL processes
Strong analytical, problem-solving, and communication skills
Ability to work effectively in Agile development environments and collaborate across technical and business teams

Benefits

Comp & perks

Medical, Rx, Dental & Vision Insurance
Personal and Family Sick Time & Company Paid Holidays
Parental Leave
401(k) Retirement Plan
Group Term Life and Travel Assistance
Voluntary Life and AD&D Insurance
Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts
Transit and Parking Commuter Benefits
Short-Term & Long-Term Disability
Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities
Employee Referral Program
Corporate Sponsored Events & Community Outreach
Care.com annual membership
Employee Assistance Program
Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)
Position may be eligible for a discretionary variable incentive bonus
Flexible benefits package