Get CRM Administration roles in your inbox
We'll email you when new ones are posted
The Business Systems Analyst’s role is to plan, design, and launch efficient finance and enterprise data systems in support of core organizational functions and business processes. This includes gathering and analyzing data, translating financial and operational data requirements into data warehouse solutions, and documenting business processes and requirements. The Business Systems Analyst is also responsible for investigating application issues and generating and compiling reports based on the findings, complete with probable causes and possible solutions to systems issues. This individual will apply proven communication, analytical, and problem-solving skills to help maximize the benefit of IT system investments, with a focus on data integrity, financial reporting accuracy, and data warehouse delivery.
Lead requirements and business process definition sessions with Finance stakeholders (Accounting, FP&A, Treasury, and Reporting); work with business leaders and decision makers to acquire approval for requirements and business process documentation related to financial data flows and reporting needs.
Create system design proposals and systems models, specifications, diagrams, and charts to provide direction to data warehouse developers, BI engineers, and quality assurance staff. This includes data flow diagrams, dimensional models, and ETL/ELT pipeline specifications.
Lead application issue investigations, document probable causes and recommendations for resolution.
Identify and establish scope and parameters of requirements, analysis and design efforts in order to define outcome criteria and measure-taking actions. Oversee small to medium data warehouse and finance systems implementation projects, ensuring alignment between IT data architecture and Finance business objectives.
Conduct research on data integration, BI, and financial systems products to justify recommendations and to support purchasing efforts. Ability to drive software selection projects including data warehouse platforms, ETL tooling, and financial reporting solutions.
Serve as the primary liaison between the Finance department and the IT Data Warehouse team, facilitating clear communication of business requirements, data definitions, and delivery priorities.
Collaborate with data engineers and architects to define data models, dimensional schemas, and data governance standards that support Finance reporting and analytics needs.
Extensive experience with one or more core software applications, including Enterprise Resource Planning (ERP) systems (e.g., SAP, Oracle, NetSuite) and/or Data Warehouse platforms (e.g., Snowflake, Redshift, Azure Synapse, Databricks).
Extensive experience with business and technical requirements elicitation, business process modeling / mapping and data modeling — including dimensional modeling (star/snowflake schemas), data lineage documentation, and data dictionary development in a Finance context.
Competency and practical knowledge of information presentation tools such as spreadsheets, flow charts, office productivity software, etc. Familiarity with BI and reporting tools (e.g., Power BI, Tableau, Looker) and basic SQL proficiency for data validation and analysis.
Experience working in a team-oriented, collaborative environment.
Incumbent must have strong interpersonal, organizational and facilitation skills to work in a high-profile environment requiring discretion, judgment, tact and diplomacy.
Demonstrated success at managing multiple projects with tight deadlines to successful completion.
Demonstrated positive team player.
Highly self-motivated and directed.
Demonstrated project management and leadership skills in overseeing the design, development, and implementation of software and hardware solutions, systems, or products.
Ability to communicate ideas in both technical and user-friendly language in written and oral forms — specifically, the ability to translate complex data warehouse and ETL concepts into actionable business terms for Finance audiences, and vice versa. Excellent listening and interpersonal skills.
5+ years of experience required, with at least 2 years in a data warehouse, business intelligence, or finance systems environment.
Bachelor’s degree or equivalent is required. Degree in Information Systems, Computer Science, Finance, Accounting, or a related field preferred.
Working knowledge of financial concepts including general ledger, chart of accounts, period-close processes, financial consolidation, budgeting/forecasting, and regulatory reporting.
Experience with ETL/ELT tools and data pipeline concepts (e.g., dbt, Informatica, Talend, Azure Data Factory) is a plus.
Pay Range: $74,772 - $125,184
#CA-EH8
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), 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 .
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.
Opens in a new tab
The Jackson Laboratory is a nonprofit biomedical research institution specializing in mammalian genetics and genomics. It conducts disease research, breeds and distributes genetically defined mice to researchers worldwide, and provides education and data resources to advance precision medicine.
Visit website$74,772 – $125,184
Base Only