[Remote] Data Engineer

Note: The job is a remote job and is open to candidates in USA. Guidehouse is a consulting firm that seeks a Data Engineer to support in building, optimizing, and maintaining data pipelines, cloud-based solutions, and analytics platforms. The role involves designing and developing robust data pipelines, optimizing data architectures, and collaborating with cross-functional teams to deliver high-quality data solutions.ResponsibilitiesDesign, develop, and maintain robust data pipelines and ETL processes for ingesting, transforming, and loading data from diverse sourcesBuild and optimize data architectures and models to support analytics, reporting, and operational needsImplement and manage CI/CD pipelines for data engineering workflows using tools such as Jenkins, Maven, and GitDevelop and deploy cloud-based solutions leveraging AWS (S3, Lambda, ECS, SQS), Azure (CosmosDB, Functions), and containerization (Docker, Kubernetes)Collaborate with DBAs and application developers to design and integrate data models, stored procedures, and APIsEnsure data quality, integrity, and security through rigorous validation, monitoring, and logging (e.g., Splunk, CloudWatch, Kibana)Support data migration, integration, and modernization initiatives, including legacy system upgrades and cloud adoptionTroubleshoot and resolve issues in production environments, ensuring high availability and reliabilityDocument data flows, processes, and technical solutions for knowledge sharing and complianceStay current with emerging technologies and best practices in data engineering, cloud, and DevOpsSkillsU.S. Citizenship/ Green Card is requiredA bachelor's degree is requiredMinimum of EIGHT (8) years of experience in data engineering, software development, or related rolesProficiency in programming languages and technologies, including Java, Python, SQL, and PySpark, as well as API development (RESTful and SOAP)Strong hands-on experience designing and developing data pipelines and ETL processesExtensive experience with relational and NoSQL databases, such as Oracle, MySQL, PostgreSQL, SQL Server, and MongoDB, including data modeling and stored procedure developmentDemonstrated experience with AWS cloud services, including S3, Redshift, Lambda, ECS, and SQSExperience working with Databricks and large-scale data processing environmentsFamiliarity with containerization and orchestration technologies, including Docker and KubernetesExperience with CI/CD tools and pipelines, such as Jenkins, Maven, Git, GitHub, and BitbucketHands-on experience with monitoring and logging tools, including Splunk, CloudWatch, Kibana, and ElasticsearchProven experience operating in Agile development environmentsFamiliarity with version control and collaboration tools, including Git, Jira, and ConfluenceAbility to work independently in a fast-paced environmentStrong analytical and troubleshooting skillsExcellent verbal and written communication skills, with the ability to clearly communicate complex technical concepts to diverse audiencesExperience supporting federal programs and/or large-scale data modernization projectsCertifications in AWS, or other cloud/data engineering domainsExperience with data visualization tools (e.g., Kibana, Tableau)Familiarity with security best practices and compliance in federal environmentsExperience with microservices, Spring Boot, and integration of AI/ML componentsPrevious consulting experienceBenefitsMedical, Rx, Dental & Vision InsurancePersonal and Family Sick Time & Company Paid HolidaysPosition may be eligible for a discretionary variable incentive bonusParental Leave and Adoption Assistance401(k) Retirement PlanBasic Life & Supplemental LifeHealth Savings Account, Dental/Vision & Dependent Care Flexible Spending AccountsShort-Term & Long-Term DisabilityStudent Loan PayDownTuition Reimbursement, Personal Development & Learning OpportunitiesSkills Development & CertificationsEmployee Referral ProgramCorporate Sponsored Events & Community OutreachEmergency Back-Up Childcare ProgramMobility StipendCompany OverviewGuidehouse offers consulting services for public and commercial markets with expertise in management, technology, and risk consulting. It was founded in 2018, and is headquartered in Washington, District of Columbia, USA, with a workforce of 10001+ employees. Its website is https://guidehouse.com.