Business Intelligence Data Warehouse Developer/Analyst

The Jackson Laboratory for Genomic Medicine

Bar Harbor, ME

Job posting number: #7074415 (Ref:JAX28224)

Posted: January 25, 2021

Application Deadline: Open Until Filled

Job Description


The Jackson Laboratory in Bar Harbor, Maine has multiple positions for a Business Intelligence Data Warehouse Developer/Analyst I.  This is not a remote based role.


The Business Intelligence Data Warehouse Developer/Analyst I defines, analyzes, designs, develops, tests, and maintains new software applications in support of the achievement of business requirements. Elicits, documents, and modifies software requirements and specifications throughout the software system life cycle. Responsible for analyzing and amending software errors in a timely and accurate fashion and for providing status reports where required. Performs data warehouse design, including determining client requirements; designing dimensional star schemas; designing OLAP cubes; analyzing data from operational systems; designing and documenting ETL (extract, transfer, load) requirements; designing and documenting OLAP load routines; working with programmers to build ETL programs; and testing data loads for accuracy, completeness, and usefulness. Provides data warehouse user analysis and support and designs, creates, and manages the end user reporting layer; creates user metadata documentation; markets data warehouse resources to the client community; assist clients in creating reports in the data warehouse and OLAP environments; and provides guidance to clients as needed. Works as a database designer for transaction systems, understands the design concepts applied to normalized transaction databases and the data modeling techniques, and leads client groups in data design and determining functional requirements.


The minimum requirements for the positions are a Bachelor’s degree or foreign equivalent degree in computer science, information science, software engineering, or a related field. This position requires 1 year of professional experience working in a cube environment performing data warehouse design and analysis that includes writing SQL queries and functions to develop reports from various databases, designing OLAP data cubes using dimensional star schemas, designing and developing ETL (Extract, Transfer, Load) solutions for data warehouse, and administering the creation of reports from various databases and OLAP environments used in project analysis.


RATE OF PAY: Between $73,190 and $100,025/year

ADDRESS OF EMPLOYMENT: 600 Main Street, Bar Harbor, ME 04609.


Please submit a cover letter and resume!

About Us

The Jackson Laboratory (JAX) is an independent, nonprofit biomedical research institution with more than 2,300 employees. Headquartered in Bar Harbor, Maine, it has a National Cancer Institute-designated Cancer Center in Augusta, Maine, a genomic medicine institute in Farmington, Connecticut, and facilities in Ellsworth, Maine, Sacramento, California, and Shanghai, 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.

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.

JAX employees work in a collaborative, value-driven, and team-based environment where the focus is on advancing science and improving patients’ lives. Researchers apply genetics to increase the understanding of human disease and advance treatments and cures for cancer, neurological and immune disorders, diabetes, aging, and heart disease. JAX was voted among the top 15 “Best Places to Work in Academia” in the United States in a poll conducted by The Scientist magazine!

Our Values:

INTEGRITY - Courage and commitment to do what is right

PEOPLE - Inspiring our people to enhance the health of all

ONE TEAM - Unified by our promise to transform medicine and science

EXCELLENCE - Achieving world-class results

INNOVATION - Leading with discovery and creative solutions

STEWARDSHIP - Caring for and enhancing the resources entrusted to us


What do we have to offer?

JAX offers a dynamic and supportive work environment, competitive salaries, and a comprehensive benefits package, including a medical plan, outstanding retirement plan, generous paid time off, and tuition reimbursement including an MBA program. Our campus offers a fitness center with an award-winning wellness program, an onsite full service cafeteria, and a fully operational primary care facility available to employees and their families.


Most importantly, every position contributes to JAX’s mission of discovering precise genomic solutions for human disease and empowering the global biomedical community in our shared quest to improve human health.


Employment will require successful completion of references, background check, credit check, and an appropriate non-compete agreement.

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.

Learn more about career opportunities at JAX:


Apply Now

Please mention to the employer that you saw this ad on

Job posting number:#7074415 (Ref:JAX28224)
Application Deadline:Open Until Filled
Employer Location:The Jackson Laboratory for Genomic Medicine
United States
More jobs from this employer
Institution Website