IT Business Systems Analyst II

EMPLOYER: 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 and China. 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 visit www.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.

About Us

Bar Harbor:

The Jackson Laboratory's 43-acre scenic Bar Harbor campus is nestled between the Gulf of Maine and the mountains of Acadia National Park. Some of the best hiking and biking in the world (over 50 square miles of mountains, lakes, views, and dramatic coastline) is accessible from our campus. We are one mile from downtown Bar Harbor, which offers a vibrant downtown district with a plethora of restaurants, shops, museums, and galleries.

Ellsworth:

The Charles E. Hewett Center in Ellsworth, Maine, is a state-of-the-art facility that serves researchers world wide. The facility represents the culmination of nine decades of unmatched experience and leadership in breeding and caring for laboratory mice.

Ellsworth, Maine, is one of Maine’s fastest growing cities. With a growth rate of nearly 20%, Ellsworth is a bustling year-round community and acts as a hub for surrounding towns. It is located nearby Acadia National Park and hosts numerous special events, concerts and festivals each year. Residents have access to fabulous shopping, recreation, museums, galleries, and dining at a variety of independent restaurants.

Farmington:

JAX Genomic Medicine is transforming medicine by improving patient care, lowering costs, and increasing life span and health span. JAX Genomic Medicine’s research focuses on the complex genetic causes of disease and on the development of genomic solutions tailored to each person's unique genetic makeup.

JAX Genomic Medicine sits on a 17-acre site on the campus of the University of Connecticut Health Center. The 183,500-square-foot facility opened in the fall of 2014. Now, it houses over 300 biomedical researchers, technicians, and support staff in state-of-the-art computing facilities and laboratories.

In Connecticut, JAX resides in the scenic town of Farmington, in the state’s capitol region. The Hartford region, which offers some of the best public schools in the country, is made up of both bigger cities and smaller, charming historic New England towns. JAX Genomic Medicine is also geographically located within 2 hours of Boston and New York and is close to multiple transportation systems, including bus lines, highways, railroads and international airports.

Sacramento:

The JAX® Mice, Clinical and Research Services facility is located in Sacramento, the state capital of California. Sacramento is less than a two-hour drive from San Francisco, Napa Valley, and scenic Lake Tahoe, and a short flight to both Los Angeles and Orange County. Sacramento is the birthplace of the nation’s Farm to Fork movement, and offers excellent restaurants, gastro-pubs, wineries, theaters, and museums. Outdoor activities are plentiful: Boating, white water rafting, and riding the scenic bicycle trails are popular. Housing and other costs of living are more affordable in Sacramento and its surrounding suburbs than in most other neighboring areas in the North Bay, making Sacramento one of the hottest housing markets in the country year after year.

Augusta:

JAX’s Maine Cancer Genomics Initiative (MCGI) is located in Augusta, Maine, in the Harold Alfond Center for Cancer Care (HACCC), at Maine General Hospital. It began operations in 2016 with three overarching goals: to provide cancer genomic testing for Maine cancer patients; to develop and deliver physician education about clinical genomic cancer diagnostics; and to build a network in Maine of oncology practices conducting studies in genomic medicine.