Data Engineer

Urgent Need Data Engineer on W2 basis / Remote / /

Job Title - Data Engineer 3       

Location: 100% Remote or open to all CAT hubs (Chicago, Dallas, Peoria, Champaign, Westminster) – US Time zone only

Duration: 12 months with possibility to extend up to 2 years

Education & Experience Required:

• A 4-year degree and/or Master’s degree from an accredited college or university or equivalent experience
• 5-7 years’ experience in data management or data engineering or data operations (data design, data quality, metadata, governance, etc.)

Position’s Contributions to Work Group:

• Perform all necessary data related tasks which could include data design, data quality, data triage, data governance or data architecture – SQL, Snowflake, AWS
• Develop a break/fix solution and address the root cause in the data pipeline implementation/code – Python, AWS
• Develop scripts and automation tools to better detect and correct data issues.
• Develop monitoring and alerting capabilities to proactively detect data issues
• Works directly on complex application/technical problem identification and resolution, including responding to off-shift and weekend support calls.

This position will contribute significantly to the efficiency and effectiveness of our data operations, enabling the team to deliver high-quality data solutions and support to various business units.

Technical Skills

(Required)

• 5-7 years’ experience in data management or data engineering or data operations (data design, data quality, metadata, governance, etc.)
• Experience with development and delivery of microservices using serverless AWS services (S3, RDS, Aurora, DynamoDB, Lambda, SNS, SQS, Kinesis, IAM)
• 4 year or more of experience in a Cloud environment (AWS, Snowflake)
• Strong SQL and Python

(Desired)

• Strong AWS experience, including SageMaker, S3, RDS, Cloudwatch and related services
• Strong Snowflake experience
• Strong SQL, Python development skillset
• Understanding of logical data Domains, primarily Customer & Equipment Domains
• Experience in Data Operations, Tier 2 Support, or comparable Data Engineering Support role
• Strong knowledge of end-to-end data lifecycle across traditional data warehouses, relational databases, operational data stores,business intelligence reporting, and big data analytics.
• Knowledge of data technology products and components for Big Data and Cloud (AWS, Data Lakes, and similar).
• Ability to work collaboratively in a complex, rapidly changing, and culturally diverse environment.

Soft Skills

(Required)

• Verbal and written communication skills. Ability to clearly communicate complex technical ideas
• Problem solving skills, customer service and interpersonal skills
• Ability to work collaboratively in a complex, rapidly changing, and culturally diverse environment
•  

Typical task breakdown:

• Identify, investigate, and obtain resolution commitments for platform and data issues to maintain and improve the quality and performance of assigned digital product data.
• Issue Identification: Reports in all forms from customers, dealers, industry representatives, and subsidiaries.
• Issue Investigation: Statistical analysis, data triage, and infrastructure problem-solving.
• Issue Resolution: Identify root causes, create SageMaker scripts to fix data, and perform break/fix tasks on data pipeline code.
• Develop scripts and automation tools to better detect and correct data issues.
• Develop monitoring and alerting capabilities to proactively detect data issues.
• Work directly on complex application and technical problem identification and resolution, including responding to off-shift and weekend support calls.
• Communicate with end users and internal customers to help direct the development, debugging, and testing of application software for accuracy, integrity, interoperability, and completeness.
• Employee is also responsible for performing other job duties as assigned by Caterpillar management from time to time.