BI Specialist II

ScanSource • Greenville, SC

12d • Onsite

About The Position

The BI Specialist II joins ScanSource’s Data & Analytics team and supports internal data systems, improves business processes, and drives data-related activities. The role works with stakeholders across the business—including senior management, software developers, IT support, sales, and marketing—to respond to technical support queries and gather requirements for BI projects. It delivers data visualization solutions for ScanSource’s global customer base and supports long-term dashboard and analytics initiatives by defining requirements, recommending solutions, and refining deliverables as business priorities evolve.

Requirements

• Ability to communicate effectively in written and spoken English.
• Bachelor’s degree in accounting, business, economics, computer science, or a related discipline.
• Three to five years of similar or related experience.
• Advanced understanding of Microsoft Power BI, DAX, Power Automate, Power Apps, Power Query, and SQL.
• Knowledge of Power BI role-level security, premium capacity, embedded capacity, paginated reports, data modeling, incremental refresh, and gateway maintenance.
• Ability to ensure Power BI reports and dashboards perform optimally as models change over time and with large data sets.
• Knowledge of data integration and ETL tools.
• Advanced Microsoft Excel skills, including pivot tables, macros, and VLOOKUPs.
• High attention to detail and ability to be flexible and learn quickly.
• Excellent organization, time-management, and task-management skills.
• Reliability, consistent attendance, and ability to meet strict deadlines.
• Ability to follow and develop processes and procedures.
• Ability to work in a team and independently with limited supervision.
• Ability to identify basic problems and procedural irregularities, collect data, establish facts, and draw valid conclusions.
• Ability to apply logic, reasoning, and problem-solving.
• Knowledge of Microsoft 365 software, including Outlook, Word, and PowerPoint.
• Ability to sit at a computer terminal for long periods.
• Ability to be physically present at the workstation at the designated company office location during the normal business hours designated for the position.

Nice To Haves

• Working understanding of the SDLC and QA lifecycle and methodology.
• Experience with Python or Spark for data processing.
• Experience integrating with source control tools such as Azure DevOps, Git, or GitHub.
• Knowledge of cloud architecture.
• Experience using ServiceNow or Jira task-management tools.
• Experience with Azure, Data Factory, Azure Pipelines, and dataflows.
• Experience using Power Query and Power Apps.
• Experience working with data in Salesforce or Tableau.
• Experience using Visual Studio for SSIS.
• Experience using SAP.

Responsibilities

• Solve problems for large corporate clients in multiple business sectors.
• Develop visualization solutions, dashboards, and data models.
• Share BI knowledge and expertise with other teams.
• Perform Power BI service administrative duties.
• Apply best practices when building and maintaining reports.
• Assist in managing SAP BI reporting requests.
• Partner with business stakeholders on long-term dashboard and analytics initiatives, defining requirements, recommending solutions, and refining deliverables as priorities and objectives evolve.
• Support business users with technical queries and gather requirements for BI-related projects.
• Troubleshoot and resolve user or refresh issues using Power BI.
• Perform data transformations and cleansing to prepare accurate, complete data for analysis.
• Train team members and internal customers on the Power BI interface.

Benefits

• Medical, dental, and vision coverage.
• Life insurance.
• 401(k) plan with matching provision.
• 128 hours of paid time off each calendar year, prorated based on hire date, outside California.
• In California, paid time off accrues each pay period at a rate totaling 128 hours annually.
• 10 paid company holidays.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level