Data Analytics Engineer (Data Warehouse / BI)

| Greater Denver Area

Job Description:

The Principal Data Analytics Engineer will maintain and enhance the end-to-end analytics landscape from cloud ETL data warehousing to highly optimized models and reports in Power BI, for the Arrow Global Services business unit. This person will empower end users with clean data sets focused on agile self-service analytics. This person will expand upon Arrow’s newly deployed modern cloud data warehouse to meet new business requirements.

What You’ll Be Doing

  • Develop new data orchestration pipelines using Azure Data Factory
  • Design star schema based dimensional objects in Azure Synapse leveraging efficient MPP design considerations
  • Work with business stakeholders to understand project requirements and translate into actionable development tasks
  • Design, develop and support complex data models in Power BI
  • Lead efforts to consolidate BI applications and data silos into Azure data warehouse
  • Write and maintain technical documentation supporting BI deployments
  • Monitor data environment performance, logged errors and application activity to facilitate SLA management

What We’re Looking For

  • 8+ years in analytics; including data warehousing, data design, ETL, report development
  • 2+ years of experience building datasets, reports, and dashboards in Power BI, Tableau or related data visualization tool
  • 4 year Bachelors Degree
  • In-depth understanding of database structure principals
  • Must be self-motivated and organized with high attention to detail.  Ability to act independently under general guidance
  • Must have strong command with SQL and Data Analysis Expressions (DAX)
  • Experience creating star schema and snowflake schema data models
  • Must have competency in data storytelling via compelling data visualization
  • Good communication and problem-solving skills are required. The candidate will be working with technical peers to solve challenging data requirements and will have interaction with business stakeholders to understand and discuss requirements

Even Better if You Have

  • Exposure to Oracle Business Intelligence (OBIEE)
  • Experience with Azure Synapse, Azure Data Factory, Azure Data Lake Store, and GIT (or similar version control) is strongly preferred
  • Experience with SQL Server Data Tools and Azure DevOps pipelines (or another CI/CD supporting service) to perform state-based deployments is 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!

Arrow is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, gender, sexual orientation, gender identity, national origin, veteran or disability status. (Arrow EEO/AAP policy)

 

Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

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.51 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
HR
Internships
Legal
Marketing
Operations
Project Mgmt
Sales
Developer
new
Denver
Developer
new
Denver
Data + Analytics
new
Denver
Data + Analytics
new
Denver
Project Mgmt
new
Denver
Data + Analytics
new
Denver
HR
new
Denver
Developer
new
Denver
Sales
new
Remote
Sales
new
Remote
Sales
new
Remote
Data + Analytics
new
Denver
Project Mgmt
new
Denver
Sales
new
Denver
Operations
new
Denver
Developer
new
Denver
Sales
new
Denver
Operations
new
Denver
Developer
new
Denver
Data + Analytics
new
Denver
Operations
new
Denver
Project Mgmt
new
Remote
Project Mgmt
new
Remote
Sales
new
Remote
Finance
new
Denver
Operations
new
Denver