Senior Data Engineer / ETL Developer

Coca-Cola Bottling Co. Consolidated; Charlotte (NC); Hybrid; USD 80,000 - 110,000; Full time

Benefits offered by this job

401(k) match

Health coverage

Employee stock purchase plan

Dedicated training and mentorship

Job summary

Coca-Cola Bottling Co. Consolidated is seeking a Senior Developer III in Charlotte, NC, responsible for developing and maintaining ETL and data integration solutions. You will become a technical leader and mentor while driving best practices and ensuring code quality.

The ideal candidate possesses over 5 years of experience in ETL and SQL, along with strong skills in C#/.NET. Enjoy a supportive work environment with opportunities for mentorship and career advancement.

Qualifications

• 5+ years of experience in ETL and SQL.
• Experience with SSIS or ADF tools, and C#/.NET integration development.
• 3+ years of experience in domain-specific framework development.

Responsibilities

• Develop and manage ETL processes with SQL Server, SSIS, ADF, and Snowflake.
• Design, develop, test, and support processes using best practices.
• Participate in Agile Scrum events and manage backlogs.

Skills

ETL development

SQL

C#/.NET

Agile methodologies

Problem-solving

Education

High school diploma or GED; 2 years of education beyond high school

BS in Computer Science or related field

Tools

Azure Data Factory

SSIS

SQL Server

Snowflake

Azure DevOps

Job description

Requisition ID: 237809

Locations: Charlotte

Job Overview

In this role, you will be responsible for development, configuration, and maintenance of ETL or data integration solutions. This position will also troubleshoot and resolve testing issues; focus on programming and configuration of data integration solutions. This role requires expertise SSIS or ADF (or any ETL tool) and C#/.NET (console app) Integration development. The Senior Developer III will act as a technical leader, mentor, and innovator, driving best practices, ensuring code quality, and significantly contributing to architectural integrity and IT initiative success.

Duties & Responsibilities

• Work closely with IT and Business Teammates to identify potential business process candidates
• Coordinate with business partners to re-imagine and improve business processes as appropriate
• Design, develop, test, deploy and support processes using CCCI best practices
• Contribute to the CCCI shared library of [Domain] components and best practices
• Participate in rotational on-call support, maintenance activities and other duties as determined by the team
• Develop and manage ETL processes with SQL Server, SSIS, ADF, and Snowflake for efficient data integration.
• Write code in lower-level (i.e. C#, .NET, Python) programming languages to optimize the performance and efficiency of an organization's IT platform, infrastructure
• Configure, customize, diagnose, and enhance SAAS, off-the-shelf, in-house developed or third-party supplied systems software including operating system software and utilities that manage access to peripherals, facilitate networking, and manage memory allocation
• Write diagnostic programs to test integrated software, hardware systems and resolve system faults to indicate that the program is not functioning properly or meeting the technical, functional requirements. Participate and actively contribute to the following Agile Scrum events, as well as Backlog Grooming, including Sprint - a time box of 1-4 weeks during which a usable 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 usable 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

Knowledge, Skills, & Abilities

• Ability to identify existing business processes suitable for [Domain]
• Demonstrated ability to take ownership of complex initiatives and drive them to successful completion
• Ability to design well-structured and efficient processes and objects following standard principles and practices
• Ability to proactively coordinate security-related best practices and solutions with IT security and agile delivery teams
• Ability to document, evangelize, and guide adoption and implementations across agile delivery teams
• Strong analytical and 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
• 5+ years of experience in ETL
• 5+ years of experience working with SQL
• Experience working with SSIS or ADF or other ETL tools
• C#, .NET integration development (console application) where console application experience is mandatory
• 3+ years experience in domain-specific framework development

Preferred Qualifications

• Experience with Azure API Management
• Experience with Azure Data Factory
• Experience leading and mentoring technical teams in complex development environments
• Agile delivery in a matrixed organizational structure
• MS Azure environment development experience
• MS Azure DevOps or Git experience
• Familiarity with data integrations and exchange frameworks (JSON, XML, EDI)
• BS in Computer Science or Information Technology related field

Benefits

• Clear pathways to advance and develop your career
• 401(k) match + health coverage + employee stock purchase plan
• Create meaningful impact in the communities you serve
• Dedicated training + personalized mentorship

Work Environment

In office 4 days a week, 1 day remote

Equal Opportunity Employer - All qualified applicants will be considered for employment without regard to disability, protected veteran status, or any other characteristic protected by applicable law.