Software Data Engineering Intern

Sky Mavis; City of Binghamton (NY); On-site; USD 25,000 - 36,000; Full time

Benefits offered by this job

Hands-on experience

Mentorship

Resume support

Full-time opportunities

Real projects

Job summary

iA (Innovation Associates) is seeking a Software Data Engineering Intern to help build data pipelines, ETL processes, and analytics-ready data on cloud platforms. You will work with senior engineers on Databricks and enterprise data solutions, learning data governance, security, and AI enablement while contributing to real projects in a 10-week summer program.

The internship focuses on Databricks, data modelling, and metadata management, offering mentorship and an opportunity to explore

Qualifications

• Pursuing degree in CS/IT/Data Science or related field.
• Hands-on knowledge of SQL and at least one modern language.
• Familiarity with Excel, Tableau/Power BI.
• Some programming experience with JavaScript/TypeScript or Python.
• Some classes on object-oriented design.
• Knowledge of data structures and algorithms.
• Interest in data engineering, AI, ML, or using data to solve real-world problems.
• Exposure to Databricks, Spark, data lakes, or modern data platforms.
• Experience with Python for data processing.
• Familiarity with generative AI or NLP.
• Exposure to data governance, metadata management, or semantic data models.
• Interest in enterprise data prepared for AI applications.

Responsibilities

• Implement components of data warehousing systems and ETL processes under guidance.
• Develop data solutions on Databricks enabling analytics, AI, and ML capabilities.
• Help create and maintain curated, trusted data models for analytics and AI.
• Improve and maintain data metadata, descriptions, relationships, and business context.
• Prepare data for self-service AI and analytics experiences using approved tools.
• Participate in developing proof-of-concept AI and data solutions.
• Evaluate AI-generated data queries for accuracy and alignment with definitions.
• Attend and contribute to daily team meetings.
• Follow senior engineers to apply best industry practices.
• Deploy cloud software components under supervision.
• Collaborate to implement technical designs.
• Maintain security of company data and applications.
• Create technical documentation for proposed and implemented solutions.

Skills

SQL

Python

JavaScript/TypeScript

Tableau/Power BI

Databricks

Azure

Education

Pursuing degree in Computer Science, Information Technology, Data Science, or related fields

Tools

Databricks

Power BI

Azure

Spark

Job description

The Role:

We are looking for an enthusiastic, passionate for technology, self-motivated and creative Software Data Engineering Intern to join our team. The intern will work on our next-generation pharmacy fulfillment solutions and our enterprise data platform. The Software Data Engineering Intern will participate in the entire software development lifecycle - analyze the business requirements, design, test, and developing cloud-based data solutions. The intern will gain hands‑on experience building solutions on Databricks that help transform the data we collect into analytics, operational insights, and AI-enabled capabilities for the business. Working closely with Senior Engineers and cross-functional teams, the intern will help develop and maintain data pipelines, data models, and metadata that make data easier to discover, understand, and use by AI, analytics, and third‑party tools. As an engineering team member, the intern will learn and apply industry best practices in software development, data engineering, cloud technologies, data governance, security, AI enablement, and product delivery.

The iA Intern Program is a 10-week summer internship, running from, Tuesday June 1, 2027, through Friday, August 6, 2027.

What you’ll do:

• Based on design documents and under Sr. Software Engineers guidance, implement components of data warehousing systems, build extract, transform, load (ETL) processes, and deploy them to the cloud.
• Develop and enhance data solutions on Databricks that enable analytics, AI, and machine-learning capabilities using customer and operational data.
• Help create and maintain curated, trusted data models that can be consumed by analytics, AI applications, and business users.
• Improve and maintain data metadata, descriptions, relationships, definitions, and business context to make data easier for people and AI-powered tools to understand and use.
• Help prepare data for self-service AI and analytics experiences, including Databricks Genie One and other approved third-party tools.
• Participate in developing proof-of-concept AI and data solutions that help teams identify trends and derive insights from customer and operational data.
• Evaluate and validate AI-generated data queries and insights for accuracy and alignment with the underlying data and business definitions.
• Participate and contribute to team’s daily meetings.
• Follow senior engineer(s) directions to learn and apply best industry practices in design and implementation.
• Under supervision implement, troubleshoot, and deploy on cloud software components
• Liaising with colleagues to implement technical designs.
• Maintain the security of the company data and applications using security best practices.
• Participate in creating strong technical documentation of proposed and implemented solutions.

Who you are:

• Pursuing degree in Computer Science, Information Technology, Data Science, or related fields.
• Hands‑on knowledge on any flavor of database querying language, SQL, TSQL.
• Familiarity with Excel, tableau/Power BI
• Some programming experience with at least one modern language e.g. JavaScript/Typescript, Python.
• Some classes on object-oriented design.
• Knowledge of data structures and algorithm.
• Interest in data engineering, artificial intelligence, machine learning, or using data to solve real-world business problems.
• Interest in learning how data quality, metadata, and business context influence the quality of analytics and AI solutions.
• Exposure to Databricks, Spark, data lakes, data warehouses, or modern data platforms.
• Experience using Python for data processing or analytics.
• Familiarity with generative AI, large language models, AI agents, or natural-language data analysis.
• Exposure to data governance, data cataloging, metadata management, or semantic data models.
• Experience with AI-assisted data or development tools through coursework, internships, or personal projects.
• Interest in how enterprise data can be prepared and used by AI applications, agents, analytics platforms, and third-party tools.

It would be great if you also have:

• SQL, Power BI.
• Exposure to Azure cloud (or any cloud) is a plus.

Applicants must be authorized to work for ANY employer in the U.S. Employer will not sponsor applicants for work visas.

Compensation:

The estimated hourly rate range for this position is $18.00 to $26.00 per hour, though a candidate's hourly rate shall be determined on a range of factors, including, but not limited to, qualifications and experience.

What are the perks?

• Gain hands‑on experience
• Work on real projects with industry professionals
• Receive mentorship and build your professional network
• Get career‑building and resume support
• Explore potential full-time opportunities

More about iA:

iA® (Innovation Associates®) is a pharmacy fulfillment company that provides an integrated platform of capabilities to support Centralized and Community Pharmacy Fulfillment Solutions. With over 30 years of experience in the pharmacy fulfillment business, we have developed and implemented a suite of automation and software solutions that help deliver quick and sustainable business results. Our integrated Pharmacy Fulfillment Platform enables scalable solutions that helps run the prescription fulfillment process from prescription acceptance to delivery, supporting dynamic design flexibility to service pharmacies in a variety of volumes and settings. Our solutions improve workflow, and increase efficiency, while enabling more time for pharmacists to focus on their patients. iA works with pharmacy providers in the Commercial, Health Systems, Government, and Mail Order/eCommerce markets. iA can help customers transform their pharmacy. For more information, visit iARx.com.

Our Mission:

We partner with providers to transform pharmacy through our leading-edge software enabled fulfillment technology and partners to deepen the patient‑pharmacist relationship, enhancing patient safety and choice while increasing operational efficiency. iA empowers pharmacists to focus on patient care. iA can run the prescription fulfillment process from start to finish, helping pharmacies manage fulfillment and inventory to help lower costs, improve efficiency, increase safety, and provide comprehensive Rx tracking and real‑time support.

Our Products:

• Software
• Modular Hardware
• Sophisticated Counting and Collation Devices

Our Core Values:

• Solutions Driven
• Customer Centric
• Championing Diversity
• Empowering Ownership
• Trust Daringly

To learn more about iA’s product, people and culture visit us at iARx.com OR check us out on LinkedIn, Facebook, or YouTube!

iA provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

#LI-DNI