Log in

Winsupply - Business Intelligence Analyst

01/05/2022 1:03 PM | Kaitlin Quellhorst (Administrator)

Apply at https://www.winsupplyinc.com/support-services-careers

Position Summary

The Business Intelligence (BI) Analyst’s role is to study business requirements and design and implement BI software and systems to resolve those requirements. This includes integrating databases, data warehouses, and data access tools with business processes to drive success.

Accountabilities/Responsibilities

  1. Prioritize and select projects.
  2. Partner with business to gather requirements and translate into BI solutions.
  3. Design, test, deploy, and supporting BI solutions to business constituents both within and outside Winsupply.
  4. Assist users with questions, problems, communications, and training
  5. Discover and troubleshoot issues as they arise in the technical environment
  6. Participates in project and production support environments
  7. Assists in ad-hoc projects as assigned
  8. Provide detailed status and problem updates and analyses to all constituents
  9. Provide guidance to others within the department and across other IS groups

Competencies for Success

  1. Communication
  2. Team work
  3. Analytical and Critical Thinking
  4. Communication
  5. Planning and Organizing

Qualifications/Experience

  • Minimum Qualifications
  • BA/BS in Information Technology, Information Systems or Mathematics
  • 4+ years of relevant IT or IS experience and School
  • 2+ years of database experience
  • Experience with Power BI or equivalent visual analytic tools
  • Experience with the concepts of modern relational database management systems.
  • Strong TSQL experience to include stored procedures, functions, merge statements and analytical functions.
  • Have an understanding of the difference between operational and decisional databases.
  • Experience with Microsoft SQL Server including
    • SQL Server Management Studio (SSMS)
    • SQL Server Integration Services (SSIS)
    • SQL Server Reporting Services (SSRS)
    • SQL Server Analysis Services (SSAS)
    • SQL Server Agent
    • SQL Server Developer Tools
  • Understanding of the various information domains in a typical data warehouse environment
  • Must be able to do basic tuning and optimization of data warehouse databases
  • Understand the basics of indexing schemes, constraints and be comfortable studying query execution plans
  • Must be able to extract and load data from multiple systems/applications into data warehouse and vice versa through SSIS and SQL Server Agent jobs built from TSQL scripts
  • Must be able to ensure accuracy and integrity of the data in data warehouse that is loaded from multiple source systems.
  • Must be able to cleanup data as required
  • Must have a grasp of basic statistical analysis concepts
  • Tabular or multi-dimensional modeling preferred

The performance of essential job functions for this position require both access to valuable assets and interaction with others under potentially stressful conditions. Therefore, individuals demonstrating a history of illegal substance abuse, theft or violence present a higher risk of loss and may be disqualified.

Physical Demands

The physical demands here are representative of those that must be met to successfully perform the essential job functions with or without reasonable accommodations:

  • Sitting for extended periods of time
  • Dexterity of hands and fingers to operate a computer keyboard, mouse, power tools, and other computer components

Winsupply is an equal opportunity employer, so it encourages all qualified individuals to apply including minorities, veterans, women, and those with disabilities.


Author
Comment
 

ANNUAL PARTNERS

Our Annual Partners share a common goal; to connect, strengthen and champion the IT community in our region. A Technology First Annual Partner is an elite member leading the support, development and expansion of Technology First services. In return, Annual Partners improve community visibility and increase their revenue. Make a difference in our region and your business. Become a Technology First Annual Partner.  

Learn more about the benefits of being one of our Annual Partners.




Technology First

1435 Cincinnati St, Ste 300, Dayton Ohio 45402

Info@TechnologyFirst.org

© Technology First, All Rights Reserved