Data Engineer (AWS Redshift/Python) (contract)

Capgemini; Cincinnati (OH); On-site; USD 48,050 - 75,079; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

Retirement benefits

Job summary

A leading technology consulting firm is seeking a Data Engineer in Cincinnati, Ohio. The role involves designing and maintaining data pipelines using AWS Redshift, optimizing data performance, and collaborating with data scientists. Candidates should have a bachelor's degree and strong SQL proficiency, with additional skills in Tibco Spotfire preferred. The pay range is $34.88 - $54.50 per hour and includes benefits such as medical and retirement plans.

Qualifications

• 2+ years of experience as a Data Engineer, particularly with AWS Redshift.
• Strong background in ETL tools and processes.
• Knowledge of programming languages such as Python is a plus.

Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL processes using AWS Redshift.
• Optimize and manage Redshift clusters for performance and cost efficiency.
• Implement data models and schemas to support business intelligence and analytics.

Skills

SQL

Database management

Tibco Spotfire

Problem-solving

Collaboration

Education

Bachelor's degree in Computer Science, Information Technology, or related field

Tools

AWS Redshift

AWS S3

AWS Lambda

AWS Glue

Job description

The pay range that the employer in good faith reasonably expects to pay for this position is $34.88/hour - $54.50/hour. Our offered benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.

Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL processes using AWS Redshift.
• Optimize and manage Redshift clusters for performance and cost efficiency.
• Implement data models and schemas to support business intelligence and analytics.
• Collaborate with data scientists, analysts, and other stakeholders to understand data requirements and deliver solutions.
• Ensure data quality and integrity through rigorous testing and validation.
• Monitor and troubleshoot data pipeline issues, ensuring timely resolution.
• Develop and maintain documentation for data processes and architecture.
• Stay updated with the latest trends and best practices in data engineering and AWS technologies.
• Design, develop, and maintain reports using Tibco Spotfire.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or related field.
• Proven experience as a Data Engineer, with a focus on AWS Redshift.
• Strong proficiency in SQL and database management.
• Strong proficiency in Tibco Spotfire.
• Experience with ETL tools and processes.
• Familiarity with AWS services such as S3, Lambda, and Glue.
• Knowledge of data warehousing concepts and best practices.
• Excellent problem-solving skills and attention to detail.
• Strong communication skills and ability to work collaboratively.
• Knowledge on CICD process.

Preferred Qualifications

• Certifications in AWS (e.g., AWS Certified Solutions Architect, AWS Certified Big Data Specialty).
• Experience with other data technologies such as Hadoop, Spark, or Kafka.
• Knowledge of programming languages such as Python.
• Understanding of data governance and security practices.

Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.