Business Intelligence (BI) Architect

Business Intelligence (BI) Architect

Position Purpose

Define overall BI Data Architecture that encompasses ETL processes, Operational Data Store, Enterprise Data Warehouse, and Data Marts. Develop a roadmap for Enterprise wide BI reporting, and a supporting analytics platform. Participate and guide in proper tool selection for BI roadmap. Work with Data Team Director and other architects to ensure logical, physical, and conceptual models support analysis needs for the business. Be a guide for all initiatives in a the BI sphere. Collaborate with key business stakeholders in realm of continuous improvements of data management and delivery.

Essential Position Functions

Principle Accountability | Team Membership

  • Active member of a data team that solves BI problems, establishes standards, and enforces them via processes, tools, and properly communicates any standard changes.
  • Assist Data engineers, other architects, and team leads in proper development of BI components, including ETL processes, design, POCs, etc.
  • Act as a liaison between business users and the data team
  • Act in the interest of the overall team
  • Actively work on broadening knowledge and adding technical skills
  • Seek help only after appropriately attempting to solve a problem

Principle Accountability | Data Quality and Governance Operations

  • Understand concept of MDM and has proven record in establishing or being part of analyzing, and establishing Master Data Management systems.
  • Understand how to engage business, leverage different technical techniques in establishing proper Reference data Mastering concepts with Technical and Non-Technical audience.
  • Identify key data elements in business areas covered by the data warehouse (ODS and DW)
  • Has established record in highly scalable, ODS, EDW, Data Marts solutions that also encompass Near Real Time features.
  • Proven record for best practices designing and implementing ETL solutions
  • Proven record in analyzing, preparing, and designing brand new reporting tools/solutions
  • Design, code, test and able to document new or modified BI systems, applications, and programs.
  • Development of the semantic layer, meta-data, reports, and report definitions.
  • Conduct research and make recommendations on BI products, services, and standards in support of procurement and development efforts.
  • Ensure data is used consistently across all data marts, warehouses, ODS.
  • Mentor and/or provide leadership to junior members of the team.
  • Ability to trace data through multiple systems and processes
  • Propose data quality initiatives to the data team and business stakeholders
  • Advocate good data quality and increase awareness among data producers and consumers
  • Participate in building and enforcing Data Quality processes to ensure good data quality on enterprise level.

Position Requirements

  • Master’s Degree in Computer Science, Statistics, Math, Business Systems or other quantitative field, or equivalent years of experience
  • 6-8 years of experience working with Echo and/or equivalent logistics experience highly desirable
  • Proven track record (6-8 years) working in a fast-paced environment, on time sensitive projects that require:
    • Experience as a BI Architect implementing a successful BI Framework and solution for one or more organizations from the ground up
    • Clear and timely communication of key information deemed critical to project success
    • Organizational skills required to balance risk and priorities
    • Familiarity with Scrum/Agile methodologies required
    • Advanced communication and conflict resolution skills
    • Excellent written and verbal communications skills and ability to effectively work with business leaders at all levels.
  • Proficient in the use of Microsoft office productivity suite applications (I.E. MS Word, Excel, PowerPoint etc.)
  • Lastly, this position is hands on (prove that you know all of the above). It does encompass the architecture role, but it is also expecting a hands on effort - assuming you will drive solutions from beginning to the end.

 All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, status as a qualified individual with a disability, or Vietnam era or other protected veteran.

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • JavascriptLanguages
    • T-SQLLanguages
    • jQueryLibraries
    • BootstrapLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • Node.jsFrameworks
    • MVCFrameworks
    • CQRSFrameworks
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • RedisDatabases
    • ElasticSearchDatabases
    • KafkaDatabases
    • RabbitMQDatabases
    • Google AnalyticsAnalytics
    • KissmetricsAnalytics
    • IllustratorDesign
    • PhotoshopDesign
    • SketchDesign
    • UXPinDesign
    • ConfluenceManagement
    • SmartsheetManagement
    • VersionOneManagement
    • Quality CenterManagement
    • DrupalCMS
    • SalesforceCRM
    • SendGridEmail


Located in River North overlooking the River! Easily accessible and close to various train and bus stops, including a shuttle from Union Station.

An Insider's view of Echo Global Logistics

How would you describe the company’s work-life balance?

Managers at Echo get to know you by having one on one meetings, so they understand your personal life. Echo is flexible with when you arrive and leave from work, so that it fits with your schedule. Echo understands that life happens, so leaving early isn’t a problem as long as you make it up later. I feel that Echo respects my personal time.


Software Engineer

What projects are you most excited about?

I am most excited around a project designed to transform and re-build our API architecture. This project is not only very beneficial to our clients but also allows members of my team to work on and be exposed to a high visibility design that will have a positive impact on the client experience when integrating with Echo.


Integration Operations TL

How does the company support your career growth?

Echo has a start-up feel but has an infrastructure that supports training, learning, and development, which in-turn allows for growth potential. At Echo you will be challenged in honing your skills in a constantly evolving industry and company. This can allow for each person to set themselves up for overall career growth.


Business Architect

What unique initiatives do you have that encourage innovation?

Echo structures itself into small teams that focus on key initiatives. We spend time planning, executing, and delivering technology to simplify the complex demands of transportation.


Chief Information Officer

What are Echo Global Logistics Perks + Benefits

Echo Global Logistics Benefits Overview

401k with company matching
Medical insurance through Blue Cross/Blue Shield
Health Savings Account (HSA)
Flexible Spending Account
Parental leave
Paid time off
Commuter benefits
Divvy discount code
Employee training programs
Volunteer time off
Casual dress code
Pet insurance
Gym membership discounts
Mobile carrier discounts
Employee assistance program

Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Onsite Gym
River North Gym is in the building
Retirement & Stock Options Benefits
401(K) Matching
Performance Bonus
Vacation & Time Off Benefits
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Game Room
Happy Hours
Recreational Clubs
Echo has it's own Softball league in the spring/summer!
Professional Development Benefits
Job Training & Conferences

Additional Perks + Benefits

Fast-paced. People-focused. Career-growth-centric. At Echo we work hard and carry the load together, but we also know how to have fun. Walking onto the sales floor of our 225,000-square-foot Chicago headquarters, you can feel the energy created by more than 700 sales representatives hustling to move over 14,000 shipments every day. When the last load is booked, you might find co-workers gearing up for summer softball, talking shop at our weekly “Beer Friday,” or competing in a game of foosball, ping-pong, or pop-a-shot.

More Jobs at Echo Global Logistics18 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Data + Analytics
Data + Analytics
Design + UX
Data + Analytics