Lead Data Engineer (AWS, Azure, GCP)

ZipRecruiter; Charlotte (NC); On-site; USD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a skilled Cloud Data Engineer to join their innovative team. In this role, you will design and implement cutting-edge data pipelines, leveraging cloud technologies to optimize data systems for clients. With a strong focus on collaboration and problem-solving, you will partner with product owners and stakeholders to deliver sustainable engineering solutions. This is an exciting opportunity to grow your career in a supportive environment that values learning and development, while making a significant impact on data-driven decision-making for various clients across industries.

Benefits

Generous PTO

Health Coverage

401(k) Matching

Learning & Development Programs

Mental Health Support

Personalized Lifestyle Benefits

Diversity and Inclusion Initiatives

Flexible Work Environment

Qualifications

• 5+ years of experience in data engineering on cloud platforms.
• Expertise in SQL and data pipeline design for large datasets.

Responsibilities

• Design and maintain modern data pipelines using cloud technologies.
• Provide technical leadership and collaborate with teams for optimal solutions.

Skills

Cloud Data Engineering

Data Pipeline Design

SQL

ETL / Data Orchestration

Programming (Python, Java, R)

Data Warehousing

Big Data Concepts

Technical Leadership

Education

Bachelor's Degree in Computer Science or related field

Tools

AWS

Azure

GCP

Git

Jira

Job description

Job Description

Company 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 a 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 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 with 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).
• 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 the data engineering space.
• Cloud certification on any platform is a plus.

Additional Information

We want everyone at CapTech to be able to envision a lasting and rewarding career here, which is why we offer a variety of career paths based on your skills and passions. You decide where and how you want to develop, and we help get you there with customizable career progression and a comprehensive benefits package to support you along the way. Alongside our suite of traditional benefits encompassing generous PTO, health coverage, insurance, paid family leave, and more, we’ve launched extended benefits to help meet our employees’ needs.

• CapFlex – Employee-first mentality that supports a remote and hybrid workforce and empowers daily flexibility while servicing 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 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, 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 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 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, Equity, and Inclusion efforts, click HERE. As part of this commitment, CapTech will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact Laura Massa directly via email [e-mail].

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.

#LI-LM1

#LI-Remote