Business Intelligence Engineer

Ascend is transforming the regional truckload sector by leveraging technology, building density, and offering driver-friendly routes and policies—making us the carrier of choice for shippers that demand high performance and flexibility at competitive rates, and the employer of choice for drivers seeking a better work-life balance.
PURPOSE
Ascends Business Intelligence Engineer is responsible for developing and maintaining in-house developed Business Intelligence applications and solutions. They are data experts, as they work primarily with databases and different types of software. As the primary focus of this position is to solve problems, BI engineers must always be mining data and presenting it in an understandable way. They should be capable of creating tables and writing reports on their findings, and they often simplify highly technical language for others in the company.
ACCOUNTABILITIES

• A BI Engineer is accountable for researching and planning solutions for existing problems within the company. BI Engineers also are responsible for building OLAP, or online analytical processing. They also work with databases, both relational and multidimensional.
• Deliver quality technology solutions with the application development team with a winning attitude and in-line with Ascends business objectives.
• Participate in the design, development, and analysis of data architecture and warehousing approaches.
• Create Business Intelligence tools and reports, such as physical data models and dimensional analyses.
• Design, code, test, and aggregate results from SQL queries to provide information to users.
• Create technical documents to document SQL or other database contents, concepts, and mapping between databases.
• Follow the guidance of more experienced team members to ensure technical skillsets are shared through knowledge transfer.
• Maintain relationships and alignment with Engineering, System Analysts, Networking, and other supporting departments to ensure maximum delivery in support of business units.
• Commit to continued growth as a technology professional including enhancing and gaining the technical skillsets required.
• Hold self and others accountable to demonstrate Ascends Values: Zero Safety Events; Be Courageous; Act with Integrity; Inspire Trust; Teamwork; Have Fun and Build a Legacy.

QUALIFICATIONS

• Experience with data querying or modeling with SQL.
• Experience with building and maintain basic data artifacts.
• Experience with one or more industry analytics visualization tools.

KNOWLEDGE, SKILLS, AND TRAITS

• Microsoft SQL Server 2012-2016, TSQL.
• SSRS (SQL Server Reporting Services).
• Power BI, Tableau, SSPS, or other data visualization platforms.
• Visual Studio 2010-2015.
• Team Foundation Server.
• R (preferred).
• C#.Net.
• ASP.NET / MVC.
• Ability to collect data, analyze, gain insight, and make recommendations for action.
• Ability to deliver exceptional service through positive engagement and patience.

EDUCATION, CERTIFICATIONS, & LICENSE REQUIREMENTS

• Minimum Bachelor’s Degree inn a Computer Science or Computer Information Systems field of study or other equivalent technical discipline.
• Minimum Bachelor’s Degree with 4 years equivalent work experience in a software development role.
• Master’s Degree Preferred.

WE OFFER

• Medical, Dental, Vision - 1st of month after hire
• 401(k) - 5% match
• Employee Assistance Benefit
• Enhanced Benefits (STD, LTD, Critical Care)
• Paid Holidays
• Paid Time Off

Ascend is an equal opportunity employer committed to a diverse, inclusive environment where all individuals may grow and thrive, respecting the different experiences that each employee brings to their job. Ascend believes that a diverse work environment results in a better experience for employees and customers and makes Ascend stronger.
With our mission of diversity and inclusion in mind, we provide equal employment opportunities to all qualified persons without regard to race, color, national origin, gender, pregnancy (including childbirth and related medical conditions), religion, age, disability, citizenship, sex (including sexual orientation, gender identity or expression), marital status, ancestry, genetic information, veteran and/or military status, or any other characteristic protected by applicable federal, state, or local law or Ascend policy.
This job description is intended to describe the general nature and level of work being performed by employees in this position. It is not intended to be an exhaustive list of all responsibilities, duties, and skills required for this position, other duties outside of normal responsibilities may be performed as necessary to meet the needs of the organization. Nothing in this position description restricts management’s right to assign or reassign duties and responsibilities to this position at any time.
Employee’s acknowledgment constitutes employee’s understanding of the principal accountabilities and duties of the position and certifies that they are physically able to perform the necessary duties in the work environment.

Disability insurance, Health insurance, Dental insurance, Paid time off, 401(k) 5% Match, Vision insurance