Lead Data Engineer; AWS, Azure, GCP

Overview

Cap Tech is an award-winning consulting firm that collaborates with clients to achieve what’s possible through the power of technology. We’re passionate about the work we do and the results we achieve for our clients. Today we work alongside Fortune 100 companies, mid-sized enterprises, and government agencies across the country.

Cap Tech 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. Cloud Data Engineers leverage the client’s cloud infrastructure to deliver 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.

• 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.

• 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 No
  
  SQL databases (Postgre
  
  SQL, MySQL, SQL Server, Oracle, Aurora, Presto, Big Query).
• 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 one or more Dev Ops 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.

We want everyone at Cap Tech to envision a lasting and rewarding career here. We offer customizable career progression and a comprehensive benefits package, including generous PTO, health coverage, disability insurance, paid family leave, and extended benefits.

• Learning & Development – Certification and tuition support, digital on-demand learning, mentorship, and skill development paths
• Modern Health – Mental health and well-being platform with 1:1 care, group support, and self-serve resources
• Carrot Fertility – Inclusive fertility and family-forming coverage for all paths to parenthood
• Fringe – Stipend program for personalized lifestyle benefits
• Employee Resource Groups – Diversity and inclusion initiatives
• Philanthropic Partnerships – Pro-bono projects and community partnerships
• 401(k) Matching – Generous matching with no vesting period

Cap Tech is an equal opportunity employer committed to fostering a culture of equality, inclusion, and fairness. We provide reasonable accommodations for applicants with disabilities. If accommodations are needed to participate in the job application or interview process, please contact Laura Massa at

At this time, Cap Tech 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.