IT Business Systems Analyst II

The Jackson Laboratory•Bar Harbor, ME

1d•$98,446 - $108,857•Remote

About The Position

The IT Business Systems Analyst II plans, designs, and launches efficient business, financial, and operations systems supporting core organizational functions and business processes. The role supports scientific research operations by analyzing complex data-processing challenges and designing scalable solutions. Working closely with scientific product owners, software engineers, and product managers, the analyst delivers end-to-end software capabilities that enhance biomedical research workflows and data integrity, including support for Clinical Research Services. The position gathers and analyzes data, documents business processes and requirements, investigates application and system issues, and prepares findings that include probable causes and potential solutions. In an Agile environment, the analyst facilitates cross-functional collaboration, translates scientific and operational requirements into actionable user stories, and ensures that IT systems align with research objectives. The role leads initiatives to automate and streamline data collection, reporting, and analysis using cloud and integration tools, and applies technical expertise in SQL Server, Microsoft Dynamics 365, Power Automate, and Azure to develop and optimize systems for Clinical Research Services. The analyst participates in Agile ceremonies, evaluates commercially available software, leads small-to-medium product research efforts, documents findings, and communicates complex technical concepts to non-technical stakeholders. The position is based at The Jackson Laboratory in Bar Harbor, Maine, and is permitted to be fully remote. The listed annual pay range is $98,446 to $108,857.

Requirements

Master’s degree in Information Systems or a directly related field and at least 1 year of business systems analysis experience delivering scalable solutions to complex application and system administration challenges supporting scientific research operations; experience must include data lifecycle optimization, ERP decommissioning, and cloud-based integrations.
Alternatively, a Bachelor’s degree in Information Systems or a directly related field and at least 3 years of the specified business systems analysis experience.
At least 1 year of experience optimizing SQL Server performance by tuning queries, developing stored procedures, and managing multi-million-record datasets using SSMS and PL/SQL to accelerate report generation and minimize latency.
At least 1 year of experience building custom solutions in Microsoft Dynamics 365 Finance & Operations using X++ and Visual Studio, including entity modeling, staging table setup, and BYOD integration.
At least 1 year of experience designing and implementing scalable ETL pipelines integrating SQL Server, Excel, flat files, and Azure Blob Storage, maintaining data integrity across hybrid environments and enabling ingestion into an enterprise data warehouse.
At least 1 year of experience developing interactive Power BI and Tableau dashboards using advanced DAX, row-level security, bookmarks, and custom visuals.
At least 1 year of experience leading Agile product ownership by decomposing backlogs, planning sprints, and coordinating delivery through Azure DevOps and Jira across cross-functional bioscience teams.

Responsibilities

Plan, design, and launch business, financial, and operations systems supporting organizational functions and processes.
Analyze complex data-processing challenges and design scalable solutions for scientific research operations.
Collaborate with scientific product owners, software engineers, and product managers to deliver software capabilities that support biomedical research workflows and data integrity.
Gather and analyze data and document business processes and requirements.
Investigate application and system issues; compile reports documenting findings, probable causes, and potential solutions.
Translate scientific and operational requirements into actionable user stories and align IT systems with research objectives.
Lead initiatives to automate and streamline data collection, reporting, and analysis using cloud and integration tools.
Develop and optimize systems supporting Clinical Research Services using SQL Server, Microsoft Dynamics 365, Power Automate, and Azure.
Participate in Agile ceremonies, including sprint planning, backlog grooming, and retrospectives.
Evaluate commercially available software solutions, lead small-to-medium product research efforts, and document findings.
Communicate complex technical concepts to non-technical stakeholders and maintain transparency across teams.
Optimize SQL Server performance through query tuning, stored procedures, and management of large datasets.
Build custom solutions in Microsoft Dynamics 365 Finance & Operations, including entity modeling, staging table setup, and BYOD integration.
Design and implement ETL pipelines integrating data from SQL Server, Excel, flat files, and Azure Blob Storage while maintaining data integrity and supporting ingestion into the enterprise data warehouse.
Develop interactive Power BI and Tableau dashboards using advanced DAX, row-level security, bookmarks, and custom visuals.
Lead Agile product ownership by decomposing backlogs, planning sprints, and coordinating delivery through Azure DevOps and Jira.