Senior Data Engineer (AWS, Azure, GCP)

CapTech Consulting; Chicago (IL); Hybrid; USD 90,000 - 200,000; Full time

Benefits offered by this job

Generous PTO

Health coverage

Flexible work environment

Learning & Development programs

Mental health support

Inclusive fertility coverage

Company paid stipend for lifestyle benefits

Philanthropic partnerships

401(k) matching

Job summary

CapTech Consulting is seeking a Data Engineer in Chicago, IL. You will design, implement, and maintain data pipelines, and work closely with product owners to provide engineered solutions. The ideal candidate has extensive experience in cloud technologies and data engineering.

Benefits include flexible work arrangements, professional development programs, and support for mental health and family needs. The salary range is between $90,000 and $200,000, reflecting the skills and experience required for the role.

Qualifications

• 5+ years of experience delivering data engineering solutions on cloud platforms.
• Experience with cloud-based data solutions like Snowflake or Redshift.
• Expertise in SQL and database design.

Responsibilities

• Design and maintain modern data pipelines using cloud technologies.
• Provide technical leadership and collaborate with teams.
• Stay updated with the latest cloud technologies and share knowledge.

Skills

Building/operating highly available distributed systems

Data engineering solutions on cloud platforms

Implementing modern designs with cloud-based solutions

ETL / Data Orchestration technology

Cloud-based data warehousing solutions

SQL or NoSQL database skills

Database design/structure expertise

Programming language (Python, Java, etc.)

DevOps tools familiarity

Understanding of big data and data streaming

Strategic thinking and recommendations

Technical leadership and mentoring

Cloud certification

Job description

Job Description

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 experiencedelivering data engineering solutionson cloudplatform
• 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 cloud-based data warehousing and data lake solutions like Snowflake, Redshift, Databricks
• 5+ years of experience with SQL or NoSQL database (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 data engineering space
• Cloud certification on any platform 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, disability insurance, paid family leave and more, we’ve launched extended benefits to help meet our employees’ needs.

• CapTech is committed to providing a flexible work environment and helping our employees achieve a work‑life balance that suits their individual needs. Employees must be available to work onsite in a client location or a CapTech office as requested. We allow CapTech employees to work remotely when compatible with CapTech and client needs.
• 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, pregnancy, and more – and opportunities for employer‑sponsored funds to help pay forcare
• 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 and inclusion 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, inclusion 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, Inclusion and Belonging efforts, clickHERE . 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 [emailprotected].

CapTech supports Equal Pay for all. In addition, in the State of Illinois, we are committed to Equal Pay for ALL in accordance with the Illinois Equal Pay Act. The base pay range for this role is: $90,000 - $200,000.

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.