Business Intelligence & Data Solutions Specialist

Sonwil Logistics; Town of West Seneca, Northern (NY, KY); Hybrid; USD 85,000 - 105,000; Full time

Job summary

Sonwil Logistics is seeking a Business Intelligence & Data Solutions Specialist in West Seneca, NY. The role develops and maintains reporting and analytics using SQL Server, Power BI, SSRS, and Excel to transform operational data into trusted datasets and actionable insights.

You will collaborate with leaders to translate requirements into robust data models, measures, and dashboards, promoting self-service analytics while exploring AI-enabled technologies.

Qualifications

• Degree or technical training in information systems, data analytics, CS or related field; equivalent experience considered.
• Strong SQL skills and experience with Microsoft SQL Server.
• Experience developing reports, dashboards, data models, and analytics using Power BI.
• Experience with SSRS/SSAS, OLAP or related Microsoft reporting tech is beneficial.
• Strong Excel skills for business analysis and reporting.
• Experience transforming OLTP data into structured reporting datasets.
• Understanding of relational DB design, data warehousing, BI concepts.
• Experience creating DAX measures, queries, and Power BI calculations.
• Ability to translate business requirements into analytical solutions.
• Attention to data quality, testing, governance, and documentation.

Responsibilities

• Develop, maintain, and improve reports, dashboards, scorecards, and analytical tools using Power BI, SSRS/SSAS, Excel, and related Microsoft tech.
• Transform transactional data into structured datasets and data models for reporting and analytics.
• Design and maintain reporting tables, views, transformations, and calculations for trusted information.
• Develop reporting solutions with organization-wide performance measurement and drill-down to operations, customers, locations, or departments.
• Collaborate with stakeholders to translate requirements into data models, measures, reports, and dashboards.
• Develop reporting to identify trends, exceptions, opportunities, and actionable items.
• Administer Power BI resources: workspaces, apps, refreshes, distribution, usage, and security.
• Maintain accuracy and performance of reporting solutions and troubleshoot issues.
• Maintain consistent definitions for measures, dimensions, and KPIs per governance.
• Promote self-service analytics with documented, trusted datasets accessible via Excel, Power BI, and other tools.
• Coach users on interpreting data and incorporating it into day-to-day management.
• Develop testing/validation to ensure accuracy and reliability of outputs.
• Identify and resolve data quality issues with developers and users.
• Maintain documentation for datasets, rules, definitions, reports, dashboards.
• Evaluate AI-enabled analytics and emerging technologies while ensuring data quality and governance.
• Continuously identify opportunities to improve reporting capabilities and drive improvements.

Skills

SQL

Power BI

SSRS/SSAS

Excel

Data modeling

OLAP

Data governance

DAX

Stakeholder coaching

Education

Degree in Information Systems or related

Tools

Power BI Service

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Business Intelligence & Data Solutions Specialist

Regular Full Time Technical West Seneca, NY, US 1 Attachments

7 days ago Requisition ID: 1276

Salary Range: $85,000.00 To $105,000.00 Annually

Job purpose

The Business Intelligence & Data Solutions Specialist is responsible for improving how the company organizes, presents, and uses data to manage operations, measure performance, and support decision-making.

This hands-on individual contributor role will develop and maintain reporting and analytical solutions using the company's Microsoft data environment, including SQL Server, Power BI, Reporting Services, and Excel. A key focus will be transforming transactional data from operational systems into well-structured, reliable, and reusable reporting datasets that provide users with consistent definitions and trusted information.

The position will work directly with users and leaders across the organization to understand business processes, translate requirements into effective analytical solutions, and coach users on how to use data to manage operations and people. The role will combine strong technical and analytical skills with business acumen and an ability to turn data into meaningful insights and actionable information.

The position will also explore emerging AI and data-access technologies that can make trusted company information easier for employees to access, understand, and use.

Duties and responsibilities

