Senior BI Developer

SunSource and its family of companies represent 270+ locations and 4,000+ employees making up one of North America's leading value-add industrial distribution companies. We provide customers with products and value-added solutions within Fluid Power, Fluid Process, Fluid Conveyance, Automation, General Industrial Components, and Industrial Repair.


SunSource is a growing company looking for a highly talented and passionate Business Intelligence Developer to design, build and maintain our enterprise Power BI reports, dashboards and data models in support of enterprise value creation and business growth. This position will work closely with business and technology leaders to understand the enterprise objectives and build our capabilities in BI, Reporting & Analytical applications to support Sales, Operations and Shared Services. This role will also be instrumental in advancing our data modeling and BI architecture capabilities, including the use of Databricks, to lead the industry in the utilization of data to capture market share and outperform our competition.

Responsibilities & Qualifications

• Own the data available within the Reporting environment, serving as a resource for the business to understand what data and capabilities currently exist.

• Meet with subject matter experts in different areas of the business, be able to quickly learn the concepts and business language relevant to their line of business and develop an understanding of how their data supports their business processes.

• Ability to transform data into insight can help to improve the value of the business. Design Power BI UX - visualizations, reports, and dashboards to tell stories and uncover insights for actionable analytics via mockups and functional specs.

• Perform BI solution development activities including requirements gathering, data model design, development & testing of reports & dashboards in Power BI. Test reports to ensure optimal user experience and data accuracy. Investigate and resolve any data discrepancies within Power BI datasets and models.

• Partner with Data Engineers to understand the data they make available and use it as the foundation for Power BI reporting and data models

• Build and maintain Power BI semantic data models and datasets sourced from Databricks, including relationships, DAX measures and calculation groups, to support scalable and reusable reporting.

• Create and maintain documentation that includes the design, requirements and user manuals for the organization.

• Facilitate and lead senior IT and business teams through challenging data issues.

• Excellent interpersonal, communication, listening and presentation skills.

• Excellent problem solving and analytical skills.

• Ability to influence and persuade, build consensus, drive and energize teams.

• Apply superior judgment as it pertains to prioritizing work for yourself and others and escalating roadblocks when necessary.

Key Competencies

Accountability: Demonstrates an understanding of the link between one's own job responsibilities and overall organizational goals and needs, and performs one's job with the broader goals in mind.

Collaborative Leadership: Promotes and generates cooperation among one's peers in leadership to achieve a collective outcome; fosters the development of a common vision and fully participates in creating a unified leadership team that results.

Planning and Organizing: Establishes a systematic course of action for self or others to ensure accomplishment of a specific objective. Sets priorities, goals and timetables to achieve maximum productivity. Self-starter with excellent organization, administrative, interpersonal skills and project management

Organizational Understanding: Understands the agendas and perspectives of others, recognizing and effectively balancing the interests and needs of one's own group with those of the broader organization. Ability to interact cross-functionally with a wide variety of IT and business stakeholders

Technical Expertise: Applies and improves extensive or in-depth specialized knowledge, skills and judgment to accomplish a result or to serve one's "customers" effectively. (Customers can be co-workers, peers or management as well as external consumers of a service.)

Attention to Detail: Thoroughness in accomplishing a task through concern for all the areas involved, no matter how small. Monitors and checks work or information and plans and organizes time and resources efficiently

Communication: Creates an atmosphere in which timely and high quality information flows smoothly both up and down the organization, inside the organization; encourages open expression of ideas and opinions. Excellent communication, presentation and relationship skills, especially the ability to articulate advanced technical topics and build consensus among business and technical constituents

General Education & Experience

• Bachelor's degree in Business Analytics, Information Systems, Computer Science, Data Science or a related field preferred, or equivalent combination of education, training and experience

• 3+ years designing and developing BI reports and data models in Power BI or equivalent BI tools

• 5+ years of relevant experience

• Strong knowledge and experience of data, BI/analytics, reporting platforms and data visualization techniques and tools.

• Experience in Manufacturing or Distribution Industry with knowledge of key KPIs & business processes

• Minimum of 2 years of experience working in a medium to large organization

• Able to work flexible hours as required by business priorities

• Limited travel may be required

Preferred Qualifications

• Experience with Databricks or similar cloud data platforms

• Experience with data modeling and BI architecture design within Power BI (star schema design, DAX, Power Query)

• Experience with modern data/BI architectures

Equal Opportunity Employer, including disability and protected veteran status. If you are an individual with a disability and require an accommodation to complete the application process, please contact [email protected] to request reasonable accommodation. Only requests for accommodation in the application process will be returned from this email address. This employer uses E-Verify. Please click here for additional information. (For Illinois E-Verify information click here, aquí). Sun-Source | Privacy Policy

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.