LogoFresh Jobs Ahead
Guidehouse
Guidehouse
H1B Visa SponsorDefenseHealthcareLogistics
Guidehouse is a global consulting firm that provides advisory, digital, and managed services to commercial and public-sector organizations. Its work supports clients in national security, financial services, healthcare, energy, and infrastructure, combining data analytics, digital technologies, risk management, and related expertise to address complex operational and strategic challenges. Guidehouse also emphasizes sustainability and innovation in its approach to organizational transformation.
LinkedIn
Company Jobs

Remote ETL Developer

Build and support enterprise ETL/ELT pipelines, data warehouses, and integration workflows for Guidehouse consulting services. Help deliver secure, governed, high-performance data solutions.

USUnited States
$113,000 – $188,000 / year
RemoteFull-timeMiddleSeniorEnglish RequiredAnalytics Engineer
AWSCloudCyber SecurityETLInformaticaMySQLOraclePostgresSQLSSIS

Description

  • Design, develop, test, and maintain enterprise ETL/ELT solutions that integrate data from multiple source systems.
  • Develop scalable, high-performance pipelines for batch and near-real-time data processing.
  • Build and maintain integration workflows with modern ETL tools and cloud data platforms.
  • Analyze source systems and business needs to define data mapping, transformation, and validation rules.
  • Tune ETL performance, troubleshoot processing issues, and implement optimizations.
  • Work 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.
  • Maintain technical documentation, design specifications, and operational runbooks.
  • Support production deployments, incident resolution, and ongoing improvements.
  • Ensure compliance with data governance, security, privacy, and organizational standards.

Requirements

  • U.S. citizenship or permanent residency, and ability to obtain Public Trust clearance.
  • Bachelor’s degree in computer science, cybersecurity, engineering, or a related field; four additional years of relevant experience may substitute for the degree.
  • At least six years of hands-on ETL development, data integration, and data warehousing experience.
  • Strong experience with ETL tools such as Informatica, SSIS, Talend, DataStage, AWS Glue, or similar platforms.
  • Proficiency in SQL and databases such as SQL Server, Oracle, PostgreSQL, or MySQL.
  • Experience designing complex data transformations, migrations, and integrations.
  • Strong understanding of data warehousing, dimensional modeling, and star and snowflake schemas.
  • Experience with cloud data services and modern data platforms.
  • Knowledge of data quality, governance, and metadata management practices.
  • Experience tuning performance, handling errors, and troubleshooting large-scale ETL processes.
  • Strong analytical, problem-solving, and communication skills.
  • Ability to work effectively in Agile environments and collaborate across technical and business teams.

Benefits

  • Medical, prescription, dental, and vision insurance.
  • Personal and family sick time, plus company-paid holidays.
  • Parental leave.
  • 401(k) retirement plan.
  • Group term life insurance and travel assistance.
  • Voluntary life and AD&D insurance.
  • Health Savings Account, Health Care and Dependent Care Flexible Spending Accounts.
  • Transit and parking commuter benefits.
  • Short- and long-term disability coverage.
  • Tuition reimbursement, personal development, certifications, and learning opportunities.
  • Employee referral program.
  • Company-sponsored events and community outreach.
  • Annual Care.com membership.
  • Employee Assistance Program.
  • Supplemental benefits through Corestream, including critical care, hospital indemnity, accident insurance, legal assistance, and identity theft protection.
  • The position may be eligible for a discretionary variable incentive bonus.
  • Flexible benefits package.

Related Jobs