Business Intelligence, Business Systems Analyst

This is a fully remote position, open to applicants in Pennsylvania.

📋 Description

• Design, sustain, and enhance Power BI datasets, semantic models, dashboards, reports, and drill-through views.

• Convert leadership and operational needs into practical reporting solutions.

• Assist with pipeline, portfolio, departmental operations, capacity, financial, project, and integrated business reviews.

• Establish repeatable reporting procedures that lessen reliance on manually maintained spreadsheets and trackers.

• Document definitions of reports, calculations, refresh schedules, dependencies, target audiences, and user instructions.

• Create and manage data models that link financial, project, and operational data sources, primarily eLIMS and CRM.

• Define and document relationships, transformation logic, calculated measures, inclusion criteria, and reusable analytical frameworks.

• Collaborate with IT, database, and system resources regarding source data, access requirements, refresh processes, and integration limitations.

• Test and validate data pipelines and reporting outputs after system or model modifications.

• Manage CRM users, permissions, fields, views, workflows, and configurations within established governance frameworks.

• Assist with CRM account hierarchy, leads, opportunities, ownership, classification, and project-linkage requirements.

• Oversee testing, release readiness, issue tracking, and user acceptance for approved enhancements.

• Maintain system documentation, training materials, configuration records, and change logs.

• Facilitate alignment among CRM, eLIMS, reporting, SharePoint, and other business tools.

• Monitor data completeness, accuracy, consistency, timeliness, duplication, and adherence to MDS standards.

• Develop ongoing data-quality checks, exception reports, reconciliation processes, and remediation tracking.

• Investigate discrepancies between reports and source systems, documenting root causes and corrective actions.

• Collaborate with Sales, Operations, Project Management, Finance, and technical teams to rectify data issues and enhance adoption.

• Provide support and training for reports, CRM workflows, dashboards, and associated systems.

• Collect user feedback and transform recurring issues into improvement requirements.

• Identify opportunities to automate manual tasks and enhance business visibility or control.

• Mentor and guide data analytics interns or temporary resources on assigned tasks.

⛳️ Requirements

• Bachelor’s degree in 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 similar role.

• Practical experience in developing Power BI reports and data models.

• Advanced proficiency in Excel.

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

• Preferred experience in integrating data from multiple enterprise systems.

• Preferred experience in medical device, life sciences, laboratory services, healthcare, or another regulated environment.

• Preferred experience with user acceptance testing, release management, workflow configuration, or access administration.

• Preferred experience mentoring interns or junior analysts.

• Preferred experience utilizing AI to support data model and report development.

🏝️ Benefits

• Excellent full-time benefits including comprehensive medical coverage, dental, and vision options.

• Life and disability insurance.

• 401(k) with company match.

• Paid vacation and holidays.

• Remote work option.