Captech Ventures - Columbus, OH

posted 3 months ago

Full-time - Mid Level
Columbus, OH
Professional, Scientific, and Technical Services

About the position

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. 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. As a Lead Data Engineer, you will be a trusted advisor to customers, providing best practices, methodologies, and technologies to implement data engineering solutions. You will design, implement, and maintain modern data pipelines to deliver optimal solutions utilizing appropriate cloud technologies. Partnering with product owners and business SMEs, you will analyze customer requirements and provide a supportable and sustainable engineered solution. You will also provide technical leadership and collaborate within and across teams to ensure that the overall technical solution is aligned with customer needs. Staying current with the latest cloud technologies, patterns, and methodologies is essential, as you will share knowledge by clearly articulating results and ideas to key stakeholders.

Responsibilities

  • 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 customer needs.
  • Stay current with the latest cloud technologies, patterns, and methodologies; share knowledge by clearly articulating results and ideas to key stakeholders.

Requirements

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

Nice-to-haves

  • Cloud certification on any platform is a plus.

Benefits

  • Generous PTO
  • Health coverage
  • Disability insurance
  • Paid family leave
  • CapFlex - Employee-first mentality that supports a hybrid workforce and empowers daily flexibility while servicing 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.
  • Carrot Fertility - Inclusive fertility and family-forming coverage for all paths to parenthood.
  • Fringe - A company paid stipend program for personalized lifestyle benefits.
  • Employee Resource Groups - Employee-led committees that embrace and incorporate diversity and inclusion.
  • Philanthropic Partnerships - Opportunities to engage in partnerships and pro-bono projects.
  • 401(k) Matching - Generous matching and no vesting period.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service