Data Engineer

Guidehouse; Charlotte (NC); On-site; USD 53,000 - 88,000; Full time

Benefits offered by this job

Medical, Rx, Dental & Vision Insurance

401(k) Retirement Plan

Paid Holidays

Tuition Reimbursement

Job summary

Guidehouse seeks a Data Engineer I to support development, maintenance, and enhancement of data pipelines, cloud-based data platforms, and analytics solutions. An early-career professional with foundational experience in data engineering or cloud technologies is preferred.

The role involves building ETL/ELT processes, supporting data models, and collaborating with engineers, analysts, and stakeholders to deliver high-quality solutions. Travel up to 10% may be required.

Qualifications

• Bachelor's degree in a related technical field.
• Foundational knowledge of programming languages such as Python, Java, or SQL.
• Experience in data engineering, software engineering, data analytics, computer science, or a STEM related technical discipline.
• Familiarity with cloud platforms such as AWS or Azure.
• Exposure to data integration, ETL, data warehousing, or analytics concepts.

Responsibilities

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

Skills

Python

SQL

PySpark

Git

AWS

Azure

ETL/ELT

Data pipelines

Data modeling

Education

Bachelor's degree

Tools

Databricks

Kubernetes

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