Senior BI & Analytics Engineer (Power BI + Databricks)

SunSource Company; Addison (IL); On-site; USD 90,000 - 130,000; Full time

Job summary

SunSource is seeking a Business Intelligence Developer to design, build and maintain enterprise Power BI reports, dashboards, and data models in support of growth across Sales, Operations and Shared Services.

You will work with Data Engineers to leverage Databricks data, create scalable semantic models, and deliver actionable analytics. The role emphasizes storytelling through visuals and rigorous data quality, with opportunities to shape BI architecture and governance.

Qualifications

• 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

Responsibilities

• 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

Skills

Interpersonal skills

Communication

Problem solving

Leadership

Prioritization

Education

Bachelor’s degree in Business Analytics/Information Systems/CS/Data Science or related field

Tools

Power BI

Databricks

DAX

Power Query

Job description

SunSource is seeking a Business Intelligence Developer to design, build and maintain enterprise Power BI reports, dashboards, and data models in support of growth across Sales, Operations and Shared Services.

You will work with Data Engineers to leverage Databricks data, create scalable semantic models, and deliver actionable analytics. The role emphasizes storytelling through visuals and rigorous data quality, with opportunities to shape BI architecture and governance.