Job Family:
Software Development & Support
Travel Required:
None
Clearance Required:
Ability to Obtain Public Trust
What You Will Do:
- Design, develop, test, and maintain enterprise ETL/ELT solutions to integrate data from multiple source systems.
- Develop scalable and 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 efficient data mapping, transformation, and validation rules.
- Optimize ETL performance, troubleshoot data processing issues, and implement tuning strategies to improve efficiency.
- Collaborate with data architects, database administrators, business analysts, and application teams to deliver reliable data solutions.
- 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.
What You Will 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.
What Would Be Nice To Have:
- Experience with AWS data services such as AWS Glue, S3, Redshift, Lambda, Athena, and Step Functions.
- Experience with modern data lake and lakehouse architectures.
- Knowledge of Python, PySpark, Shell Scripting, or other automation technologies.
- Experience with CI/CD pipelines and DevOps practices for data engineering.
- Familiarity with data visualization and analytics tools such as Power BI, Tableau, or QuickSight.
- Experience supporting federal government or highly regulated environments.
- Industry certifications related to cloud platforms, data engineering, or database technologies.
- Experience implementing master data management (MDM) and data governance frameworks.
- Knowledge of big data technologies such as Spark, Kafka, or Hadoop.
- Experience mentoring junior developers and leading technical implementation efforts.
The annual salary range for this position is $113,000.00-$188,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.
What We Offer:
Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.
Benefits include:
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
