Business Operations Specialist

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

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.

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

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.

• 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.

• 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.

• 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.