Data Engineering Associate Consultant (Graduating Dec 2026 - Summer 2027)

CapTech is an award-winning consulting firm that collaborates with clients to achieve what’s possible through the power of technology. At CapTech, we’re passionate about the work we do and the results we achieve for our clients. From the outset, our founders shared a collective passion to create a consultancy centered on strong relationships that would stand the test of time. Today we work alongside clients that include Fortune 100 companies, mid-sized enterprises, and government agencies, a list that spans across the country. Learn more at captechconsulting.com.

Please note: we are hiring for this position in multiple locations (Atlanta, Charlotte, Columbus, Denver, Philadelphia, Reston/DC, and Richmond).

CapTech Data Engineering Associate Consultants are technology enthusiasts with a passion for solving complex business problems and implementing cutting-edge data solutions for our clients. You will enjoy working within a collaborative team environment to help define and deliver innovative, data-driven solutions to our clients.

We attract creatively innovative, ethically insightful, driven, value conscious, caring, and passionate people who love what they do and bring that enthusiasm to projects.

What You Can Expect

- Hands-On Experience: Gain practical, client-facing experience from the start, supported by our client-simulated boot camp. This immersive 3-week program will kickstart your journey as an Associate Consultant in our one-year Discovery Program, designed to support your transition from college to CapTech.
- Continuous Learning: We offer ongoing learning opportunities, including workshops, cross-training, and social events that foster networking and skill development across different areas of our business.
- Mentorship and Growth: Engage in our coaching culture, where you'll be mentored by our Subject Matter Experts. Our commitment to professional growth ensures that you can discover and pursue what you're passionate about through various consulting projects.

Our Data Engineers focus on building and implementing advanced data systems to deliver high quality data to drive business solutions. Utilizing engineering best practices to ingest and process data quickly and efficiently, our engineers look to build advanced systems that bring data together from disparate sources for businesses to use.

Technical skills needed

- Familiarity with data ingestion and transformation fundamentals
- Understanding of data analysis and data quality principles
- Experience developing data solutions using relational database management systems such as: SQL Server, MySQL, Redshift, Amazon RDS, etc.
- Fundamental proficiency in: Python, SQL or another scripting language to extract and manipulate data
- Familiar with version control systems such as GIT
- Familiarity with fundamental AI/ML concepts
- Understanding of data preparation for use with AI models

Set yourself apart with prior work/internships in a related technical field and/or this experience

- Working with one or more data transformation tools/products: Azure Data Factory, AWS Glue, Google Data Fusion
- Fundamental understanding of one or more cloud providers and storage solutions such as: AWS (S3), Google Cloud Platform and Storage, Azure (Blob Storage)
- Experience using AI to accelerate development of data engineering solutions

*Graduate students only considered if they went straight to grad school from undergrad and have no prior full-time work experience, otherwise please refer to our experienced hire postings at https://www.captechconsulting.com/careers/captech-experiencedhires

Responsibilities

Build data systems that bring together data from disparate sources, making it available to data scientists, analysts, and other users; Ingest, clean, and transform structured and unstructured datasets to solve data problems and deliver data solutions; Design, develop, and implement data processing pipelines at scale; Leverage AI to accelerate development and validation of data pipelines

Requirements

Graduating in December 2026 - Spring/Summer 2027 with a bachelor’s or +1/accelerated masters* degree in Information Systems, Data Analytics, Computer Science, or similar discipline; Prior work, internship or classroom experience in business concepts and processes with the chance to work with specific tools; Excellent oral and written communication skills, including the ability to collaborate with cross-functional teams and communicate AI concepts to non-technical colleagues; Strong problem solving and troubleshooting ability