Senior Data Engineer

Ingram 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 businessand enjoys working in a connected culture we cant wait to meet you! 

The ideal candidate will have the following minimum qualifications:

• Education: Bachelors or masters degree in computer science Computer Engineering IT or a closely related technical field.
• 6 years of professional experience in data engineering or a similar data-intensive role.
• Core Languages: Expert-level proficiency in SQL and Python.
• Databases: Deep experience with MySQL and at least one major NoSQL provider (e.g. MongoDB Cassandra).
• Integration: Hands-on experience creating and deploying SSIS Packages.
• Streaming: Proven experience using Apache Kafka for event-driven architecture.
• Concepts: Strong understanding of data modeling schema design and distributed systems.

We have a preference for:

• Technical expertise in a core technology area Data and Software engineering
• Knowledge of external technologies within domain of expertise
• Knowledge of all phases of applications systems analysis and programming
• Knowledge of Development Tools with demonstrated expert experience in: Python data manipulation packages of Python
• Working knowledge of client-server architectures and RESTFul APIs
• Knowledge of software collaboration platforms like GitHub Azure DevOps and JIRA
• Ability to communicate effectively across the organization and with leadership
• Ability to apply new knowledge technology and procedure to job responsibilities
• Ability to be flexible/multi-task based on workflow demands

The Sr Java Software 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 organizations units.

Hiring Salary Range: $110981k - $141123k. 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 applicants 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 Ingrams 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 

Remote Work :

No

Employment Type :

Full-time