Business Intelligence/Reporting Developer

American Well, a national leader in the rapidly growing field of telehealth, seeks a highly motivated and professional Business Intelligence/Reporting Developer. We partner with the top health systems, health plans, employers, and digital health companies to deliver video doctor visits over mobile and web. We are changing the way healthcare is delivered by enabling every doctor to use telehealth with their patients, making care more accessible, affordable and convenient. Our goal is to bring care home.

Brief Overview:

The Business Intelligence/Reporting Developer will play a critical role in the Hosting department. Specifically, the Business Intelligence/Reporting Developer will create and implement new reports using Oracle SQL and Looker BI tools to support our growing business.  You will meet with internal stakeholders to turn requirements into reports and dashboards.  You will maintain these reports as our software platform evolves and new reporting features are required.  You will need to be proficient writing reports using Oracle SQL queries and creating data transformations using Looker’s LookML.  You will need to optimize queries for performance. You will manage your deliverables using Liquibase and Git. 

Core Responsibilities:

  • Ability to understand complex data sources
  • Create sustainable, scalable reports from those sources.
  • This is not a database administrator position. You will have the support of a top-notch team of DBAs, but will need to have sufficient operational experience with Oracle databases to be self-reliant for basic database administration.

Qualifications:

  • Solid understanding of data reporting/BI including the creation of optimized schemas, writing efficient SQL queries against these schemas and optimization of the resulting reports and data structure.
  • Oracle SQL, PL/SQL experience is a must
  • Excellent written and oral communications are a must.
  • Ability to transfer knowledge effectively to consumers of the reporting system.
  • Ability to work with QA to ensure that reporting quality is being measured effectively.
  • Python or Java development experience is a plus
  • Experience working with Git & Liquibase is a plus

 

Your Team:

Should you join American Well and the Hosting team, you can expect:

American Well’s Operations group is a mission-focused technology team made up the best and brightest technical talent.  Operating out of our Boston headquarters, our engineers specialize in Information Technology, Cyber Security & Compliance, Hosting Operations, Business Intelligence, Kiosk Operations and Network Engineering.  We operate a state of the art Cyber Command Center designed specifically to manage and protect our global telehealth infrastructure.

We leverage the latest technologies including an array of deployment and management tools as well as several cyber threat intelligence networks to keep our systems running smoothly around the clock.

If you enjoy working hard, challenging yourself, and staying at the cutting edge of technology, this is the team for you. 

Working at American Well: 

American Well is changing how care is delivered through online and mobile technology. We make online doctor visits accessible to everyone for one-off care issues like colds or infections, and chronic condition management, such as diabetes or depression. We make the hard work of healthcare look easy and that requires a mission-driven mentality. We’re a “go getter” culture that pride itself on smarts, initiative, creative thinking, and a strong work ethic.

Our corporate headquarters are located in downtown Boston at 75 State Street –in the heart of the city. In addition to the opportunity to build the future of healthcare technology and a great location, we offer:

  • Unlimited Personal Time Off (Vacation time)
  • 401K match
  • Competitive healthcare, dental and vision insurance plans
  • Free gym access – on-site
  • Prime office space with views overlooking all of Boston
  • Complimentary snacks and drinks

 

 

Apply for this Job

* Required
  
  


U.S. Equal Opportunity Employment Information (Completion is voluntary)

Individuals seeking employment at American Well are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.


Form CC-305

OMB Control Number 1250-0005

Expires 1/31/2020

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

Because we do business with the government, we must reach out to, hire, and provide equal opportunity to qualified people with disabilities1. To help us measure how well we are doing, we are asking you to tell us if you have a disability or if you ever had a disability. Completing this form is voluntary, but we hope that you will choose to fill it out. If you are applying for a job, any answer you give will be kept private and will not be used against you in any way.

If you already work for us, your answer will not be used against you in any way. Because a person may become disabled at any time, we are required to ask all of our employees to update their information every five years. You may voluntarily self-identify as having a disability on this form without fear of any punishment because you did not identify as having a disability earlier.

How do I know if I have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

  • Blindness
  • Deafness
  • Cancer
  • Diabetes
  • Epilepsy
  • Autism
  • Cerebral palsy
  • HIV/AIDS
  • Schizophrenia
  • Muscular dystrophy
  • Bipolar disorder
  • Major depression
  • Multiple sclerosis (MS)
  • Missing limbs or partially missing limbs
  • Post-traumatic stress disorder (PTSD)
  • Obsessive compulsive disorder
  • Impairments requiring the use of a wheelchair
  • Intellectual disability (previously called mental retardation)
Reasonable Accommodation Notice

Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job or to perform your job. Examples of reasonable accommodation include making a change to the application process or work procedures, providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.

1Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.