Senior Data Engineer (Application Support)
About The Position
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!
Requirements
- 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.
Nice To Haves
- 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
Responsibilities
- 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.
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)
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
