ETL Developer Intern Job at Wellness Pet Company, Burlington, MA

bHhZVDZqVmM2OFZDK1lRTG0zUDRFT2NFVEE9PQ==
  • Wellness Pet Company
  • Burlington, MA

Job Description

About the Wellness Pet Company

The Wellness Pet Company is on a mission to help the next generation of pet parents fulfill a shared life of wellbeing with their pets through a foundation of proven nutrition. We are committed to crafting high-quality pet food, dental chews, treats, and topper recipes that are made with the perfect balance of high-quality natural ingredients paired with the latest scientific research and technologies. As a community of people working together, Wellies are positively obsessed with how to deliver proven health outcomes that pet parents can see and pets can taste. Wellies bring their best to work every day, come ready to collaborate, embrace the hard things, and own their outcomes.

Our Team is based out of our office in Burlington, Massachusetts, where we work in-office Monday through Thursday each week, and remotely on Fridays. Team members must reside within or be willing to relocate to a commutable distance from our Burlington office.

We are seeking a Boomi ETL Developer intern to develop, implement, and support reporting, analytics, and business intelligence solutions (For example, dashboards, scorecards, operational, self-service delivery) for all functional areas at Wellness Pet using the Boomi integration tool. This individual will play a key role in turning data into actionable information for business performance monitoring and to drive informed business decision-making at all levels within the organization.

What You’ll Accomplish

  • Develop ETL pipelines to acquire and load data from internal and external data sources into a data warehouse using Boomi or Microsoft SSIS.
  • Design and develop ETL processes using Boomi.
  • Profile data sources to understand the quality and integrity of data sources.
  • Conduct unit testing and troubleshooting processes.
  • Provide ongoing support for ETL processes.
  • Work with the Wellness BI Team on data extraction/modification requirements.
  • Provide ongoing support and maintenance of ETL processes.
  • Assist in database management and optimization.

Data Management and Quality:

  • Manage data extraction, transformation, and loading processes.
  • Implement data quality checks to ensure accuracy and integrity.
  • Monitor data pipeline performance and modify processes as needed.

Who We’re Looking For:

Team Wellie is a group of people who are truly obsessed with all the best ways about winning for the consumer and the pets they love. And so, we are seeking an individual who:

  • Always starts with the consumer
  • Is dedicated to doing it right the first time
  • Brings their best every day
  • Has an “all-in” mindset
  • Embraces the hard things and does them right away
  • Owns their outcomes
  • Gives back to their community

In addition, for this specific role, we need someone who:

  • 2-3 years of experience in ETL development with Boomi or any other ETL tool.
  • Understanding of SQL Server or Oracle database designs, development, and optimization.
  • Design and develop ETL processes using Boomi.
  • Possess working knowledge of SQL or PL/SQL.
  • Basic understanding of Data Warehousing concepts.
  • Adept at developing stored procedures (PL-SQL, T-SQL), functions, queries, and views.
  • Basic knowledge of programming languages is required: Java,. Net.
  • Experience working with ERP and CRM systems.
  • Able to interact effectively with business users to decipher business and technical requirements.
  • Strong problem-solving and analytical skills.

Why Wellness Pet?

We care about the wellbeing of our people, their families, and their pets. More information about what makes us special can be found on our website. The Wellness Pet Company is proud to be an equal opportunity workplace. We foster an inclusive work environment and are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, or veteran status.

The annual salary range for this position is $31.25 to $33.65 an hour, based on a full-time work schedule, anticipated responsibilities, market benchmarks, and organizational equity. Compensation may vary within that pay range depending on the selected candidate’s professional background, experience, operational needs, and other considerations permitted by law.

#LI-RD1

Job Tags

Full time, Internship, Work at office, Remote work, Relocation, Monday to Thursday

Similar Jobs

Ria Health

Psychiatrist / Addiction Medicine Physician in GA (1099) Job at Ria Health

 ...interdependently with team members and departments. Physicians must have demonstrated training in addiction, either during residency or through post graduate...  ...Psychiatrist (or Physician Certified in Addiction Medicine). Preference given to candidates who possess additional... 

XO Taco

Host/Hostess Job at XO Taco

 ...XO Taco is looking for a host/hostess to add to its growing team! The qualified candidate will greet guests as they enter, strategize a floor plan, and show each guest to their table or waiting area. Responsibilities: Greeting guests as they enter, and putting them... 

BioLife

Paramedic/EMT-P Job at BioLife

 ...nursing program with state requirements Currently licensed or certified in the state where responsibilities will be assigned: EMT-Paramedic Current Cardiopulmonary Resuscitation (CPR) and AED certification Fulfill state requirements (in state of licensure)... 

Compass Group

Conference Aide - Goldman Sachs San Francisco Job at Compass Group

Salary:$24 - $25 / hour Rapport is a specialized division of FLIK Hospitality Group focused on all aspects of guest and employee services, meeting and event planning and conference center management. Distinct from recruitment agencies, we do not engage in temporary...

Zirtual

Remote Executive Assistant Job at Zirtual

 ...Zirtual is a work-life balanced company that provides clients with experienced, highly skilled remote assistants for both personal and professional needs. Our Executive Assistants are committed to delivering efficient, proactive, and high-quality support that meets and...