Data Engineer with SQL Experience

 Data Engineer - SQL You will play a vital role in building our Data Platform and developing ETL processes that support our analytical reporting systems. You will also be involved in our reporting, analytics and data mining projects and on-going growth.

Responsibilities:

● Play an integral role in the development of a world-class highly scalable, highly performing reporting/analytical system from the ground-up
● Building of ConsumerTrack’s data warehouse/data marts, development of ETL processing and development of analytical reporting
● Support CTI’s current systems—troubleshooting and understanding stored procedures, data flows, architecture and reporting (also includes writing, tuning, etc.) Must Have Skills:
● 3-5 years of experience in MySQL or SQL, including DDL, DML, stored procedures, triggers, events (MySQL experience a big plus)
● 2-4 years of experience in OLTP/OLAP data Modeling / DB architecture, including a working knowledge of various business process and system modeling tools including: data flow diagrams, process models, ER diagrams, dimensional data models, context models, event modeling, state modeling, process decomposition, and use case scenarios
● Strong understanding of data, data modeling and set-based processing
● 1-3 years of experience in development of ETL and large data migrations
● Experience with workflow management tools (Airflow, Oozie, Azkaban)
● Excellent skills in troubleshooting data integrity issues, database issues, and SQL performance tuning
● Proficiency with one or more scripting languages: Shell, PHP, Python
● Experience with Agile methodology

Strong Pluses:
● Working knowledge of Snowflake, Matillion, Tableau, or other similar tools
● Experience with Amazon Web Services 

Want to apply later?

Type your email address below to receive a reminder

Apply to Job

ErrorRequired field
ErrorRequired field
ErrorRequired field
ErrorRequired field
Error
insert_drive_file
ErrorRequired field
ErrorRequired field
ErrorRequired field
ErrorRequired field
ErrorRequired field
ErrorRequired field