BI- Business Analyst

  • location: Alsip, IL
  • type: Permanent
  • salary: $90,000 - $120,000 per year

job description

BI- Business Analyst

job summary:
Our client is looking to hire a BI Business Analyst with good experience in building business intelligence dashboards to join their team in a permanent capacity!

Summary: This position is responsible for building, implementing and supporting Microsoft BI solutions that provide data, analytics, visualizations and other tools to deliver data access, trend analysis and decision support. In addition, this position will help to develop the corporate framework and governance to help drive business intelligence for a global audience. This position will play a Key role in leading our Data Presentation initiatives at the global level.

Essential Duties & Responsibilities:

  • Proven experience in all stages of BI project work (requirements and logical design, physical design, implementation, testing and deployment) with a demonstrated strength in Data Presentation using Power BI.
  • Exhibit a firm grasp of BI implementation methodologies and an in-depth knowledge of, and experience with, the Microsoft BI Stack (SSIS, SSRS and SSAS).
  • Leverage Data Presentation skills, design and implementation for data visualization and analytical abilities to develop insightful conclusions and generate solutions to address user needs
  • Direct quality assurance and user acceptance testing by writing test plans and managing the execution of testing (Unit and UAT)
  • Share in team ongoing 2nd/3rd level technical support for supported applications and environments supported by the Information management and Shared Services team.

    • For example, HRIS, Time and Attendance, Educational systems, Compensation planning, Goal and Career planning, Payroll, Costing, Pricing and Sales Reporting
  • Collaborate with other teams within the organization and be able to devise the technical solution as it relates to the business & technical requirements
  • Create written communication materials that effectively summarize findings and support recommendations
  • Conduct basic project leadership

    • Develop project plans and provide time estimates on related project work
    • Create and follow timelines
    • Communicate project status(s) within IT
  • Mentor colleagues and be proactive in developing colleague skill sets to have a better understanding of Analysis Services, particularly Data Presentation.
Requirements:

  • Bachelor's degree in systems related field or equivalent experience.
  • Minimum of 5 years of experience in database design and/or business analysis with skills in analytics and OLAP cube and Tabular Model development.
  • Preferred 3 years of experience using Microsoft business intelligence stack to produce analytics and reporting capabilities.
  • Preferred demonstrated experience developing Power BI reports and dashboards as well as data connection and transformation capabilities of Power BI. If not Power BI, then equivalent knowledge/experience of Tableau

    • Excel, Power BI, Power Pivot and other Microsoft Data solutions.
  • Technical experience includes the following:

    • SQL Relational Database and SQL Language
    • Nice to Have:

      • Report Development (Microsoft SSRS)
      • Extraction, Transformation and Loading (ETL) (Microsoft SSIS)
      • Dimensional Modeling (Kimball Methodology)
  • Skills and behaviors needed to teach, tailor messaging, and-when necessary-to assert control during interactions with business partners. Ability to communicate clearly and concisely and adjust communication style by medium and audience.
  • Experience supporting manufacturing or product development environments a plus.

    • Distribution, Finance, Manufacturing, Inventory, Warehouse Management, Transportation Management, Capital Asset Management, Pricing and Job Costing
  • Experience with Microsoft Dynamics AX or D365 for Finance & Operations a plus.
 
location: Alsip, Illinois
job type: Permanent
salary: $90,000 - 120,000 per year
work hours: 8am to 4pm
education: Bachelors
 
responsibilities:
Summary: This position is responsible for building, implementing and supporting Microsoft BI solutions that provide data, analytics, visualizations and other tools to deliver data access, trend analysis and decision support. In addition, this position will help to develop the corporate framework and governance to help drive business intelligence for a global audience. This position will play a Key role in leading our Data Presentation initiatives at the global level.

Essential Duties & Responsibilities:

  • Proven experience in all stages of BI project work (requirements and logical design, physical design, implementation, testing and deployment) with a demonstrated strength in Data Presentation using Power BI.
  • Exhibit a firm grasp of BI implementation methodologies and an in-depth knowledge of, and experience with, the Microsoft BI Stack (SSIS, SSRS and SSAS).
  • Leverage Data Presentation skills, design and implementation for data visualization and analytical abilities to develop insightful conclusions and generate solutions to address user needs
  • Direct quality assurance and user acceptance testing by writing test plans and managing the execution of testing (Unit and UAT)
  • Share in team ongoing 2nd/3rd level technical support for supported applications and environments supported by the Information management and Shared Services team.

    • For example, HRIS, Time and Attendance, Educational systems, Compensation planning, Goal and Career planning, Payroll, Costing, Pricing and Sales Reporting
  • Collaborate with other teams within the organization and be able to devise the technical solution as it relates to the business & technical requirements
  • Create written communication materials that effectively summarize findings and support recommendations
  • Conduct basic project leadership

    • Develop project plans and provide time estimates on related project work
    • Create and follow timelines
    • Communicate project status(s) within IT
  • Mentor colleagues and be proactive in developing colleague skill sets to have a better understanding of Analysis Services, particularly Data Presentation.
Requirements:

  • Bachelor's degree in systems related field or equivalent experience.
  • Minimum of 5 years of experience in database design and/or business analysis with strong skills in analytics and OLAP cube and Tabular Model development.
  • Preferred 3 years of experience using Microsoft business intelligence stack to produce analytics and reporting capabilities.
  • Preferred demonstrated experience developing Power BI reports and dashboards as well as data connection and transformation capabilities of Power BI. If not Power BI, then equivalent knowledge of Tableau

    • Excel, Power BI, Power Pivot and other Microsoft Data solutions.
  • Technical experience includes the following:

    • SQL Relational Database and SQL Language
    • Nice to Have:

      • Report Development (Microsoft SSRS)
      • Extraction, Transformation and Loading (ETL) (Microsoft SSIS)
      • Dimensional Modeling (Kimball Methodology)
  • Skills and behaviors needed to teach, tailor messaging, and-when necessary-to assert control during interactions with business partners. Ability to communicate clearly and concisely and adjust communication style by medium and audience.
  • Experience supporting manufacturing or product development environments a plus.

    • Distribution, Finance, Manufacturing, Inventory, Warehouse Management, Transportation Management, Capital Asset Management, Pricing and Job Costing
  • Experience with Microsoft Dynamics AX or D365 for Finance & Operations a plus.
 
qualifications:
  • Experience level: Experienced
  • Minimum 5 years of experience
  • Education: Bachelors
 
skills:
  • Business Systems Analyst
  • System Analyst
  • Power BI
  • Microsoft BI Stack
  • SSIS
  • SSRS
  • SSAS
  • SQL

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs


    Senior Business Analyst

  • location: Chicago, IL
  • job type: Permanent
  • salary: $100,000 - $110,000 per year
  • date posted: 7/23/2021

    Sr. E-Commerce Analyst

  • location: Oak Brook, IL
  • job type: Permanent
  • salary: $80,000 - $100,000 per year
  • date posted: 7/15/2021