Senior Data Engineer (Application Support)

Job Description

Ingram Content Group (ICG) is currently seeking a Senior Data Engineer to join our team in LaVergne, TN (Greater Nashville area). This person leverages the latest ETL/ELT technologies including data pipeline design principles and integration patterns as a basis for supporting analytics and an enterprise data warehouse. Performs complex and senior level data integration pattern design and development activities in support of maintaining both legacy and modern data sourcing. Performs all aspects of the development life cycle. Delivers results through impeccable work ethic and perseverance to seek growth. This position will be hybrid and work from the Ingram headquarters 4 days per week.

Want to help explore and build new ways to deliver content to the world?

At Ingram, our Technology team is blazing a trail by providing content distribution services to thousands of publishers with key initiatives around business intelligence, machine learning, continuous integration and omnichannel.  We support diverse people and technology that highlights innovation through SaaS platforms, metadata, cloud, and containerization.   Our teams are agile, and emphasize authenticity, creativity, and transparency upon a fact-based foundation. 

The world is reading, and it is our goal to connect as many people as possible to the content they want in the simplest ways.  If you are an IT professional who strives to deliver results through collaborative partnerships, understanding what drives business, and enjoys working in a connected culture, we can’t wait to meet you!

The ideal candidate will have the following minimum qualifications:

• Education: Bachelor's or master's degree in computer science, Computer Engineering, IT, or a closely related technical field.
• 6 years of ETL, development, and /or database architectural design experience.
• 2 years of experience with writing and optimizing existing complex SQL queries 
• 2 years of database application development experience
• 3 years of professional experience with database technologies and ETL/ELT tools and scripting.

We have a preference for:

• Knowledge of modernizing or consolidating legacy siloed databases.
• Strong knowledge across multiple database technologies including both columnar and row indexed relational DBs such as Vertica and SQL Server.
• Knowledge of schema driven design, development, and administration.
• Advanced knowledge of SQL, relational databases, query authoring
• Ability to execute SQL, T-SQL, ETL/ELT scripting, and automation techniques.
• Knowledge of common tools for Linux (logs, piping, redirections, grep, sed, yum)
• Knowledge of Linux scripting (Python, Perl, shell scripts)
• Experience with architecting data modeling and meeting requirements for data visualization or reporting tools
• Knowledge of data concepts around change data capture, and slowly changing dimensions

The Sr Data Software Engineer key responsibilities are:

• Creates, develops, modifies, and maintains data pipelines for internal and external facing data applications as part of an Agile/SCRUM engineering team.
• Collaborate heavily with data modeling and subject matter experts based on data driven industry best practices.
• Delivers solutions to provide full product life cycle support, collaborating within and across teams, database development and deployment.
• Explores new technologies and development techniques to foster innovation.
• Coordinates and communicates with users, developers, and product owners to design and implement solutions that services the end user.
• Mentors and develops junior engineers through code reviews, co-development and best practices.
• Assembles large and complex data sets that meet business requirements.
• Develops design patterns, standards, documentation, etc. and works with other developers for implementation.
• Provide data integration oversight for Third Party integrations and database core components.

Hiring Salary Range: $110,981k - $141,123k. This range represents the anticipated low and high end of the salary for this position. It will be determined by factors including but not limited to:  the applicant’s education, experience, knowledge, skills, and abilities, geographic location, as well as internal equity and alignment with market data.

Additional Information

Perks/Benefits:

• A highly competitive compensation package with generous benefits beginning first day of employment for Medical/Prescription Drug plans, HSA, Vision, Dental and Health Care FSA.
  • 15 vacation days & 12 sick days accrued annually and 3 personal