ETL Developer (Pentaho)

| Greater Denver Area

Job Description:

Data Engineer/ETL Developer Arrow Electronics, Inc. – Englewood, CO

Reports To: Manager, IT The Data Engineer

You will be a member of our Data Management team that is responsible for various system integrations, data transformations and reporting to support the arrow.com eCommerce platform. Our new team member will be responsible for ETL processes and general reporting.

 

Essential Duties and Responsibilities This individual will be responsible for the entire life-cycle of each data task he/she is given: designing, developing, testing and deploying. One of the largest responsibilities for this individual will be moving around large amounts of data on-boarding inventory from various suppliers.

This individual will work closely with the pricing and big data teams ensuring the most competitive/strategic price for each item is listed on the website at all times. As a Data Engineer, this individual will provide support to our internal sales/operations team if they have questions around the data.

- The ideal candidate will have an eye for continual improvement.

- They will help to identify and create designs and architecture that help to make all systems and business processes scalable.

- This individual will be responsible for maintaining the existing ETL order fulfillment integrations as well as developing new ETL integrations.

- The majority of the time, the goal behind the new ETL integrations is to reduce the manual workload currently being done by our internal operations team. Gather data for reporting mission-critical information to be used in influencing the direction of the business.

 

Principal Accountability
- Act as technical lead on complex ETL development projects with multiple team members, providing mentoring, technical assistance, troubleshooting and alternative development solutions.
- Develop logical and physical data models. Perform advanced ETL development activities using Pentaho, PDI, Informatica, PL/SQL, etc. 
- Write and maintain technical documentation describing standard processes which other developers must follow.
- Manage a large-scale ETL environment, including configuration, servers, releases, metadata, system performance, system stability, user administration, and standards.
- Create, update and maintain project documents including (but not limited to): business requirements, functional and non-functional requirements, functional design, data mapping, etc.

 

Architecture/Designing/Developing an infrastructure to implement and support a reporting new reporting system. Documentation and knowledge transfer.

 

Qualifications Strong development background with RDBMS and coding in PL/SQL and T-SQL. Experience with enterprise reporting systems

Experience with ETL tools and processes (Pentaho/PDI preferred)

Experience working within a development environment and with common tools such as code repositories and group collaboration applications

Experience extracting data from a variety of relational databases for analysis (MySQL, SQL Server, Oracle, etc.).

Query optimization and working knowledge of transaction isolation levels Ability to be self-driven, take initiative and resolve issues.

Proven ability and extensive experience gathering, understanding and documenting business needs, translating them into requirements, and implementing solutions.

Excellent communication and analytical skills; ability to manage multiple projects simultaneously

Experience working with SOAP and REST APIs

Preferred Architectural knowledge to design, implement and maintain highly scalable, durable and performant RDBMS

Experience with Kettle/Pentaho/PDI (preferred)

Experience with XML and JSON Unix shell scripting

Familiarity with Linux Experience as a member of an Agile / Scrum development team, Java Programming System or network administration, database administration and optimization

Experience with NoSQL databases and big data concepts

 

What is in it for you?

Training Skills development, Performance coaching Medical, dental, vision, paid time off, 401k domestic partners program and more. Community involvement opportunities Career advancement opportunities

 

At Arrow, we are driving innovation and choice by offering employees a variety of benefits designed to keep you and your family physically and financially healthy. Our comprehensive, competitive benefits program is an important part of your total compensation package. We offer a variety of plans and coverage including health and welfare, retirement, paid time off, and voluntary benefits as well as resources to help you make cost-effective decisions for you and your family.

 

Everyone counts at Arrow, and our benefits enable you to achieve and maintain better health and plan for your future as we work together toward smarter solutions in tomorrow’s technology. Arrow offers competitive time off for you, which includes accrued vacation time, personal and floating holidays, in addition to other observed holidays.

These are granted based on the date you join the company in any given year. http://benefits.arrow.com

EOE Minorities/Females/Protected Veterans/Disabled Arrow Electronics, Inc. is committed to working with and providing reasonable accommodation to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the employment process, please refer to our Hiring Process & Accommodations Request Instructions on our Career Site to let us know the nature of your request and your contact information.

#DICE#

 

Read Full Job Description

Technology we use

  • Engineering
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • RLanguages
    • ScalaLanguages
    • SqlLanguages
    • jQueryLibraries
    • Twitter BootstrapLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • SpringFrameworks
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • OracleDatabases
    • SitecoreCMS
    • SalesforceCRM
    • Movable InkEmail
    • Oracle EloquaLead Gen

Location

Our offices are approximately 15 miles south of Downtown Denver. Employees enjoy the easy access to the light rail station and I-25.

An Insider's view of Arrow Electronics, Inc.

What's something quirky about your company?

