Data Engineer 2 Job at IDC Engineering

IDC Engineering Peoria, IL

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




Please Note :
epokagency.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, epokagency.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.