Data Engineer 2
Job Location
Peoria, IL
Work from Home
Temporary
Type of Job
Digital
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