Business Intelligence and Business Systems Analyst

Position Summary

The Business Intelligence and Business Systems Analyst develops and supports the data, reporting, and business-system capabilities used to manage Medical Device Services (MDS). The role combines business intelligence, data modeling, data-quality management, and day-to-day business administration of CRM and related operational systems.

This position builds Power BI models and reports that integrate CRM and eLIMS data to present financial, project, and operational information. It also supports CRM configuration, testing, user administration, documentation, and data integrity under the governance and priorities established by the Business Operations leadership.

The role is designed to offload technical reporting and systems work from Business Operations leadership while preserving clear separation between business governance and day-to-day administration.

Key Responsibilities

Business Intelligence and Reporting:

• Develop, maintain, and enhance Power BI datasets, semantic models, dashboards, reports, and drill-through views.
• Translate leadership and operational requirements into clear, actionable reporting solutions.
• Support pipeline, portfolio, departmental operations, capacity, financial, project, and integrated business reviews.
• Create repeatable reporting processes that reduce dependence on manually maintained spreadsheets and trackers.
• Document report definitions, calculations, refresh schedules, dependencies, intended audience, and user guidance.

Data Modeling and Integration

• Develop and maintain data models connecting financial, project, and other operational data sources, primarily eLIMS and CRM
• Define and document relationships, transformation logic, calculated measures, inclusion criteria, and reusable analytical structures.
• Work with IT, database, and system resources to understand source data, access requirements, refresh processes, and integration constraints.
• Test and validate data pipelines and reporting outputs following system or model changes.

CRM and Business Systems Administration

• Perform day-to-day CRM administration within established MDS governance, including user setup and permissions, fields, views, workflows, and configuration support.
• Support account hierarchy, leads, opportunities, ownership, classification, and project-linkage requirements in the CRM.
• Coordinate testing, release readiness, issue tracking, and user acceptance for approved enhancements.
• Maintain system documentation, training materials, configuration records, and change logs.
• Support appropriate alignment among CRM, eLIMS, reporting, SharePoint, and other business tools.

Data Integrity and Governance Support

• Monitor data completeness, accuracy, consistency, timeliness, duplication, and conformance with MDS standards.
• Develop recurring data-quality checks, exception reports, reconciliation processes, and remediation tracking.
• Investigate discrepancies between reports and source systems and document root causes and corrective actions.
• Support master-data and reporting-definition governance established by the Manager, Business Operations Strategy.
• Partner with Sales, Operations, Project Management, Finance, and technical teams to correct data issues and improve adoption.

User Support and Continuous Improvement

• Provide practical support and training for reports, CRM workflows, dashboards, and related systems.
• Gather user feedback and translate recurring problems into improvement requirements.
• Identify opportunities to automate manual work and improve business visibility or control.
• Support and guide data analytics interns or temporary resources on defined assignments.

Qualifications

Qualifications Required

• Master’s degree in science (M.Sc, M. Pharma), Business Analytics, Information Systems, Data Analytics, Computer Science, Industrial Engineering, or a related field.
• Three or more years of experience in business intelligence, data analytics, business systems, CRM administration, or a comparable role.
• Hands-on experience developing Power BI reports and data models.
• Advanced proficiency with Excel and working knowledge of relational data concepts.
• Experience administering or supporting CRM, LIMS, ERP, or related enterprise systems.
• Strong analytical, troubleshooting, documentation, and stakeholder-communication skills preferred
• Experience with Microsoft Dynamics 365, Salesforce, LIMS, SQL Server, Power Query, DAX, SharePoint, Dataverse, and the broader Power Platform.
• Experience integrating data from multiple enterprise systems.
• Experience in medical device, life sciences, laboratory services, healthcare, or another regulated environment.
• Experience with user acceptance testing, release management, workflow configuration, or access administration.
• Experience guiding interns or junior analysts.
• Experience using AI to support data model and report development

Additional Information

• Analytical and technically curious with strong attention to detail.
• Able to understand both business processes and underlying data structures.
• Able to create and comprehend data and reporting requirements.
• Disciplined about documentation, testing, change control, and data integrity.
• Service-oriented and able to explain technical concepts clearly to business users.
• Proactive in identifying risks, inconsistencies, and opportunities for automation.
• Comfortable balancing recurring administration with longer-term development work.