Data Engineer (AWS, Azure, GCP)

CapTech Richmond - Philadelphia, PA

Full-time - Mid Level

Philadelphia, PA

Professional, Scientific, and Technical Services

About the position

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.

Responsibilities

• Developing data pipelines and other data products using Amazon Web Services (AWS), Microsoft Azure, or Google Cloud Platform (GCP)
• Advising clients on specific technologies and methodologies for utilizing cloud resources to efficiently ingest and process data quickly
• Utilizing your skills in engineering best practices to solve complex data problems
• Collaborating with end users, development staff, and business analysts to ensure that prospective data architecture plans maximize the value of client data across the organization.
• Articulating architectural differences between solution methods and the advantages/disadvantages of each

Requirements

• Experience delivering solutions on a major cloud platform
• Ability to think strategically and relate architectural decisions/recommendations to business needs and client culture
• Experience in the design and implementation of data architecture solutions
• A wide range of production database experience, usually including substantial SQL expertise, database administration, and scripting data pipelines
• Ability to assess and utilize traditional and modern architectural components required based on business needs.
• A demonstrable ability to deliver production data pipelines and other data products.

Nice-to-haves

• Experience with SQL, Python, Java, R, C# / C++ / C
• Familiarity with SQL Server, PostgreSQL, Snowflake, Redshift, Aurora, Presto, BigQuery, Oracle
• Experience with git, docker, subversion, Kubernetes, Jenkins
• Knowledge of Spark, Databricks, Kafka, Kinesis, Hadoop, Lambda, EMR
• Certifications such as AWS Cloud Practitioner, Microsoft Azure Data Fundamentals, Google Associate Cloud Engineer

Benefits

• Generous PTO
• Health coverage
• Disability insurance
• Paid family leave
• CapFlex - Employee-first mentality that supports a remote and hybrid workforce
• Learning & Development programs offering certification and tuition support
• Modern Health - A mental health and well-being platform
• Carrot Fertility - Inclusive fertility and family-forming coverage
• Fringe - A company paid stipend program for personalized lifestyle benefits
• Employee Resource Groups - Employee-led committees for diversity and inclusion
• Philanthropic Partnerships - Opportunities for community engagement
• 401(k) Matching - Generous matching and no vesting period