BI Specialist II

ScanSource; Greenville (SC); On-site; USD 80,000 - 90,000; Full time

Benefits offered by this job

Medical/dental/vision coverage

Life insurance

401(k) with matching

128 hours PTO per year

10 paid holidays

Job summary

ScanSource seeks a BI Specialist to become a subject-matter expert for internal data systems, delivering industry-leading visualization solutions to a global customer base. You will partner with senior management, developers and analysts to gather requirements and drive data-driven improvements.

You will develop dashboards, data models and reports, while ensuring performance and scalable data integration. Strong Power BI, SQL and Excel skills are essential.

Qualifications

• Bachelor's degree in accounting, business, economics, computer science or related field.
• 3–5 years of related experience.
• Advanced Power BI, DAX, Power Automate, Power Apps, Power Query and SQL understanding.
• Knowledge of Power BI security, premium/embedded capacity, paginated reports, data modeling and incremental refresh.
• Excel skills with pivot tables, macros and lookups.
• Knowledge of data integration and ETL tools; data cleansing for analysis.

Responsibilities

• Develop dashboards, data models and visualization solutions for global users.
• Collaborate with stakeholders to gather requirements and define deliverables.
• Ensure performance of Power BI reports as data models evolve.
• Troubleshoot user issues and optimize refresh processes.
• Lead BI reporting requests and assist with SAP BI workflows.
• Train team members and internal customers on Power BI interfaces.

Skills

Power BI

DAX

SQL

Power Automate

Power Apps

Power Query

Data Modeling

Excel

ETL

Troubleshooting

Communication

Teamwork

Education

Bachelor's degree in accounting, business, economics, computer science or related

Tools

Azure DevOps

GitHub

Jira

ServiceNow

Job description

This role will become a subject-matter-expert, supporting internal data systems, improving business processes and driving data-related activities. As the BI Specialist you will work closely with multiple stakeholders within the business, from senior management to software developers, IT support, sales and marketing. You will engage with business users from a support perspective whilst also gathering requirements for BI related projects. You will be business-facing, with experience in understanding users’ technical support queries as well as requirements for data-driven process improvement initiatives. This role joins the Data & Analytics team and is responsible for delivering industry-leading data visualization solutions to ScanSource's global customer base.

• Solve problems for large corporate clients in multiple business sectors.
• Develop leading visualization solutions, dashboards and data models.
• Share your passion and knowledge with other teams.
• Implement best practices when building & maintaining reports.
• Assist in managing SAP BI reporting requests
• Partner with business stakeholders on long-term dashboard and analytics initiatives, helping define requirements, recommending solutions, and refining deliverables as business priorities and objectives evolve

Reporting Relationships: Manager, BI Data Analyst

Requirements:

• Ability to effectively communicate both written and verbally in English.
• A bachelor’s degree in accounting, business, economics, computer science or a related discipline is required.
• Three to five years of similar or related experience.
• Advanced Microsoft Power BI, DAX, Power Automate, Power Apps, Power Query and SQL understanding.
• 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 & dashboards perform optimally as models change overtime and with large data sets.
• Knowledge of Data Integration and ETL tools. Perform data transformations and cleansing tasks to ensure that data is accurate, complete and ready for analysis.
• Ability to quickly troubleshoot and solve user or refresh issues using Power BI.
• Advanced Microsoft Excel skills, including pivot tables, Macro’s, vlookups, etc.
• High attention to detail and ability to be flexible and learn quickly.
• Excellent organization, time and task management skills.
• Must be reliable, maintain consistent attendance and meet strict deadlines.
• Ability to follow and develop processes and procedures.
• Ability to work in a team environment and work independently with limited supervision.
• Ability to train other team members and internal customers on Power BI interface.
• Ability to identify basic problems and procedural irregularities, collect data, establish facts, and draw valid conclusions.
• Application of logic, reasoning, and problem solving.
• Knowledge of Microsoft 365 software (Outlook, Word, PowerPoint, etc.).

Preferred:

• Working understanding of the SDLC and QA lifecycle and methodology.
• Experience with Python or Spark for data processing.
• Experience using integration with source control. (Azure DevOps, Git or GitHub)
• Knowledge of cloud architecture.
• Experience using ServiceNow or Jira task management tools.
• Experience using power query and power apps.
• Experience working with data in Sales Force or Tableau.
• Experience using Visual Studio for SSIS.
• Experience using SAP.

Physical Requirements:

• Ability to sit at a computer terminal for long periods of time.
• Ability to be physically in attendance at workstation at designated company office location during normal business hours designated for this position.

Compensation Range: $80,000 - $90,000

Actual annual salary offered to a candidate will be based on a number of variables including work experience, education and skills/ achievements, and will be mutually agreed upon at the time of offer. This position is not eligible for a variable pay component as part of the hiring range.

While we’re committed to providing top-tier solutions, we’re just as committed to supporting our own team. Our employees enjoy a variety of comprehensive benefits, including medical/dental/vision coverage, life insurance, and a 401(k) plan with matching provision. Outside of CA, ScanSource grants 128 hours of paid time off (PTO) each calendar year (prorated for date of hire). In the state of CA, employees accrue a set number of hours each pay period equaling the same 128 hours of PTO. ScanSource also celebrates 10 paid company holidays.

ScanSource, Inc. is an Equal Opportunity Employer

EOE/M/F

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.