Data Engineer 2

Job Location

Peoria, IL

Work from Home

Temporary

Type of Job

Digital

Published Date

31 March 2021, 9:00:00 pm

About the Job

Database design, data modeling and maintenance using SQL/Snowflake. Analytics and Reporting.

Responsibilities

Database design, data modeling and maintenance using SQL/Snowflake:

  • Maintain existing database and pipelines making sure data is being refreshed according to set frequency

  • Maintain scripts / job queues in sync with IT updates on server etc.

  • Maintain access management to dashboards / SharePoint sites

  • Implement support structure for underlying DB query scripts, job queues, usage tracking etc.

Analytics and Reporting:

  • Work with business partners to develop analysis and reports to drive effective decision making for marketing and business execution

  • Leverage business and analytics acumen to deliver insights, root causes, and corrective actions

  • Perform analysis on interesting observations to identify insights, possible root causes, and corrective actions

  • Provide written and verbal communications to the team on a weekly basis.

Requirements

  • This position will require an accredited, four-year Data Science, Data Analytics, Mathematics, Computer Science or related technical degree.

  • 2 years’ experience in ETL and data manipulation

  • 1-2 years’ experience using advanced SQL/Snowflake or other relational database design, data modeling, and structured query language

  • 1-2 years’ experience in using python

  • Willingness to learn

  • Good technical and communication skills are required.

Top candidates will also have:

  • Strong project management skills.

  • Advanced understanding of SQL and relational databases such MS SQL, mySQL, Oracle, Snowflake, or similar

  • Experience with Alteryx

  • Experience with analytical language such as SAS, Python, Java or similar.

  • Experience creating Tableau dashboards

  • Experience exploring, cleaning, analyzing, and reporting on dataset

  • Knowledge of AWS and Azure cloud services

  • Knowledge of Snap logic