• Develop, maintain, and improve reports, dashboards, scorecards, and analytical tools using Power BI, SQL Server Reporting Services (SSRS), Excel, and related Microsoft technologies.
• Transform transactional data from company operational systems into structured datasets and data models designed for reporting, analytics, and reuse across the organization.
• Design and maintain reporting tables, views, transformations, measures, calculations, and other data structures that provide consistent definitions and trusted business information.
• Develop reporting solutions that support both organization-wide performance measurement and appropriate drill-down to individual operations, customers, locations, departments, or other business entities.
• Work directly with stakeholders to understand business processes and translate operational and management requirements into effective data models, measures, reports, and dashboards.
• Develop reporting that helps users identify trends, exceptions, opportunities, and areas requiring action rather than simply presenting data.
• Administer Power BI reporting resources, including workspaces, applications, report distribution, data refreshes, usage, and appropriate security access.
• Maintain the functionality, accuracy, relevance, and performance of existing reporting solutions and troubleshoot issues as they arise.
• Establish and maintain consistent definitions for key business measures, dimensions, calculations, and performance indicators in alignment with company data governance practices.
• Promote self-service analytics by providing users with understandable, documented, and trusted datasets that can be effectively used through Excel, Power BI, Reporting Services, and other approved tools.
• Coach users and leaders on interpreting data, selecting appropriate measures, developing effective reports, and incorporating data into day-to-day management practices.
• Develop appropriate testing and validation processes to ensure the accuracy and reliability of reports, datasets, measures, and analytical outputs.
• Identify and resolve data quality and consistency issues in collaboration with application developers, business users, and other technical resources.
• Develop and maintain documentation for reporting datasets, business rules, data definitions, reports, dashboards, and related analytical resources.
• Evaluate AI-enabled analytics, natural-language data access, and other emerging technologies that may help employees more effectively access and use company information while maintaining appropriate data quality, security, and governance.
• Continually identify opportunities to improve reporting capabilities and use data, analytics, and emerging technologies to drive operational and company-wide improvement.

Qualifications

• Degree or technical training in Information Systems, Data Analytics, Computer Science, Business Analytics, or a related discipline preferred; equivalent relevant experience will be considered.
• Strong SQL skills and experience working with Microsoft SQL Server.
• Experience developing reports, dashboards, data models, and analytical solutions using Power BI.
• Experience with SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), OLAP, or related Microsoft reporting technologies is beneficial.
• Strong working knowledge of Excel and its use as a business analysis and reporting tool.
• Experience transforming transactional/OLTP data into structured datasets designed for reporting, analytics, and OLAP workloads.
• Understanding of relational database design, data modeling, data warehousing, and business intelligence concepts.
• Experience developing DAX measures, calculations, queries, and functions within Power BI.
• Experience administering Power BI workspaces, applications, refreshes, distribution, usage, and security is beneficial.
• Ability to understand business processes and translate business requirements into meaningful analytical solutions.
• Strong analytical and problem-solving skills with the ability to convert data into meaningful insights and identify opportunities for improvement.
• Strong communication and coaching skills with the ability to work effectively with users and leaders at all levels of the organization.
• Ability to manage multiple priorities, work independently with limited supervision and keep stakeholders informed of progress.
• Experience with logistics, warehousing, transportation, distribution, or other operational environments is beneficial.
• Familiarity with AI-enabled analytics, natural-language data access, or related emerging technologies is beneficial.
• Strong attention to data quality, testing, validation, security, governance, and documentation.

Physical requirements

• Ability to work for extended periods at a computer workstation using database, reporting, and analytical software.
• Ability to communicate and collaborate effectively with employees across technical, operational, and management functions.
• Ability to occasionally access warehouse and operational environments to observe business processes and better understand reporting and analytical requirements.
• Ability to safely work in active warehouse and industrial environments while following applicable safety requirements.Ability to travel occasionally to company facilities or project locations as required.

Direct reports

No direct reports are expected.

Job purpose

The Business Intelligence & Data Solutions Specialist is responsible for improving how the company organizes, presents, and uses data to manage operations, measure performance, and support decision-making.

This hands-on individual contributor role will develop and maintain reporting and analytical solutions using the company's Microsoft data environment, including SQL Server, Power BI, Reporting Services, and Excel. A key focus will be transforming transactional data from operational systems into well-structured, reliable, and reusable reporting datasets that provide users with consistent definitions and trusted information.

The position will work directly with users and leaders across the organization to understand business processes, translate requirements into effective analytical solutions, and coach users on how to use data to manage operations and people. The role will combine strong technical and analytical skills with business acumen and an ability to turn data into meaningful insights and actionable information.

