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!
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!
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: http://www.jax.org/careers.