IT Business Systems Analyst II

The Jackson Laboratory; United States; Remote; USD 98,000 - 109,000; Full time

Job summary

The Jackson Laboratory is seeking an IT Business Systems Analyst II to plan, design, and launch scalable systems supporting core organizational functions in biomedical research. You will collaborate with scientists, software engineers, and product managers to deliver end-to-end capabilities that enhance data integrity and research workflows.

Applicants should have a master’s or bachelor’s in information systems with 1–3 years of experience, strong SQL Server, D365, and BI skills, and familiarity

Qualifications

• Masters or Bachelors in IS with relevant experience.
• Experience delivering scalable business system solutions.
• Strong SQL Server, ETL, and BI dashboard skills.

Responsibilities

• Plan, design and launch business, financial, and operations systems.
• Collaborate with product owners, engineers, and managers to deliver end-to-end software.
• Analyze data, document processes, and provide reports with root-cause analysis.

Skills

SQL Server

Power BI

Azure

Agile

Communication

Education

Master's degree in Information Systems

Bachelor's degree in Information Systems

Tools

SQL Server

Microsoft Dynamics 365

Power BI

Tableau

Azure

Power Automate

Azure DevOps

Jira

Job description

EMPLOYER: The Jackson Laboratory

The Jackson Laboratory

POSITION: IT Business Systems Analyst II

DUTIES:

The IT Business Systems Analyst II role is to plan, design and launch efficient business, financial, and operations systems in support of core organizational functions and business processes for bio-sciences organization. The IT Business Systems Analyst II plays a critical role in supporting scientific research operations by analyzing complex data processing challenges and designing innovative, scalable solutions. This position collaborates closely with scientific product owners, software engineers, and product managers to deliver end-to-end software capabilities that enhance biomedical research workflows and data integrity and supports Clinical Research Services. This includes gathering and analyzing data and documenting business processes and requirements. The position is responsible for investigating application issues and generating and compiling reports based on the findings, complete with probable causes and possible solutions to systems issues. Working within an Agile development environment, the IT Business Systems Analyst II facilitates cross-functional collaboration, translates scientific and operational requirements into actionable user stories, and ensures alignment between IT systems and research objectives. Leading initiatives to automate and streamline data collection, reporting, and analysis using modern cloud and integration tools. Investigating application and system issues, compiling detailed reports with root cause analysis, and proposing effective solutions. The position applies deep technical expertise in SQL Server, Microsoft Dynamics 365, Power Automate, and Azure to develop and optimize systems that support Clinical Research Services. Participates in Agile ceremonies such as sprint planning, backlog grooming, and retrospectives. Evaluates and recommends commercially available software solutions, leads small to medium product research efforts, and documents findings. Communicates complex technical concepts to non-technical stakeholders and ensures transparency across teams.

RATE OF PAY:

Between $98,446 and $108,857 per year.

REQUIREMENTS:

Master’s degree in Information Systems or directly related field and 1 year of business systems analysis experience delivering scalable solutions to complex application and system administration challenges supporting scientific research operations to deliver end-to-end software capabilities that enhance biomedical research workflows and data integrity, including data lifecycle optimization, ERP decommissioning, and cloud-based integrations or, alternatively, a Bachelor’s degree in Information Systems or directly related field and 3 years of business systems analysis experience delivering scalable solutions to complex application and system administration challenges supporting scientific research operations to deliver end-to-end software capabilities that enhance biomedical research workflows and data integrity, including data lifecycle optimization, ERP decommissioning, and cloud-based integrations. All qualified applicants must have performed the following for 1 year: 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 building custom solutions in Microsoft Dynamics 365 Finance & Operations using X++ and Visual Studio, including entity modeling, staging table setup, and BYOD integration to enhance enterprise reporting capabilities; designing and implementing scalable ETL pipelines that integrate data from SQL Server, Excel, flat files, and Azure Blob Storage, maintaining data integrity across hybrid environments and enabling seamless ingestion into the enterprise data warehouse (EDW); developing interactive dashboards in Power BI and Tableau using advanced DAX, row-level security, bookmarks, and custom visuals to drive strategic decisions across finance, supply chain, and research functions; and leading Agile product ownership by decomposing backlogs, planning sprints, and coordinating delivery through Azure DevOps and Jira, managing over across cross-functional bio-science teams.

ADDRESS OF EMPLOYMENT:

This position is based at The Jackson Laboratory, 600 Main Street, Bar Harbor, ME 04609. Telecommuting permitted as fully remote role.

About JAX:

The Jackson Laboratory is an independent, nonprofit biomedical research institution with a National Cancer Institute-designated Cancer Center and nearly 3,000 employees in locations across the United States (Maine, Connecticut, California, New York, Florida),Japan andChina. Its mission is to discover precise genomic solutions for disease and empower the global biomedical community in the shared quest to improve human health. Founded in 1929, JAX applies over nine decades of expertise in genetics to increase understanding of human disease, advancing treatments and cures for cancer, neurological and immune disorders, diabetes, aging and heart disease. It models and interprets genomic complexity, integrates basic research with clinical application, educates current and future scientists, and provides critical data, tools and services to the global biomedical community. For more information, please visitwww.jax.org.

EEO Statement:

The Jackson Laboratory provides equal employment opportunities to all employees and applicants for employment in all job classifications without regard to race, color, religion, age, mental disability, physical disability, medical condition, gender, sexual orientation, genetic information, ancestry, marital status, national origin, veteran status, and other classifications protected by applicable state and local non-discrimination laws.