What are the responsibilities and job description for the Business Intelligence Analyst position at Western Express?
Western offers competitive pay, benefits, paid time off, paid holidays, and a fun, family-oriented culture. The Western Express campus is a state-of-the-art facility rebuilt in 2020, with three on site gyms, guided fitness classes, and a cafeteria. We are proud to be a culture that promotes from within, has infinite growth potential, and will offer relocation. One of our core values is to be hardworking, and we reward those individuals with opportunity and incentive.
Western Express is seeking a Business Intelligence Analyst to join the BI team and contribute to the growth of our reporting and analysis solutions. In this role, you will contribute on the BI team to create stakeholder reporting and offerings using data cleansing and mining expertise, data modeling, and business intelligence tooling. We are seeking an individual with excellent problem-solving skills, the ability to communicate clearly and confidently with technical and business stakeholders, and the drive to own deliverables and initiatives while working both self-directed and on team projects. As a Business Intelligence Analyst at Western Express, you will spend 50% of your time writing complex queries in T-SQL and the remaining 50% of your time developing data visualizations in our BI tool, WebFOCUS.
In this role, you will:
Applicants with disabilities may be entitled to reasonable accommodation under the terms of the Americans with Disabilities Act or other similar state or local laws. A reasonable accommodation is a change in the way things are normally done which will ensure an equal employment opportunity without imposing undue hardship on Western. Please inform the company's personnel representative if you need assistance completing this application or to otherwise participate in the application process.
I understand, where permissible under applicable federal, state, and local law, I may be subject to a pre-employment drug test after receiving a conditional offer of employment. Upon employment, employees may be required to have their picture taken.
Western Express is seeking a Business Intelligence Analyst to join the BI team and contribute to the growth of our reporting and analysis solutions. In this role, you will contribute on the BI team to create stakeholder reporting and offerings using data cleansing and mining expertise, data modeling, and business intelligence tooling. We are seeking an individual with excellent problem-solving skills, the ability to communicate clearly and confidently with technical and business stakeholders, and the drive to own deliverables and initiatives while working both self-directed and on team projects. As a Business Intelligence Analyst at Western Express, you will spend 50% of your time writing complex queries in T-SQL and the remaining 50% of your time developing data visualizations in our BI tool, WebFOCUS.
In this role, you will:
- Use T-SQL to access and update tables, views, stored procedures, etc.
- Ingest data from various internal systems, track key performance indicators, and build custom dashboards and repeatable analyses
- Develop tools to support end user's needs using MS SQL Suite, TIBCO Webfocus, AS400, SQL Viewpoint, or researching options not currently used internally
- Own the creation and enhancement of reporting tools for stakeholder use
- Field ad-hoc requests from stakeholders to provide accurate datasets for fast decision making
- Simplify time-intensive and error-prone processes through the development of programmatic solutions
- Document processes and procedures
- Work with BI Team Leads on project priorities and deliverable timelines
- Personal development and continuing education encouraged and supported
- Interpret results using a variety of techniques, ranging from simple data aggregation via statistical analysis to complex data mining
- Designs, develops, implements, and maintains business solutions
- Strong technical accomplishments in SQL and data analysis skills using other tools
- Comfortable dealing with large and complex data sets, and have experience building self-service dashboards and using visualization tools
- Providing user-friendly and effective reporting tools to end users using TIBCO Webfocus
- Managing multiple complex projects in a methodical and structured way
- Strong communication with teammates and in working with stakeholders
- Turn business questions into data solutions optimized for reporting
- Demonstrating solution-oriented and motivated attitude
- Have 1-2 years of experience in a Data Analyst, Data Developer, or Data Engineer role using SQL
- Have 1-2 years of experience with BI Tools (Tableau, Power BI, Webfocus, etc.)
- Eager self-starter
- Great communicator
- Strong focus on stakeholder satisfaction
- Able to work across teams to accomplish goals
- Dedication to the quality and ownership of your work products
- TIBCO Webfocus experience is a plus
- The opportunity to join a new, developing team driving data culture/literacy and data-driven decision making in an essential business industry.
- Competitive benefits including health, dental & vision insurance; and 401k
- Company wide emphasis on wellness, including work-life balance and fitness
- On site cafeteria, fitness center, hot yoga room, instructed sessions for Crossfit, Yoga, Interval Training
Applicants with disabilities may be entitled to reasonable accommodation under the terms of the Americans with Disabilities Act or other similar state or local laws. A reasonable accommodation is a change in the way things are normally done which will ensure an equal employment opportunity without imposing undue hardship on Western. Please inform the company's personnel representative if you need assistance completing this application or to otherwise participate in the application process.
I understand, where permissible under applicable federal, state, and local law, I may be subject to a pre-employment drug test after receiving a conditional offer of employment. Upon employment, employees may be required to have their picture taken.
