IT Business Systems Analyst II
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 at a biosciences organization. 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 software capabilities that enhance biomedical research workflows and data integrity and support Clinical Research Services. The position gathers and analyzes data, documents business processes and requirements, investigates application issues, and prepares reports describing findings, probable causes, and potential solutions. In an Agile development environment, the analyst facilitates cross-functional collaboration, translates scientific and operational requirements into user stories, and aligns IT systems with research objectives. The role also leads initiatives to automate and streamline data collection, reporting, and analysis using cloud and integration tools. The analyst applies expertise in SQL Server, Microsoft Dynamics 365, Power Automate, and Azure to develop and optimize systems supporting Clinical Research Services. The position participates in Agile ceremonies, evaluates and recommends commercial software, leads small- to medium-sized product research efforts, documents findings, and communicates technical concepts to non-technical stakeholders.
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, or cloud-based integrations as described in the posting.
- Alternatively, a bachelor’s degree in Information Systems or a directly related field and at least 3 years 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, or cloud-based integrations as described in the posting.
- 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.
- 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 supporting enterprise data warehouse ingestion.
- 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, decomposing backlogs, planning sprints, and coordinating delivery through Azure DevOps and Jira across cross-functional bioscience teams.
- Experience with SQL Server, Microsoft Dynamics 365, Power Automate, and Azure.
Responsibilities
- Plan, design, and launch business, financial, and operations systems supporting organizational functions and business 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 for biomedical research workflows, data integrity, and Clinical Research Services.
- Gather and analyze data and document business processes and requirements.
- Investigate application and system issues; compile reports with findings, probable or root causes, and possible 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.
- Optimize SQL Server performance by tuning queries, developing stored procedures, and managing large datasets.
- Build custom Microsoft Dynamics 365 Finance & Operations solutions, 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 dashboards in Power BI and Tableau.
- Participate in Agile ceremonies, including sprint planning, backlog grooming, and retrospectives.
- Lead Agile product ownership activities, including decomposing backlogs, planning sprints, and coordinating delivery through Azure DevOps and Jira.
- Evaluate and recommend commercially available software solutions; lead and document small- to medium-sized product research efforts.
- Communicate complex technical concepts to non-technical stakeholders and ensure transparency across teams.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
