SunSource Logo

SunSource

Senior BI Developer

Posted 15 Days Ago
In-Office
60101, Addison, IL, USA
Senior level
In-Office
60101, Addison, IL, USA
Senior level
Develops and maintains enterprise Power BI reports, dashboards, semantic models, and datasets using Databricks data. Partners with business stakeholders and data engineers to gather requirements, design scalable data models, create DAX measures, test reporting solutions, resolve data discrepancies, and deliver actionable insights. The role also documents BI solutions, supports data architecture improvements, and leads cross-functional teams through complex data challenges.
The summary above was generated by AI
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. www.sun-source.com

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

HQ

SunSource Addison, Illinois, USA Office

Addison, IL, United States

SunSource Addison, Illinois, USA Office

Addison, Illnois, United States, 60101

SunSource Chicago, Illinois, USA Office

Chicago, United States

Similar Jobs

One Month Ago
Easy Apply
Hybrid
Chicago, IL, USA
Easy Apply
72K-115K Annually
Senior level
72K-115K Annually
Senior level
Fintech • Information Technology • Machine Learning • Software • Analytics • Financial Services
Designs and maintains enterprise BI reporting, analytics applications, data marts, warehouses, and ETL/ELT pipelines. Partners with cross-functional stakeholders to gather requirements and deliver scalable solutions using SQL, Python, Snowflake, Airflow, and BI visualization tools. Leads initiatives through architecture, implementation, delivery, and support, while advancing AI adoption across the BI and data development workflow.
Top Skills: Apache AirflowAstronomer AirflowAws BedrockAws RedshiftBigQueryClaudeDatabricksGeminiLookerMicrostrategyPower BIPythonSnowflakeSQLTableau
14 Days Ago
In-Office
Chicago, IL, USA
38-58 Hourly
Senior level
38-58 Hourly
Senior level
Legal Tech • Other • Professional Services • Real Estate • Business Intelligence • Consulting • Financial Services
Develops enterprise dashboards, reports, data models, and analytics solutions using Power BI or Tableau. Responsibilities include advanced SQL development, ETL/ELT workflows, data integration, executive reporting, data quality controls, issue resolution, testing, deployment, documentation, and stakeholder collaboration. The role supports operational, risk, regulatory, and financial services reporting initiatives.
Top Skills: AzureData WarehousingDatabricksDimensional Data ModelingEtl/EltMicrosoft FabricPower BISnowflakeSQLSynapse AnalyticsTableau
One Month Ago
Hybrid
Chicago, IL, USA
98K-145K Annually
Senior level
98K-145K Annually
Senior level
Professional Services
Lead recurring operational reporting and data processes for finance and HR, owning month-end and year-end close activities. Read, analyze, and correct complex SQL (views, stored procedures), maintain BI reports (Power BI, Cognos, Crystal), validate data, trace root causes to source systems, and produce confidential leadership deliverables. Automate recurring work, document processes, and support report modernization and ad hoc analysis.
Top Skills: Azure SqlCognosConfluenceCrystal ReportsDatabricksElite 3EPower BISQLSsisTableauWorkday

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account