The position will also explore emerging AI and data-access technologies that can make trusted company information easier for employees to access, understand, and use.

Duties and responsibilities

• Develop, maintain, and improve reports, dashboards, scorecards, and analytical tools using Power BI, SQL Server Reporting Services (SSRS), Excel, and related Microsoft technologies.
• Transform transactional data from company operational systems into structured datasets and data models designed for reporting, analytics, and reuse across the organization.
• Design and maintain reporting tables, views, transformations, measures, calculations, and other data structures that provide consistent definitions and trusted business information.
• Develop reporting solutions that support both organization-wide performance measurement and appropriate drill-down to individual operations, customers, locations, departments, or other business entities.
• Work directly with stakeholders to understand business processes and translate operational and management requirements into effective data models, measures, reports, and dashboards.
• Develop reporting that helps users identify trends, exceptions, opportunities, and areas requiring action rather than simply presenting data.
• Administer Power BI reporting resources, including workspaces, applications, report distribution, data refreshes, usage, and appropriate security access.
• Maintain the functionality, accuracy, relevance, and performance of existing reporting solutions and troubleshoot issues as they arise.
• Establish and maintain consistent definitions for key business measures, dimensions, calculations, and performance indicators in alignment with company data governance practices.
• Promote self-service analytics by providing users with understandable, documented, and trusted datasets that can be effectively used through Excel, Power BI, Reporting Services, and other approved tools.
• Coach users and leaders on interpreting data, selecting appropriate measures, developing effective reports, and incorporating data into day-to-day management practices.
• Develop appropriate testing and validation processes to ensure the accuracy and reliability of reports, datasets, measures, and analytical outputs.
• Identify and resolve data quality and consistency issues in collaboration with application developers, business users, and other technical resources.
• Develop and maintain documentation for reporting datasets, business rules, data definitions, reports, dashboards, and related analytical resources.
• Evaluate AI-enabled analytics, natural-language data access, and other emerging technologies that may help employees more effectively access and use company information while maintaining appropriate data quality, security, and governance.
• Continually identify opportunities to improve reporting capabilities and use data, analytics, and emerging technologies to drive operational and company-wide improvement.

Qualifications

• Degree or technical training in Information Systems, Data Analytics, Computer Science, Business Analytics, or a related discipline preferred; equivalent relevant experience will be considered.
• Strong SQL skills and experience working with Microsoft SQL Server.
• Experience developing reports, dashboards, data models, and analytical solutions using Power BI.
• Experience with SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), OLAP, or related Microsoft reporting technologies is beneficial.
• Strong working knowledge of Excel and its use as a business analysis and reporting tool.
• Experience transforming transactional/OLTP data into structured datasets designed for reporting, analytics, and OLAP workloads.
• Understanding of relational database design, data modeling, data warehousing, and business intelligence concepts.
• Experience developing DAX measures, calculations, queries, and functions within Power BI.
• Experience administering Power BI workspaces, applications, refreshes, distribution, usage, and security is beneficial.
• Ability to understand business processes and translate business requirements into meaningful analytical solutions.
• Strong analytical and problem-solving skills with the ability to convert data into meaningful insights and identify opportunities for improvement.
• Strong communication and coaching skills with the ability to work effectively with users and leaders at all levels of the organization.
• Ability to manage multiple priorities, work independently with limited supervision and keep stakeholders informed of progress.
• Experience with logistics, warehousing, transportation, distribution, or other operational environments is beneficial.
• Familiarity with AI-enabled analytics, natural-language data access, or related emerging technologies is beneficial.
• Strong attention to data quality, testing, validation, security, governance, and documentation.

Physical requirements

• Ability to work for extended periods at a computer workstation using database, reporting, and analytical software.
• Ability to communicate and collaborate effectively with employees across technical, operational, and management functions.
• Ability to occasionally access warehouse and operational environments to observe business processes and better understand reporting and analytical requirements.
• Ability to safely work in active warehouse and industrial environments while following applicable safety requirements.
• Ability to travel occasionally to company facilities or project locations as required.

Direct reports

No direct reports are expected.

Monday-Friday, 8:00am-4:30pm

Attachments (1)

Job Description-SDC-Business Intelligence Data Solutions Specialist.doc