Database Analyst

Trek Bicycle Corp Waterloo , WI 53594

Posted 6 days ago

Company Description

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:

We call our team the Awesome Bus. Want to join us on this incredible ride? Well, today is your lucky day! If you are an agile and effective with data, spreadsheets, and SQL, then our Database Analyst position might be for you!

Confident that you can help run the backbone our retail systems? Submit your application! Our Database Analyst should take pride in being the go-to-person for those working in Trek Stores, as well as those on the Retail Accounting and Purchasing teams. Additionally, the database analyst is responsible for the overall integrity of our data, including, but not limited to the management of categories, vendors, users, payments and pricing.

Position Responsibilities:

  • Maintain central databases in North America

  • Support the acquisition and transition of data into a primary database

  • Responsible for entering new products, categories, special orders, vendor updates, and pricing

  • Database cleanup functions

  • A variety of other tasks may become the focus of this position be flexible!

Position Requirements:

  • Bachelor's degree preferred or relevant work experience

  • Exceptional business and technical communication skills required

  • Demonstrated success managing business and/or technical requirements throughout the development and/or project lifecycle.

  • Experience with Database principles, Inventory Control/Management, Point of Sale (POS), Familiarity with SQL and/or 3rd party integration platforms for software.

  • Commitment to excellence in customer service, product quality, and doing the "right thing" in a dynamic environment with multiple and rapidly changing priorities.

  • Effective working individually or with a team.

  • Strong process management and problem-solving skills required with experience in agile software development a plus.

  • Experience with Ascend RMS is preferred.

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
lc_ad

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
BI Analyst

Trek Bicycle Corp

Posted 6 days ago

VIEW JOBS 3/15/2019 12:00:00 AM 2019-06-13T00:00 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. QUALIFICATIONS AND EDUCATION REQUIREMENTS * 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 Trek Bicycle Corp Waterloo WI

Database Analyst

Trek Bicycle Corp