IT Development Engineer - Data Warehouse/ETL in Charlotte, NC at Coca-Cola Consolidated, Inc.

Date Posted: 5/4/2021

Job Snapshot

Job Description

Requisition ID:  20822 

Posting Locations: Charlotte 

Click here to view a Day in the Life of our Teammates!

Job Overview

The IT Development Engineer is responsible for the development, configuration, and testing of Enterprise Data Warehouse, integrations (ETL) and reporting as per the technical requirements and specifications from the business and identifying opportunities for improvement. This position will also troubleshoot and resolve testing issues; focus on performance improvements and automation of the existing processes; support business analyst community with their dashboards and reports build. 

Duties & Responsibilities

  • Participates in the requirement gathering sessions to understand the business process, source system functionality and data.
  • Profiles and analyze large sets of data (using SQL) from different source systems both internal and external 3rd party vendors to understand the data and to make sure it meets the technical, functional requirements.
  • Participates and actively contributes to designing the BI star schema data model using Kimball methodology.
  • Creates technical, bus matrix documents for the star schema data models.
  • Writes SQL queries used in the ETL process, reports, and dashboards.
  • Builds integrations using ETL tools, dashboards/reports using Tableau/Power BI
  • Proactively monitors the system for long running queries, identify bottle necks and propose solutions to optimize queries.
  • Participates and actively contributes to the following Agile Scrum events, as well as Backlog Grooming, including Sprint – a time box of 1-4 weeks during which a useable and potentially releasable increment of work is completed Sprint
  • Planning – an event where the team determines what they can confidently complete in the upcoming Sprint, and self-organizes to plan the tasks needed to do so
  • Daily Standup – 15 minute time-boxed event held every day of the Sprint for the Agile team to plan work for the next 24 hours. This optimizes team collaboration and performance.
  • Sprint Review – held at the end of the Sprint for the agile team to share with stakeholders what was done in the Sprint, elicit their feedback, and agree on the next Sprint’s work to optimize value to the business
  • Sprint Retrospective - held at the end of the Sprint for continuous improvement of the team where the team inspects itself and creates a plan for improvements to be enacted during the next sprint
  • Backlog Grooming – breaking down high-level ideas into independent, estimable, and testable increments of useable and potentially releasable units of work that can be completed within a Sprint.
  • Creates technical documentation of systems software programs and code to be leveraged for audit purposes and documents why the program was built.
  • Provides on-going support, maintenance activities and other duties as determined by the team.

Knowledge, Skills, & Abilities

  • 1-3 Years of Agile Delivery in a Matrixed organizational Structure
  • 2-3 Years of data warehousing experience using Kimball methodology
  • 1-3 Years of experience in database development, troubleshooting, and performance tuning of SQL queries
  • 2-3 Years ETL experience using Microsoft tool set.
  • 2-3 Years’ experience in building reports and dashboards using Tableau/Power BI
  • 1-3 Years MS Azure DevOps operational (pipeline) experience
  • 1-3 Years of Data integrations and exchange frameworks (jSON, XML, EDI)
  • Strong Analytical and self-problem-solving abilities
  • Strong understanding of data

Minimum Qualifications

  • High school diploma or GED;2 years of education beyond high school in college or technical school
  • Knowledge acquired through 1 to up to 3 years of work experience
  • Prior SQL, ETL and report build experience in a data warehouse environment is mandatory.

Preferred Qualifications

  • Bachelor’s degree in Information Technology Business, Computer Science or related field
  • Certifications pertaining to the job description are a plus.

Work Environment

Office Environment

Coca-Cola Consolidated, Inc. is an Equal Opportunity Employer.

Not Ready To Apply?

Joining our Talent Network will enhance your job search and application process. Whether you choose to apply or just leave your information, we look forward to staying connected with you.

Join Our Talent Network