Senior Data Warehouse, ETL Developer

| Greater Denver Area

Position:

Senior Data Warehouse, ETL Developer

 

 

Job Description:

The Senior ETL Developer is responsible for providing technical leadership for data warehouse and data lake implementations, playing both an architect and lead role. The Sr. ETL Developer is expected to lead the team with technical direction for the design, development, testing, implementation and maintenance of DW solutions; as well as identification and resolution of Data Quality issues. This role needs to understand business requirements, develop ETL solutions and provide ongoing support for the Data Warehouse.

Essential Duties and Responsibilities

•    Data integration with ETL tools like Informatica.
•    Support ETL architecture, design and development
•    Design and implement data pipelines to prepare, process and organize data in the warehouse
•    Mentor team on coding standards and perform code reviews
•    Lead multiple small projects
•    Develop functional specifications for data acquisition, transformation and load processes
•    Ensure data integration/ETL is implemented & monitored successfully to enable data quality, and on time availability
•    Monitor daily/other database jobs and data loads to resolve issues pro-actively and ensure maximum availability of the data for reporting
•    Identifies and evaluates new technologies for implementation.
•    Analyzes code to find causes of errors and revise programs as needed.

Required Qualifications
•    At least 7+ years of Extensive experience with designing, developing, and ongoing support of a data warehouse environments
•    5+ years hands on experience with ETL tools like Informatica
•    Experience leading large and small teams
•    Expert level SQL experience
•    Experience with Teradata would be a huge plus
•    Experience working with the Hadoop ecosystem and tools is nice to have but not required.
•    Good understanding and experience with cloud platforms and technologies like Azure is preferred
•    Excellent scripting and programming skills using python or shell or any other programming language
•    Demonstrated ability to understand data architectures and systems 
•    Strong communication and customer relationship skills.
•    Self-starter, quick learner, problem-solver with a positive, collaborative, and team-based attitude.

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
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
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