Summary:
This role will become a subject-matter-expert, supporting internal data system, 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 post joins the Data & Analytics team within Enterprise Architecture with a responsibility to deliver industry leading visualization solutions to ScanSource’s world customer base.
Essential Job Duties:
- 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.
- Perform Power BI service administrative duties.
- Implement best practices when building & maintaining reports.
Reporting Relationships:
Data & Analytics Team Lead
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 skills.
- 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 over time 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:
- Ability to learn new technologies quickly.
- 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.
- Azure, Data factory, Azure Pipeline & dataflow experience.
- Experience using power query and power apps.
- Experience working with data in Sales Force or Tableau, a plus.
- Experience using Visual Studio for SSIS, a plus.
- Experience using SAP, a plus.
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:
Compensation Range: $65,000 - $78,000 CAD annually
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
Skills Required
- Bachelor's degree in accounting, business, economics, computer science or related discipline
- Three to five years of similar or related experience
- Advanced Microsoft Power BI, DAX, Power Automate, Power Apps, Power Query and SQL skills
- Advanced Microsoft Excel skills, including pivot tables, macros, vlookups
- Knowledge of Data Integration and ETL tools
- Ability to quickly troubleshoot and solve user or refresh issues using Power BI
- Excellent organization, time and task management skills
- Ability to train other team members and internal customers on Power BI interface
ScanSource Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about ScanSource and has not been reviewed or approved by ScanSource.
-
Fair & Transparent Compensation — External salary snapshots for certain sales roles provide concrete benchmarks that help set expectations in negotiations.
-
Retirement Support — A retirement plan and an Employee Stock Purchase Plan are highlighted, supporting longer‑term wealth building.
-
Wellbeing & Lifestyle Benefits — Health and wellness resources include medical, dental, vision, telemedicine, wellness programs, and on‑site clinic and fitness options at HQ.
ScanSource Insights
What We Do
ScanSource is a leading hybrid distributor connecting devices to the cloud and accelerating growth for partners across hardware, software, connectivity and cloud. Our partners include value-added resellers (VARs), sales partners or agents, independent sales organizations (ISOs), and independent software vendors (ISVs). We are proud of the relationships we build with our partners, and we strengthen these bonds through transparency that leads to immense trust. Since the very beginning, we have concentrated on being the best-possible, technology provider for our partners. One that builds on that foundation of relationships, goes the extra mile, and isn’t afraid to take a leap into an evolving – sometimes unknown – future. As the channel has evolved, so have we to better serve our partners. We continue to grow our offerings, investing in the key assets and capabilities that have expanded our routes to market, launched us into new technology segments, and developed our professional services capabilities, all while continuing to deliver the solutions our partners needs to be successful. Our goal? Empowering our partners by giving them more to sell. And helping them grow their businesses and strengthen relationships with their customers. Because the global marketplace is more customer-centric than ever before. And so are we.
