Data Engineer

Data Engineer

Vacancy expired!

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, Google Cloud Platform 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.