As a tech company, we showcase the use of tech all throughout our building. We hang art over the building made of various consumer electronics and we even have access to an Electronics Testing lab. My R&D team also loves to make fun code names for our projects, we recently launched Project Deathstar (announced as ArrowPlus powered by Freelancer)!

Stephen

Manager, Product Management and Engineering

What projects are you most excited about?

There is a big drive at Arrow to support tech entrepreneurs, so part of my job involves collaborating and working with local startups - you’d be amazed to see the new ideas coming out of Denver! I get to work closely with local incubators and accelerators, and also plan events and sessions for big events like Denver Start Up week.

Lia

Marketing Specialist

How has your career grown since starting at the company?

I first began my career at Arrow six years ago as a summer intern on the Customer Support team. The career growth I have achieved since has led me to my current role as Delivery Manager of Arrow.com. Through mentorship programs and working with a team that values trust while promoting curiosity, the experiencing has been nothing short of rewarding.

Kristen

Delivery Manager

How do your team's ideas influence the company's direction?

In today’s fast moving world my team is continually collaborating with the business to evolve our digital channels. Combining competitor insight, industry best practices and innovative capabilities we can react quickly to changing needs, design robust solutions, as well as developing innovations for future growth.

Michelle

Director, Technology & Planning

What’s the vibe like in the office?

Our office promotes an open and active vibe that inspires collaboration with your fellow coworkers. The overall environment supports our focus on driving innovation forward.

Taylor

Asset Specialist

What are Arrow Electronics, Inc. Perks + Benefits

Arrow Electronics, Inc. Benefits Overview

•Medical, Dental, Vision Insurance
•401k, With Matching Contributions
•Competitive Paid Time Off
•Health Savings Account (HSA)/Health Reimbursement Account (HRA) Options
•Short-Term/Long-Term Disability Insurance
•Parental Leave Options
•Employee Discount on Annual RTD Pass
•Wide Variety of Growth Opportunities
•Casual Work Environment

Culture
Volunteer in local community
Friends outside of work
Eat lunch together
Intracompany committees
Open door policy
Team owned deliverables
Team based strategic planning
Diversity
Dedicated Diversity/Inclusion Staff
Someone's primary function is managing the company’s diversity and inclusion initiatives
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Team workouts
Acme Co.'s team fitness initiatives include In-office yoga, In-office fitness classes, Sponsored race teams.
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Match charitable contributions
Child Care & Parental Leave Benefits
Generous Parental Leave
Company sponsored family events
Acme co. sponsors family oriented events Semi-annually.
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Game Room
Our game room includes Ping Pong, Foosball.
Stocked Kitchen
Parking
We offer employees Free on-site garage parking.
Professional Development Benefits
Job Training & Conferences
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Customized development tracks
More Jobs at Arrow Electronics, Inc.320 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Internships
Marketing
Operations
Product
Project Mgmt
Sales
Content
Operations
new
Denver
new
Denver
new
Denver
new
Denver
new
Denver
new
Denver
new
Denver
new
Denver
Developer
new
Denver
new
Denver
new
Denver
Operations
new
Denver
Operations
new
Denver
Finance
new
Denver
Operations
new
Denver
Operations
new
Denver
Operations
new
Denver
Marketing
new
Denver
Operations
new
Denver
Project Mgmt
new
Denver
Operations
new
Denver
Product
new
Denver
Operations
new
Denver
Finance
new
Denver
Data + Analytics
new
Denver
Data + Analytics
new
Denver
Finance
new
Denver
Finance
new
Denver
Project Mgmt
new
Denver
Operations
new
Denver
Design + UX
new
Denver
Internships
new
Denver
Data + Analytics
new
Denver
Sales
new
Denver
Data + Analytics
new
Denver
Finance
new
Denver
Data + Analytics
new
Denver
Sales
new
Denver
Finance
new
Denver
Finance
new
Denver
Developer
new
Denver
Operations
new
Denver
Data + Analytics
new
Denver
HR
new
Denver
Operations
new
Denver
Finance
new
Denver
Finance
new
Denver
Finance
new
Denver
Finance
new
Denver
Finance
new
Denver
Data + Analytics
new
Denver
Finance
new
Denver
Finance
new
Denver
Data + Analytics
new
Denver
Sales
new
Denver
new
Denver
Operations
new
Denver
new
Denver
new
Denver
Sales
new
Denver
new
Denver
new
Denver
Sales
new
Denver
new
Denver
new
Denver
new
Denver
new
Denver
new
Denver
new
Denver
new
Denver
Developer
new
Denver
new
Denver
new
Denver
Finance
new
Denver
new
Denver
Finance
new
Denver
Sales
new
Denver
Sales
new
Denver
new
Denver
new
Denver
new
Denver
Finance
new
Denver
Finance
new
Denver
Developer
new
Denver
Sales
new
Denver
new
Denver