BI Analyst

Trek Bicycle Corp Waterloo , WI 53594

Posted 7 days ago

Trek Bicycle Corporation in Waterloo, WI is seeking to hire a Business Intelligence (BI) Analyst. The BI Analyst is responsible for building strong relationships with business stakeholders, collecting business requirements, formulating functional designs, prototyping solutions, conducting data analysis, testing, and training the business on features developed by the Business Intelligence group.

The BI Analyst will participate in prioritizing BI requests and requirements globally and provide technical requirements for a Business intelligence developer under an Agile methodology. The candidate is expected to support business users with Level II data support, provide analytics assistance from BI, and provide training of BI tools and solutions to business users.

The BI Analyst quickly learns Trek's enterprise data warehouse, the sources used to populate it, and how its data is utilized by all areas of the company.

The candidate is familiar with Microsoft Business Intelligence tools (SQL, SSAS, SSIS, SSRS, Azure Data products, Excel, Power BI, DAX) and can write SQL queries and utilize them to validate new features or trouble-shoot data issues. The BI area is a fast-paced team that interacts with all area of the business.

Core Responsibilities:

  • Proactively collaborate with stakeholders in all levels of the company.

  • Gather requirements from business stakeholders.

  • Document the requirements in the form of an Agile story, create mock-ups, prototypes, ad-hoc SQL queries, and other artifacts to support requirements.

  • Execute testing needed to assure the desired functionality and data integrity of BI solutions meet the business requirements and deadlines.

  • Provide end-to-end training for the global business.

  • Provide on-going analytical support for BI solutions released to the business.

  • Proactively identify data quality issues and recommend data integrity checks to alert users when such issues occur.

  • Innovate, using the latest technology, or deliver information needed to drive business decisions.

  • Provide Level II Business Intelligence Help Desk support for Trek employees globally.

  • Proactively assist in communicating to users with respect to BI software upgrades and new features released by BI.

  • Proactively share knowledge with co-workers and ensure appropriate knowledge transfer to cover duties during illness, vacations, training, etc.

  • Developing and delivering reporting for business users on multiple platforms such as Power BI, SSRS, Power Pivot, and Excel.


  • Bachelor's degree, preferably in Computer Science (equivalent professional experience considered)

  • Minimum 3 years of experience in an IT Business Analysis role with at least 2 years of hands-on continuous work experience in using Microsoft SQL Server Business Intelligence tools to support user reporting needs.

  • Ability to understand complex business & system processes and clearly articulate business requirements.

  • Ability to perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source system data and data samples).

  • Able to read and write SQL query statements.

  • Proficient in MS Excel and Microsoft's Power BI Suite (Power BI, Power Query, PowerPivot, DAX)

  • Professional experience in successfully supporting users' reporting and data needs.

  • Experience with Azure data products.

  • Good written / oral communication skills.

  • Demonstrated success working in an Agile or team-based environment.

  • One (1) year experience working with ERP data is preferred (Trek uses JD Edwards)

  • eCommerce data experience is a plus

  • Experience with SharePoint is a plus

  • Experience with CRM is a plus

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
ERP Distribution Analyst

Trek Bicycle Corp

Posted Yesterday

VIEW JOBS 3/21/2019 12:00:00 AM 2019-06-19T00:00 Company Summary Trek Bicycle is a global leader in the design and manufacture of bicycles and related products. Trek believes the bicycle can be a simple solution to many of the world's most complex problems, and is committed to breaking down the barriers that prevent people from using bicycles more often for transportation, recreation, and inspiration. Our mission is to create products we love and take care of our customers. We value our team, making sure the best is on the field. We value new ideas from anywhere, inspiring others with our positive energy, dealing with reality to make the tough calls, and getting things done fast- turning ideas into reality. Position Description The IT ERP Department is enhancing its staff through the hiring of an ERP/J.D. Edwards Distribution Analyst with expertise in J.D. Edwards 9.1. It would be a plus if the candidate has experience in DSI or dcLINK script logic for Scanners, or Transform Overlay development, or Loftware Labeling development, or SOA/Oracle Fusion Middleware specification creation. This position reports to the IT Global ERP/J.D. Edwards Distribution Manager and provides expertise in configuring, designing, enhancing, and maintaining applications for Distribution Processes: Sales, Claim Management, Advanced Warehousing, Pricing, Costing, and Purchasing, as well as working with Internal Business User customers. The position is focused, but not limited to, configuring for J.D. Edwards 9.1 Applications/Reports using the J.D. Edwards toolsets or surrounding technology toolsets. Position Responsibilities The successful analyst will interface with business partners and IT development staff throughout the development lifecycle of multiple and concurrent activities, projects, and system implementations to analyze business requirements and develop detailed specifications. Responsibilities will include ensuring that the architectural, business, coding, design, and quality standards for the J.D. Edwards applications/reports are met. This individual will leverage existing tools and participate in the application and development of new tools to assist with and/or lead the creation of business and technical requirements, the identification of applicable and innovative solutions, the accurate estimation of work effort, and the initiation and management of development, project, and task plans. This person will be self-motivated, require minimal supervision, and be responsible for the quality and timeliness of their own work including the management of incidents in an efficient manner while providing accurate status updates on all activities. A plus is having SQL Syntax knowledge and the ability to write simple Microsoft SSRS reports. Position Requirements * Bachelor's Degree in Business Administration or Information Technologies or related discipline and 5+ years of J.D. EDWARDS 9.1 experience required. * Knowledge of business distribution, supply chain, inventory and financials, as well as a sound technical understanding of IT processes are essential. * Strong Analysis, Design, Development, Problem Solving, and Process Management Skills required. * Exceptional business and technical listening, oral, and written skills required. * In-Depth understanding of Software Development/Engineering Methodology in Development, Production, and Testing Environments with Standards Documentation required. * Experience with DSI or dcLINK script logic for Scanners or Transform Overlay development or Loftware Labeling development, or SOA/Oracle Fusion Middleware development a plus Additional skills * Ability to work in a fast moving environment, meet deadlines and multitask * Ability to get into detailed work where necessary * Positive attitude and proactive approach * Accountability and commitment * Thinks and acts globally * Open to ideas from anywhere and sees positive change as opportunity Trek Bicycle Corp Waterloo WI

BI Analyst

Trek Bicycle Corp