Lead Data Engineer (AWS, Azure, GCP)

ZipRecruiter; Richmond (VA); Remote; USD 100,000 - 130,000; Full time

Job summary

A leading consulting firm seeks a Cloud Data Engineer to develop and maintain data systems that empower decision-makers. The role involves creating data pipelines, collaborating with clients, and leveraging cloud infrastructure. Suitable candidates will have strong experience in data engineering, cloud platforms, and ETL technologies.

Benefits

Employee-first mentality supporting remote and hybrid workforces

Certification and tuition support

Mental health and well-being platform

Inclusive family-forming coverage

Personalized lifestyle benefits stipend

Employee Resource Groups fostering inclusion

401(k) Matching

Qualifications

• 5+ years of experience delivering data engineering solutions on cloud platforms.
• Advanced proficiency with ETL/Data Orchestration technology.
• Expertise with SQL and database design.

Responsibilities

• Design, implement, and maintain modern data pipelines.
• Provide technical leadership for customer data solutions.
• Stay current with latest cloud methodologies and technologies.

Skills

Data Engineering

Cloud Technologies

ETL

SQL

Python

Education

Cloud Certification

Tools

Azure Data Factory

Informatica

Snowflake

Git

Job description

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.

Job Description

CapTech Data Engineering consultants enable clients to build and maintain advanced data systems that bring together data from disparate sources in order to enable decision-makers. We build pipelines and prepare data for use by data scientists, data analysts, and other data systems. We love solving problems and providing creative solutions for our clients. Cloud Data Engineers leverage the client’s cloud infrastructure to deliver this value today and to scale for the future. We enjoy a collaborative environment and have many opportunities to learn from and share knowledge with other developers, architects, and our clients.

The Value You Deliver (or What You’ll Do)

• Be trusted advisor to customers with best practices, methodologies, and technologies to implement data engineering solutions.
• Design, implement, and maintain modern data pipelines to deliver optimal solutions utilizing appropriate cloud technologies.
• Partner with product owners and business SMEs to analyze customer requirements and provide a supportable and sustainable engineered solution.
• Provide technical leadership and collaborate within and across teams to ensure that the overall technical solution is aligned with the customer needs.
• Stay current with the latest cloud technologies, patterns, and methodologies; share knowledge by clearly articulating results and ideas to key stakeholders.

Qualifications

• Experience building/operating highly available distributed systems of data extraction, ingestion, and processing large data sets.
• 5+ years of experience delivering data engineering solutions on cloud platforms.
• 5+ years of experience implementing modern designs using at least one cloud-based solution/platform (AWS, Azure, GCP).
• Advanced 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 with SQL, database design/structure, and data structures (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 DevOps tools (git, Jenkins, CI/CD, Jira).
• Fundamental understanding of big data, open source, and data streaming concepts.
• Ability to think strategically and provide recommendations utilizing traditional and modern architectural components based on business needs.
• Experience providing technical leadership and mentoring other engineers in data engineering.
• Cloud certification on any platform is a plus.

Additional Information

We want everyone at CapTech to envision a lasting and rewarding career here, which is why we offer various career paths based on your skills and passions. You decide where and how you want to develop, and we support you with customizable career progression and a comprehensive benefits package.

• CapFlex – Employee-first mentality supporting remote and hybrid workforces with flexibility.
• Learning & Development – Certification and tuition support, digital courses, mentorship, and skill development.

• Modern Health – Mental health and well-being platform offering care, support sessions, and resources.
• Carrot Fertility – Inclusive fertility and family-forming coverage, including adoption, surrogacy, and treatments.
• Fringe – Stipend program for personalized lifestyle benefits, from entertainment to services.
• Employee Resource Groups – Employee-led committees fostering inclusion and community.
• Philanthropic Partnerships – Opportunities for community engagement and pro-bono projects.
• 401(k) Matching – Generous employer matching to support financial wellness.

CapTech is an equal opportunity employer committed to diversity and inclusion. We strive to create a welcoming environment where everyone can bring their ideas and experiences. For more about our diversity and belonging efforts, click HERE. We provide reasonable accommodations for persons with disabilities. If needed, contact Laura Massa at [e-mail].

Currently, CapTech cannot transfer nor sponsor work visas for this position. Applicants must be authorized to work in the U.S. without sponsorship.

#LI-LM1

#LI-Remote