Senior Data Engineer (Application Support)
- Full-time
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 days
- 401K match, Life and AD&D, Employee Assistance programs, Group Legal, & more
- Wellness program with access to onsite gym and basketball court for associates
- Encouraged continued education with our tuition reimbursement program
- Financial and in-kind opportunities to engage with non-profits in your community
- Company match program for United Way donations
- Volunteer opportunities and in-kind drives for non-profits throughout the year
- Take breaks or brainstorm in our game room with ping pong & foosball
- Casual Dress Code & Flexible Schedules (per team)
The world is reading, and Ingram Content Group (“Ingram”) connects people with content in all forms. Providing comprehensive services for publishers, retailers, libraries and educators, Ingram makes these services seamless and accessible through technology, innovation and creativity. With an expansive global network of offices and facilities, Ingram’s services include digital and physical book distribution, print-on-demand, and digital learning. Ingram Content Group is a part of Ingram Industries Inc. and includes Ingram Book Group LLC, Ingram Publisher Services LLC, Lightning Source LLC, Ingram Library Services LLC, Tennessee Book Company LLC, Ingram Content Group UK Ltd. and Ingram Content Group Australia Pty Ltd.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, work related mental or physical disability, veteran status, sexual orientation, gender identity, or genetic information.
- EOE-Race/Gender/Veterans/Disabled
- We participate in EVerify.
- EEO Poster in English
- EEO Poster in Spanish