Data Engineering Associate Consultant

Job Description

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.

Other ways you’ll contribute as an Associate Data Engineer:

• 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

Qualifications

General qualifications include:

• Graduating in December 2025 - Spring/Summer 2026 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

Technical skills needed:

• Familiarity with data ingestion and transformation fundamentals
• Understanding of data analysis and data quality prinicples
• 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)
• Familiarity with entity relationship diagrams (ERD)

*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

Additional Information

We provide challenging and impactful opportunities in our client work and internal teams, while keeping individual interests in mind. We want everyone at CapTech to be able to envision a lifelong career here, which is why we offer a variety of career paths based on your skills and passions. As a CapTecher, you will experience exciting and rewarding roles that help you grow and make a difference, while having fun along the way.  

At CapTech we offer a competitive and comprehensive benefits package including, but not limited to:  

• Learning & Development – Programs offering certification and tuition support, digital on-demand learning courses, mentorship, and skill development paths
• Modern Health –A mental health and well-being platform that provides 1:1 care, group support sessions, and self-serve resources to support employees and their families through life’s ups and downs
• Carrot Fertility –Inclusive fertility and family-forming coverage for all paths to parenthood – including adoption, surrogacy, fertility treatments, pregnancy, and more – and opportunities for employer-sponsored funds to help pay for care
• Fringe –A company paid stipend program for personalized lifestyle benefits, allowing employees to choose benefits that matter most to them – ranging from vendors like Netflix, Spotify, and GrubHub to services like student loan repayment, travel, fitness, and more
• Employee Resource Groups – Employee-led committees that embrace and incorporate diversity and inclusion into our day-to-day operations
• Philanthropic Partnerships – Opportunities to engage in partnerships and pro-bono projects that support our communities 
• 401(k) Matching – Generous matching and no vesting period to help you continue to build financial wellness

CapTech is an equal opportunity employer committed to fostering a culture of equality, inclusion and fairness — each foundational to our core values.  We strive to create a diverse environment where each employee is encouraged to bring their unique ideas, backgrounds and experiences to the workplace. For more information about our diversity, Inclusion and belonging efforts, click HERE. 

CapTech is committed to providing a flexible work environment and helping our employees achieve a work-life balance that suits their individual needs. Employees must be available to work onsite in a client location or a CapTech office as requested. We allow CapTech employees to work remotely when compatible with CapTech and client needs. 

CapTech supports Equal Pay for all. In addition, in the State of Illinois and the State of Colorado we are committed to Equal Pay for ALL in accordance with the Illinois Equal Pay Act and the Colorado Equal Pay for Equal Work Act. The base pay range for this role is: $84,000-$88,000.

At this time, CapTech cannot transfer nor sponsor a work visa for this position. Applicants must be authorized to work directly for any employer in the United States without visa sponsorship.  

CapTech is a Drug-Free work place.
CapTech has not contracted/does not contract with any outside vendors in its recruitment process. If you are interested in this position, please apply to CapTech directly.

#LI-RE!