Senior Data Engineer (Warehousing Support)

Job DescriptionIngram Content Group (ICG) is currently seeking a Senior Data Engineer to join our team in LaVergne, TN (Greater Nashville area). This person will design, build, and optimize the systems that allow our data to be gathered, ingested, stored, analyzed, transformed, and distributed. You will be responsible for the entire lifecycle of data pipelines, from ingestion to the creation of Operational Data Stores (ODS). Senior Data Engineer Acts as the senior/lead technical programmer in the team, owns the solution stack, and has an appetite for problem solving. Delivers results through independent contributions and mentoring of junior engineers. Works with the data architect, CI/CD architects, and other data engineers to build and deliver world-class data platforms. 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 experienceWe have a preference for: Technical expertise in a core technology area Data and Software engineeringKnowledge of external technologies within domain of expertiseKnowledge of all phases of applications systems analysis and programmingKnowledge of Development Tools with demonstrated expert experience in: Python, data manipulation packages of PythonWorking knowledge of client-server architectures and RESTFul APIsKnowledge of software collaboration platforms like GitHub, Azure DevOps, and JIRAAbility to communicate effectively across the organization and with leadershipAbility to apply new knowledge, technology, and procedure to job responsibilitiesAbility to be flexible/multi-task based on workflow demandsThe Senior Data Engineer key responsibilities are:

Pipeline Development:

Design and implement robust ETL/ELT data pipelines using Apache Kafka for streaming and batch processing.

Database Management:

Architect and maintain both Relational (MySQL, SQL Server) and Non-relational (NoSQL) database environments to ensure high performance and scalability.

SQL server related: Transact-SQL, ETL and Data warehousing, SQL server management studio, maintaining and optimizing stored procedures, maintaining and monitoring background jobs.

ODS Architecture:

Build and manage Operational Data Stores to integrate data from disparate sources for real-time and batched operational reporting.

Data Handling:

Write complex, optimized SQL queries, develop Python scripts using libraries like Pandas, NumPy, and PySpark, and integrate Kafka for sophisticated data transfer, manipulation and cleansing.

System Optimization:

Monitor and tune database performance, ensuring data integrity and security across all platforms.

Lead and execute testing to ensure data validation and data integrity.

Drives solutions and guides the work of others to provide full application development life cycle support including specifications, prototypes, development, quality assurance, and deployment.

Works with user/customer community, business analysts, and architects to capture system requirements and design.

Leverages a technical network to collaborate across the organization's units.

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 InformationPerks/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 days401K match, Life and AD&D, Employee Assistance programs, Group Legal, & moreWellness program with access to onsite gym and basketball court for associatesEncouraged continued education with our tuition reimbursement programFinancial and in-kind opportunities to engage with non-profits in your communityCompany match program for United Way donationsVolunteer opportunities and in-kind drives for non-profits throughout the yearTake breaks or brainstorm in our game room with ping pong & foosballCasual 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/DisabledWe participate in EVerify.

EEO Poster in English EEO Poster in Spanish