Data Warehouse, ETL Developer

Sorry, this job was removed at 5:13 p.m. (MST) on Wednesday, April 8, 2020
Find out who's hiring in Greater Denver Area.
See all Data + Analytics jobs in Greater Denver Area
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

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
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Technology we use

  • Engineering
  • Sales & Marketing
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • PHPLanguages
    • PythonLanguages
    • RLanguages
    • ScalaLanguages
    • SqlLanguages
    • jQueryLibraries
    • Twitter BootstrapLibraries
    • ASP.NETFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • SpringFrameworks
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • OracleDatabases
    • SnowflakeDatabases
    • SQLiteDatabases
    • 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

At Arrow, we recognize that financial rewards and great benefits are important aspects of an ideal job. That’s why we offer competitive financial compensation, including various compensation plans, and a solid benefits package. We want our employees to thrive physically, emotionally, financially, and socially. We offer various programs which help you build your wellbeing and health.

•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
•Talent Growth Opportunities
•Casual Work Environment

Culture
Volunteer in local community
Partners with nonprofits
Open door policy
OKR operational model
Team based strategic planning
Remote work program
Diversity
Dedicated diversity and inclusion staff
Highly diverse management team
At Arrow, we embrace inclusion and diversity as catalysts for innovation and we are fully committed to equal opportunities for all.
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability insurance
Dental insurance
Vision insurance
Health insurance
Life insurance
Pet insurance
Wellness programs
Team workouts
Mental health benefits
Financial & Retirement
401(K)
401(K) matching
Performance bonus
Charitable contribution matching
Child Care & Parental Leave Benefits
Childcare benefits
Generous parental leave
Family medical leave
Company sponsored family events
Vacation & Time Off Benefits
Generous PTO
Paid holidays
Paid sick days
Office Perks
Commuter benefits
Free snacks and drinks
Onsite office parking
Onsite gym
Professional Development Benefits
Job training & conferences
Lunch and learns
Promote from within
Mentorship program
Customized development tracks

More Jobs at Arrow Electronics, Inc.

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about Arrow Electronics, Inc.Find similar jobs like this