Data Engineer

  • location: Chicago, IL
  • type: Temp to Perm
  • salary: $46 - $62 per hour

job description

Data Engineer

job summary:
Our in-store Marketing client is looking for a Data Engineer to join their team! The Data Engineer will work remotely, 40 hours/week, in a contract to hire capacity. They'll work cross-functionally to implement analysis & validation strategies and turn data into actionable insights for the business.

Responsibilities:

  • Develop, validate & implement various Data Warehousing & Data Analysis solutions
  • Perform Data Analysis, Data Profiling & Data Integrity checks using SQL & other tools
  • Monitor, troubleshoot & debug existing Data Warehouse solutions and applications
  • Partner with business users to establish requirements & synthesize into one or more reusable DW/ETL products
  • Performs tasks and duties related to ad hoc analysis, design and processing
Requirements:

  • 2+ years as a Data Engineer in Warehousing, Integration & Validation
  • 2+ years with Data Warehousing tools (MySQL or similar, Pentaho ETL, Java ETL or similar ETL tools)
  • Excellent knowledge of large data manipulation & data mining using complex SQL
  • Experience writing complex SQL statements to validate data & ETL code
  • Able to collaborate across teams and understand business objectives & requirements
  • Understanding of Big Data Ecosystems is a plus
  • Understanding of Snowflake, GCP or MS Azure a plus
  • Experience in working with Java a plus
 
location: Chicago, Illinois
job type: Contract
salary: $46 - 62 per hour
work hours: 8am to 4pm
education: Bachelors
 
responsibilities:
  • Design, develop and validate various Data Warehousing & Data Analysis solutions.
  • Work with business users to establish requirements to achieve business objectives through Data.
  • Decompose the business requirements into one or more reusable DW/ETL products.
  • Translate business requirements into Data/ETL Solutions
  • Performs tasks and duties related to ad hoc analysis, design and processing.
  • Ensure effective communication of user requirements.
  • Debugging, monitoring and troubleshooting existing Data Warehouse solutions and applications.
  • Excellent working knowledge of large data manipulation and data mining using complex SQL.
  • Implement data validation/verification strategies, plans and use cases for various Data Warehousing & Data Analysis solutions.
  • Experience in writing complex SQL statements to validate data and ETL code based on the data mapping & requirements and perform extensive data analysis to identify the defects.
  • Perform detailed Data Analysis, Data Profiling and Data Integrity check using SQL, Shell scripts or any other tools.
 
qualifications:
  • Experience level: Experienced
  • Minimum 3 years of experience
  • Education: Bachelors
 
skills:
  • Data Center
  • Data Warehouse
  • Infrastructure
  • Quality
  • Quality
  • Data Analysis

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    Sr. Data Engineer - Cloud

  • location: Schaumburg, IL
  • job type: Temp to Perm
  • salary: $52.50 - $65.50 per hour
  • date posted: 10/27/2020

    Data Engineer

  • location: Chicago, IL
  • job type: Temp to Perm
  • salary: $46 - $62 per hour
  • date posted: 11/18/2020

    ERP Solutions Architect

  • location: Chicago, IL
  • job type: Permanent
  • salary: $120,000 - $140,000 per year
  • date posted: 11/20/2020