Data Engineer

Guidehouse; San Antonio (TX); On-site; USD 53,000 - 88,000; Full time

Benefits offered by this job

Health insurance

401(k)

Paid holidays

Parental Leave

Job summary

Guidehouse seeks a Data Engineer I to support development, maintenance, and enhancement of data pipelines and analytics solutions. The ideal candidate is an early-career professional with foundational experience in data engineering, software development, or cloud technologies, eager to learn and grow in a collaborative environment.

Responsibilities include developing ETL/ELT processes, data models, and cloud-based solutions on AWS/Azure, and contributing to CI/CD practices.

Qualifications

• Requires U.S. citizenship or Green Card and ability to obtain/maintain public trust.
• Bachelor's degree in a technical field (CS/DS/IS/Engineering/Math).
• Experience in data engineering, software, analytics, or related technical discipline.
• Programming in Python, Java, or SQL.
• Experience with ETL, data warehousing, or analytics concepts.

Responsibilities

• Assist in developing, testing, and maintaining data pipelines/ETL processes.
• Support data models, databases, and cloud-based data solutions.
• Participate in data integration and modernization initiatives under guidance.
• Develop scripts and queries using Python, SQL, and PySpark.
• Support AWS/Azure cloud data environments and CI/CD practices.
• Monitor pipelines, troubleshoot issues, and ensure data quality.

Skills

Python

SQL

PySpark

ETL/ELT

Data Modeling

Git

CI/CD

Data Analytics

Education

Bachelor's degree in Computer Science / Data Science / Information Systems / Engineering / Mathematics

Tools

Databricks

Spark

Git

AWS

Azure

Power BI

Job description

What You Will Do

Guidehouse seeks a

• 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.

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 I 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.
• Role contingent upon contract award

What You Will Need

• U.S. Citizenship or Green Card 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.
• Experience in data engineering, software engineering, data analytics, computer science, or a related technical discipline.
• Experience in programming languages such as Python, Java, or SQL.
• 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.
• Exposure to Databricks, Spark, or large-scale data processing technologies.
• Basic understanding of relational databases and data querying concepts.
• Familiarity with cloud platforms such as AWS or Azure through coursework, certifications, internships, or professional experience.
• 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.
• 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.

The annual salary range for this position is $53,000.00-$88,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

About Guidehouse

Guidehouse is an Equal Opportunity Employer–Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation.

Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.

If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at [e-mail]. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.