Data Warehouse, ETL Developer

| Greater Denver Area

What You'll Be Doing

Job duties for the ETL Developer include:

  • Analyze, design, develop, implement and support Data Warehouse and ETL solutions based on business requirements and technical specifications.
  • Perform advanced ETL development activities using Informatica, PL/SQL, Oracle Database tuning, SQL tuning, etc.
  • Provide data analysis to support new project definition/design as well as to troubleshoot/resolve issues with existing subject areas.
  • Design and develop logical and physical data models and frameworks to support analytics applications.
  • Follow established standards and best practices and provide input for improvement of those processes.
  • Work independently or as part of a team to deliver data warehouse ETL projects.
  • Create, update and maintain project documents including (but not limited to): business requirements and user stories, functional and technical design, data mapping, etc.
  • Provide project status and progress updates to BI Management team.
  • Work with offshore resources to coordinate design and development tasks.
  • Perform other related activities as assigned.

What We're Looking For

The ideal candidate for this position should possess the following skills:

  • At least 3+ years of demonstrated experience in end-to-end deployments of data warehouse and ETL solutions
  • Adept at SQL queries with experience in constructing/deconstructing complex packages
  • In depth understanding of data management concepts: data modeling; database design and development; tuning and optimization
  • Hands-on experience with current Informatica application (10.x)
  • Expertise in understanding business process flow and designing reports with demonstrated experience in requirement gathering, business user interactions and converting requirements into specifications
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
  • Excellent written and verbal communication skills

Even Better if You Have

  • Experience with Oracle Business Intelligence (OBIEE) platform in a development capacity
  • Exposure to Oracle ERP systems and experience navigating data models of similar enterprise applications
  • Experience with cloud-based data engineering solutions – certification on AWS or Azure highly-preferred

What We Offer at Arrow:

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.

Not only do we offer a competitive salary and work-life balance, we offer benefits to match your needs:

  • Medical, Dental, Vision Insurance
  • 401k, With Matching Contributions
  • Paid Time Off
  • Health Savings Account (HSA)/Health Reimbursement Account (HRA) Options
  • Growth Opportunities
  • Short-Term/Long-Term Disability Insurance
  • Discounted RTD Passes, with convenient office location off RTD Light Rail (Dry Creek Exit)
  • On-site Café with Catering Option for Busy Lifestyles
  • 24/7/365 On-site Gym and Lockers, Free for Use to All Employees!
  • Free covered parking, included bicycle and motorcycle parking
  • And more!
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.89 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
HR
Internships
Legal
Marketing
Operations
Project Mgmt
Sales
Finance
new
Denver
Finance
new
Denver
Finance
new
Denver
Finance
new
Denver
Finance
new
Denver
Operations
new
Denver
Operations
new
Denver
Data + Analytics
new
Denver
Data + Analytics
new
Denver
Sales
new
Denver
Operations
new
Denver
Operations
new
Denver
Project Mgmt
new
Denver
Data + Analytics
new
Denver
Data + Analytics
new
Denver
Operations
new
Denver
Project Mgmt
new
Denver
Project Mgmt
new
Denver
Marketing
new
Denver
Operations
new
Denver
Project Mgmt
new
Denver
HR
new
Denver
Data + Analytics
new
Denver
Sales
new
Denver
Finance
new
Denver
Sales
new
Denver
Data + Analytics
new
Denver
Developer
new
Denver
Finance
new
Denver
Finance
new
Denver
Operations
new
Denver
Operations
new
Denver
Sales
new
Denver
Finance
new
Denver
Data + Analytics
new
Denver
Data + Analytics
new
Denver
Data + Analytics
new
Denver
Finance
new
Denver
Finance
new
Denver
Finance
new
Denver
Project Mgmt
new
Denver
Data + Analytics
new
Denver
Project Mgmt
new
Denver
Finance
new
Denver
Operations
new
Denver
Project Mgmt
new
Denver
Operations
new
Denver
Developer
new
Denver
HR
new
Denver
Operations
new
Denver
Finance
new
Denver
Operations
new
Denver
Operations
new
Denver
Internships
new
Denver
Data + Analytics
new
Denver
Finance
new
Denver
Operations
new
Denver