Business Operations Specialist

NCMS – National Center for Manufacturing Sciences; Ann Arbor (MI); Hybrid; USD 65,000 - 90,000; Full time

Job summary

NCMS – National Center for Manufacturing Sciences is seeking a Business Operations Specialist to build and optimize Power BI dashboards, transform data from multiple sources, and deliver clear, actionable insights for stakeholders. The role supports diverse projects, requires collaboration across units, and emphasizes data integrity and exceptional customer service.

The position is hybrid (three days in Ann Arbor office, two days remote) with a strong focus on Excel, Power BI, SharePoint, and

Qualifications

• Must be a US citizen.
• Must be able to obtain government security clearance.
• Must be fully vaccinated against COVID-19 unless legally exempt.
• Hybrid schedule: three days in the office, two days remote.
• Degree or 5 years admin/tech experience.
• Proficient in pivot tables, VLOOKUP, complex formulas, and data analysis tools.
• Experience building interactive dashboards and reports in Power BI, writing DAX for columns/measures, and Power Query for data transformation.

Responsibilities

• Maintain and optimize Power BI dashboards and reports to support decision making.
• Collaborate with business units to collect data and understand processes.
• Run queries in Power BI to fulfill data requests.
• Design, build, and maintain dashboards and reports.
• Extract and clean data from sources (Excel, SharePoint, Google Analytics, SQL).
• Write DAX measures and calculated columns for business logic.
• Monitor data quality and troubleshoot issues in reports/datasets.
• Document data models, workflows, and report logic.
• Assist in ad-hoc analysis and data requests.
• Support project meetings with notes and process documentation.
• Contribute to quarterly and final project reports.

Skills

Power BI

Excel (Advanced)

Data analysis

DAX

SharePoint

Office 365

Communication

Organization

Problem solving

Education

Bachelor's degree in related field

5+ years admin/tech experience

Tools

Power BI

SharePoint

Excel

Job description

This is a hybrid role and requires 3 days in the office in Ann Arbor, Michigan.

Who We Are:

The National Center for Manufacturing Sciences (NCMS) is a cross-industry technology development consortium, dedicated to improving the competitiveness and strength of the U.S. industrial base. As a member-based organization, it leverages its network of industry, government, and academic partners to develop, demonstrate, and transition innovative technologies efficiently, with less risk and lower cost.

NCMS enables world-class member companies to work effectively with other members on new opportunities – bringing together highly capable companies with providers and end-users who need their innovations and technology solutions. NCMS members benefit from an accelerated progression of idea creation through execution.

Supervisory Duties:

This position does not have supervisory responsibilities or direct people management responsibilities.

Job Purpose:

The Business Operations Specialist is responsible for building, maintaining, and optimizing Power BI dashboards and reports that help stakeholders make informed decisions. This role will support cleaning, transforming, and analyzing data from multiple sources to turn complex datasets into clear, actionable insights. The specialist is responsible for supporting diverse projects and other business activities while providing exceptional customer service.

Primary Responsibilities:

• Maintain data integrity and accuracy through validation, including comparison to and review of official NCMS documentation.
• Collaborate with various business units to understand processes and collect data.
• Fulfill data requests from internal customers through the running of queries in Power BI.
• Design, build, and maintain Power BI dashboards and reports.
• Extract and clean data from various sources (e.g. Excel, SharePoint, Google Analytics, SQL databases).
• Write Data Analysis Expressions (DAX) measures and calculate columns to support business logic.
• Monitor data accuracy and troubleshoot issues in reports and datasets.
• Document data models, workflows, and report logic for transparency.
• Assist in ad-hoc analysis and data requests.
• Provide project meeting support as needed via attending meetings, preparation and distribution of project meeting notes. Assist in the documentation and improvement of procedures.
• Assist in preparation and/or review of quarterly and final project reports.
• Maintain project information, collect and maintain data files/folders, develop presentations.

Requirements:

• Must be a citizen of the United States.
• Must have or be eligible to obtain government security clearance.
• Must be fully vaccinated against COVID-19 unless legally exempt.
• Flexibility to work a hybrid schedule; three days in the office & two days home.
• Degree in Business Administration, Science/Technology or related field or a minimum of 5 years’ experience in an administrative role with customer service and/or technology focus.
• Advanced Microsoft Excel skills required including proficiency in pivot tables, VLOOKUP, complex formulas, and data analysis tools.
• Experience in Power BI including building interactive dashboards and reports, writing DAX for calculated columns or measures, and using Power Query for data transformation.
• Ability to develop a comprehensive understanding of the business data, how it relates, and the importance of it to the organization.
• Critical thinking & problem-solving skills are required.
• Microsoft Office 365 experience.
• SharePoint functional knowledge.
• Effective communicator in written and oral formats.
• Demonstrated high level of organization and attention to detail.
• Demonstrated ability to develop and deliver suggestions for process improvements.
• Demonstrated customer service excellence.

Physical Requirements:

• Ability to remain in a stationary position for extended periods while working at a computer.

This position is contingent upon the successful completion of a background screening, which may include checks for criminal history, driving records, financial history, and education verification, as permitted by law.