Public Health Data Engineer

Guidehouse; San Antonio, Northern (TX, KY); Hybrid; USD 85,000 - 125,000; Full time

Benefits offered by this job

Medical insurance

Paid holidays and sick time

401(k) plan

Professional development opportunities

Job summary

Guidehouse seeks a Data Engineer to support data pipelines, cloud platforms, and analytics solutions. The role is suited for an early-career professional eager to learn and grow in a collaborative team, with exposure to Python, SQL, PySpark, and cloud services in AWS/Azure.

You will assist in ETL/ELT development, data validation, and documentation while collaborating with cross-functional stakeholders on modernization initiatives.

Qualifications

• U.S. Citizenship or permanent residency is required and ability to obtain/maintain Public Trust.
• 2+ years in data engineering, software engineering, or related field.
• Experience with Python/SQL and cloud-based data platforms.
• Familiarity with ETL/ELT, data warehousing, and analytics concepts.

Responsibilities

• Develop, test, and maintain data pipelines and ETL/ELT processes.
• Support data models, databases, and cloud data solutions.
• Participate in data integration, migration, and modernization projects.
• Create scripts and queries using Python, SQL, and PySpark.
• Assist with CI/CD, Git workflows, and DevOps practices.

Skills

Python

SQL

PySpark

Cloud platforms

Git

Education

Bachelor's degree in Computer Science / Data Science / Engineering

Tools

Databricks

Power BI

Job description

## Public Health Data EngineerApply: US - TX, San Antonio: GH Office: Charlotte, NC: GH Office: Houston, TX: GH Office: Huntsville, AL (TCP Location): GH Office: Beavercreek, OH (TCP Location): Full time: Posted Yesterday: 43045**Job Family:**Data Science & Analysis**Travel Required:**Up to 10%**Clearance Required:**Ability to Obtain Public Trust**What You Will Do:**Guidehouse seeks a Data Engineer to support the development, maintenance, and enhancement of data pipelines, cloud-based data platforms, and analytics solutions. The ideal candidate is an early-career professional with foundational experience in data engineering, software development, or cloud technologies who is eager to learn and grow in a collaborative environment.* Assist in developing, testing, and maintaining data pipelines and ETL/ELT processes that ingest, transform, and load data from various sources.* Support the implementation and enhancement of data models, databases, and cloud-based data solutions.* Participate in data integration, migration, and modernization initiatives under the guidance of senior engineers.* Develop and maintain scripts, queries, and applications using technologies such as Python, SQL, and PySpark.* Support cloud-based data environments and services in AWS and Azure.* Assist with the implementation of CI/CD processes and software development best practices using Git and related tools.* Monitor data pipelines and systems, identify issues, and support troubleshooting and resolution activities.* Perform data validation and quality assurance activities to help ensure data accuracy, completeness, and reliability.* Collaborate with data engineers, developers, analysts, and other stakeholders to deliver high-quality solutions.* Document technical processes, data flows, and system configurations.* Continuously develop technical skills and stay current with emerging data engineering technologies and best practices.**What You Will Need:*** U.S. Citizenship or permanent residency is required and Must be able to OBTAIN and MAINTAIN a Federal or DHS \"PUBLIC TRUST.* Bachelor's degree in Computer Science, Data Science, Information Systems, Engineering, Mathematics, or a related technical field.* TWO (2) or more years of experience in data engineering, software engineering, data analytics, computer science, or a related technical discipline.* Experience with a programming language such as Python, Java, or SQL.* Experience with cloud platforms such as AWS or Azure through coursework, certifications, internships, or professional experience.* Experience with data integration, ETL, data warehousing, or analytics concepts.**What Would Be Nice To Have:*** Internship, academic, research, or project experience involving data engineering, cloud computing, or software development.* Basic understanding of relational databases and data querying concepts.* Familiarity with version control systems such as Git.* Basic understanding of software development lifecycle and Agile methodologies.* Strong analytical, problem-solving, and troubleshooting skills.* Ability to learn new technologies and work collaboratively in a team environment.* Strong verbal and written communication skills.* Experience working with public health data and agencies* Exposure to Databricks, Spark, or large-scale data processing technologies.* Familiarity with AWS services such as S3, Lambda, or Redshift, or Azure services such as Azure Data Factory, Azure Functions, or Cosmos DB.* Experience with data visualization or reporting tools such as Power BI, Tableau, or Kibana.* Exposure to CI/CD tools and DevOps practices.* AWS, Azure, Databricks, or related cloud/data certifications.* Experience supporting healthcare, public sector, or federal clients.* Interest in data architecture, machine learning, artificial intelligence, or advanced analytics.* Previous consulting, client-facing, internship, or cooperative education experience.**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