Lead Data Engineer (AWS, Azure, GCP)

Company Description

CapTech is an award-winning consulting firm that partners with clients to realize the potential of technology. At CapTech, we have a passion for our work and the results we deliver to our clients. Our founders held a shared vision of building a consulting company focused on establishing robust relationships that endure over time. Today, we work together with clients including Fortune 100 companies, mid-sized businesses, and government agencies, spanning across the country.

Job Description

CapTech Data Engineering consultants enable clients to construct and maintain advanced data systems that integrate data from variegated sources to facilitate decision-making. We build pipelines and prepare data for use by data scientists, data analysts, and other data systems. We enjoy solving problems and providing innovative solutions to our clients. Our Cloud Data Engineers utilize the client's cloud infrastructure to deliver this value today and prepare for future scalability. We cherish a collaborative environment and offer numerous chances to learn from and share knowledge with other developers, architects, and our clients. 

The Value You Deliver (or What You Will Do) 

• Act as a trusted advisor to customers regarding best practices, methodologies, and technologies in implementing data engineering solutions. 
• Design, implement and maintain contemporary data pipelines to deliver optimal solutions using suitable cloud technologies.  
• Collaborate with product owners and business SMEs to analyze customer requirements and provide sustainable and supportable engineered solutions. 
• Offer technical leadership and cooperate within and across teams to ensure the overall technical solution aligns with the customer's needs. 
• Stay updated with the most recent cloud technologies, patterns, and methodologies; share knowledge by articulately conveying results and ideas to key stakeholders. 

Qualifications

• Experience in building/operating highly available distributed systems for data extraction, ingestion, and processing of large data sets 
• 5+ years of experience in delivering data engineering solutions on the cloud platform 
• 5+ years of experience in implementing contemporary designs using at least one cloud-based solution/platform (AWS, Azure, GCP) 
• Advanced level proficiency with at least one ETL / Data Orchestration technology (Azure Data Factory, SSIS, Informatica, Alteryx, Ab Initio, Pentaho, Talend, Matillion) 
• Experience with cloud-based data warehousing and data lake solutions like Snowflake, Redshift, Databricks 
• 5+ years of experience with SQL or NoSQL databases (PostgreSQL, MySQL, SQL server, Oracle, Aurora, Presto, BigQuery) 
• Expertise in SQL, database design/structure and data structure (star, snowflake schemas, de/normalized designs) 
• 5+ years of experience with at least one programming language (Python, Java, R, C / C# / C++, Shell) 
• Familiarity with one or more DevOps tools (git, Jenkins, CI/CD, Jira) 
• Basic understanding of big data, open source, and data streaming concepts 
• Ability to think strategically and provide recommendations using traditional and modern architectural components based on business needs 
• Experience in providing technical leadership and mentoring other engineers in the data engineering sphere 
• Cloud certification on any platform is a plus 

Additional Information

We want everyone at CapTech to envision a long, fulfilling career here. Hence, we offer various career paths based on your skills and interests. You choose your progression, and we support you with customizable career development and a thorough benefits package.

• CapFlex – Employee-first approach supporting a remote and hybrid workforce and promoting daily flexibility in serving our clients.
• 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 offering 1:1 care, group support sessions, and self-serve resources to help employees and their families cope with life’s challenges.
• Carrot Fertility – Comprehensive fertility and family-building coverage for all paths to parenthood, including adoption, surrogacy, fertility treatments, pregnancy, and more. Also offers opportunities for employer-sponsored funds to assist with care expenses.
• Fringe – A company-paid stipend program for customized lifestyle benefits, allowing employees to choose benefits most important 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 integrate diversity and inclusion in our day-to-day operations.
• Philanthropic Partnerships – Opportunities to participate in partnerships and pro-bono projects that benefit our communities.
• 401(k) Matching – Generous matching with no vesting period to help you continue your financial wellness journey.

CapTech is an equal opportunity employer committed to fostering a culture of equality, inclusion, and fairness, all of which are foundational to our core values. We aim to create a diverse environment where every 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 reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation to participate in the job application or interview process, to perform essential job functions, or receive other benefits and privileges of employment, please contact Laura Massa directly via email [email protected].

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

#LI-LM1 

#LI-Remote