Data Engineer

Guidehouse; Beavercreek (OH); On-site; USD 53,000 - 88,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

401(k) Retirement Plan

Parental Leave

Tuition Reimbursement

Employee Referral Program

Job summary

Guidehouse is seeking an early-career Data Engineer I to support data pipelines, cloud-based platforms, and analytics solutions. The role targets individuals with foundational data engineering or software development experience who are eager to learn in a collaborative environment.

The position emphasizes building, testing, and maintaining ETL/ELT processes, optimizing data models, and working with Python, SQL, and PySpark in AWS/Azure environments.

Qualifications

• Familiarity with Python, SQL, and Java.
• Foundational data engineering knowledge and software development basics.
• Experience with cloud platforms (AWS or Azure) is preferred.

Responsibilities

• Assist in developing, testing, and maintaining data pipelines and ETL/ELT processes.
• Support the implementation and enhancement of data models and cloud-based data solutions.
• Collaborate with data engineers, developers, analysts, and stakeholders to deliver high-quality data solutions.
• Document technical processes, data flows, and system configurations.
• Continuously develop technical skills with emerging data engineering technologies.

Skills

Python

SQL

Java

Education

Bachelor's degree in Computer Science or related field

Tools

Git

AWS

Azure

Databricks

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.

What You Will Need

• 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 STEM related technical discipline.
• Foundational knowledge of programming languages such as Python, Java, or SQL.
• 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.
• Exposure to 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.
• 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, ... 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.

All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @guidehouse.com or [e-mail]. Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process.

If any person or organization demands money related to a job opportunity with Guidehouse, please report the matter to Guidehouse’s Ethics Hotline. If you want to check the validity of correspondence you have received, please contact [e-mail]. Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicant’s dealings with unauthorized third parties.

Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.